OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » listener

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

listener [message #251551]

Sat, 14 July 2007 12:02

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: listener [message #251556 is a reply to message #251552]

Sat, 14 July 2007 13:09

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

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: listener [message #251558 is a reply to message #251557]

Sat, 14 July 2007 13:21

seyiisq
Messages: 125
Registered: September 2005

Senior Member

thank you

Report message to a moderator

Re: listener [message #251564 is a reply to message #251551]

Sat, 14 July 2007 14:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Use CUT & PASTE to post results from:
lsrnctl start

Report message to a moderator

Re: listener [message #251565 is a reply to message #251551]

Sat, 14 July 2007 14:39

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

Report message to a moderator

Re: listener [message #251617 is a reply to message #251565]

Sun, 15 July 2007 09:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Could you please post "lsnrctl services" output.

Report message to a moderator

Previous Topic:	Using dbstart, getting error ORA-01031: insufficient privileges
Next Topic:	Upgrade Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 10:01:46 CST 2024