Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> MTS problems with NT 8.1.7.4 Standard Edition
After installing Oracle on a new machine I can't seem to get MTS
working - I've added the relevant lines to init.ora and although
querying several v$views would suggest it's working, I can't connect
when server=shared is specified in tnsnames.ora (I get ORA-12510:
TNS:listener could not find available handler for requested type of
server), no problems if its commented out. Any suggestions would be
appreciated (more details below, sorry if the output of the sql is
hard to read) and I know its unusual to use the ip address but this is
a cluster environment with fail over (a second machine picks up the
same ip address in the event of failure).
Thanks in advance
Dom
init.ora (partial)
distributed_transactions = 250
mts_dispatchers="(address=(protocol=tcp)(host=172.19.9.63))(dispatchers=4)"
compatible = 8.1.0
sort_area_size = 655360
sort_area_retained_size = 65536
listener.ora (full)
# LISTENER.ORA Network Configuration File:
C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.9.63)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.9.63)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.9.63)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP) (SESSION = RAW) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORA1)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = ORA1)
)
(SID_DESC =
(GLOBAL_DBNAME = ORA2)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = ORA2)
)
(SID_DESC =
(GLOBAL_DBNAME = ORA3)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = ORA3)
)
(SID_DESC =
(GLOBAL_DBNAME = DW1)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = DW1)
)
(SID_DESC =
(GLOBAL_DBNAME = datamdl)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = DATAMDL)
)
)
tnsnames.ora (client - partial)
ora2test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.9.63)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA2)
(server=shared)
)
)
Output from MTS related views
select * from v$parameter where name = 'mts_servers';
NUM NAME TYPE VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISMODIFIED ISADJUSTED DESCRIPTION 309 mts_servers 3 1 TRUE FALSE IMMEDIATE FALSE FALSE number ofservers to start up
select * from V$SHARED_SERVER
NAME PADDR STATUS MESSAGES BYTES BREAKS CIRCUIT IDLE BUSY REQUESTS S000 140135F4 WAIT(COMMON) 0 0 0 00 1518 0 0 select * from V$DISPATCHER NAME NETWORK PADDR STATUS ACCEPT MESSAGES BYTES BREAKS OWNED CREATED IDLE BUSY LISTENER CONF_INDX D000 (ADDRESS=(PROTOCOL=tcp)(HOST=172.19.9.63)(PORT=4534)) 1401391C WAIT YES 0 0 0 0 0 6953 0 0 0 D001 (ADDRESS=(PROTOCOL=tcp)(HOST=172.19.9.63)(PORT=4535)) 14013C44 WAIT YES 0 0 0 0 0 6922 0 0 0 D002 (ADDRESS=(PROTOCOL=tcp)(HOST=172.19.9.63)(PORT=4536)) 14013F6C WAIT YES 0 0 0 0 0 6891 0 0 0 D003 (ADDRESS=(PROTOCOL=tcp)(HOST=172.19.9.63)(PORT=4537)) 14014294 WAIT YES 0 0 0 0 0 6860 0 0 0Received on Tue May 13 2003 - 06:02:46 CDT