Oracle DBA - Oracle Client Configuration


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 - Oracle Client Configuration

Learn Oracle - Client Configuration

When a client configured with the same protocol address broadcasts a request for a connection, the listener on the server machine or Oracle DBA machine brokers the request and forwards it to the Oracle database.

The client uses a connect descriptor to specify the database it wants to connect to. This connect descriptor contains a protocol address and a database service name. A database can have multiple services defined, so a specific one must be specified for the connection. In the case of the preconfigured database that you installed, there is only one service, the name of which defaults to the global database name.

The following example shows a connect descriptor that enables clients to connect to a database service called mydb.us.acme.com:

(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=my-server) PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=mydb.us.acme.com)))

STEP 4 - Next Topics
After installing your Oracle software and database, you have a fully functional database with a client/server network environment that has been minimally configured.This Step contains the topics to help you 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 Requests
Naming Methods
Tools for Network Configuration
Viewing Listener Configuration
Starting and Shutting down the Listener
Configuring Oracle Networking on Client Machine
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