Weird listener behavior (9.2.0.4)

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 26 Apr 2004 08:32:14 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D8445@25exch1.vicorpower.vicr.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 07:29:28 CDT