OraFAQ Forum: Networking and Gateways » LISTENER

Home » RDBMS Server » Networking and Gateways » LISTENER - Error: TNS-12560

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LISTENER - Error: TNS-12560 [message #66974]

Mon, 05 May 2003 14:57

Michael
Messages: 61
Registered: October 1999

Member

Hi!
I have a problem to restart my listener again. With the current configuration the listener works fine.
But today in the morning it crashes without any other configuration and now I get the folling error messages:
LSNRCTL> start
Starting /app/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production
System parameter file is /app/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /app/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edb)(PORT=1521))
)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edb)(PORT=1521))
)
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
LSNRCTL>
Can anybody help?
Best Regards
-michael

Report message to a moderator

Re: LISTENER - Error: TNS-12560 [message #66975 is a reply to message #66974]

Mon, 05 May 2003 15:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first try this.
1. rename the listener.ora to something else.
2. create a new listener.
3. start the listener.
   if this is not helping u 
   please port your listener.ora.

Report message to a moderator

Re: LISTENER - Error: TNS-12560 [message #66976 is a reply to message #66975]

Mon, 05 May 2003 23:54

Michael
Messages: 61
Registered: October 1999

Member

Thank you for your help!!!
I could fix my problem - so simple: /etc/hosts could not be read by user ORACLE...:-(((

Report message to a moderator

Re: LISTENER - Error: TNS-12560 [message #67358 is a reply to message #66975]

Wed, 02 June 2004 00:51

Prasanna
Messages: 43
Registered: April 2001
Location: India

Member

HI,

I am trying to connect a oracle 9i server which is on WINXP from a oracle 8.0.6 client which is on TRU64 Unix.

I get the following error.

Fatal NI connect error 12197, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XX)(PORT=1521))(CONNECT_DATA=(S
ID=ABCDEFG)))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=aaa.bb.cc.co.uk)(USER=prasanna))))

VERSION INFORMATION:
TNS for DEC OSF/1 AXP: Version 8.0.6.0.0 - Production
TCP/IP NT Protocol Adapter for DEC OSF/1 AXP: Version 8.0.6.0.0 - Production
Time: 02-JUN-04 09:50:56
Tracing not turned on.
Tns error struct:
nr err code: 12197
TNS-12197: TNS:keyword-value resolution error
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Can anyone help me resolving this error please..

Thanks & Regards

Prasanna

Report message to a moderator

Previous Topic:	DEDICATED in tnsnames.ora - Security level
Next Topic:	listener problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 21 21:40:48 CST 2025