Oracle DBA - Connection requests


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 - Connection requests

Learn Oracle - Connection Requests

Users initiate a connection request by providing a connect string. A connect string includes a username and password, along with a connect identifier. This connect identifier can be the connect descriptor itself, or a name that resolves to the connect descriptor. One of the most common connect identifiers is a net service name, a simple name for a service.

The following example shows a connect string that uses net service name mydb as the connect identifier.

CONNECT scott/tiger@mydb

While the connect identifier is relatively simple as shown, the y can be long and inconvenient to use if your environment configuration is more complex. With long connect identifiers, you can use a mapping method that maps the net service name to the connect descriptor. This mapping information is stored in one or more repositories of information that are accessed with naming methods.

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 RequestsConnection 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