Extremly urgent Ora 3113 and ora 600 [kccida_kccsgfsz]

It's 10 minutes to midnight, and I am not able to get the office dba to check metalink
I have copied a controlfile from a Source database on RAC to another non-RAC(standalone) system. The source database has had a resetlogs done so getting new controlfiles from there will be useless.  whenever I try to mount the new database in the non-RAC environment I am getting a 3113. On further checks I get a instance terminated by CKPT message in the log files
the exact error is ora-600: arguments are [kccida_kccsgfsz]
I am HPUX 11i and database is Oracle 10g 10.1.0.2.0
LVL 13
anand_2000vAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

techjiCommented:
are the OS same ?

Does your alert.log looks like this (from metalink) -

ALERT LOG
---------
Thu Jun 16 12:12:25 2005
alter database mount
Thu Jun 16 12:12:25 2005
Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc:
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc:
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
CKPT: terminating instance due to error 470
Instance terminated by CKPT, pid = 31899
anand_2000vAuthor Commented:
yep
techjiCommented:
From metalink - Note:315112.1

Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0 and later
This problem can occur on any platform.
Symptoms

ALERT LOG --------- Thu Jun 16 12:12:25 2005 alter database mount Thu Jun 16 12:12:25 2005 Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc: ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], [] Thu Jun 16 12:12:26 2005 Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc: ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], [] Thu Jun 16 12:12:26 2005 CKPT: terminating instance due to error 470 Instance terminated by CKPT, pid = 31899

PARAMETER --------- control_files = /cdboil01_db1/oracle/oradata/ped_test/PEDT_dbs/PEDT_cntrl_1.dbf ...

TRACE FILE ---------- Call Stack Trace ~~~~~~~~~~~~~~~~ ... ksbabs ksbrdp opirip opidrv sou2o main libc_start_main start

PROCESS STATE ------------- ...     SO: 0xef6ebdc0, type: 6, owner: 0xf06e5d48, flag: INIT/-/-/0x00     (FIB) flags=0 reference cnt=1 incno=2 seqno=1     ----------------------------------------     SO: 0xef55eb28, type: 7, owner: 0xef6ebdc0, flag: INIT/-/-/0x00       (FOB) flags=393226 fib ptr=ef6ebdc0 incno=2 pending i/o cnt=0        fname=/cdboil01_db1/oracle/oradata/ped_test/PEDT_dbs/PEDT_cntrl_1.dbf     ...

Changes
Control- and datafiles were moved from a Sun platform to Linux server. Next, startup mount failed with ORA-600 [kccida_kccsgfsz].
Cause

Problem occured while determine the blocksize of controlfile. As different operating systems use different binary block formats the controlfiles and datafiles are not compatible. The only supported way of moving a database to a different platform is to use the export/import utilities.

@ Platform                    Endian format
Solution


1. Export database on source server site (here: SunOS).
2. Create a new database on the target database (here: Linux site).
3. Import the whole export dumpfile into the target database.

Errors

ORA-600 [kccida_kccsgfsz]

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

techjiCommented:
better format (I hope)-


Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0 and later
This problem can occur on any platform.
Symptoms

ALERT LOG
---------
Thu Jun 16 12:12:25 2005
alter database mount
Thu Jun 16 12:12:25 2005
Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc:
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
Errors in file /home/oracle/app/oracle/admin/PEDT/bdump/pedt_ckpt_31899.trc:
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
CKPT: terminating instance due to error 470
Instance terminated by CKPT, pid = 31899


PARAMETER
---------
control_files =
/cdboil01_db1/oracle/oradata/ped_test/PEDT_dbs/PEDT_cntrl_1.dbf ...


TRACE FILE
----------
Call Stack Trace
~~~~~~~~~~~~~~~~
... ksbabs ksbrdp opirip opidrv sou2o main libc_start_main start


PROCESS STATE
-------------
    ...
    SO: 0xef6ebdc0, type: 6, owner: 0xf06e5d48, flag: INIT/-/-/0x00
    (FIB) flags=0 reference cnt=1 incno=2 seqno=1
    ----------------------------------------
    SO: 0xef55eb28, type: 7, owner: 0xef6ebdc0, flag: INIT/-/-/0x00
      (FOB) flags=393226 fib ptr=ef6ebdc0 incno=2 pending i/o cnt=0
       fname=/cdboil01_db1/oracle/oradata/ped_test/PEDT_dbs/PEDT_cntrl_1.dbf
    ...
Changes
Control- and datafiles were moved from a Sun platform to Linux server. Next, startup mount failed with ORA-600 [kccida_kccsgfsz].
Cause
Problem occured while determine the blocksize of controlfile. As different operating systems use different binary block formats the controlfiles and datafiles are not compatible. The only supported way of moving a database to a different platform is to use the export/import utilities.
@ Platform                    Endian format
Solution



1. Export database on source server site (here: SunOS).

2. Create a new database on the target database (here: Linux site).

3. Import the whole export dumpfile into the target database.

Errors

ORA-600 [kccida_kccsgfsz]

________________________________________
anand_2000vAuthor Commented:
But Oracle 10g controlfile  backups using rman should not face this problem
techjiCommented:
I think you still need to a convert. Let me check.
techjiCommented:
From metalink - Doc ID:       Note:274479.1
13-NOV-2005

Creating duplicate databases across platforms requires cross-platform restore, which is not supported by Oracle on any version as per Oracle 10g. Operating systems have different block storage formats and creating a duplicate database across platforms may result in I/O error(s).

The only options for moving the database across platforms are

   1. Take a FULL export of the database
   2. Create a new database on the other server
   3. Import the dump to the new database.

You can use transportable tablespaces to move tablespaces between platforms in Oracle 10g, and use RMAN to convert between endians using the command CONVERT in RMAN.
anand_2000vAuthor Commented:
I am sorry but I think you should check out
http://www.dbasupport.com/oracle/ora10g/transportable_tablespace01.shtml

its for the entire database from 10.2 onwards only :(
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.