oracle sqlplus client on hpux 11.00

[Arunvijai_4]

Shiv, Hope this link should be enough to configure tnsnames.ora

http://www-rohan.sdsu.edu/doc/oracle/network803/A53746_01/ch6.htm

-Arun

[Eric Antunes]

Hi Shivkumar,

See if you have SQL*Net Easy Configuration installed or to install on the CD: it is like a wizard.

Else, check $ORACLE_HOME/network/admin for listener.ora and tnsnames.ora.

tnsnames.ora should have a TCP/IP example like this one:

TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)

Best Regards,

Eric Antunes

[Yogeeraj_1]

hi,

you can also directly edit the tnsnames.ora file directly or use either of the sqlnet
easy configuration or net manager programs.

e.g.

mydb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))
)
(CONNECT_DATA =
(SID = mydb)
(SERVER = DEDICATED)
)
)


hope this helps too!
kind regards
yogeeraj