Weird listener behavior (9.2.0.4)
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: "Oracle DBA List (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 08:32:14 -0400
To All,
I've some really weird behavior coming form the Listener on one of our =
production boxes. To be fair we did add another instance to this box =
over the weekend. But once the listener is started and I try to connect =
to "franklin4", which is an old instance, I get connected instead to =
"franklin7" which is the one that just got added. Now this is also one =
of 5 instances on the server, but I still can't figure out why for the =
first 5 minutes that the listener is up it connects one to the right =
instance and then starts messing up. I'm appending our listener.ora =
file just in case someone can find a flaw in my ways.
################
# Filename......: listener.ora
# Name..........: franklin.world
# Date..........: 23-MAY-00 15:14:21
################
SQLNET.AUTHENTICATION_SERVICES =3D (NONE)
LOGGING_LISTENER =3D OFF
LOGGING_EXTPROC_LISTENER =3D OFF
USE_PLUG_AND_PLAY_LISTENER =3D OFF
USE_CKPFILE_LISTENER =3D OFF
LISTENER =3D
(ADDRESS_LIST =3D
(ADDRESS=3D
(PROTOCOL=3DIPC)
(KEY=3D franklin.world)
)
(ADDRESS=3D
(PROTOCOL=3DIPC)
(KEY=3D 02)
)
(ADDRESS =3D
(PROTOCOL =3D TCP)
(Host =3D franklin)
(Port =3D 1521)
)
)
extproc9_listener =3D
(address_list =3D
(address =3D
(protocol=3Dipc)
(key=3Dextproc9_agent)
)
)
STARTUP_WAIT_TIME_LISTENER =3D 0
CONNECT_TIMEOUT_LISTENER =3D 10
TRACE_LEVEL_LISTENER =3D OFF
SID_LIST_LISTENER =3D
(SID_LIST =3D
(SID_DESC =3D
(SDU=3D8192)(TDU=3D8192)
(GLOBAL_DBNAME =3D franklin.world)
(SID_NAME =3D 02)
(ORACLE_HOME =3D /ora1/81764)
(PRESPAWN_MAX =3D 10)
)
(SID_DESC =3D
(SDU=3D8192)(TDU=3D8192)
(GLOBAL_DBNAME =3D franklin4.world)
(SID_NAME =3D 04)
(ORACLE_HOME =3D /ora1/92)
(PRESPAWN_MAX =3D 10)
)
(SID_DESC =3D
(SDU=3D8192)(TDU=3D8192)
(GLOBAL_DBNAME =3D franklin5.world)
(SID_NAME =3D 05)
(ORACLE_HOME =3D /ora1/81764)
(PRESPAWN_MAX =3D 10)
)
(SID_DESC =3D
(SDU=3D8192)(TDU=3D8192)
(GLOBAL_DBNAME =3D franklin6.world)
(SID_NAME =3D 06)
(ORACLE_HOME =3D /ora1/81764)
(PRESPAWN_MAX =3D 10)
)
(SID_DESC =3D
(SDU=3D8192)(TDU=3D8192)
(GLOBAL_DBNAME =3D franklin7.world)
(SID_NAME =3D 07)
(ORACLE_HOME =3D /ora1/92)
(PRESPAWN_MAX =3D 10)
)
)
SID_LIST_EXTPROC9_LISTENER =3D
(SID_LIST =3D
(SID_DESC =3D
(SID_NAME =3D 10)
(ORACLE_HOME =3D /ora1/92)
(PROGRAM =3D extproc)
)
)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
