Details : Client Connections
Client connections descriptors are -
Connect Descriptors
Connection Requests
Naming Methoods
Connect Descriptors:
The client uses a connect descriptor to specify the database to which it wants to connect. This connect descriptor contains a protocol and a database service name.
A database can have multiple service names defined, so a specific service name must be specified for the connect descriptor.
In a preconfigured database, there is only one service name, which defaults to the global database name.
Example:
DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=my-server) PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=mydb.us.example.com))
Users initiate a connection request by providing a connect string. A connect string includes a user name and password, and a connect identifier.
This connect identifier can be the connect descriptor itself, or a name that resolves to the connect descriptor using mapping information stored in one or more repositories accessed with the naming methods.
This name is referred to as a net service name.
Naming Method is a resolution method used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.
Oracle Net provides support for -
Easy Connect Naming Methods
Local Naming Methods
Directory Naming Methods
The easy connect naming method enables clients to connect to an Oracle database by using only a TCP/IP connect string consisting of a host name and service name.
The easy connect naming method requires no configuration.
The local naming method stores connect descriptors, identified by their net service names, in a client configuration file named tnsnames.ora.
This file is located in the ORACLE_HOME/network/admin directory.
Directory naming resolves a database service, net service name, or net service alias to a connect descriptor stored in an LDAP-compliant directory server.
-----xXx-----
No comments:
Post a Comment