on 03-20-2013 8:08 AM
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
Please check SAP Note 1868324 about Handling ORA-600/ORA-7445 error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Please check if Note 1461804 - Query failed with ORA-00600 [kdsgrp1] is relevant to your issue.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.