sqlnet.ora missing repercussions

[jlakhani]

Question. I found a prod box missin sqlnet.ora. What can be the repurcussions of that?

[gandolf989]

Apparently none. SQLNET.ORA tells Oracle how to find the databases when it tries to connect. As with most things in Oracle if you don't specify a value it will default to something. It is probably defaulting to
NAMES.DIRECTORY_PATH= (TNSNAMES)
Unless you want to make a change I wouldn't do anything to it. Because it probably works.

[jlakhani]

Hi..I get these errrors..in the sqlnet.log


***********************************************************************
Fatal NI connect error 12505, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=COMTCP)(PROTOCOL=TCP)(HOST=chihp
dv2)(PORT=1521)))(CONNECT_DATA=(SID=infd)(CID=(PROGRAM=)(HOST=chihpns2)(USER=ora
cle))))

VERSION INFORMATION:
TNS for HPUX: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.0.5.0.0 - Produc
tion
TCP/IP NT Protocol Adapter for HPUX: Version 8.0.5.0.0 - Production
Time: 11-DEC-01 06:02:25
Tracing not turned on.
~ Tnnt OS err code: 0code: 0n refusedsed from an application

[gandolf989]

I'm no expert on HPUX. But if this ever worked then you should find out what was changed and if neccessary pull back you listener file from tape. Check the TNSNAMES.ORA, SQLNET.ORA and LISTENER.ORA. and make sure that everything is ok. You might want to compare the entries to another HPUX box.
Bounce the listener, then if neccessary the box. Also make sure that the user running the database has rights to all of its files. i.e. $ORACLE_HOME/oradata/sid and $ORACLE_HOME/network/admin.