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
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
ASKER
yep
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/ad
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
Errors in file /home/oracle/app/oracle/ad
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/orada
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
...
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]
__________________________
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/ad
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
Errors in file /home/oracle/app/oracle/ad
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/orada
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
...
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]
__________________________
ASKER
But Oracle 10g controlfile backups using rman should not face this problem
I think you still need to a convert. Let me check.
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.
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.
ASKER
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 :(
http://www.dbasupport.com/oracle/ora10g/transportable_tablespace01.shtml
its for the entire database from 10.2 onwards only :(
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/ad
ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], []
Thu Jun 16 12:12:26 2005
Errors in file /home/oracle/app/oracle/ad
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