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

Hi Roby,

We are also facing the similar problem with Oracle 8.1.7 on SunOS 5.8 The dispatcher processes are registered with the listener. However, when a shared server is requested the connection is denied with ORA-12520

Som

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Roby Sherman
Sent: Thursday, November 09, 2000 8:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: **ALERT** Serious Oracle 8.1.7 MTS bug

Suzy:

What version of Solaris are you on? Support hasn't been able to duplicate on their equipment with my parameter files so now I'm beginning to wonder about OS issues (or maybe a bad CD build. ugh.)

--Roby

Suzy Vordos wrote:

> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suzy Vordos
> INET: lvordos_at_datsit.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).

--
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