ORA-01034 ORA-27101 ORACLE not available shared memory realm does not exist

**StryderKC** · 03-30-2009

On my test server I was installing a custom application which uses the Oracle Database as Backend. However My installation failed and I have contacted their support team. However my issue is that now even when I am trying to connect with plain SQL Plus into the Oracle Database I am getting this:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Now I did the basic troubleshooting and restarted Oracle service to make sure it is mounted correctly. But this is refusing to go away. It is interesting because there seems to be no issue with starting and shutting down oracle.

Any ideas?

Get a Free Complementary Copy of Oracle Magazine and other Free Magazines.

**simply_dba** · 03-30-2009

Log in administrator. Open cmd prompt. type sqlplus. Login / as sysdba (assuming u r using 9i or above). type startup. Post the results here.

**StryderKC** · 03-30-2009

Hmmm things just got wierder...

Code :

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 30 18:26:57 2009
Copyright (c) 1982, 2005, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
 
Connected to an idle instance.
SQL> startup nomount
ORA-00600: internal error code, arguments: [733], [538969648], [pga heap], [], [
], [], [], []
SQL>

Seems like i might need to raise an SR

**simply_dba** · 03-31-2009

Can you post the relevant contents of the alert log here ? Also first few paragraph of the trace file generated.

Edit:

Typically this error occurs when allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port. try lowering the following parameters and restart.
sort_area_size,hash_area_size.

Also, it may be that you have hit a bug (i found some relating to this). Better raise a SR with Oracle.

**Shekhar81** · 03-31-2009

The most common cause of the ORA-01034 ORA-27101 Problem is when the ORACLE_SID or ORACLE_HOME is not properly set. When you tried to start the database did you do so after configuring the SID like this

Code :

$ export ORACLE_SID=[your oracle SID]
or
$ setenv ORACLE_SID=[your oracle SID]

Remember that ORACLE_SID is case sensitive on unix like systems

**StryderKC** · 03-31-2009

Hi guys thanks for helping, really appreciate it. actually it seems the server was running out of resources because we rebooted the server and also disabled certain other services which were running. Now I can connect to the test server and the error is coming no more.

Thanks again.

**Nullset** · 06-07-2010

Originally Posted by simply_dba

Log in administrator. Open cmd prompt. type sqlplus. Login / as sysdba (assuming u r using 9i or above). type startup. Post the results here.

Ok first of all would like to say sorry not trying to hijack the thread, but at this very moment I'm having experiencing the same problem with the same error code which is ORA-27101: shared memory realm does not exist

when i try typing the command above, it says

Jun 7 10:19:07 scs0 scsi: [ID 107833 kern.notice] Requested Block: 156357552 Error Block: 156357552
Jun 7 10:19:07 scs0 scsi: [ID 107833 kern.notice] Vendor: SUN Serial Number: 5F24469F-00
Jun 7 10:19:07 scs0 scsi: [ID 107833 kern.notice] Sense Key: Hardware Error
Jun 7 10:19:07 scs0 scsi: [ID 107833 kern.notice] ASC: 0x0 (no additional sense info), ASCQ: 0x0, FRU: 0x0
Jun 7 10:19:07 scs0 scsi: [ID 107833 kern.warning] WARNING: /pci@1d,700000/scsi@1/sd@0,0 (sd31):
Jun 7 10:19:07 scs0 Error for Command: write(10) Error Level: Retryable

cmiiw, i assume that there is an error with the scsi hard disk?? by the look at the error on the bold error message?

**simply_dba** · 06-07-2010

Looks like you have hit a san level error. Oracle is trying to read a block through OS but it is not able to. Pass these error messages to your OS/hardware/SAN administrator and ask him/her what he/she has to say about these errors.