Correction in solution
Bharat Balothia, June 30, 2011 - 11:07 pm UTC
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup open
Solution of this problem is not complete. The actual issue can come from if installation does not creates the correct pfile for the SID so create the correct SID pfile. See following.
oracle@ubuntu:/u01/app/oracle/admin/orcl$ cd pfile/
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$ ls
init.ora.530201143628
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$ view init.ora.530201143628
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$ cp init.ora.530201143628 initorc l.ora
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jun 30 20:56:31 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup open
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1301784 bytes
Variable Size 301990632 bytes
Database Buffers 327155712 bytes
Redo Buffers 5652480 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1301784 bytes
Variable Size 301990632 bytes
Database Buffers 327155712 bytes
Redo Buffers 5652480 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 11g Release 11.1.0.6.0 - Production
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$
oracle@ubuntu:/u01/app/oracle/admin/orcl/pfile$ cd ..
July 01, 2011 - 9:02 am UTC
this made no sense to me whatsoever. Not sure what you are trying to demonstrate.
Unless you are simply trying to say "if you have erased or otherwise moved your parameter file so we cannot find it, it will not work" - I would have thought that to be *obvious*
Basically, the error asked about means what I said it means above. Either your instance is not started (and it would be harder to start without a pfile or spfile - that is for sure, but not really relevant) OR your oracle_home/oracle_sid is improperly set.
G B, September 29, 2012 - 7:33 pm UTC
I found your code very useful. Below is the error message I got when I tried to log on. I then followed your instructions and it works. See the following:
SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 29 19:56:45 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name:
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup open
Solution of this problem is not complete. The actual issue can come from if installation does not
creates the correct pfile for the SID so create the correct SID pfile. See following.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1301784 bytes
Variable Size 301990632 bytes
Database Buffers 327155712 bytes
Redo Buffers 5652480 bytes
Database mounted.
Database opened.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1301784 bytes
Variable Size 301990632 bytes
Database Buffers 327155712 bytes
Redo Buffers 5652480 bytes
Database mounted.
Database opened.
SQL> quit
Then log back on using the username and password you created during the installation.
A reader, April 22, 2014 - 6:54 am UTC
thanka dude it's working
thankyou
A reader, November 23, 2015 - 9:14 am UTC
Thankyou so much its working now
Thank You So MUch
A reader, July 15, 2017 - 5:56 pm UTC
Hello,
Thank You so much for your solution.
my problem has fixed.
god bless you tom.
Sincerely.
All the code i've triend but still error
Firma Renando Hutagalung, June 21, 2019 - 9:11 am UTC
I still got error
c:\Users\HP>SQLPLUS
SQL-PLUS: Release 11.2.0.1.0 Production on Fri Jun 21 16:07:33 2019
Copyright (c) 1982, 2010. Oracle. All Right reserved.
Enter user-name: BUNDA
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
I've tried all i read on above but still error. Please help me to solve this problem. thank you so much
June 21, 2019 - 1:37 pm UTC
Check:
That the instance is running
You have set the ORACLE_HOME & ORACLE_SID variables correctly
A reader, September 13, 2020 - 10:47 am UTC
Thank you,
i have been searching for solution for long, finally got one ;)
Fixed it !
Manan, February 04, 2021 - 9:30 am UTC
Thanks man, this fixed it. You're a life-saver!
A reader, February 02, 2022 - 3:34 am UTC
Just Go With It... Perfectly working.. Thank youuu
February 02, 2022 - 4:23 am UTC
glad we could help
It may be ORA-00020 in disguise
K, July 13, 2022 - 3:46 pm UTC
Lack of connectivity do not must mean that SGA is down.
I found today that in case of exceeding mum number of processes remote connections may end up with ORA-27101: shared memory realm does not exist.
When I connect by sqlplus directly the server I was greeted with ORA-00020 witch was a true culprit of problem hiding behind "shared memory realm does not exist" error.