1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Server Administration and Options' started by StryderKC, Mar 30, 2009.

  1. StryderKC

    StryderKC Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    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?
     
  2. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    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 likes this.
  3. StryderKC

    StryderKC Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Hmmm things just got wierder...

    Code (Text):

    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
     
  4. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    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.
     
  5. Shekhar81

    Shekhar81 Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    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 (Text):

    $ export ORACLE_SID=[your oracle SID]
    or
    $ setenv ORACLE_SID=[your oracle SID]
     
    Remember that ORACLE_SID is case sensitive on unix like systems
     
  6. StryderKC

    StryderKC Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    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.
     
  7. Nullset

    Nullset Guest

    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?
     
  8. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    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.
     
    Nullset likes this.