Description
To associate with an administration, user utilize an interface identifier in the associate string to relate with an database assistance. The associate identifier can be an interface descriptor or a basic name that maps to an associate descriptor. The interface descriptor consists of:
- System course to the administration that includes the area of the listener over a convention address.
- Oracle 8i or later discharge version of the database administration names contains the Oracle System Identifiers.
Description
A basic name is set out to an associate descriptor by a naming technique. Naming strategy arrangement comprises of the accompanying stages:
- Choose a naming technique.
- Map associate descriptors to basic names.
- Design user to utilize the naming technique.
Description
In the below example the naming methods are performed on sales,the below example illustrates a sample program.
[c]
sales=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.acme.com)))
sales=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.acme.com)
(INSTANCE_NAME=sales)))
sales=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SID=sales)))
[/c]
Conceptual
figure
Description
An associate descriptor consists of multiple convention IP Addresses of the audience and interface information data for the terminal section utility. The accompanying illustration demonstrates an interface descriptor mapped to elementary name called variable length:
[c]
variablelength =
(DESCRIPTION=(ADDRESS_LIST =
(ADDRESS=(PROTOCOL = TCP)(HOST = oraserver)(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = variablelength)
)
)
Address => consisits of IP protocol address of listener.
Connect_Data => Contain the information of target assistance.
[/c]
The Oracle client software parses TNSNAMES.ORA to do a resolution. Another way to go is to ignore TNSNAMES.ORA and use easy connect. All the exact specifications are full connection string on the command line. And the password should be consists of connect user and passwords. And user forward slash password at the server name, and then optionally colon port number forward slash service name. Especially linux is susceptible for displaying those aurgements in a run of the ps command, but easy connect is a way to bypass TNSNAMES.ORA. For trouble shooting the connectivity issuess related to oracle DBA's is a very difficult and is simple problem with a TNSNAMES file or maybe the listener hasn't been reset or reloaded. This essentially oracle's version of active directory and can identity management and also publish on oracle services in OID, as long as the client systems is present in the organisations. And an trapped into that directory database with a specific and easy resolution inside the oracle instance.
Key Points
- Oracle Naming Methods - Process of connecting clients to oracle database.
- Naming Method Configurations - Are the parameters specifics the order of naming methods.