Ask the Expert

Help with listener error

I'm receving this error:

Fatal NI connect error 12546, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/oracle/product/805/bin/oracle)(ARGV0=oracledcci)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETAVERSION INFORMATION:=(CID=(PROGRAM=)(HOST=s1dcci)(USER=raven))))

    Requires Free Membership to View

TNS for HPUX: Version 8.0.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.0.4.0.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

Any ideas?
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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: