Q

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))))
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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close