Oracle client computers must be configured before they can connect to an Oracle database.
-
Start Oracle Net Manager.
-
Select the Service Naming node, and then select the green plus sign to start the Net Service Name Wizard.
-
Specify a Service Name.
The Service Name must be the same on the server and client. You will need to provide this net service
name when creating databases, bulkloading and configuring Workshare.
-
Select TCP/IP (Internet Protocol).
-
Specify the Host name (typically the network name of the database server computer) and Port Number (default=1521) for your protocol settings.
-
Specify the Service Name and Connection Type.
-
Test the new service.
-
If the default test fails, select Change Login, type a valid username/password combination and, retest the connection.
-
When the login test is successful, select Finish to close the wizard.
-
Select File > Save Network Configuration to save your new network service.