Re: growing sqlnet.log file with "Fatal NI connect error 12545, connecting to:" error

shailesh.pjoshi_at_patni.com (Shailesh) wrote in message news:<addccc53.0409202213.7e63f101_at_posting.google.com>...
> Hello,
>
> Today I observed that my sqlnet.log file is growing with the
> following error though I am able to connect to database. The error is
> repeating. The file grows in MBs. Can anybody please help me to figure
> out what the exact problem is?
>
> ----------------------------------------------------------------------
> Fatal NI connect error 12545, connecting to:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/oracle/product/8.1.7/bin/oracle)(ARGV0=oracleP2LTCP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=as12)(USER=oracle))))
>
> VERSION INFORMATION:
> TNS for Solaris: Version 8.1.7.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for Solaris: Version
> 8.1.7.0.0 - Production
> TCP/IP NT Protocol Adapter for Solaris: Version 8.1.7.0.0 -
> Production
> Time: 12-APR-2003 03:15:05
> Tracing not turned on.
> Tns error struct:
> nr err code: 0
> ns main err code: 12545
> TNS-12545: Connect failed because target host or object does not
> exist
> ns secondary err code: 12560
> nt main err code: 515
> TNS-00515: Connect failed because target host or object does not
> exist
> nt secondary err code: 2
> nt OS err code: 0
>
> -----------------------------------------------------------------------
>
> Thanks,
> Shailesh

The ORA-12545 error indicates that some of the information contained in the tnsnames.ora entry for "(DESCRIPTION=(ADDRESS=(PROTOCOL=beq) PROGRAM=/u01/oracle/product/8.1.7/bin/oracle)(ARGV0=oracleP2LTCP)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=as12)(USER=oracle))))" is not correct.

Correct the entry.

HTH -- Mark D Powell -- Received on Tue Sep 21 2004 - 08:30:30 CDT