Database Administration (MOSC)

MOSC Banner

Oracle Instance/Process stuck - will not shutdown

edited April 2012 in Database Administration (MOSC) 9 commentsAnswered ✓
AIXOracle 11.1.0.7

  Have a DB/Instance that is stuck will not shutdown, but is not truly running.

I see MMON,MMNL,SMON,PSP0,LGWR,DBW0,MMAN,PMON,DIA0,DBRM,VKTM,DIAG,GEN0,and CKPT process in AIX

ps -ef|grep SID

  However, if logon to SQLPLUS on server and try to shutdown immediate or abort will not shut down. 

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory

At first, DBUA would not see it (trying to upgrade it to 11.2.0.3) - message DB is not mounted.

Tried STARTUP/SHUTDOWN, but would never see it.  Sounds like something is stuck.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center