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
>
> Thanks!
> Kalpana
> Oracle Technical Support
> Thursday, August 10, 2000
>
> __________________________________________________
> Do You Yahoo!?
> Thousands of Stores. Millions of Products. All in one Place.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joshi Rajanish
> INET: dbaoracle2000_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Wed Nov 08 2000 - 22:40:35 CST