Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.6.2 MTS configuration..need help?

Oracle 8.0.6.2 MTS configuration..need help?

From: Dominica Leung <dominica_l_at_yahoo.com>
Date: 8 Aug 2002 17:01:16 -0700
Message-ID: <5f8af180.0208081601.7661d6e5@posting.google.com>


Hi All,

I am trying to setup MTS on oracle 8.0.6.2 (32 bits) on Solaris 2.6 platform.

My initORACLE_SID.ora is like:


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

---------------------

My listener.ora is like:

LISTENER3 =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= db1.company1.com)(Port= 1523))   )
SID_LIST_LISTENER3 =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME= db1.company1.com)
(ORACLE_HOME= /company1/oracle/product/8.0.6)
(SID_NAME = USRDB1)

    )
  )

STrange thing is:

When I do a test connection by sqlplus testuser/testuser_at_WHATEVER

and then I do a
select server, username from V$session where username = 'testuser',

it says "DEDICATED".

I just don't get it.

WHen I run this command: lsnrctl services:



LSNRCTL for Solaris: Version 8.0.6.2.0 - Production on 08-AUG-2002 23:57:49

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    Solaris Error: 2: No such file or directory Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=db1.company1.com)) Services Summary...

  DB2                has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  USRDB1               has 1 service handler(s)
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
      D000 <machine: db1.company1.com, pid: 3096>

(ADDRESS=(PROTOCOL=tcp)(HOST=203.168.2.2)(PORT=1723))
The command completed successfully

Basically from the lsnrctl service command, I saw "USRDB1", the one I care about, has a DISPATCHER running??

I did read Oracle's admin guide and
oracle's certification exam book about how to set up MTS, and also try to find whether Oracle has a DOC # for configuration of MTS on 8.0.6.2.

I only find the one for 8.1.7.

Just quite confuse now.

Thanks in advance,

Dominica Received on Thu Aug 08 2002 - 19:01:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US