ORA-01034 And ORA-27101

August 23, 2009 at 7:49 am | Posted in Database | Leave a comment
Tags: Database

I woke up in morning, and turn on my notebook and wanna do my unfinished job, but I was surprised when the oracle send me a message

ORA-01034: ORACLE not available
ORA-27101: Shared memory realm does not exist

I dunno why I could not connect to Oracle Database Instance, cause yesterday night it was working nicely, I was trying to restart my Operating system and it didn’t make a change, so I looking for some help and found this solution:


ORA-01034: ORACLE not available 
Cause: Oracle was not started up. Possible causes include the following:- The SGA requires more space than was allocated for it.

- The operating-system variable pointing to the instance is improperly defined.
 
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.

The Solution was so simple, you just start the Oracle Instance Database Manually, because I was using Oracle 10 express , there was already menu on “start menu” Windows to start the Database Instance manually, and It was working again, thanks god