brtools raise error ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

[former_member291545]

Dear guru,

after using flash copy from production server to backup server

Database mounted

Database opened

and can startsap

My system is ECC6 EPH6 with Oracle 11.2.0.3.0

I got error in ST22 by system

Category               ABAP Programming Error

Runtime Errors         DBIF_DSQL2_DEFAULT_CR_ERROR

Except.                CX_SY_NATIVE_SQL_ERROR

ABAP Program           SAPLSYDB

Application Component  BC-DB-DBI

Date and Time          10.08.2015 13:35:52

Short text

     COMMIT/ROLLBACK error on "DEFAULT" database connection.

and I cannot access query data from some ZREPORT it stuck at query statement then shotdump.

-------------------------------------------------------------------------------------

Category               Resource Shortage

Runtime Errors         DBIF_SETG_SQL_ERROR

Date and Time          10.08.2015 12:52:13

Short text

     SQL error 600 when accessing a table.

What happened?

     Database Error Text: "ORA-00600: internal error code, arguments: [kdsgrp1], [],

      [], [], [], [], [], [], [], [], [], []"

-------------------------------------------------------------------------------------

Category               Installation Errors

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          10.08.2015 13:09:21

Short text

     SQL error 600 when accessing table "STAS".

What happened?

     Error Text of the Database: "ORA-00600: internal error code, arguments:

      [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []"

I am geting error in db check by using brtools. Please help me

BR0280I BRCONNECT time stamp: 2015-08-10 13.53.55

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: berdjtev.dbv, time: 2015-08-10 13.36.17, condition: Last 'dbv' operation failed with rc = 3

BR0973W Database operation alert - level: WARNING, operation: seqpprsz.tse, time: 2015-05-29 17.29.45, condition: Last 'tse' operation failed with rc = 4

BR0973W Database operation alert - level: WARNING, operation: beqgimpr.fnt, time: 2015-04-10 15.55.03, condition: Last successful 'fnt' operation older than 10 days

BR0280I BRCONNECT time stamp: 2015-08-10 13.53.55

BR0974I Checking database messages in /oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/alert_PRD.log ...

BR0976W Database message alert - level: ERROR, line: 1521931, time: 2015-08-10 13.31.05, message:

ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1521948, time: 2015-08-10 13.32.15, message:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1521968, time: 2015-08-10 13.35.51, message:

ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1521999, time: 2015-08-10 13.41.06, message:

ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1522016, time: 2015-08-10 13.42.15, message:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1522031, time: 2015-08-10 13.45.51, message:

ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1522054, time: 2015-08-10 13.51.04, message:

ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [1066245], [63053], [], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 1522078, time: 2015-08-10 13.52.14, message:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

[Brindavan_M]

Hi,

Mostly this issue can be thrown when orrach log file full , inconsistent of shared pool size.  Try to clean the shared memory  and reboot the system.  Then check the bad corruption of datafile or fllesytem etc..

Also run the database statics as well.

As per the error code :

ORA-00600 internal error code, arguments

It may be due to:

Timeout

A corrupted file

A crash that has affected stored data

I/O issue "(physical memory)"

Thanks,

Brindavan M

[Former Member]

Hi parinaya,

Restart the system and try again if not done.

ORA-600.That is hardware error consult your hardware vendor. futher info @ support.sap.com/notes

Regards,

Manoj.

[Former Member]

Hi Parinya

Its a Known issue, Try to

Mount the database and try to recover through the online redo logs:

SQL>startup mount

SQL>recover database;

SQL>alter database open;

Regards

Shoaib

[former_member207186]

Hi,

Have you also checked the alert log and the corresponding trace files ? Regarding this issue, you can also check carefully the SAP KBA 1868324 - "Handling ORA-600/ORA-7445 error" .

Furthermore to obtain more information about mentioned Warnings, you can refer to SAP KBA and SAP Note below

1943026 - "BR0973W Last % operation failed/older than % days in DB13/DBACOCKPIT"

17163 - "BRARCHIVE/BRBACKUP messages and codes"

Regards,

Bíborka

[Former Member]

Hi,

Please check the below mentioned SAP note on the issue...

1461804 - Query failed with ORA-00600 [kdsgrp1]

Regards,

Prithviraj.

[JamesZ]

Hi,

As per SAP note 1918966 , probably the system is hitting an oracle bug. Can you please check if the

system applied the SBP mentioned?

Best regards,
James

[former_member291545]

Bundle Patch 11.2.0.3.14 - 201505 - SBP_1120314_201505.ZIP applied

but error still occurs