OraFAQ Forum: SQL & PL/SQL » ORA-27101: shared memory realm does not exist

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-27101: shared memory realm does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27101: shared memory realm does not exist [message #12492]

Sun, 23 May 2004 21:24

Riaz
Messages: 112
Registered: February 2002

Senior Member

Code: [Select all] [Show/ hide]

Hi all
I am using oracle 8i, on windows 2000. I suddently got this error.

dbsnmp.exe has generated errors and will be closed by windows. You will need to restart the program.
An error log has been created.

Error:

ORA-01034: ORACLE not available.

ORA-27101: shared memory realm does not exist

Please help........ I have very important data in the database.....

Riaz

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #12496 is a reply to message #12492]

Mon, 24 May 2004 03:24

Barbara Boehmer
Messages: 9105
Registered: November 2002
Location: California, USA

Senior Member

Did you try re-starting your computer? If that doesn't work, here are a few things to check:

Try checking to see that you have enough space in memory and hard drive. Have you installed anything recently that took more space or added too much data for the space that you have? Have you changed anything in Oracle recently, especially in your parameter files? How were you trying to connect when you received the errors? Does it happen when you connect to any account? Were you logged in as a different operating system user than usual?

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #12498 is a reply to message #12496]

Mon, 24 May 2004 03:33

Riaz
Messages: 112
Registered: February 2002

Senior Member

Code: [Select all] [Show/ hide]

Yes, I restarted my computer but it didnt work.
I have 256 MB of RAM and almost 4 GB free space on the drive. 
neither I have installed something nor have changed any parameter files. 
I tried to conn scott/tiger. But before connecting when windows2000 starts it  also shows the message. 
I am connecting as usual account.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #12501 is a reply to message #12498]

Mon, 24 May 2004 04:30

Barbara Boehmer
Messages: 9105
Registered: November 2002
Location: California, USA

Senior Member

Do you get a shared memory realm error or anything similar when you try to run things other than Oracle? I am asking this in order to try to determine whether the problem is related only to Oracle or to your computer in general. You might also try one more re-start, wait a few minutes to make sure that Oracle has had sufficient time to start the database, shut down anything else, including e-mail and internet stuff, that might be consuming resources, then see if you still have the problem. I have received this message on occasion myself and was able to resolve it by freeing disk space and memory. Sometimes, there are things consuming memory, such as automatic McAfee and other updates, while you are connected to the Internet.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #12503 is a reply to message #12501]

Mon, 24 May 2004 05:19

Riaz
Messages: 112
Registered: February 2002

Senior Member

All other programs on my PC are running smoothly. The PC is not connected to the internet neither have installed antivirus on. I have tried to restart the computer about 7 times and have waited enough to start all services.. but the problem remains.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13037 is a reply to message #12501]

Sat, 19 June 2004 01:23

dit
Messages: 1
Registered: June 2004

Junior Member

Hi,
You have just to open a DOS session and type
svrmgrL
connect system/<system's password>@ <db name> as sysdba
startup

After these commands your database is available and you can use Sql+ for example to connect to your database.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13394 is a reply to message #12503]

Sun, 11 July 2004 23:15

Andris
Messages: 2
Registered: July 2004

Junior Member

If you're running Oracle 8.1.7 then you might need to upgrade to 8.1.7.4 (fix release). I had a similar problem with shared memory, and that was a known problem in that version. Now I'm having the same problem as you... (But I don't have that update release here...)

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13424 is a reply to message #13394]

Mon, 12 July 2004 11:42

Aaron
Messages: 13
Registered: January 2002

Junior Member

I just had the same problem, we have oracle 9i installed. We put more RAM in the server and it fixed the problem. I would shutdown all not needed services on your PC to free up memory. Our problem came about after adding a database thus creating too large of a memory load.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13459 is a reply to message #13424]

Tue, 13 July 2004 12:24

Andris
Messages: 2
Registered: July 2004

Junior Member

No no no, the simple solution (if you are running 8.1.7.1 to .3) is to install 8.1.7.4, which currects this known BUG. Hope it helps.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13460 is a reply to message #12492]

Tue, 13 July 2004 12:45

Aaron
Messages: 13
Registered: January 2002

Junior Member

We are running 9i so that doesn't apply, either way it fixed the problem.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13531 is a reply to message #12492]

Thu, 15 July 2004 20:28

sudo
Messages: 1
Registered: July 2004

Junior Member

I got the similar problem, when I tried to configure domain controller and then install oracle 8i.....
The solution we tried is configure the server in workgoup mode and install oracle 8i...it works fine...or as one of the gentleman suggested...in case of above problem you can start the database in DOS mode svrmgrl program and manual database startup....

Hopefully we should try using oracle 8.1.7.4 upgrade version....

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13533 is a reply to message #13531]

Thu, 15 July 2004 22:29

M.Ramzan
Messages: 1
Registered: July 2004

Junior Member

Need your help to solve this error problem, when we try to connect to oracle database 8i in windows2000 server (oracle services and listener is running and working).
:
: ERROR:
: ORA-01034: ORACLE not available
: ORA-27101: shared memory realm does not exist

: Thanks

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13620 is a reply to message #13037]

Tue, 20 July 2004 05:09

Oracle Newb
Messages: 1
Registered: July 2004

Junior Member

I had the same issue,

Works like a charm!

Thanks much

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13772 is a reply to message #13459]

Tue, 27 July 2004 06:46

Rubin
Messages: 1
Registered: July 2004

Junior Member

I'm running oracle 8.1.7 and i solved the problem changing some memory values on init.ora file:
shared_pool_size and large_pool_size
Hope it helps.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #13899 is a reply to message #12492]

Sun, 01 August 2004 22:27

ramkrihna g
Messages: 1
Registered: August 2004

Junior Member

same problem searched a lot.
tried many option.
i am using windows 200o pro.
oracle 9i

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #15859 is a reply to message #13037]

Thu, 28 October 2004 14:17

Kelly
Messages: 9
Registered: January 2002

Junior Member

Where/what is this svrmgrL? What is the exact syntax to run it? I tried to run it in dos, but it can't find it. I am running Oracle 9i on Windows 2000 SP 4.

Many thanks!

PS - This issue came up for me after running dbms_stats.

Report message to a moderator

Previous Topic:	Joins
Next Topic:	Is it possible to view the syntax of procedure created

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 04 00:25:49 CDT 2025