FAQ
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: John Dunn
INET: john.dunn_at_sefas.co.uk

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

Search Discussions

  • Jeremiah Wilton at Jul 19, 2001 at 8:39 pm
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 19, '01 at 3:54p
activeJul 19, '01 at 8:39p
posts2
users2
websiteoracle.com

2 users in discussion

Jeremiah Wilton: 1 post John Dunn: 1 post

People

Translate

site design / logo © 2022 Grokbase