Question Re: ORA-00600: internal error code, in Technology Q&A

ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 08:08:19 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 08:22:16 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 08:42:04 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 09:35:59 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 09:42:03 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 09:58:35 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 10:20:56 GMT

Dear orkun

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

Regards

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 10:43:38 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 10:55:08 GMT

Dear Roman

find attached log file 1998.trc

Regards

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 11:23:29 GMT

Hi Kashif,

Have your tried the database parameter mentioned above by me.

Regards,

Deepak Kori

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 11:31:54 GMT

Dear deepak

Yes I did but issue was not resolved.

Regards

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 12:24:20 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 12:30:06 GMT

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

Re: ORA-00600: internal error code,

Former Member — Wed, 20 Mar 2013 12:35:49 GMT

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

Re: ORA-00600: internal error code,

former_member182034 — Thu, 21 Mar 2013 05:58:10 GMT

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,

Re: ORA-00600: internal error code,

Former Member — Tue, 26 Mar 2013 12:06:16 GMT

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

Re: ORA-00600: internal error code,

Former Member — Tue, 26 Mar 2013 12:48:34 GMT

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

Re: ORA-00600: internal error code,

Former Member — Tue, 26 Mar 2013 13:26:29 GMT

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

Re: ORA-00600: internal error code,

Former Member — Tue, 26 Mar 2013 15:34:14 GMT

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

Re: ORA-00600: internal error code,

Former Member — Tue, 26 Mar 2013 16:30:18 GMT

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