From: billr <robillardbNOroSPAM@psns.navy.mil.invalid>
Subject: Listener
Date: 2000/03/03
Message-ID: <10405393.507c3300@usw-ex0110-076.remarq.com>#1/1
Bytes: 1545
X-Originating-Host: 199.208.172.35
X-Complaints-To: wrenabuse@remarq.com
X-Trace: WReNphoon1 952109654 10.0.2.76 (Fri, 03 Mar 2000 10:54:14 PST)
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
NNTP-Posting-Date: Fri, 03 Mar 2000 10:54:14 PST
X-Wren-Trace: eLidtbSt6qDr6qOytPS1sLivqp2tr/a987q2rajirPG7/qng77b/5uz37erktvj6
Newsgroups: comp.databases.oracle.misc


Listener hangs/misbehaves after installing 7.3.4.5 database
upgrade.  We followed the instructions on the Oracle site
for upgrading to this patch release.

On one (Solaris) box with several instances (two using MTS,
two using Dedicated only) after making listener.ora change
for a new instance that was just upgraded to 7.3.4.5 we
started receiving 12500 error msgs saying that a dedicated
session could not be created on one of the other
instances.Could not create any dedicated sessions until
listener was stop/started - then everything seems to be ok.

On another (Solaris) box with three instances (one MTS and
two dedicated) we upgraded two of the instances to 7.3.4.5
and left the other one (the ded session guy who is at
7.2.2) alone.  Did not reload or stop/start the listener.
Things were ok for about 12 hour or so and then the most
active of the newest upgraded instances started having
problems.  No one could connect through MTS.  No alert
msgs, no trace files.  Sometimes, a connection WOULD go
throught but 99% wouldn't.  I stop/started the listener and
everything came back ok and has been ok.

Wondering if there is something peculiar about this patch
or should we have "automatically" assumed that we needed to
stop/start the listener after the upgrade.  We wonder if
there is some sort of problem that is going to come back
from time to time.


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful


