|Database look like change to SUSPEND mode (Login only sys as sysdba allow) [message #608231]
||Mon, 17 February 2014 20:24
Registered: February 2014
Production DB look like change to SUSPEND mode (Login only sys as sysdba allow)|
I found this problem on production db. App can't use.
I test sqlplus on local DB. Normal user include system is authen (not show invalid user/psss)
and pending prompt return. Login by user "sys as sysdba" allow and can query only view such v$xxx.
Because of Production DB. I need DB working ASAP. I restart DB by shutdown immediate(hang), shutdown abort and startup
Can anyone suggest which way database automatic change to SUSPEND mode?
- I check at alert_SID.log, If we lauch command to change DB to suspend. It's will show in alert_SID.log
But in my problem is not show about this.
Other testing before decide DB look like SUSPEND mode:
- Set archivelog mode to manual archive, Leave redo filled by not switch log.
Result: DB Hang, But user login normal not same my problem
- Remove mount point of archive log dest, adump durning DB running.
Result: Warning show in alert_sid.log, But user login normal not same my problem
- Change DB to quiesced mode.
Result: Other user can't login. But system can login and query normal not same by problem
(Art: No Database User Can Login Except Sys And System because Resource Manager Internal_Quiesce Plan Enabled (Doc ID 396970.1)
So, I found nearly like our problem is Database Status change to SUSPEND mode.
My DB is 10.2.0.4 on Solaris10 Sparce,
I'm also check Server about free space, load on server during problem, network. If not found any abnormal.
Please help any suggestion.
Other posts about my problem:
[Updated on: Mon, 17 February 2014 20:26]
Report message to a moderator