| 2 listener entry for one listener in production [message #316189] |
Thu, 24 April 2008 03:32  |
kesavansundaram
Messages: 183
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  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
