topic Re: sqlnet.ora doubt in Operating System - HP-UX

sqlnet.ora doubt

KapilRaj — Tue, 30 Dec 2003 01:19:17 GMT

Guys,

I am basically a Sysadmin .... But would like to know what this line says .....

In one of my boxes there is a file called /etc/sqlnet.ora which states as follows ..

NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES)
What is the effect of the path when it's mentioned as (TNSNAMES, HOSTNAME) and how does it work?

Thanks in advance...

Kaps

Re: sqlnet.ora doubt

T G Manikandan — Tue, 30 Dec 2003 01:53:36 GMT

Kapil,

sqlnet.ora file is a file used for resolving network addresses and the order of resolution.

With
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES)

deciding which configuration files to search for the order of resolution

First it checks the tnsnames.ora and then the name server onames configuration file for resolving the services.

Any further help please revert

Do you have a name server with name HOSTNAME

Re: sqlnet.ora doubt

Alexander M. Ermes — Tue, 30 Dec 2003 01:56:58 GMT

Hi there.
If you go for (TNSNAMES, HOSTNAME),
possible connections will be checked first in TNSNAMES.ORA, then in your hosts file
( mostly /etc/hosts).

Extract from Oracle SQLNet manual :

-------------------------

Configuring the Host Naming Method
In environments where simple connectivity is desired, host naming can eliminate the need for service name lookup in the tnsnames.ora files. However, for large or complex environments where advanced features such as connection pooling, external procedures, or Heterogeneous Services, which require additional connect information, are desired, host naming is not suitable. In these cases, another naming method is recommended.

The host naming method is available for TCP/IP network environments only. When instances register with the listener, the global database name of the server, a name comprised of the database name and domain name. The global database name is equal to a host name on an alias in an existing name resolution service. Clients use this name in their connect string to connect to the database.

Clients may connect to a server using the alias if:

You are connecting to an Oracle8i database service with Net8 Server/Net8 Client software installed

Your client and server are connecting over a TCP/IP protocol

All names are resolved through an IP address translation mechanism such as Domain Name System (DNS), or a centrally maintained TCP/IP hosts file

No advanced features like Oracle Connection Manager or security are requested or required

-------------------------------
Extract end

Rgds
Alexander M. ERmes

Re: sqlnet.ora doubt

T G Manikandan — Tue, 30 Dec 2003 02:13:56 GMT

TNSNAMES, HOSTNAME) would define the order as tnsnames.ora and then the /etc/hosts file on unix.

This configuration of

NAMES_DIRECTORY_PATH=(hostname)

This would make resolve without any client side configuration file.

HOSTNAME adapter is only for the TCP/IP based connection which is using NET8.

Also the listener.ora file on the server side should be configured such a way that the connection is established.

Re: sqlnet.ora doubt

KapilRaj — Tue, 30 Dec 2003 02:19:46 GMT

Thanks a million .....

Kaps

Re: sqlnet.ora doubt

Yogeeraj_1 — Tue, 30 Dec 2003 02:50:46 GMT

hi,

To add to above replies, please note that sqlnet.ora is an OPTIONAL file.

attached an interesting note from metalink (1006437.6)

Best wishes
Yogeeraj