Home » RDBMS Server » Server Administration » listener
listener [message #251551] Sat, 14 July 2007 12:02 Go to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
i just set up a password for my listener so that not just anybody will be able to stop it.
but now i discover that i am having protocol adapter error (TNS12560 and TNS00530)

i checked fpr the error in my oracle_home\network\log and fpund the following problem

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 14-JUL-2007 18:02:36

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

System parameter file is C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.1.0\Db_1\network\log\orcl_1.log
Trace information written to C:\oracle\product\10.1.0\Db_1\network\trace\orcl_1.trc
Trace level is currently 0

Started with pid=3376
TNS-01151: Missing listener name, orcl_1, in LISTENER.ORA


pls can you help

[Updated on: Sat, 14 July 2007 12:07]

Report message to a moderator

Re: listener [message #251552 is a reply to message #251551] Sat, 14 July 2007 12:25 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
No the real error is:
>TNS-01151: Missing listener name, orcl_1, in LISTENER.ORA
which is what you need to fix.
Re: listener [message #251556 is a reply to message #251552] Sat, 14 July 2007 13:09 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
i don't know how pls can you help
this is my listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
      (PROGRAM = extproc)
    )
  )

LOGGING_LISTENER = OFF

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = sey)(PORT = 1521))
      )
    )
  )

TRACE_LEVEL_LISTENER = OFF


#----ADDED BY TNSLSNR 14-JUL-2007 16:46:26---
PASSWORDS_LISTENER = 8924AA867ED37D40
#--------------------------------------------

[Updated on: Sat, 14 July 2007 13:12]

Report message to a moderator

Re: listener [message #251557 is a reply to message #251551] Sat, 14 July 2007 13:16 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
How/why do you expect anyone to help you when we have NO idea what EXACTLY you did that resulted in this error
& we have no idea about the contents of the listener.ora file.
You should read & FOLLOW the posting guidelines in the #1 STICKY post at the top of this forum.
Have you tried reversing/undoing what ever you did just before getting the error?
Why are you making changes when you don't seem to be qualified to do so?

Look at the bright side, you accomplished your goal.
Nobody else can stop the listener now; but primarily because it is not running.

Use CUT & PASTE in combination to use of code tags to post the output from:

lsnrctl status
Re: listener [message #251558 is a reply to message #251557] Sat, 14 July 2007 13:21 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
thank you
Re: listener [message #251564 is a reply to message #251551] Sat, 14 July 2007 14:26 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Use CUT & PASTE to post results from:
lsrnctl start
Re: listener [message #251565 is a reply to message #251551] Sat, 14 July 2007 14:39 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
thanks i have ie as below

LSNRCTL> start
Starting tnslsnr: please wait...

Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  32-bit Windows Error: 1056: Unknown error
Re: listener [message #251617 is a reply to message #251565] Sun, 15 July 2007 09:36 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Could you please post "lsnrctl services" output.
Previous Topic: Using dbstart, getting error ORA-01031: insufficient privileges
Next Topic: Upgrade Database
Goto Forum:
  


Current Time: Mon Dec 05 04:39:07 CST 2016

Total time taken to generate the page: 0.18593 seconds