This discussion is archived
1 2 3 4 Previous Next 49 Replies Latest reply: Aug 12, 2012 2:08 PM by sybrand_b Go to original post RSS
  • 45. Re: Need help on this errors : ORA-01034: ORACLE not available  and ORA-27101
    sybrand_b Guru
    Currently Being Moderated
    sorry, I have no time right now, will be back later today.

    ----------
    Sybrand Bakker
    Senior Oracle DBA
  • 46. Re: Need help on this errors : ORA-01034: ORACLE not available  and ORA-27101
    sybrand_b Guru
    Currently Being Moderated
    No sufficient clues exists in the alert.
    However there should be a trace file with 4028 in the filename, which is the tracefile of the offending process.
    Hopefully this contains more info.

    -----------
    Sybrand Bakker
    Senior Oracle DBA
  • 47. Re: Need help on this errors : ORA-01034: ORACLE not available  and ORA-27101
    808794 Newbie
    Currently Being Moderated
    Hi Sybrand,
    Here is the content of trace file :



    Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4028.trc
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Windows XP Version V5.1 Service Pack 3
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x0x00000000
    Memory (Avail/Total): Ph:1152M/1799M, Ph+PgF:2874M/3693M, VA:1288M/2047M
    VM name : VMWare Version (6)
    Instance name: orcl
    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 19
    Windows thread id: 4028, image: ORACLE.EXE (SHAD)


    *** 2012-08-12 14:22:46.116
    *** SESSION ID:(1.3) 2012-08-12 14:22:46.116
    *** CLIENT ID:() 2012-08-12 14:22:46.116
    *** SERVICE NAME:() 2012-08-12 14:22:46.116
    *** MODULE NAME:(sqlplus.exe) 2012-08-12 14:22:46.116
    *** ACTION NAME:() 2012-08-12 14:22:46.116

    Error: kccpb_sanity_check_2
    Control file sequence number mismatch!
    fhcsq: 3018 bhcsq: 3027 cfn 0

    *** 2012-08-12 14:22:46.116
    USER (ospid: 4028): terminating the instance
    ------------------------------------------------------------------------------------------------
  • 48. Re: Need help on this errors : ORA-01034: ORACLE not available  and ORA-27101
    sb92075 Guru
    Currently Being Moderated
    805791 wrote:
    Hi Sybrand,
    Here is the content of trace file :



    Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4028.trc
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Windows XP Version V5.1 Service Pack 3
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x0x00000000
    Memory (Avail/Total): Ph:1152M/1799M, Ph+PgF:2874M/3693M, VA:1288M/2047M
    VM name : VMWare Version (6)
    Instance name: orcl
    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 19
    Windows thread id: 4028, image: ORACLE.EXE (SHAD)


    *** 2012-08-12 14:22:46.116
    *** SESSION ID:(1.3) 2012-08-12 14:22:46.116
    *** CLIENT ID:() 2012-08-12 14:22:46.116
    *** SERVICE NAME:() 2012-08-12 14:22:46.116
    *** MODULE NAME:(sqlplus.exe) 2012-08-12 14:22:46.116
    *** ACTION NAME:() 2012-08-12 14:22:46.116

    Error: kccpb_sanity_check_2
    Control file sequence number mismatch!
    Oracle files are NOT consistent across all of them
    I suspect that DB restore procedure is flawed.
  • 49. Re: Need help on this errors : ORA-01034: ORACLE not available  and ORA-27101
    sybrand_b Guru
    Currently Being Moderated
    I just googled for the routine name and got http://halimdba.blogspot.nl/2011/04/ora-00600-internal-error-code-arguments.html

    ---------------
    Sybrand Bakker
    Senior Oracle DBA
1 2 3 4 Previous Next

Legend

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