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

Hi Roby,

Until a few days ago, I had MTS running on Solaris & 8.1.7, with none of the errors you describe. However, I received some complaints about connection delays from Weblogic (which uses JDBC and manages it's own connection pools). I was told the delays were exactly 60 seconds, and didn't occur for all connections, just some of them.

Statistics from v$shared_servers, v$dispatchers, v$queue and v$circuit looked healthy. The MTS configuration was two listeners (1521 & 1526) queuesize=20, tnsnames.ora service_name with both ports, init.ora local_listener=service_name 4 dispatchers (1 ipc 3 tcp) and 4 servers.

No complaints until I implemented MTS, and no complaints since disabling it.

Suzy

Roby Sherman wrote:
>
> Hi everyone.
>
> I've been working a critical 8.1.7 bug most of the day that I thought
> you would give you a heads up on:
>
> The short of the story is that MTS is basically broken in Oracle 8.1.7.0
> on Solaris (don't know yet about NT or other Unix flavors).
>
> The longer explanation is that when the database starts up, it only
> registers the "local" service (dedicated) with the listener. The
> dispatchers never register with the listener, causing user connections
> to either 1> Connect to the database with a dedicated server connection
> (a problem that might not be noticed in development environments
> adopting the new release, but sure as heck could cripple some production
> environments) or be refused a connection because the listener could not
> locate the MTS service name.
>
> Oracle cannot find a bug (or subsequent patch) for this problem and
> there is no workaround at this time (short of using dedicated or
> downgrading back to 8.1.6)
>
> I'll have a bug# tomorrow (HOPEFULLY once support finds an 8.1.7
> instance to test on internally and reproduce the problem) for those of
> you who want to track the progress of this. In the meantime, I've had to
> pull 8.1.7 out of our deployment center and issue a bunch of
> internalized alerts. This may be the terminal release, but I'm letting
> our Enterprise adopt this version until we get a good patch set under
> our belts. :)
>
> In the meantime, if ANYONE has 8.1.7 on this or any other platform with
> the same or different results, please e-mail me. I'd like to get an idea
> if this is simply a Solaris issue or if this is more widespread.
>
> Cheers,
>
> --Roby
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roby Sherman
> INET: rxsherm_at_interealm.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
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Nov 09 2000 - 10:52:23 CST