on 06-25-2009 5:32 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go to DB17>QUERY_REWRITE_ENABLED>active flag>Yes>Check condition-->Not equal to FALSE
& then run dbcheck job & try.
Thanks
Sushil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check point not complete - you can increase online redo log file.
Check log archive process how many assigned. You can increase it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.