This discussion is archived
14 Replies Latest reply: Nov 23, 2012 4:36 AM by BSalesRashid RSS

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

Gajananh999 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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.. Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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.

Legend

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