ORA-27101: shared memory realm does not exist

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


Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible


you could be receive ORA-27101 because you tried to modify the database parameters such as SGA_MAX_SIZE size. You can try to bring back the original parameters.

C:\Documents and Settings\Administrator>sqplus /nolog

– SQL> conn / as sysdba;

– SQL> shutdown immediate;

– SQL> startup pfile=’D:\oracle\product\10.2.0\admin\wiapps\pfile\init.ora.112320071736′;

– SQL> create spfile from pfile;

– SQL> shutdown immediate;

– SQL> startup;

This logic is startup with pfile and copy oracle parameter in pfile to spfile, then startup with new spfile.


2 Responses

  1. Thanks for the information. Your blog is added to your bookmarks. Develop.
    Your reader.

  2. i can’t connect to new database that i create from ole database in drive c (new database in drive d) that occure this error. i have to check
    1.oracle_sid= OK
    2.tnsping OK
    3.pfile & controlfile was modified OK
    please help.
    thank a lot, Akamon

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: