Regarding the steps below, all of the Oracle service names that will participate in the workshare must be configured as a local net service at each location. For example, on the host server you must add the Oracle service name for each satellite server that is participating in the workshare. On each satellite server that is participating in the workshare, you must add the Oracle service name for the host.
-
Start the Oracle Net Configuration Assistant.
-
On the Welcome page, select Local Net Service Name configuration, and then select Next.
-
Select Add on the Net Service Name Configuration page, and then select Next.
The Service Name cannot contain a period.
-
On the Service Name page, enter the name that identifies the database service in the Service Name box that you want to add, and then select Next.
The service name is the Oracle database instance name, not the database server computer
name.
-
Select the TCP protocol, and then select Next.
-
Type the computer name of the database server in the Host name box. You can also enter the TCP/IP address.
-
Select Next.
-
Select Yes, perform a test to perform the connection test, and then select Next.
-
Select Change Login, and enter the system user name and password to use to test this connection.
-
If the test is successful, then select Next.
-
Enter the Net Service name. This name becomes the alias by which the Oracle database server is identified.
-
Select No when asked if you want to configure another service, and then finish the wizard.
When you complete the step above, select the option to perform a test of the net service name information. During a test, Oracle Net Configuration Assistant attempts to contact the remote database service, establishes a connection, and then ends contact.
-
Repeat this procedure until all of the Oracle service names participating in the Workshare have been configured as a local net service.
-
For more information about using Oracle Net Configuration Assistant, see the Oracle Database Net Services Administrator's Guide delivered with the Oracle database software.