-
Listener Problem
Dear all,
I have oracle9i in my home computer. I could not connect through oracle client. I tried to stop and start the listener. Here is the error message. How do i solve this prolem.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:
23
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
ORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Listener failed to start. See the error message(s) above...
LSNRCTL>
-
-
post the d:\oracle\ora92\network\admin\listener.ora
and d:\oracle\ora92\network\log\listener.log
-
d:\oracle\ora92\network\admin\listener.ora
================================
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
)
=========================================
d:\oracle\ora92\network\log\listener.log
=========================================
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:24:10
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=172
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:40:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=2804
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:40:13
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=2832
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:41:33
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=2584
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:47:04
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=164
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:10
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=1048
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:42
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=572
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:58:39
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=996
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:07:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=1624
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:07:30
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=332
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:26:55
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=1500
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:37:46
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Trace information written to d:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0
Started with pid=3248
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
-
you have two addrsss_lists
have something simple like this
Code:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
)
)
-
Code:
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Problem is with the Protocol - correct,save and run.
"What is past is PROLOGUE"
-
Hello,
I changed the listener content as you said. But still having the problem...
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
)
Here is the error message after changed the listener.ora as above.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Govindasamy>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-DEC-2005 10:27:
38
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
ORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Listener failed to start. See the error message(s) above...
LSNRCTL> sto
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
ORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Listener failed to start. See the error message(s) above...
LSNRCTL> STOP
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
ORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Listener failed to start. See the error message(s) above...
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> exit
C:\Documents and Settings\Govindasamy>lsnrctl
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-DEC-2005 10:39:
37
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is d:\oracle\ora92\network\admin\listener.ora
Log messages written to d:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
ORT=1521)))
TNS-12532: TNS:invalid argument
TNS-12560: TNSrotocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Listener failed to start. See the error message(s) above...
LSNRCTL>
The listener was working fine. Suddenly, it is started giving problem. Then reinstalled the oracle. but no luck..
-
Dear Dbasan,
You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.
-
Dear Dbasan,
You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.
-
Originally Posted by pranavgovind
Dear Dbasan,
You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.
Code:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
)
When you are editing these file be carefull take acopy before doing. Address parameter is not set right. Also it is better to use IP address in host instead of name. Good luck.
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|