Database went in quiesce state?
I am on Oracle 11.1.1.0.7 on HP UNIX . This morning, I came to know no one could connect to database from application logins. Some of the application logins have sysdba role. I could however login to database from system and sys. I just restarted the database and problem went away.
I looked in alert.log to find root cause. I see a line that database in quiesce mode
Mon Sep 26 21:20:04 2011
LNS: Standby redo logfile selected for thread 1 sequence 4063 for destination LOG_ARCHIVE_DEST_2
Mon Sep 26 21:42:21 2011
Database in quiesce mode
I do see archive logs are still being generated afite 21:42 as shown in alert.log
. No one ran any alter database to put it in that mode. I do not know why it went in that mode (if it did). I would think if database was in that mode, when connecting to database, one will get a message that database was in that mode instead of just getting hung. Also, should login with sysdba privilege can login even when it is that mode. Appreciate any insight.