Home » RDBMS Server » Server Administration » Database look like change to SUSPEND mode (Login only sys as sysdba allow) (DB 10.2.0.4, Solaris10 Sparc)
Database look like change to SUSPEND mode (Login only sys as sysdba allow) [message #608231] Mon, 17 February 2014 20:24 Go to next message
kittipong.at
Messages: 4
Registered: February 2014
Location: Thailand
Junior Member
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:
https://community.oracle.com/thread/3516488
http://www.orafaq.com/forum/m/607952/??SQ=&S=c420f7efdbc78955ae0ed9931806dbe2#msg_607952

Thank you

Best regards,

[Updated on: Mon, 17 February 2014 20:26]

Report message to a moderator

Re: Database look like change to SUSPEND mode (Login only sys as sysdba allow) [message #608232 is a reply to message #608231] Mon, 17 February 2014 20:45 Go to previous message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
http://docs.oracle.com/cd/B19306_01/server.102/b14231/start.htm#sthref614
Previous Topic: The doubts about column segment_file & relative_fno in v$sort_segment
Next Topic: Huge core file in ORACLE_HOME/dbs
Goto Forum:
  


Current Time: Sat Aug 23 05:10:54 CDT 2014

Total time taken to generate the page: 0.08358 seconds