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

in Oracle Database; On my test server I was installing a custom application which uses the Oracle Database as Backend. However My installation ...
+ Post Reply + Post New Topic
Results 1 to 8 of 8
  1. #1
    StryderKC is offline Junior Member
    Points: 320, Level: 6
    Join Date
    10 Feb 2009
    Posts
    10
    Points
    320

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

    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. #2
    simply_dba's Avatar
    simply_dba is offline Forum Advisor
    Points: 1,740, Level: 24
    Join Date
    13 Oct 2008
    Location
    Kolkata, India
    Posts
    95
    Points
    1,740

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

    Log in administrator. Open cmd prompt. type sqlplus. Login / as sysdba (assuming u r using 9i or above). type startup. Post the results here.
    Some of the world's greatest feats were accomplished by people not smart enough to know they were impossible.
    StryderKC says Thanks.

  3. #3
    StryderKC is offline Junior Member
    Points: 320, Level: 6
    Join Date
    10 Feb 2009
    Posts
    10
    Points
    320

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

    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

  4. #4
    simply_dba's Avatar
    simply_dba is offline Forum Advisor
    Points: 1,740, Level: 24
    Join Date
    13 Oct 2008
    Location
    Kolkata, India
    Posts
    95
    Points
    1,740

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

    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.
    Last edited by simply_dba; 03-31-2009 at 06:19 AM.
    Some of the world's greatest feats were accomplished by people not smart enough to know they were impossible.

  5. #5
    Shekhar81 is offline Junior Member
    Points: 390, Level: 7
    Join Date
    24 Nov 2008
    Posts
    16
    Points
    390

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

    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

  6. #6
    StryderKC is offline Junior Member
    Points: 320, Level: 6
    Join Date
    10 Feb 2009
    Posts
    10
    Points
    320

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

    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. #7
    Nullset is offline Junior Member
    Points: 10, Level: 1
    Join Date
    07 Jun 2010
    Posts
    1
    Points
    10

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

    Quote Originally Posted by simply_dba View Post
    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?

  8. #8
    simply_dba's Avatar
    simply_dba is offline Forum Advisor
    Points: 1,740, Level: 24
    Join Date
    13 Oct 2008
    Location
    Kolkata, India
    Posts
    95
    Points
    1,740

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

    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.
    Some of the world's greatest feats were accomplished by people not smart enough to know they were impossible.
    Nullset says Thanks.

Other Solutions
  1. Oracle not avail, ORA-01034 & ORA-27101
    By Popeye.Tom in forum Installation - Windows
    Replies: 2
    Last Post: 03-09-2011, 10:32 PM
  2. Memory leak in Oracle 10g 10.0.2.3
    By fisher in forum Oracle Database
    Replies: 1
    Last Post: 03-16-2010, 02:13 AM
  3. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
    By cluboracle.arun in forum Server Administration and Options
    Replies: 1
    Last Post: 07-08-2009, 07:42 PM
  4. ORA-00942 table or view does not exist Error in Oracle Forms
    By sakchennai in forum Oracle Forms and Reports
    Replies: 4
    Last Post: 07-08-2009, 10:02 AM