Ora-600 error and DBIF_RSQL_SQL_ERROR

[Former Member]

Dear Team,

After Upgradation from Bw3.0b to NW07 everyday night our Database is shutting down. As per sap recommendation We have set following db parameter on Development Server.

BTREE_BITMAP_PLANS=FALSE

BLOOMFILTER_ENABLED=FALSE

FIXCONTROL='4728348:OFF'

INDEXJOIN_ENABLED=FALSE

INMEMORY_UNDO=FALSE

OPTIMPEEK_USER_BINDS=FALSE

OPTIMIZERMJC_ENABLED=FALSE

SORTELIMINATION_COST_RATIO=10

TABLELOOKUP_PREFETCH_SIZE=0

Still we are facing same problem.

In Application level some times it is giving

DBIF_RSQL_SQL_ERROR Short dumps.

while starting the database it is giving below mentioned errors

Fri Feb 22 09:52:47 2008

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri Feb 22 09:52:47 2008

SMON: enabling cache recovery

Fri Feb 22 09:52:50 2008

Successfully onlined Undo Tablespace 16.

Fri Feb 22 09:52:50 2008

SMON: enabling tx recovery

Fri Feb 22 09:52:51 2008

Database Characterset is WE8DEC

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

Completed: ALTER DATABASE OPEN

Fri Feb 22 09:53:00 2008

Errors in file /oracle/BD1/saptrace/background/bd1_smon_17187.trc:

**ORA-00600: internal error code, arguments: [kcbzcheck_objd_typ_1], [0], [0], [1], [], [], [], []Fri Feb 22_ 09:53:01 2008Starting background process CJQ0

CJQ0 started with pid=30, OS id=18215

Fri Feb 22 10:07:45 2008

Stopping background process CJQ0

Please help me this regards.

Thanks & Regards,

Satish.Kasaraneni

[Former Member · Accepted solution]

Hi check the note 1042182 -->

The following runtime error may also be triggered: 'DBIF_RSQL_SQL_ERROR' or 'DBIF_RSQL_SQL_ERROR' with reference to database error 'ORA-600'; 'ORA-1502'.

Award if helpful.

Regards.

[former_member204746 · Accepted solution]

Are you using Oracle 10.2.0.3? you should use 10.2.0.2...

anyways, check http://www.cublog.cn/u/7586/showart_477276.html

it explains the problem... but unfortunately, SAP does not support that version.

Ask SAP what to do with this.

[Former Member · Accepted solution]

Hi Eric,

Our Oracle version is 10.2.0.2.0.

Thanks & Regards,

Satish.Kasarneni

[Former Member · Accepted solution]

Hi Sergo,

While executing 'RSAR_PSA_PARTITION_CHECK' program same error arised.(DBIF_RSQL_SQL_ERROR).

Thanks & Regards,

Satish.Kasaraneni

[Former Member · Accepted solution]

Can you applay last support package for BW?

Regards.

[former_member204746 · Accepted solution]

there are a few SAP notes about program RSAR_PSA_PARTITION_CHECK.

SAP note 1042182 Secondary index is inconsistent for PSA tables

SAP note 1012607 SQL/runtime error when writing/activating DataStore

Import Support Package 13 for SAP NetWeaver 2004s BI (BI Patch 13 or SAPKW70013) into your BI system.