RE: all network connections hang

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 18 Dec 2000 13:25:36 -0500
Message-Id: <10714.124856@fatcity.com>

This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages.

--=_98C391A2.A1C0AA08

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

So far only the 8.1.6.x databases have the problem, not our 7.3/8.6 = databases. Good thought though.

>>> "Aponte, Tony" <AponteT_at_hsn.net> 12/18/00 10:21:28 AM >>>
The same scenario happed to us last week. Research on Metalink pointed us to the listener.ora configuration file. We had EPC_DISABLED=3DTRUE set = for
pre-8.1.6 versions of the databases. Everything was running fine until = last
week and we haven't been able to determine any changes that would have triggered the problem. We don't plan to pursue it any mode since removing the parameter fixed the problem.

Hope it helps.

Tony

-----Original Message-----
Sent: Monday, December 18, 2000 9:01 AM
To: Multiple recipients of list ORACLE-L

As anyone seen this:

Two weeks ago on different servers, during the weekend ,an 8.1.6 production= =20
database started to refuse all network connections. Stopping and restarting= =20
the listener did not help. Stopping and restarting the database resolved = the

problem.
Today, upon arrivial I learned this time it was happening to one of our 8.1.6=20
development databases. This time, shutting down of the database was=20 unsuccessful (shutdown never completed). Messages in the alert.log for = the=20
shutdown as follows:

Shutting down instance (immediate)
License high water mark =3D 31
Mon Dec 18 07:46:22 2000
Errors in filee:\oracle\trace\ORA00488.TRC: ORA-27103: internal error
ORA-01089: immediate shutdown in progress - no operations are permitted

This is probably due to sessions trying to connect (this was an Oracle=20 Financials database) and the Concurrent Manager background tasks had = refused

shutdown, probably since could not connect to the database. Previous to this message were no other errors in the alert log so = Oracle=20
apparently did not realize it was having a problem. Other 8.1.6 databases on this same box continued to function so the = listener

appears to be okay.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Aponte, Tony
INET: AponteT_at_hsn.net

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

--=_98C391A2.A1C0AA08
Content-Type: text/plain
Content-Disposition: attachment; filename="TEXT.htm"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3207.2500" name=GENERATOR></HEAD>
<BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">So far

only the 8.1.6.x databases have the problem, not our 7.3/8.6 databases.  Good thought though. >>> "Aponte, Tony" <AponteT_at_hsn.net> 12/18/00 10:21:28 AM >>> The same scenario happed to us last week.  Research on Metalink pointed us to the listener.ora configuration file.  We had EPC_DISABLED=TRUE set for pre-8.1.6 versions of the databases.  Everything was running fine until last week and we haven't been able to determine any changes that would have triggered the problem.  We don't plan to pursue it any mode since removing the parameter fixed the problem. Hope it helps. Tony -----Original Message----- Sent: Monday, December 18, 2000 9:01 AM To: Multiple recipients of list ORACLE-L As anyone seen this: Two weeks ago on different servers, during the weekend ,an 8.1.6 production database started to refuse all network connections. Stopping and restarting the listener did not help. Stopping and restarting the database resolved the problem. Today, upon arrivial I learned this time it was happening to one of our 8.1.6 development databases. This time, shutting down of the database was unsuccessful (shutdown never completed). Messages in the alert.log for the shutdown as follows: Shutting down instance (immediate) License high water mark = 31 Mon Dec 18 07:46:22 2000 Errors in filee:\oracle\trace\ORA00488.TRC: ORA-27103: internal error ORA-01089: immediate shutdown in progress - no operations are permitted This is probably due to sessions trying to connect (this was an Oracle Financials database) and the Concurrent Manager background tasks had refused shutdown, probably since could not connect to the database. Previous to this message were no other errors in the alert log so Oracle apparently did not realize it was having a problem. Other 8.1.6 databases on this same box continued to function so the listener appears to be okay. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A> -- Author: Aponte, Tony   INET: AponteT_at_hsn.net Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing

Lists<BR>--------------------------------------------------------------------<BR>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 Received on Mon Dec 18 2000 - 12:25:36 CST