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..




rotocol adapter error
Reply With Quote