Re: **ALERT** Serious Oracle 8.1.7 MTS bug

Dear Roby,
I think your talking about bug 777306 which I come accross on 8.1.5 on sun . Metalink has this bug record hope this is same bug your having.

Regards,
Rajanish Joshi

P.s They said they will fixed it in 8.1.6 but I thinks it will take more time :) Document from metalink follows

Hi,

 I'm trying to configuration our 8.1.5 instance to be MTS. Here are the MTS related entries in init.ora
 file:

 mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)" 
 mts_dispatchers = "(protocol=TCP)(HOST=sapdev)(PORT=1526)(SERVICE=PSAT)(DISP=4)" 
 mts_max_dispatchers = 5 
 mts_servers = 2 
 mts_max_servers = 20 

 Here is my listener.ora entries:
 LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = IPC)(KEY = PSAT))
 )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sapdev)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = sapdev)(PORT = 1526))
 )
 )
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)

 )
(ADDRESS = (PROTOCOL = TCP)(HOST = sapdev)(PORT = 2481))
 )
 )

 SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle)
(PROGRAM = extproc)

 )
(SID_DESC =
(GLOBAL_DBNAME = letter.econnections)
(ORACLE_HOME = /oracle)
(SID_NAME = letter)

 )
(SID_DESC =
(GLOBAL_DBNAME = PSAT.econnections)
(ORACLE_HOME = /oracle)
(SID_NAME = PSAT)

 )
 )

 And the tnsnames.ora file:
 LETTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sapdev)(PORT = 1521))
 )
(CONNECT_DATA =
(SERVICE_NAME = letter.econnections)

 )
 )

 PSAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sapdev)(PORT = 1526))
 )
(CONNECT_DATA =
(SERVICE_NAME = PSAT.econnections)

 )
 )

 EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
 )
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

 )
 )

 NOW, the server start up ok, but all connections to the PSAT instance are still DEDICATED!  Looking at the 'lsnrctl services' for PSAT:  Services Summary...
 PSAT has 6 service handler(s)
 DEDICATED SERVER established:0 refused:0  LOCAL SERVER
 DISPATCHER established:0 refused:0 current:0 max:254 state:ready  D000 <machine: sapdev, pid: 2462>
(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev)(PORT=43439))
 Presentation: oracle.aurora.server.SGiopServer  DISPATCHER established:0 refused:0 current:0 max:254 state:ready  D001 <machine: sapdev, pid: 2464>
(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev)(PORT=43440))
 DISPATCHER established:0 refused:0 current:0 max:254 state:ready  D002 <machine: sapdev, pid: 2466>
(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev)(PORT=43441))
 DISPATCHER established:0 refused:0 current:0 max:254 state:ready  D003 <machine: sapdev, pid: 2468>
(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev)(PORT=43442))
 DISPATCHER established:0 refused:0 current:0 max:254 state:ready  D004 <machine: sapdev, pid: 2470>
(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev)(PORT=43443))
 PSAT has 1 service handler(s)
 DEDICATED SERVER established:0 refused:0  LOCAL SERVER  it seemed like all the port numbers are wrong! How do I correct this p

 From: Oracle, Kalpana Malligere 07-Mar-00 21:16  Subject: Re : MTS Configuration Problem

 Hello,

 Looks like you are running into bug # 777306 with Abstract: LISTENER CONNECTS TO  DEDICATED EVEN WHEN MTS IS REQUIRED, fixed in V8.1.6.

 FYI: You can get the following articles by entering the search found on top of this page  NOTE:73141.1 - Configuring MTS in 8.1.5 Part 1, Overview of MTS  Note:73145.1 - Configuring MTS in 8.1.5 Part 2, SQL*Net/Net8

 Thanks!
 Kalpana
 Oracle Technical Support
Thursday, August 10, 2000