ORA-27101: shared memory realm does not exist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-27101: shared memory realm does not exist

  1. #1
    Join Date
    Jun 2012
    Posts
    3

    ORA-27101: shared memory realm does not exist

    Okay, so I have spent over 2 days trying to fix this problem. I have googled the issue, searched the archives of various forums, as well as read the documentation on oracle's website. At this point I am lost.


    I am running Oracle Database 11g Release 2 EXPRESS EDITION. I am running Fedora 17 in Oracle's VirtualBox. The client I am attempting to connect to the server with is SQLDeveloper, and I am using the latest version of it.

    When I am logged in as root, these are two of the many lines I have when I type "export" in the shell:

    declare -x ORACLE_HOME="/u01/app/oracle/product/11.2.0/xe"
    declare -x ORACLE_SID="PLSExtProc"

    Some other things to know:

    [root@zeke admin]# uname -a
    Linux zeke 3.3.4-5.fc17.x86_64 #1 SMP Mon May 7 17:29:34 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

    [root@zeke admin]# ls /u01/app/oracle/product/11.2.0/xe/network/admin
    listener.ora samples tnsnames.ora

    (these are the only files + one directory in that particular folder)

    And here are the contents of both the .ora files:
    [root@zeke admin]# cat listener.ora

    # listener.ora Network Configuration File:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)

    # tnsnames.ora Network Configuration File:

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    And lastly, here is the content of the sqldeveloper.sh file:

    [root@zeke admin]# cat /opt/sqldeveloper/sqldeveloper.sh
    #!/bin/bash
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    ORACLE_SID=PLSExtProc
    export ORACLE_HOME
    export ORACLE_SID
    cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*

    Please let me know if I need to provide any other information. Thank you.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    You should not run an Oracle database as root, you should run it as the oracle user.


    Try doing the following at a command prompt and post the results.

    Code:
    ps -ef | grep dbw0
    this space intentionally left blank

  3. #3
    Join Date
    Jun 2012
    Posts
    3
    Hello gandolf,

    Thank you very much for our reply. I ran the oracle daemon as root, but all the relevant programs are running under the oracle user nonetheless. Does it make a difference in that case? Also, here is the result from the command you told me to execute:

    [zeke@zeke bin]$ ps -ef | grep dbw0
    oracle 12804 1 0 04:39 ? 00:00:00 xe_dbw0_XE
    zeke 13453 11461 0 04:54 pts/1 00:00:00 grep --color=auto dbw0

    Please let me know if there is anything else I can do to be helpful or useful.

    Much appreciated,

    ezekielg

  4. #4
    Join Date
    Jun 2012
    Posts
    3
    Oh, by the way gandolf989, I apologize in advanced for this (and to any other people reading this thread), but here is some other information that I thought might help. I'm not sure how relevant it is, but just to show everything is running:

    Code:
    [zeke@zeke bin]$ ./tnsping xe
    --- SNIP ---
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
    OK (0 msec)

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    Log in as the oracle user. and do the following:

    . /usr/local/bin/oraenv
    xe

    then try this:

    sqlplus '/as sysdba'

    select instance_name, host_name, status from v$instance;

    and you will have your answer.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width