?
Solved

ORA-27101: shared memory realm does not exist Error

Posted on 2003-03-25
4
Medium Priority
?
481 Views
Last Modified: 2010-08-05
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

Thanks,

Brent
0
Comment
Question by:barnesb1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Expert Comment

by:srividyaram
ID: 8210640
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.
0
 

Expert Comment

by:ssaravanamoorthy
ID: 8210863
Hi,
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.

Bye,
Moorthy.
0
 

Accepted Solution

by:
tarnaigy earned 300 total points
ID: 8210948
Hi!

Have you tried to change the
SQLNET.AUTHENTICATION_SERVICES in the SQLNET.ORA file?

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

SQLNET.AUTHENTICATION_SERVICES = (NTS) to

SQLNET.AUTHENTICATION_SERVICES = NONE

Reboot and it should work without any problem.
0
 

Author Comment

by:barnesb1
ID: 8213822
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.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question