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

Joshi:

Somewhat similar, only in our case the services never register with the listener and aren't visible from lsnrctl. If you force an MTS connection via the client's tnsnames.ora entry, you actually get a "Unable to locate service" type error. As a side note MTS does work fine for us in 8.1.6, it is in only 8.1.7 where this new behavioral problem is occurring.

Cheers!

--Roby

Joshi Rajanish wrote:

> 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
Received on Thu Nov 09 2000 - 05:52:35 CST