22 June 2007

Workaround for "ORA-00600: internal error code, arguments: [kmgs_getgran_from_comp_1]"

A few days ago i was importing an dump file to oracle 10.1. I get error below at the end of import.
IMP-00058: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

Then i looked the trace file to learn more about error. The trace file says an internal error that is simply shown below:

*** SERVICE NAME:(SYS$BACKGROUND) 2007-05-24 07:10:49.050
*** SESSION ID:(170.1) 2007-05-24 07:10:49.050
*** 2007-05-24 07:10:49.050
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kmgs_getgran_from_comp_1], [], [], [], [], [], [], []

When i research, this error caused by 4153846 bug of oracle which is resolved 10.2 release. To workaround of this error which i follow was described as:

SQL> alter system set "_memory_broker_shrink_java_heaps"=0;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1526726656 bytes
Fixed Size 1302616 bytes
Variable Size 432807848 bytes
Database Buffers 1090519040 bytes
Redo Buffers 2097152 bytes
Database mounted.
Database opened.
SQL>

No comments: