BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKS

[Former Member]

Dear all:

Running the CheckDB in the transaction DB13 and i get the following

message of error:

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

Other Details :-

OS :- Win 2003 server

DB :- Oracle 10g

So please help on this issue.

Thanks.

Regards

[Former Member]

Dear all:

I have the answers and thank you for everything.

Regards.

[former_member204746]

please change status of this topic to "answered".

thanks.

[Former Member]

Hi,

Please check Note 900522 - Incorrect alerts/warnings in database check for Oracle 10g

Regards

Shaji

[former_member204746]

SAP recommends setting DB_BLOCK_CHECKSUM to TRUE.

so, make sure this is the case in your SPFILE or initSId.ora file. once this is done, adapt entry in transaction code DB17 accorsingly so that it is also set to TRUE.

Good luck.

[Former Member]

Hi,

Oracle allows customers to use advanced block checking features to enable a higher protection against hardware and software problems.

Also with block checking/checksum turned on, it is absolutely necessary to verify your database. Enabling this feature will only find blocks which are touched (read into the SGA).

Advanced block checking can be enabled by setting either

db_block_checksum = true

or

db_block_checking = true

The reason for this warning is given in the following SAP Note 923919 - Advanced Oracle block checking features

Default recommended by SAP is TRUE.

If this information is helpful please reward points.

Regards,

Suhas