T-code DB14 got many errors after upgraded to Oracle 10g

[Former Member]

I just upgraded my SAP Oracle 9i to Oracle 10g (but keep the SAP version), but I got a series of error when my SAP executed Database Check (t-code : DB14)

This afternoon, I add 5 GB to the PSAPPRD tablespace and executed Database Check again, but I still got the following error,

Maybe there are more than 1 error on my new Oracle 10g, please help me to fix all of them, thanks.

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object:PSAPPRD, value: (max_extn of 18 files on disk 1073807364) 197046280 KB (> 64252178 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object:PSAPPRD620, value: (max_extn of 12 files on disk 1073807364) 99524616 KB (> 64252178 KB)

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been run in clean-up period

BR0973W Database operation alert - level: WARNING, operation: Complete database backup, condition: Operation too old or has been run in clean-up period

BR0974I Checking database messages in /oracle/PRD/saptrace/background/alert_PRD.log ...

BR0976W Database message alert - level: WARNING, line: 59344, time: 2011-06-27 16.13.07, message:

Checkpoint not complete

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_CACHING, value: 0 (>< 100,20)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: ALL_ROWS (<> 0)

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (== TYPICAL)

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

[Former Member]

Hi Ming,

first of all, these are WARNINGS, not ERRORS.

BR0969I Checking database administration...
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object:PSAPPRD, value: (max_extn of 18 files on disk 1073807364) 197046280 KB (> 64252178 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object:PSAPPRD620, value: (max_extn of 12 files on disk 1073807364) 99524616 KB (> 64252178 KB)

Update the contents of table DBCHECKORA according to SAP note 403704 by running the correct script (I assume dbcheckora10_oltp.sql).

BR0972I Checking database operations...
BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been run in clean-up period
BR0973W Database operation alert - level: WARNING, operation: Complete database backup, condition: Operation too old or has been run in clean-up period

Do you perform your backups with brbackup and brarchive? If yes, then the messages should vanish soon.

BR0976W Database message alert - level: WARNING, line: 59344, time: 2011-06-27 16.13.07, message:
Checkpoint not complete

This is a classic message, there are lots of threads in the SDN forum about this message because it is difficult to get rid of.

BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_CACHING, value: 0 (>< 100,20)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: ALL_ROWS (<> 0)
BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (== TYPICAL)
BR0978W Database profile alert - level: WARNING, parameter: TIMED_STATISTICS, value: TRUE (set in parameter file)

I would ignore these warnings alltogether. If you want to check the Oracle parameter settings for correctness, use the scripts from SAP note 1171650.

Regards,

Mark