Home » RDBMS Server » Networking and Gateways » Listener failed to start. (10.2.0.3.0)
Listener failed to start. [message #557883] Sat, 16 June 2012 23:30 Go to next message
dsnaveen
Messages: 3
Registered: June 2012
Junior Member
Hello huys,

Please need your help in resolving the error

C:\Documents and Settings\naveen>lsnrctl start PLSExtProc

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 17-JUN-2012 11:41
:02

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

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb10g_home1TNSListenerPLSExtProc>, error 1060.
TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\plsextproc.log

TNS-01151: Missing listener name, PLSExtProc, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

The log message is given below.

TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production on 17-JUN-2012 11:41:22

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

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

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


My listener.ora entry is given below.

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.233.128)(PORT = 1521))
)
)


tnsnames.ora is given below.

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SCOTT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.233.128)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = scott)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


Can you please let me know what all changes to be done.

Thanks,
Naveen
Re: Listener failed to start. [message #557884 is a reply to message #557883] Sat, 16 June 2012 23:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

move,remove, rename listener.ora file which is NOT required to start listener
after listener.ora no longer exists then do as below

lsnrctl start
lsnrctl status
lsnrctl service


COPY command & results the PASTE all back here
Re: Listener failed to start. [message #557886 is a reply to message #557883] Sun, 17 June 2012 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
lsnrctl start PLSExtProc


Your listener is not named "PLSExtProc", it is named "LISTENER".

Regards
Michel
Re: Listener failed to start. [message #558002 is a reply to message #557886] Mon, 18 June 2012 11:35 Go to previous messageGo to next message
dsnaveen
Messages: 3
Registered: June 2012
Junior Member
Hi Guys,

Thanks for the mail,

Iam connnecting Informatica, having issue in the middle while doing Configure Domain Database
please find the attached error message.

Please let me know below entries looks good. Iam not sure of Database Service name, what should i give.

C:\Documents and Settings\naveen>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 18-JUN-2012 23:25
:00

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
Start Date 17-JUN-2012 13:19:35
Uptime 1 days 10 hr. 5 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.233.128)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Thanks,
Naveen
  • Attachment: Error1.GIF
    (Size: 61.34KB, Downloaded 1563 times)
Re: Listener failed to start. [message #558003 is a reply to message #558002] Mon, 18 June 2012 11:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
with V10 any database on the server will register itself with the listener every minute.
Given that no DB is reported by lsnrctl status, I conclude that no instance is online & available.

what clues exist within alert_{SID}.log file about the status of the DB?
Re: Listener failed to start. [message #558023 is a reply to message #558003] Mon, 18 June 2012 23:24 Go to previous messageGo to next message
dsnaveen
Messages: 3
Registered: June 2012
Junior Member
Thanks for the mail.

I have attached the alert_scott.txt

In that database I have given scott, still some other error, it is showing.

Can you please help to check is this the file.

Thanks,
Naveen
Re: Listener failed to start. [message #558025 is a reply to message #558023] Mon, 18 June 2012 23:40 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OK, DB has been up for more than 1 day; late Sunday to early Tuesday.
Complete disconnect between DB & listener log files.
What exists that I don't know about?
What don't I know about that exists?
Previous Topic: issue with tns connection
Next Topic: Setting QUEUESIZE Parameter in listener.ora
Goto Forum:
  


Current Time: Fri Mar 29 08:33:48 CDT 2024