RE: all network connections hang

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-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Monday, December 18, 2000 9:01 AM
To: Multiple recipients of list ORACLE-L Subject: all network connections hang

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 Received on Mon Dec 18 2000 - 09:14:15 CST