cancel
Showing results for 
Search instead for 
Did you mean: 

DB check warnings & errors

Former Member
0 Kudos

Hi all,

When i am doing a Database check I am getting following errors & warnings.

Why this 2 errors occur even on fresh SAP system ...

-*****************************************************************************************************************

BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

***********************************************************************************************

What recommendations i can take when my profile parameters are in warning.

**************************************************************************************************************

BR0976W Database message alert - level: WARNING, line: 395408, time: 2009-06-16 11.25.45, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 395420, time: 2009-06-16 11.26.02, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 395432, time: 2009-06-16 11.26.18, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 396608, time: 2009-06-19 12.10.40, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 396627, time: 2009-06-19 12.11.07, message:

Checkpoint not complete

BR0280I BRCONNECT time stamp: 2009-06-23 03.01.06

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14254080 (>< 4096,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file)

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

                                                • Please advice me on the following

regards

rahul

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Rahul,

Database message alert - level: WARNING, line: 395408, time: 2009-06-16 11.25.45, message: Checkpoint not complete BR0976W Database message alert - level: WARNING, line: 395420, time: 2009-06-16 11.26.02, message: Checkpoint not complete BR0976W Database message alert - level: WARNING, line: 395432, time: 2009-06-16 11.26.18, message: Checkpoint not complete BR0976W Database message alert - level: WARNING, line: 396608, time: 2009-06-19 12.10.40, message: Checkpoint not complete BR0976W Database message alert - level: WARNING, line: 396627, time: 2009-06-19 12.11.07, message: Checkpoint not complete BR0280I

If this warnings are coming frequently, then

1-Increase size of redo log file.

2-Add a new redo log file

Check

For rest of he warning messages you need to set it in tcode DB17,

Thanks

Sushil

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

The "BR0978W Database profile alert - level: ERROR" is due to the reason that for those profile parameters mentioned in the alert, the parameter values mentioned in Transaction DB17 (All Database Check Conditions, Condition Type: PROF), does not match with the current value of the parameters.

In that case, change the check conditions for those particular parameters in transaction DB17.

I presume that the parameter values are in accordance with SAP Note 830576 (Parameter recommendations for Oracle 10g).

For the "Checkpoint not complete BR0976W error", please refer to the below link:

Thanks,

Subhajit.

Former Member
0 Kudos

Go to DB17>QUERY_REWRITE_ENABLED>active flag>Yes>Check condition-->Not equal to FALSE

& then run dbcheck job & try.

Thanks

Sushil

Former Member
0 Kudos

Hi,

Check point not complete - you can increase online redo log file.

Check log archive process how many assigned. You can increase it

Former Member
0 Kudos

Go to -->

Note 830576 - Parameter recommendations for Oracle 10g

About "Checkpoint not complete"

read the Note 79341 - Checkpoint not complete

Note 309526 - Enlarging redo log files

Regards.

Former Member
0 Kudos

Dear all,

Thanx for sharing & going through sap notes as recommended.I am in planing part how to rectify warnings.

But as i noticed in sap note

Note 753199 - ORA-7445 with query_rewrite_enabled=TRUE

from the log it is understood that query_rewrite_enabled is set to TRUE by default.

BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

then why it showing an error. request to please rectify..

rgds

rahul