| TNS issues! strange! [message #202681] |
Fri, 10 November 2006 23:14  |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Hi
I'm surprise the way my listiner working
I have chnaged my listener name from LISTENER to DLISTENER in listener.ora file,
Please go through follwoing lines, when I issue status DLISTENER it give me bizare error, but it seems Listener is working fine
please guide
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 10-NOV-2006 12:42:38
Uptime 0 days 16 hr. 1 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/app/oracle/product/XHRSDB_102g/network/admin/list ener.ora
Listener Log File /usr/app/oracle/product/XHRSDB_102g/network/log/listen er.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oberon.intranet.xchanging.com)(PORT= 1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XHRSDW" has 1 instance(s).
Instance "XHRSDW", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> stop LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> start DLISTENER
Starting /usr/app/oracle/product/XHRSDB_102g/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
System parameter file is /usr/app/oracle/product/XHRSDB_102g/network/admin/liste ner.ora
Log messages written to /usr/app/oracle/product/XHRSDB_102g/network/log/dlistene r.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oberon.intranet.xchangin g.com)(PORT=1522)))
TNS-01101: Could not find service name
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias DLISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 11-NOV-2006 04:46:57
Uptime 0 days 0 hr. 0 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/app/oracle/product/XHRSDB_102g/network/admin/listener.ora
Listener Log File /usr/app/oracle/product/XHRSDB_102g/network/log/dlistener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oberon.intranet.xchanging.com)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XHRSDW" has 1 instance(s).
Instance "XHRSDW", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status DLISTENER
TNS-01101: Could not find service name ÿÿ
LSNRCTL> status DLISTENER
TNS-01101: Could not find service name ÿÿ
LSNRCTL> status DLISTENER
TNS-01101: Could not find service name ÿÿ
LSNRCTL> stop DLISTENER
TNS-01101: Could not find service name ÿÿ
LSNRCTL> start DLISTENER
Starting /usr/app/oracle/product/XHRSDB_102g/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
System parameter file is /usr/app/oracle/product/XHRSDB_102g/network/admin/listener.ora
Log messages written to /usr/app/oracle/product/XHRSDB_102g/network/log/dlistener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Solaris Error: 125: Address already in use
Listener failed to start. See the error message(s) above...
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias DLISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 11-NOV-2006 04:46:57
Uptime 0 days 0 hr. 2 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/app/oracle/product/XHRSDB_102g/network/admin/listener.ora
Listener Log File /usr/app/oracle/product/XHRSDB_102g/network/log/dlistener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oberon.intranet.xchanging.com)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XHRSDW" has 1 instance(s).
Instance "XHRSDW", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
|
|
|
|
|
|
|
|
| Re: TNS issues! strange! [message #202717 is a reply to message #202716] |
Sat, 11 November 2006 04:40  |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Hi ken also find my oracle database listener.ora file
# listener.ora Network Configuration File: /usr/app/oracle/product/XHRSDB_102g/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_DLISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/app/oracle/product/XHRSDB_102g)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = XHRSDW)
(ORACLE_HOME = /usr/app/oracle/product/XHRSDB_102g)
(SID_NAME = XHRSDW)
)
)
DLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = oberon.intranet.xchanging.com)(PORT = 1522))
)
)
===========================================================
# sqlnet.ora Network Configuration File: /usr/app/oracle/product/XHRSDB_102g/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
