Home » RDBMS Server » Networking and Gateways » 2 listener entry for one listener in production (oracle 10g rel 2 / sun solaris 9)
2 listener entry for one listener in production [message #316189] Thu, 24 April 2008 03:32 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,
we have one serious listener problem in live env.
when i checked listener entry this morning, there were only one entry for my listener ( AS BELOW )

oracle@MPSPRD01:/oracle/Ora10>ps -ef | grep -i LIST
oracle10 1509 1 0 Apr 22 ? 125:39 /oracle/Ora10/10.2.0/Db_1/bin/tnslsnr LISTENER -inherit
oracle10 28487 19519 0 12:49:52 pts/5 0:00 grep -i LIST




but after 3 hours,
when i checked, i found 2 entries for one listener
( I HAVE TAKEN SCREEN SHOT, BUT IAM NOT ABLE TO ATTACH THAT FILE...) ...

actually along with abv entry, there is one more entry and it shows started time 09:39 today...but we did not start anything..



pls tell me what is the reason..
actually we killed the 2nd entry....
we need to know how again listener started....
how to suppress this ?

my listener.ora entry :
------------------
oracle@MPSPRD01:/oracle/Ora10>more listener.ora
# LISTENER.ORA Network Configuration File: /oracle/Ora10/10.2.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENERBO =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.2.24)(PORT = 1525))
)
)
)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.2.24)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/Ora10/10.2.0/Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = QRPRD)
(ORACLE_HOME = /oracle/Ora10/10.2.0/Db_1)
(SID_NAME = QRPRD)
)

(SID_DESC =
(GLOBAL_DBNAME = IPAUD)
(ORACLE_HOME = /oracle/Ora10/10.2.0/Db_1)
(SID_NAME = IPAUD)
)

)

SID_LIST_LISTENERBO =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = QRPRD)
(ORACLE_HOME = /oracle/Ora10/10.2.0/Db_1)
(SID_NAME = QRPRD)
)
)



tks/rgds
kesavan
Re: 2 listener entry for one listener in production [message #316213 is a reply to message #316189] Thu, 24 April 2008 05:09 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Listener file entries itself shows 2 listeners configured
1 - Default - Listener, 2 - LISTENERBO.

Are you telling that same listener (name), two entries ?
for "ps -aef" ? or in listener.ora ? Also same name two entries
is not correct and gives error while starting the listener.

Else you can check when this listener.ora file changed and log
($ORACLE_HOME/network/admin/listener.ora &
$ORACLE_HOME/network/log/listener.log )

Regards,

MSMallya

[Updated on: Thu, 24 April 2008 05:20]

Report message to a moderator

Re: 2 listener entry for one listener in production [message #316383 is a reply to message #316213] Thu, 24 April 2008 21:06 Go to previous message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

dear sir,
when i issue command ps -ef | grep -i LIST,
iam getting 2 entries for default listener LISTENER...
( not for LISTENERBO ).

i will check the log file for default listener and get back to you...

thank you
Previous Topic: lsnrctl hangs before and during installation
Next Topic: Problem with Listener in DB10g on Linux
Goto Forum:
  


Current Time: Fri Dec 09 17:15:11 CST 2016

Total time taken to generate the page: 0.23992 seconds