Re: Oracle 8.0.6.2 MTS configuration..need help?

From: Dominica Leung <dominica_l_at_yahoo.com>
Date: 9 Aug 2002 11:37:16 -0700
Message-ID: <5f8af180.0208091037.414de66c@posting.google.com>

Hi Sybrand,

thanks a lot,
I got it work now, after I change the "LOCAL_LISTENER" lines in the initORACLE_SID.ora file.
I even do a
select server from V$session,
now it show "NONE", which is CORRECT.

Sorry, one question, the mts_dispatchers should be listenering on its own port right?
Not the same as the LISTENER.

Sorry my concept is NOT that clear, even I already read the "oracle admin guide, how to manage oracle process".

Dominica

mts_dispatchers="(ADDRESS=(HOST=dbserver1.company1.com)(PORT=1723)(PROTOCOL=TCP))"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=8

LOCAL_LISTENER="(ADDRESS_LIST = (Address = (Protocol = TCP)
(Host=dbserver1.company1.com) (Port=1523)) (Address=(Protocol = TCP)
(Key= db1.company1.com))

                                (Address = (Protocol = TCP)

(Host=dbserver1.company1.com) (Port=1524)) (Address=(Protocol = TCP)
(Key= db1.company1.com)))"

Now, when I do
lsnrctl services LISTENER3
lsnrctl service LISTENER4

LSNRCTL for Solaris: Version 8.0.6.2.0 - Production on 09-AUG-2002 18:34:04

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=dbserver1.company1.com)(Port=1523)) Services Summary...

  USRDEV                has 2 service handler(s)
    DEDICATED SERVER established:19 refused:0
      LOCAL SERVER
    DISPATCHER established:94 refused:0 current:14 max:254 state:ready
      D000 <machine: dbserver1.company1.com, pid: 3885>
      (ADDRESS=(PROTOCOL=tcp)(HOST=YYY.168.2.2)(PORT=1723))

The command completed successfully Received on Fri Aug 09 2002 - 13:37:16 CDT