1 2 Previous Next 16 Replies Latest reply: Dec 12, 2012 7:37 AM by EdStevens RSS

    ORA-01034  shared memory realm does not exist

    PVOWUSU
      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
          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
            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
              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
                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
                  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
                    Vijayaraghavan Krishnan
                    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
                      From UNIX prompt try: tnsping ctslive
                      • 8. Re: ORA-01034  shared memory realm does not exist
                        PVOWUSU
                        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
                          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
                            Vijayaraghavan Krishnan
                            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
                              [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
                                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
                                  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
                                    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