1 2 3 4 Previous Next 49 Replies Latest reply: Aug 12, 2012 4: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
        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
          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
            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
              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
                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