14 Replies Latest reply: Nov 23, 2012 6:36 AM by BSalesRashid RSS

    ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File

    Gajananh999
      Dear Everyone,

      I don't know whats wrong with my database i m getting this error everytime when i am trying to start the database. and my database is also going down frequently. i am not getting what is the reason for that.

      SQL> startup
      ORA-27100: shared memory realm already exists
      Linux-x86_64 Error: 17: File exists
      Additional information: 1
      Additional information: 720898
      Additional information: 8
        • 1. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
          BSalesRashid
          Hi,
          Gimme more details about your environment (OS, Database, version)
          What alert.log shows ?

          Edited by: BSalesRashid on 22/11/2012 12:27
          • 2. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
            Osama_Mustafa
            If you post more information it will be useful DB version , Os version

            Check
            Startup Fails With ORA-27100 After Restarting The Windows Service [ID 370469.1]
            • 3. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
              Gajananh999
              Hello,

              Oracle 11g, and Redhat linux machine. I am using a amazon EC2 machine.

              and when i restart the linux server and trying to start the database it will start the database but after some time it will again go down

              here is the alert.log containt.

              oracle@ip-10-84-238-191:[home/oracle/oradiag_oracle/diag/clients/user_oracle/host_1672212190_76/alert]
              $ tail -20 log.xml
              </txt>
              </msg>
              <msg time='2012-11-23T01:03:52.181+05:30' org_id='oracle' comp_id='clients'
              type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
              host_addr='10.84.238.191'>
              <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
              </txt>
              </msg>
              <msg time='2012-11-23T01:13:57.681+05:30' org_id='oracle' comp_id='clients'
              type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
              host_addr='10.84.238.191'>
              <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
              </txt>
              </msg>
              <msg time='2012-11-23T10:34:46.670+05:30' org_id='oracle' comp_id='clients'
              type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
              host_addr='10.84.238.191'>
              <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
              </txt>
              </msg>
              • 4. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                Niket Kumar
                Directory does not exist for read/write [/u01/app/oracle/product/11.2.0/db_1/log] [/u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
                check for permissions are given to oracle user on following directories for read wright.
                • 5. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                  Gajananh999
                  Dear Niket,

                  /u01/app/oracle/product/11.2.0/db_1/ folder have all the rights.
                  • 6. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                    Gajananh999
                    Hello

                    Here it is

                    root@ip-10-84-238-191:[u01/app/diag/rdbms/sa/SA/trace]
                    $ vi alert_SA.log
                    root@ip-10-84-238-191:[u01/app/diag/rdbms/sa/SA/trace]
                    $ tail -20 alert_SA.log
                    Process W000 died, see its trace file
                    Process W000 died, see its trace file
                    Process W000 died, see its trace file
                    Fri Nov 23 10:59:54 2012
                    Process W000 died, see its trace file
                    Fri Nov 23 10:59:57 2012
                    Process J000 died, see its trace file
                    kkjcre1p: unable to spawn jobq slave process
                    Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                    Process J000 died, see its trace file
                    kkjcre1p: unable to spawn jobq slave process
                    Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                    Process W000 died, see its trace file
                    Process W000 died, see its trace file
                    Fri Nov 23 11:00:07 2012
                    Process W000 died, see its trace file
                    Process W000 died, see its trace file
                    Process W000 died, see its trace file
                    Fri Nov 23 11:00:20 2012
                    Process W000 died, see its trace file
                    • 7. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                      Niket Kumar
                      have you set the enviorment variable correctly.

                      export ORACLE_SID='database_name'
                      sqlplus> startup
                      • 8. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                        Gajananh999
                        Hello Niket,


                        oracle@ip-10-84-238-191:[home/oracle]
                        $ export ORACLE_SID='SA'
                        oracle@ip-10-84-238-191:[home/oracle]
                        $ sqlplus

                        SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 23 11:10:24 2012

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

                        Enter user-name: sys as sysdba
                        Enter password:
                        Connected to an idle instance.

                        SQL> startup
                        ORA-27100: shared memory realm already exists
                        Linux-x86_64 Error: 17: File exists
                        Additional information: 1
                        Additional information: 1114114
                        Additional information: 8
                        • 10. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                          Gajananh999
                          Dear Niket,

                          This are the last 100 lines,

                          root@ip-10-84-238-191:[u01/app/diag/rdbms/sa/SA/trace]
                          $ tail -100 alert_SA.log
                          Fri Nov 23 11:00:07 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:00:20 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:00:31 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:00:42 2012
                          Process m000 died, see its trace file
                          Fri Nov 23 11:00:43 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:00:55 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:11 2012
                          Process m000 died, see its trace file
                          Fri Nov 23 11:01:13 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:25 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:32 2012
                          Process m000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:37 2012
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:38 2012
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process W000 died, see its trace file
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process W000 died, see its trace file
                          Fri Nov 23 11:01:49 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:02:01 2012
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Process W000 died, see its trace file
                          Fri Nov 23 11:03:40 2012
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Fri Nov 23 11:04:15 2012
                          Process m000 died, see its trace file
                          Fri Nov 23 11:04:50 2012
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Fri Nov 23 11:04:53 2012
                          Process m000 died, see its trace file
                          Fri Nov 23 11:10:40 2012
                          Starting ORACLE instance (normal)
                          Fri Nov 23 11:12:42 2012
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Fri Nov 23 11:13:28 2012
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Process J000 died, see its trace file
                          kkjcre1p: unable to spawn jobq slave process
                          Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_cjq0_28555.trc:
                          Fri Nov 23 11:14:53 2012
                          Process m000 died, see its trace file
                          • 11. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                            Niket Kumar
                            is there any ora error in the alert log?
                            • 13. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                              santosh..
                              Gajananh999 wrote:
                              Hello Niket,


                              oracle@ip-10-84-238-191:[home/oracle]
                              $ export ORACLE_SID='SA'
                              oracle@ip-10-84-238-191:[home/oracle]
                              $ sqlplus

                              SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 23 11:10:24 2012

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

                              Enter user-name: sys as sysdba
                              Enter password:
                              Connected to an idle instance.

                              SQL> startup
                              ORA-27100: shared memory realm already exists
                              Linux-x86_64 Error: 17: File exists
                              Additional information: 1
                              Additional information: 1114114
                              Additional information: 8
                              ps -ef|grep pmon
                              export ORACLE_SID=<PMON>
                              export ORACLE_SID=SA
                              Enter user-name: sys as sysdba
                              Enter password:
                              Connected to an idle instance.
                              sql>startup
                              • 14. Re: ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File
                                BSalesRashid
                                Hi,
                                Do you have issues with DST [Day Saving Time] ?

                                Check date at OS [date]
                                and check date at the Database [select to_char(sysdate,'MM/DD/YYYY hh24:mi:ss') from dual]

                                And post the results here.

                                Thanks.