Home » RDBMS Server » Server Administration » TNS issues! strange!
TNS issues! strange! [message #202681] Fri, 10 November 2006 23:14 Go to next message
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 #202713 is a reply to message #202681] Sat, 11 November 2006 04:25 Go to previous messageGo to next message
KenJ
Messages: 69
Registered: July 2006
Location: London
Member
Hi,
Please post your listener.ora and sqlnet.ora. What version of Oracle are you using, OS etc etc.
Ken
Re: TNS issues! strange! [message #202716 is a reply to message #202681] Sat, 11 November 2006 04:39 Go to previous messageGo to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member

Hi Ken

Please find the desired files

# listener.ora Network Configuration File: /usr/app/oracle/product/XINFRA/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/app/oracle/product/XINFRA)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oberon.intranet.xchanging.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
=====================================================

# sqlnet.ora Network Configuration File: /usr/app/oracle/product/XINFRA/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT, ONAMES, HOSTNAME)
Re: TNS issues! strange! [message #202717 is a reply to message #202716] Sat, 11 November 2006 04:40 Go to previous message
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)
Previous Topic: Archivelog grows too fast
Next Topic: Regarding Segment Statistics
Goto Forum:
  


Current Time: Tue Dec 06 06:16:20 CST 2016

Total time taken to generate the page: 0.06558 seconds