Fatal NI connect error 12546, connecting to:
Oracle Bequeath NT Protocol Adapter for HPUX: Version 18.104.22.168.0 - ProductiTime: 11-NOV-03 14:33:48
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: Message 12206 not found; No message file for product=NETWORK, facilitns main err code: 12546
TNS-12546: Message 12546 not found; No message file for product=NETWORK, facilitns secondary err code: 12560
nt main err code: 516
"sqlnet.log" 42 lines, 1992 characters
This happens when running a daemon on a HP Unix server with Oracle 805. It is a segment from the sqlnet.log file. Here is the profile I'm using:
# standard profile # @(#) Profile.raven @(#) # # Oracle stuff gets added here export ORACLE_HOME=/opt/oracle/product/805 export ORACLE_SID=dcci export TNS_ADMIN=/etc/tnsnames.ora export PATH=$PATH:/opt/raven/bin:$ORACLE_HOME/bin HOSTNAME=`hostname` export HOSTNAME # for Raven RAVENHOME=/opt/raven export RAVENHOME BBORALIB=$ORACLE_HOME/lib export BBORALIB #SQRDIR=/opt/sqr/ora/bin export SQRDIR BBSQRSRC=$RAVENHOME/bin/sqr export BBSQRSRC BBTEMP=$RAVENHOME/tmp export BBTEMP BBLOG=$RAVENHOME/log export BBLOG BBBIN=$RAVENHOME/bin export BBBIN BBLIB=$RAVENHOME/lib export BBLIB BBSRC=$RAVENHOME/src export BBSRC ~ ~ ~ "profile.raven" 20 lines, 614 characters
Typically, this type of error occurs because the user that started the Listener does not have the appropriate file permissions to write information in specific directories on the server. Your problem is the ORA-12546 error, "TNS: permission denied". Also make sure that you listener is listening on the correct port and that no one else is using it.
This was first published in November 2003