ORA-00600: internal error code,

[Former Member]

Dear all,

I have copied the SAP Data files from QAS system to Test system and upgradaded the oracle patches. now oracle successfully startup and shutting  down but when I try to start any tx then getting follwoing issue.

DBIF_REPO_SQL_ERROR
What happened?
    An exceptional situation has occurred in the ORACLE software,
    possibly due to an error.
    This is not an error in an application program.
How to correct the error
    Database error text........: "ORA-00600: internal error code, arguments:
     [ktsplbfmb-dblfree], [0], [96866943], [96866756], [187], [0], [], [], [], [],
     [], []"
    Triggering SQL statement...: "CL_I18N_BIDI==================CP "
    Internal call code.........: "[REPO/*/CLBW/LREF/CL_I18N_BIDI==================C
    P ]"
    Please check the entries in the system log (Transaction SM21).
    If the error occures in a non-modified SAP program, you may be able to
    find an interim solution in an SAP Note.
    If you have access to SAP Notes, carry out a search with the following
    keywords:
    "DBIF_REPO_SQL_ERROR" " "
    "CL_I18N_BIDI==================CP" or
     "????????????????????????????????????????"
    " "

fyi...

Source System: QAS installed with oracle 10.2.0.5

Target System: TST installed with Oracle 11.2.0.2

Regards,

kanjum

[Former Member]

Hi Kashif,

You have copied the datafiles from QA to test whereas the test system database at 10.2.0.5 release. Then, upgraded to 11.2.0.2 successfully, correct?

If it is, check the usertrace folder the for the trace file and upload here. You can find the usertrace folder by using the statement, below;

SQL> show parameter user_dump_dest

Best regards,

Orkun Gedik

[Former Member]

Dear ,

fyi...

orkun@ I installed the test system with Oracle  11g and copied the sap datafile from QA server which were oracle 10.2.0.5.

Maria@ I also applied the patches of Oracle 11g and run the catupgrd.sql script successfully.

now database opened successfully.

please find attached alert log.

Regards,

Kanjum

alert.txt.zip

[Former Member]

Hi Kashif,

SAP note 1765347 provides a workaround for ORA-600

star_transformation_enabled=temp_disable

Could you add this parameter in initSID.ora. Create an spfile and check the results.

Regards,

Deepak Kori

[Former Member]

By the errors in the trace file, the database did not opened succesfully. Please follow the procedure "Upgrade a Database Manually" carrefully, in the document, below;

http://docs.oracle.com/cd/E14072_01/server.112/e10819.pdf

Additionally, could you upload E:\ORACLE\diag\rdbms\tst\tst\trace\tst_ora_3540.trc here?

Best regards,

Orkun Gedik

[Former Member]

Dear orkun

You can see below image in which Oracle opened and down successfully and also find attaached log file

Regards

ora_3540.txt.zip

[Former Member]

Please attach log file E:\ORACLE\diag\rdbms\tst\tst\trace\tst_ora_1988.trc.

[Former Member]

Dear Roman

find attached log file 1998.trc

Regards

ora_1998.txt.zip

[Former Member]

Hi Kashif,

Have your tried the database parameter mentioned above by me.

Regards,

Deepak Kori

[Former Member]

Dear deepak

Yes I did but issue was not resolved.

Regards

[Former Member]

Kashif,

It is obvious that there are some missing steps in your copy procedure. Please read the doc that I provided and double check the steps.

Best regards,

Orkun Gedik

[Former Member]

Hi Kashif,

For further investigation we need to analyze where the corruption exits.

For this refer following link http://www.oraclepitstop.com/2012/02/ora-00600-kdsgrp1/

Apart from that execute dbcheck and following the commands mentioned in the SAP Note 365481 - Block corruptions to identify problematic segment or block.

Post these results solution can be provided for rectification.

Regards,

Deepak Kori

[Former Member]

Please check if Note 1461804 - Query failed with ORA-00600 [kdsgrp1] is relevant to your issue.

[former_member182034]

hi kashif,

would You share the file (opatch_history) and it is located in %Oracle_home%\cfgtoollogs\opatch

or just copy and past above path in run.

Regards,