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_member207463]

Please check SAP Note 1868324 about Handling ORA-600/ORA-7445 error.

[Former Member]

Hi,

  Please execute the following steps.

1. login as orasid

2.navigate to /oracle/SID/112_64/rdbms/admin/catupgrd.sql

3.navigate to /oracle/SID/112_64/rdbms/admin/utlirp.sql

Mostly this should fix your issue.

Thanks and Regards,

Vimal

[Former Member]

Dear All (Orkun, Maria, Deepak, Roman)

I have installed again oracle 10.2.0.2 then upgraded its patches 10.2.0.5 with all patches but still same error.

then I upgraded oracle from 10.2.0.5 to 11.2.0.3 with all patches but still facing below error.

DBIF_RSQL_SQL_ERROR CX_SY_OPEN_SQL_DB
Database error text........: "ORA-00600: internal error code, arguments: [510],
 [0x3AAD18228], [cache buffers chains], [], [], [], [], [], [], [], [], []"
Internal call code.........: "[RSQL/READ/TBTCO ]"
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_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"
"SAPMSSY2" or "SAPMSSY2"
"INITIATE_JOB_START"

today ST22 is showing more then 1000 dumps

please help me to sortout this issue.

Regards,

Kanjum

[former_member188883]

Hi Kanjum,

Could you share the relevant trace file details.

Additionally please get the hardware check with the vendor as due to OS and hardware problems ORA-600 problems can appear.

Regards,

Deepak Kori

[Former Member]

Kashif,

>> 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

Did you apply the steps, I noted above?

As far as I understand by your message that you just upgraded the database and overwrite old (10g) datafiles on to the new (11g) database, correct?

Best regards,

Orkun Gedik

[Former Member]

Dear Orkun,

>> As far as I understand by your message that you just upgraded the database and overwrite old (10g) datafiles on to the new (11g) database, correct?

I installed the system ecc 6 with oracle 10.2.0.2 on window server 2008 after that I upgraded the oracle from 10202 to 10205 then copied the datafile from QA(10205) to TST(10205) system at this stage oracle patch level was same and I faced the ora-600 with ora-8103(resolved).

after that..

I thought , may issue will be resolved If I upgrade the oracle from 10205 to 11203 on TST system, So I upgraded and copied the datafile from QA(10205) to TST(11203) but same issue.

Regards,

Kanjum

[Former Member]

In general to perform oracle upgrade you need:

1) install required oracle binaries;

2) upgrade your DB to the same level.

After your oracle binaries and database at the same level the procedure of upgrade finished.

In your case:

1) install TST system with Oracle 10.2.0.5;

2) copy database from QA (10.2.0.5) to TST (10.2.0.5);

3) install new oracle home 11.2.0.3;

4) upgrade your database to 11.2.0.3.

You can download manual about how to upgrade oracle database for SAP on SAP Service Marketplace:

Windows: https://websmp201.sap-ag.de/~sapdownload/011000358700000608442010E/win_ora_upgrade.pdf

Unix: https://websmp201.sap-ag.de/~sapdownload/011000358700000333942010E/GUIDE_UX_ORA_UPGR_112_302.pdf

[Former Member]

Ok. At this stage please upload latest alert log and user trace files here when you face with the error. It needs to be investigated in detail.

Best regards,

Orkun Gedik

[Former Member]

To be sure that both systems have same kernel level and unicode?

[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_member188883]

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_member188883]

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_member188883]

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,