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

Solaris 2.7, with all current patchsets recommended in the 8.1.7 release notes. If there is an MTS bug, I'm pondering the possibility that the 60-second connection delay was failover of a refused connection to another listener. Maybe try a 2-listener config and see what happens??

Suzy

Roby Sherman wrote:
>
> 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
Received on Thu Nov 09 2000 - 15:52:34 CST