OraFAQ Forum: Networking and Gateways => 2 listener entry for one listener in production

Members

Help

Home

Home » RDBMS Server » Networking and Gateways » 2 listener entry for one listener in production (oracle 10g rel 2 / sun solaris 9)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

2 listener entry for one listener in production [message #316189]

Thu, 24 April 2008 03:32

kesavansundaram
Messages: 38
Registered: October 2007
Location: MUMBAI

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

Report message to a moderator

Re: 2 listener entry for one listener in production [message #316213 is a reply to message #316189 ]

Thu, 24 April 2008 05:09

msmallya
Messages: 56
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

kesavansundaram
Messages: 38
Registered: October 2007
Location: MUMBAI

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 15:22:21 CDT 2008

Total time taken to generate the page: 0.07791 seconds

.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.