ORA-27101: shared memory realm does not exist Error

I'm hoping someone can help me here.  I've installed Oracle 8.1.7 on a Dual Xeon processer server running Win2K.  All I've currently got installed is the base operating system and now Oracle 8.1.7 Enterprise Edition.  I went through the Oracle installation successfully and opted to create the database later during the installation.  I then created then database using the database configuration assistant and this went through successfully.  I then logged successfully into DBA studio and created my BLOBS, 17 BLOBS at 2560MB per BLOB.  The problem now is that whenever I re-boot the server, I can't connect to the database, it states: ORA-27101: shared memory realm does not exist.  I have discovered a way to fix it, and that is to go into Database configuration assistant and run through the setup of the database again.

Please feel free to e-mail me at any time: barnesb@tpg.com.au


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ORA-27101: shared memory realm does not exist --> usually means that the Oracle db is down and needs to be restarted.  So when you reboot your server, you would need to start Oracle instance.
Check your database size. I hope it will be too large that the drive in which the database is present, may be full. Clear some files from the drive. Then try it out.


Have you tried to change the

If not, edit SQLNET.ORA under ORACLE_HOME\Network\Admin with notepad, and change



Reboot and it should work without any problem.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
barnesb1Author Commented:
Thank you very much for your help.  I modified that one file and it fixed my problem straight away.  Just wondering what modifying that entry means?  Either way your help is much appreciated.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.