Step 4 - Configuring Oracle Networking on Client Machines
Learn Oracle - Configuring Oracle Networking on Client Machines
Client machines need to be configured before they can connect to an Oracle database.
To configure the client machine, Oracle DBA must first install Oracle client software, which
includes Oracle Net software.
This example shows you how to configure a Windows client with local naming, which
involves adding a connect descriptor entry to the local tnsnames.ora file. The connect
descriptor specifies the host name, protocol address, and service name of the database
to connect to.
On Windows, you can use the Oracle Net Manager program to create a new net
service entry in your tsnames.ora file as follows:
Start Oracle Net Manager by clicking Start->Programs->Oracle->Configuration
and Migration Tools->Net Manager
Highlight Local Naming and click the plus (+) on the left hand side of the page.
The Net Service Name Wizard appears.
> Enter a net service name to identify it. The name Oracle DBA choose will appear under the
Service Naming folder. Click Next.
Select the protocol to use to connect to your database. For example, Oracle DBA can accept
the default TCP/IP (Internet Protocol). The database listener must be configured
to use the same network protocol. Click Next.
Enter the host name of the database machine, such as coconuts.island.com.
Enter either the database service name or the database SID. In addition, select a
Connection Type, either Shared or Dedicated. Shared connections require your
database to be running in shared mode. If Oracle DBA choose Dedicated, the database
dedicates a single server process to serve your connection. If Oracle DBA are unsure or
would like to use the default database connection type, select Database Default.
The last screen of the wizard enables Oracle DBA to test the connection using the
information you entered. To do so, click Test. To log in to the database, you can use
the SYS user and the password you specified when you configured your database.
The wizard tells you if the connection test succeed or not.
Click Finish. The new service appears under the Service Naming folder. You can
view or modify the configuration for the highlighted service under Service
Identification and Address Configuration.