Tom,

I have instalelled Oracle Database 10g. The operating system is SuSE Linux Enterprise Server8.

Initially my tnsname.ora and listener.ora were not installed.
But I was able to connect to the Database and logon to the SQLPLUS.

After that I ran ./netmgr from $ORACLE_HOME/bin to create tnsnames.ora and listener.ora.

Now my $ORACLE/HOME/network/admin directory is as follows:

oracle@dhswits:~/product/10.1.0/db_1/network/admin> ls
listener.ora samples shrept.lst tnsnames.ora

My first question is that
Am I missing sqlnet.ora?

Note:
Currently my sqlnet.ora file existed under /product/10.1.0/db_1/network/admin/samples>

Second Part:

Now if run tnsping 159.226.120.65 (my_machine_ip_address) from command line.

I got result as follows:

oracle@dhswits:~> tnsping 119.226.120.65

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 25-AUG-2004 20:14:18

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=119.226.120.65))(ADDRESS=(PROTOCOL=TCP)(HOST=159.225.140.75)(PORT=1521)))
OK (0 msec)


I do not understand " Used HOSTNAME adapter to resolve the alias".

Is it normal or I need to do some actions.
Please suggest me.


Cheers,
Dawar