Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database in quiesce mode

user645399Oct 14 2010 — edited Oct 15 2010

How should I come out of this?

Suddenly I am seeing this message in the alert log after everyone complained that they couldn't do anything with the database?

I tried this

SQL> ALTER SYSTEM UNQUIESCE
  2  ;
ALTER SYSTEM UNQUIESCE
*
ERROR at line 1:
ORA-25502: concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running


SQL> v$blocking_quiesce
SP2-0734: unknown command beginning "v$blocking..." - rest of line ignored.
SQL> select * from v$blocking_quiesce
  2  ;

no rows selected

SQL> select active_state from V$INSTANCE
  2  ;

ACTIVE_ST
---------
QUIESCING

Thanks

Nith

Edited by: user645399 on Oct 15, 2010 10:50 AM

Edited by: user645399 on Oct 15, 2010 10:56 AM

This post has been answered by Srini Chavali-Oracle on Oct 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2010

Added on Oct 14 2010

#database-upgrade

3 comments

1,877 views