Re: immediate shutdown messages- when nothing being shutdown

Another instance (a standby, maybe?) is registering with the same SID/service name with your listener (via MTS or dedicated service registration).

Do a lsnrctl services on your listener, and find out which host/instance the unwanted registered instance is on, and eliminate references to the production host's listener address from the init.ora on that host.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 19 Jul 2001, John Dunn wrote:



> Users are complaining of getting the following messages Oracle PL/SQL Error

> Code : -1089 Error Description : Error in sleep - ORA-01089: immediate

> shutdown in progress - no operations are permitted

>

> ..even when there is no shutdown in progress...nothing in the alert log?

>

> Then the messages go away

>

> Whats going on?

>

> Oracle 8.1.6.2 on Solaris?


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