Re: MTS not workin ??

From: Ibrahim DOGAN <ibrahim.dogan_at_lowes.com>
Date: 19 Aug 2003 07:05:41 -0700
Message-ID: <33634314.0308190605.c13b00d@posting.google.com>

quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprt4djwoozkogxn_at_haydn>... ...
>
> All you should have is:
>
> mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=3)
> mts_servers=5
>
> You don't need a 'listener' parameter in the setting for dispatchers,
> because quite evidently, your listener runs tcp/ip on port 1521, and those
> are the defaults, and therefore the dispatchers will register themselves
> with that in any case. You only need all that other guff if your listener
> is not running tcp/ip, not on port 1521, or isn't called "listener".
>
> With that tidied up (and don't forget to bounce your instance), you need to
> make sure that the listener has recived registration details from the
> dispatchers:
>
> lsnrctl services
>

Ora version is 8.1.7
now i have only mts_servers and mts_dispatchers parameters as you specified...
i shutdown and restarted the instance..
stopped and started the listener..
when i do 'lsnrctl services', i get the following:   PLSExtProc has 1 service handler(s)     DEDICATED SERVER established:0 refused:0

      LOCAL SERVER
  PRACTICE              has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  RCAT          has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  mrdbdev               has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER

The instance i'm trying to configure as shared server is PRACTICE.. but lsnrctl still says it's DEDICATED... no idea what's going wrong here...

here is the listener.ora if it hepls:

LISTENER =
  (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = irm2)(PORT = 1521))   )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = mrdbdev)
      (ORACLE_HOME = /home/oracle)
      (SID_NAME = mrdbdev)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = PRACTICE
      (ORACLE_HOME = /home/oracle)
      (SID_NAME = PRACTICE)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = RCAT
      (ORACLE_HOME = /home/oracle)
      (SID_NAME = RCAT)

    )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF thanks for taking your time.. Received on Tue Aug 19 2003 - 09:05:41 CDT