Balasankar C

Balasankar C

Geek. Freedom. Privacy.

Home | Blog | Talks | Setup | Feed

Oracle not available : Shared memory realm doesnot exist

On opening sqlplus, I get the error:

“Oracle not available”
“Shared memory realm does not exist”

Solution done by me after searching Google:–

1.> In cmd type "sqlplus conn / as sysdba" without quotes

2.> startup nomount;
It shows the message

ORACLE instance started.

Total System Global Area (some value) bytes

Fixed Size (some value) bytes

Variable Size (some value) bytes

Database Buffers (some value) bytes

Redo Buffers (some value) bytes

3.>alter database mount;

4.> alter database open;

Now your data base is ready to use.

Courtesy :

I just posted it here because it will be easier for me to access if the error repeats...