Oracle DBA - Configuring Oracle Networking on Client Machines


I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and Oracle DBA friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

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. Click Next.

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.

STEP 4 - Next Topics
After installing your Oracle software and database, Oracle DBA have a fully functional database with a client/server network environment that has been minimally configured.This Step contains the topics to help Oracle DBA completely configure your client/server network. Learn Oracle DBA Step 4 by clicking links below:
Understanding Network ConfigurationOracle DBA
Oracle Net Listener ConfigurationOracle DBA
Client ConfigurationConfiguring client
Connection RequestsConnection Requests
Naming MethodsNaming Methods
Tools for Network ConfigurationTools for network configuration
Viewing Listener Configurationviewing listener configuration
Starting and Shutting down the ListenerStarting and shutting listener
Configuring Oracle Networking on Client MachineConfiguring Network
More Tutorials on Oracle dba ...

Source : Oracle Documentation | Return to Learn Oracle

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info