This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Dec 12, 2012 5:37 AM by EdStevens RSS

ORA-01034  shared memory realm does not exist

PVOWUSU Newbie
Currently Being Moderated
Hi Gurus,

The following error was encountered when connecting to 11g database:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

The database is Opened but cannot connect to it. Below are the parameters in the init file:

CTSLIVE.__db_cache_size=4563402752
CTSLIVE.__java_pool_size=67108864
CTSLIVE.__large_pool_size=67108864
CTSLIVE.__oracle_base='/ORACLE/u01/app/oracle'#ORACLE_BASE set from environment^M
CTSLIVE.__pga_aggregate_target=4093640704
CTSLIVE.__sga_target=6039797760
CTSLIVE.__shared_io_pool_size=0
CTSLIVE.__shared_pool_size=1275068416
CTSLIVE.__streams_pool_size=0
*.audit_file_dest='/ORACLE/u01/app/oracle/admin/CTSLIVE/adump'
*.audit_trail='none'
*.compatible='11.2.0.0.0'
*.control_files='/ORACLE/u01/app/oracle/oradata/CTSLIVE/control01.ctl','/USERS/CONTROL_FILE/control02.ctl','/home/oracle/CONTROL_FILE/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='CTSLIVE'
*.diagnostic_dest='/ORACLE/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CTSLIVEXDB)'
*.log_archive_dest_1='LOCATION=/DATA'
*.log_archive_format='ctslive_%t_%s_%r.arc'
*.memory_target=10099884032
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'


Total memory size on server is *24659996 kB*.

Your help will be appreciated.

Thank you.
  • 1. Re: ORA-01034  shared memory realm does not exist
    sb92075 Guru
    Currently Being Moderated
    PVOWUSU wrote:
    Hi Gurus,

    The following error was encountered when connecting to 11g database:

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory

    The database is Opened but cannot connect to it. Below are the parameters in the init file:
    I don't believe you.
    post proof that DB is up & online.

    What clues exist within alert_SID.log file?


    Handle:     PVOWUSU
    Status Level:     Newbie
    Registered:     Aug 30, 2010
    Total Posts:     98
    Total Questions:     34 (25 unresolved)

    why so MANY unanswered questions?
  • 2. Re: ORA-01034  shared memory realm does not exist
    PVOWUSU Newbie
    Currently Being Moderated
    Thanks for your response. Find below the proof:



    SQL> conn /as sysdba
    Connected to an idle instance.
    SQL> startup pfile='/tmp/pfile_new.ora';
    ORACLE instance started.

    Total System Global Area 1.0088E+10 bytes
    Fixed Size 2215984 bytes
    Variable Size 5502930896 bytes
    Database Buffers 4563402752 bytes
    Redo Buffers 19640320 bytes
    Database mounted.
    Database opened.
    SQL> select open_mode from v$database;

    OPEN_MODE
    --------------------
    READ WRITE

    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    CTSLIVE




    SQL> conn ctslive@CTSLIVE
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory

    NOTE: connecting to the database on the server works fine but when connecting remotely using tns causes the above error.
  • 3. Re: ORA-01034  shared memory realm does not exist
    sb92075 Guru
    Currently Being Moderated
    PVOWUSU wrote:
    Thanks for your response. Find below the proof:



    SQL> conn /as sysdba
    Connected to an idle instance.
    SQL> startup pfile='/tmp/pfile_new.ora';
    ORACLE instance started.

    Total System Global Area 1.0088E+10 bytes
    Fixed Size 2215984 bytes
    Variable Size 5502930896 bytes
    Database Buffers 4563402752 bytes
    Redo Buffers 19640320 bytes
    Database mounted.
    Database opened.
    SQL> select open_mode from v$database;

    OPEN_MODE
    --------------------
    READ WRITE

    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    CTSLIVE




    SQL> conn ctslive@CTSLIVE
    above OBVIOUSLY directs to different DB
    I suspect problem involving some tnames.ora file entry

    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory

    NOTE: connecting to the database on the server works fine but when connecting remotely using tns causes the above error.
  • 4. Re: ORA-01034  shared memory realm does not exist
    jgarry Guru
    Currently Being Moderated
    This most likely means you are not setting ORACLE_SID correctly. Check your oratab, all tnsnames.ora all .profile .bashrc /etc/profile /etc/bashrc and similar files, including system startup files.
  • 5. Re: ORA-01034  shared memory realm does not exist
    PVOWUSU Newbie
    Currently Being Moderated
    Below is a screen shoot of sqlpus connection to the db on the server hope that helps:

    [oracle@ABG-CTSDB-01 ~]$ sqlplus /nolog

    SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 11 21:45:55 2012

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    SQL> conn /as sysdba
    Connected.
    SQL>
    SQL>
    SQL> conn ctslive
    Enter password:
    Connected.
    SQL>
    SQL> conn ctslive@ctslive
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0


    Warning: You are no longer connected to ORACLE.
    SQL>
  • 6. Re: ORA-01034  shared memory realm does not exist
    VijayaraghavanKrishnan Pro
    Currently Being Moderated
    Hi,

    Post you listener and tnsnames file. We hope that the below one is looking for a different server.
    conn ctslive@ctslive
    Try connecting without "@CTSLIVE" provided if you set the ORACLE_SID before starting sqlplus

    Thanks,
    Vijay

    Edited by: Vijayaraghavan Krishnan on Dec 11, 2012 3:57 PM

    Edited by: Vijayaraghavan Krishnan on Dec 11, 2012 3:58 PM

    Edited by: Vijayaraghavan Krishnan on Dec 11, 2012 4:02 PM
  • 7. Re: ORA-01034  shared memory realm does not exist
    fosterk Explorer
    Currently Being Moderated
    From UNIX prompt try: tnsping ctslive
  • 8. Re: ORA-01034  shared memory realm does not exist
    PVOWUSU Newbie
    Currently Being Moderated
    TNS PING
    ---------
    [oracle@ABG-CTSDB-01 admin]$ tnsping ctslive

    TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 11-DEC-2012 22:48:33

    Copyright (c) 1997, 2009, Oracle. All rights reserved.

    Used parameter files:
    /ORACLE/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    )SERVICE_NAME = ctslive)CP)(HOST = 10.236.8.91)(PORT = 1521))
    OK (0 msec)


    SQL> conn /as sysdba
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 1.0088E+10 bytes
    Fixed Size 2215984 bytes
    Variable Size 5502930896 bytes
    Database Buffers 4563402752 bytes
    Redo Buffers 19640320 bytes
    Database mounted.
    Database opened.
    SQL> conn ctslive@CTSLIVE
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0


    Warning: You are no longer connected to ORACLE.
    SQL> conn ctslive@ctslive
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0







    listener confi:

    # listener.ora Network Configuration File: /ORACLE/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.



    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /ORACLE/u01/app/oracle/product/11.2.0/db_1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ctslive)
    (ORACLE_HOME = /ORACLE/u01/app/oracle/product/11.2.0/db_1)
    (SID_NAME = ctslive)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ABG-CTSDB-01)(PORT = 1521))
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.236.8.91)(PORT = 1521))
    )
    )


    ADR_BASE_LISTENER = /ORACLE/u01/app/oracle




    -----------

    tns entries




    # tnsnames.ora Network Configuration File: /ORACLE/product/10.2.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.



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

    FCRLIVE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.0.88)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = fcrlive)
    )
    )
    ctslive =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.236.8.91)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ctslive)
    )
    )
  • 9. Re: ORA-01034  shared memory realm does not exist
    sb92075 Guru
    Currently Being Moderated
    post the results of the following OS commands

    id
    env | sort
    lsnrctl status
    lsnrctl service
    uname -a
    cat /etc/hosts
    /sbin/ifconfig
    hostname
    ps -ef | grep -i pmon
    cat $ORACLE_HOME/network/admin/tnsnames.ora


    COPY the results from commands above then PASTE all back here
  • 10. Re: ORA-01034  shared memory realm does not exist
    VijayaraghavanKrishnan Pro
    Currently Being Moderated
    Hi,

    Try connecting to oracle using this.
    sqlplus ctslive/PASSWORD@//10.236.8.91:1521/ctslive
    Do not try the instance name in CAPS, try out in same case as in listener.

    Thanks,
    vijay
  • 11. Re: ORA-01034  shared memory realm does not exist
    PVOWUSU Newbie
    Currently Being Moderated
    [oracle@ABG-CTSDB-01 admin]$ id
    uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper)
    [oracle@ABG-CTSDB-01 admin]$




    [oracle@ABG-CTSDB-01 admin]$ env|sort
    _=/bin/env
    CLASSPATH=/ORACLE/u01/app/oracle/product/11.2.0/db_1/jlib:/ORACLE/u01/app/oracle/product/11.2.0/db_1/rdbms/jlib
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=ABG-CTSDB-01
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LD_LIBRARY_PATH=/ORACLE/u01/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
    MAIL=/var/spool/mail/oracle
    ORACLE_BASE=/ORACLE/u01/app/oracle
    ORACLE_HOME=/ORACLE/u01/app/oracle/product/11.2.0/db_1
    ORACLE_HOSTNAME=ABG-CTSDB-01
    ORACLE_SID=CTSLIVE
    ORACLE_UNQNAME=CTSLIVE
    PATH=/ORACLE/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
    PWD=/ORACLE/u01/app/oracle/product/11.2.0/db_1/network/admin
    SHELL=/bin/bash
    SHLVL=2
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=10.236.9.114 59920 22
    SSH_CONNECTION=10.236.9.114 59920 10.236.8.91 22
    SSH_TTY=/dev/pts/5
    TERM=vt100
    TMPDIR=/tmp
    TMP=/tmp
    USER=oracle
    [oracle@ABG-CTSDB-01 admin]$



    [oracle@ABG-CTSDB-01 admin]$ lsnrctl services

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-DEC-2012 23:41:25

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.236.8.91)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "ctslive" has 1 instance(s).
    Instance "ctslive", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:15 refused:0
    LOCAL SERVER
    The command completed successfully
    [oracle@ABG-CTSDB-01 admin]$



    [oracle@ABG-CTSDB-01 admin]$ lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-DEC-2012 23:42:45

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.236.8.91)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date 11-DEC-2012 18:40:21
    Uptime 0 days 5 hr. 2 min. 23 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /ORACLE/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
    Listener Log File /ORACLE/u01/app/oracle/diag/tnslsnr/ABG-CTSDB-01/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.236.8.91)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "ctslive" has 1 instance(s).
    Instance "ctslive", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    [oracle@ABG-CTSDB-01 admin]$



    [oracle@ABG-CTSDB-01 admin]$ uname -a
    Linux ABG-CTSDB-01 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux



    [oracle@ABG-CTSDB-01 admin]$ cat /etc/hosts
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1 ABG-CTSDB-01 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6
    10.236.8.91 ABG-CTSDB-01.ghana.accessbankplc.com ABG-CTSDB-01




    [oracle@ABG-CTSDB-01 admin]$ /sbin/ifconfig
    eth0 Link encap:Ethernet HWaddr E4:1F:13:6C:EA:CC
    inet addr:10.236.8.91 Bcast:10.236.8.255 Mask:255.255.255.0
    inet6 addr: fe80::e61f:13ff:fe6c:eacc/64 Scope:Link
    UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
    RX packets:3207770 errors:0 dropped:0 overruns:0 frame:0
    TX packets:5660980 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:1000
    RX bytes:255728528 (243.8 MiB) TX bytes:7722429385 (7.1 GiB)
    Interrupt:169 Memory:92000000-92012800

    eth1 Link encap:Ethernet HWaddr E4:1F:13:6C:EA:CE
    inet addr:10.236.8.91 Bcast:10.236.8.255 Mask:255.255.255.0
    UP BROADCAST MULTICAST MTU:1500 Metric:1
    RX packets:0 errors:0 dropped:0 overruns:0 frame:0
    TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:1000
    RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
    Interrupt:138 Memory:94000000-94012800

    lo Link encap:Local Loopback
    inet addr:127.0.0.1 Mask:255.0.0.0
    inet6 addr: ::1/128 Scope:Host
    UP LOOPBACK RUNNING MTU:16436 Metric:1
    RX packets:10137 errors:0 dropped:0 overruns:0 frame:0
    TX packets:10137 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:0
    RX bytes:4204715 (4.0 MiB) TX bytes:4204715 (4.0 MiB)

    usb0 Link encap:Ethernet HWaddr E6:1F:13:5E:EA:CF
    inet addr:10.236.8.91 Bcast:10.236.8.255 Mask:255.255.255.0
    inet6 addr: fe80::e41f:13ff:fe5e:eacf/64 Scope:Link
    UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
    RX packets:7438 errors:0 dropped:0 overruns:0 frame:0
    TX packets:3737 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:1000
    RX bytes:484190 (472.8 KiB) TX bytes:163840 (160.0 KiB)




    [oracle@ABG-CTSDB-01 admin]$ hostname
    ABG-CTSDB-01
    [oracle@ABG-CTSDB-01 admin]$



    [oracle@ABG-CTSDB-01 admin]$ ps -ef | grep -i pmon
    oracle 10512 1 0 22:49 ? 00:00:00 ora_pmon_CTSLIVE
    oracle 11070 10679 0 23:47 pts/5 00:00:00 grep -i pmon
    [oracle@ABG-CTSDB-01 admin]$



    [oracle@ABG-CTSDB-01 admin]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
    # tnsnames.ora Network Configuration File: /ORACLE/product/10.2.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.


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

    FCRLIVE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.0.88)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = fcrlive)
    )
    )
    ctslive =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.236.8.91)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ctslive)
    )
    )
  • 12. Re: ORA-01034  shared memory realm does not exist
    sb92075 Guru
    Currently Being Moderated
    on *NIX ORACLE_SID is CaseSensitive; orcl is different from ORCL

    it works better when you use consistent CASE; either lower or UPPER
  • 13. Re: ORA-01034  shared memory realm does not exist
    jgarry Guru
    Currently Being Moderated
    Ah yes, that is it. Lowercase in listener.ora and tnsnames.ora, so it finds it but thinks it is different than uppercase running db.

    Edit: So this is what confuses me: why doesn't the running db auto register so you see both in listener status? I guess it doesn't auto-register if different case is already registered?

    Edited by: jgarry on Dec 11, 2012 4:38 PM
  • 14. Re: ORA-01034  shared memory realm does not exist
    PVOWUSU Newbie
    Currently Being Moderated
    Thank for your replies. Issue resolved.

    I configured oracle database to start when server is coming up. I followed the steps below and with details in the link provided.


    made changes to 'oratab' file
    dev10ee:/u01/app/oracle/product/10.2.0/db_1:Y

    - created 'dbora' startup (configuration) file under /etc/init.d territory.

    - Set permissions on the dbora file to 700
    chmod 700 /etc/init.d/dbora

    - ran chkconfig command to create links as below:
    $ cd /etc/init.d
    $ /sbin/chkconfig --add dbora


    http://docs.oracle.com/cd/B19306_01/server.102/b15658/strt_stp.htm#CFAHAHGA

    http://docs.oracle.com/cd/B19306_01/server.102/b15658/strt_stp.htm


    Thank you all.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points