Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.6.2 MTS configuration..need help?
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 ---------------------
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:
(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>The command completed successfully
(ADDRESS=(PROTOCOL=tcp)(HOST=203.168.2.2)(PORT=1723))
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