Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist followed by ORA-01017 (Oracle Enterprise Linux 4.5 and Oracle 11g)
ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist followed by ORA-01017 [message #405605] Thu, 28 May 2009 10:00 Go to next message
Chaka1313
Messages: 1
Registered: May 2009
Location: Cambridge, Ontario
Junior Member
Hi all!

I have been racking my brain trying to get this setup to work. Here is a run down of my issue...

I have set all the environment variables, created a user with DBA privileges and when I go to log in to sqlplus / as sysdba, here is what I get...

SAdmin@localhost bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu May 28 10:37:24 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

I try loging in then as sys and enter the password and here is what I get...

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

I've made several attempts at making sure that the ORACLE_SID, ORACLE_HOME and PATH are all set correctly. I'm quite sure that the DB is not running, but I have no way of getting past all this to try and start it up. (And oh how I've tried!) the only way I can get in is through sqlplus /nolog but I get insufficient privileges when I try to start up the DB.

ANY help would be greatly appreciated!!!

Re: ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist followed by ORA-0 [message #405609 is a reply to message #405605] Thu, 28 May 2009 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please search BEFORE posting this has been asked many and many and many times and not so far than yesterday.

In addition, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist followed by ORA-0 [message #405701 is a reply to message #405605] Fri, 29 May 2009 02:23 Go to previous message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
Properly export the oracle_sid you might be having multiple database and also check tnsnames.ora file for the same.
Previous Topic: Wait event still prevailing
Next Topic: No more data to read from socket
Goto Forum:
  


Current Time: Tue Jul 02 22:42:07 CDT 2024