| ORA-27101: shared memory realm does not exist [message #12492] |
Sun, 23 May 2004 21:24  |
Riaz
Messages: 112
Registered: February 2002
|
Senior Member |
|
|
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
|
|
|
|
|
|
| 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 |
|
|
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.
|
|
|
|
| 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.
|
|
|
|
| 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.
|
|
|
|
| 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.
|
|
|
|
| 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...)
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| 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....
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
