| Listener failed to start. [message #557883] |
Sat, 16 June 2012 23:30  |
 |
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 #558002 is a reply to message #557886] |
Mon, 18 June 2012 11:35  |
|
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 2107 times)
|
|
|
|
|
|
|
|
| Re: Listener failed to start. [message #558025 is a reply to message #558023] |
Mon, 18 June 2012 23:40 |
 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
