Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

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

Thanks,

Brent
0
barnesb1
Asked:
barnesb1
1 Solution
 
srividyaramCommented:
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
 
ssaravanamoorthyCommented:
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
 
tarnaigyCommented:
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
 
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now