Thứ Sáu, 4 tháng 4, 2014

Database Health Alerts..


Last successful database check

Cause: The threshold for the number of days since the last successful database check, which includes BRCONNECT return codes of 0 (successful) or 1 (successful but with warnings), has been exceeded.


Action: Run brconnect -f check.




Last brconnect -f check run

Cause: The last run of brconnect -f check has an invalid status.


Action: Correct the problem and repeat brconnect -f check.




Last evaluation of check results

Cause: Using information stored in the DBMSGORA table by the last run of brconnect -f check, the collection method of this node feeds all others marked with [BRCONNECT].


Action: You can start the collection method of this node manually if you want to immediately evaluate the last database check run.




Start of database check

This lets you directly start the database check with brconnect -f check.




Database administration

The alerts in this section correspond to the checks stored in the DBCHECKORA table for database administration.



Archiver destination full [BRCONNECT] [NON-STANDARD]

Cause: The used space in the archiver destination directory is above the preconfigured threshold. For more information, see ARCHIVER_STUCK in BRCONNECT Default Conditions for Database Administration.


Action: Either back up and delete offline redo logs using BRARCHIVE or add more space to the archiver destination to accommodate more logs.


The standard equivalent to this alert is Archiver destination full in Database Backup/Restore Alerts.




Control file not mirrored [BRCONNECT]

Cause: The control file is not mirrored. For more information, see CONTROL_FILE_MIRROR in BRCONNECT Default Conditions for Database Administration.


Action: Edit the init<DBSID>.ora profile and add the additional control files under the parameter CONTROL_FILES. We recommend you have at least three copies of the file. Each copy of the file must be stored on a separate physical hard disk. After you edit the profile, restart the database to activate your changes.



Note Note


If you only use hardware mirroring, you can inactivate this check. For more information, see Configuring Database System Check (Oracle).


End of the note.




Missing control file [BRCONNECT]

Cause: The control file is missing. For more information, see CONTROL_FILE_MISSING in BRCONNECT Default Conditions for Database Administration.


Action: Look for the parameter CONTROL_FILES, in the init<DBSID>.ora initialization file to determine which directories the control files are stored in. Make sure you can display all the files and that they are available in the file system. Restore access to any non-accessible files.




Critical autoextendable file [BRCONNECT]

Cause: There are data files with an activated auto extend feature that would consume the entire remaining free disk space if extended. A check is made to see whether the file system can be brought to overflow, due to the existing parameter setting (NEXT and MAXSIZE) during the automatic file extension. For more information, see CRITICAL_FILE in BRCONNECT Default Conditions for Database Administration.


Action: Add more space to the file system or reduce the autoextend parameters.




Critical segment [BRCONNECT] [NON-STANDARD]

Cause: There are segments with too few allocatable extents due to lack of free space in the tablespace. “Too few” is defined in the CHKVAL field of the DBCHECKORA table (range is 1 to 5).


For more information, see CRITICAL_SEGMENT in BRCONNECT Default Conditions for Database Administration.


Action: If the NEXT storage parameter for this segment is set too high, decrease it to allow the segment to allocate more extents. If NEXT is set as intended, add another data file to the tablespace.


The standard equivalent to this alert is Segments with too few allocatable extents in Space Management Alerts.




Data file mismatch [BRCONNECT]

Cause: There are data files that are flagged as MISSING in the Oracle dictionary.


For more information, see DATA_FILE_MISMATCH in BRCONNECT Default Conditions for Database Administration.


Action: Execute CREATE CONTROLFILE using Oracle SQLPLUS, specifying either the correct file or no file at all.




Missing data file [BRCONNECT]

Cause: There are data files that no longer exist in the file system.


For more information, see DATA_FILE_MISSING in BRCONNECT Default Conditions for Database Administration.


Action: Perform Complete Database Recovery with BR*Tools.




Database file offline [BRCONNECT]

Cause: There are data files or online redo log files that are offline.


For more information, see FILE_OFFLINE in BRCONNECT Default Conditions for Database Administration.


Action: Close all applications and enter the following commands using Oracle SQLPLUS:




  1. connect / as sysdba

  2. shutdown immediate

  3. startup mount

  4. alter database data file <data file> online;

  5. alter database open



Alternatively, use Complete Database Recovery with BR*Tools.




File system full [BRCONNECT]

Cause: The fill level of file systems on the database host is too high. All file systems are checked by default against the same threshold value. However, you can define different threshold values for individual file systems by specifying the file system in the OBJECT field of the DBCHECKORA table (transaction DB17).


For more information, see FILE_SYSTEM_FULL in BRCONNECT Default Conditions for Database Administration.


Action: Increase the amount of space in the file system.




Harmful statistics [BRCONNECT] [NON-STANDARD]

Cause: There are tables or indexes that have statistics, although they should not have these (for example, pool and cluster tables).


For more information, see HARMFUL_STATISTICS in BRCONNECT Default Conditions for Database Administration.


Action: Remove statistics from these tables or indexes. For more information, see brconnect -f stats.


The standard equivalent to this alert is Harmful statistics in Space Management Alerts.




Invalid file type [BRCONNECT]

Cause: There are database files that have an illegal operating system type, for example, block raw files on UNIX or compressed files on Windows.


For more information, see INVALID_FILE_TYPE in BRCONNECT Default Conditions for Database Administration.


Action: Troubleshoot to determine the cause of the problem. If you are not sure how to proceed, contact SAP technical support.




Segment in wrong tablespace [BRCONNECT] [NON-STANDARD]

Cause: A segment is in the wrong tablespace, as raised by the BRCONNECT database check. For more information, see IN_WRONG_TABLESPACE in BRCONNECT Default Conditions for Database Administration.


Action: Use Reorganizing Tables with BR*Tools, which moves the tables into a tablespace of the correct type.


The standard equivalent to this alert is Segment in wrong tablespace in Space Management Alerts.




Missing index [BRCONNECT] [NON-STANDARD]

Cause: There are tables that do not have any indexes and are not specified in the DBDIFF table exception.


For more information, see MISSING_INDEX in BRCONNECT Default Conditions for Database Administration.


Action: Create the missing indexes using transaction SE11.


The standard equivalents to this alert in Database Consistency Alerts are:




  • Objects missing in database: Primary indexes

  • Objects missing in database: Secondary indexes

  • Unknown objects in ABAP dictionary: Tables without unique index





Missing statistics [BRCONNECT] [NON-STANDARD]

Cause: There are tables or indexes that do not have any statistics, although they should have these.


For more information, see MISSING_STATISTICS in BRCONNECT Default Conditions for Database Administration.


Action: Create statistics for these tables or indexes. For more information, see brconnect -f stats.


The standard equivalent to this alert is Missing Statistics in Database Performance Alerts.




Database in NOARCHIVELOG mode [BRCONNECT] [NON-STANDARD]

Cause: The database is running, but online redo logs are not being archived.


For more information, see NOARCHIVELOG_MODE in BRCONNECT Default Conditions for Database Administration.


Action: Using BRSPACE, restart the database and change to archivelog mode.


The standard equivalent to this alert is Archiving Off in Database Backup/Restore Alerts.




Segment with non-zero PCTINCREASE [BRCONNECT] [NON-STANDARD]

Cause: Segments have a PCTINCREASE value other than zero. Since Oracle now allows a MAX_EXTENTS setting of “unlimited”, setting PCTINCREASE to something other than zero no longer makes sense. Setting PCTINCREASE to non-zero can potentially introduce unnecessary fragmentation into your tablespace. Only segments in the SAP schema are considered.


For more information, see PCTINCREASE_NOT_ZERO in BRCONNECT Default Conditions for Database Administration.


Action: Evaluate whether the segment”s storage parameter can be set to zero.


The standard equivalent to this alert is Segments with non-zero PCTINCREASE in Space Management Alerts.




Redolog file not mirrored [BRCONNECT]

Cause: The online redo logs are not mirrored. Mirroring is required for safe operation. For more information, see REDOLOG_FILE_MIRROR in BRCONNECT Default Conditions for Database Administration.


Action: Using Oracle SQLPLUS, activate mirroring of the online redo logs in your database, with the statement ALTER DATABASE ADD LOGFILE MEMBER.




Missing redolog file [BRCONNECT]

Cause: An online redo log is missing, which reduces the effect of mirroring. Mirroring is required for safe operation. For more information, see REDOLOG_FILE_MISSING in BRCONNECT Default Conditions for Database Administration.


Action: First, check the file that cannot be accessed, and check the system for problems (network problems, server down, and so on). One possible action (only for Oracle experts, as an error could result in an incomplete chain of offline redo logs, which might prevent a full recovery of the database): If a second member of the group that cannot be accessed exists, delete the non-accessible member. Using Oracle SQLPLUS, execute:


ALTER SYSTEM SWITCH LOGFILE


Then, check if the status of the online redo logs in the table V$logfile is correct, and execute:


ALTER DATABASE ADD LOGFILE MEMBER




Tablespace full [BRCONNECT] [NON-STANDARD]

Cause: A tablespace is full. All tablespaces are checked by default against the same threshold value. However, you can define different threshold values for individual tablespaces by specifying the tablespace name in the OBJECT field of the DBCHECKORA table, using transaction DB17.


For more information, see TABLESPACE_FULL in BRCONNECT Default Conditions for Database Administration.


Action: Extend the tablespace, if necessary, based on your estimate of anticipated growth.




Tablespace in backup mode [BRCONNECT] [NON-STANDARD]

Cause: A tablespace is in backup mode, which reduces the performance of the SAP System. For more information, see TABLESPACE_IN_BACKUP in BRCONNECT Default Conditions for Database Administration.


Action: Confirm that no database backup is running, either with BRBACKUP or an external tool. Then cancel the backup mode by using BRSPACE to reset the backup status.


The standard equivalent to this alert is Tablespace in backup mode in Database Backup/Restore Alerts.




Tablespace offline [BRCONNECT]

Cause: A tablespace is offline. For more information, see TABLESPACE_OFFLINE in BRCONNECT Default Conditions for Database Administration.


Action: Use BRSPACE to set the tablespace online.




Segment with too many extents [BRCONNECT] [NON-STANDARD]

Cause: There are tables or indexes, for which the number of allocated extents exceeds the specified threshold value. All tables or indices are checked by default against the same threshold value. However, you can define different threshold values for individual tablespaces by specifying the tablespace name in the OBJECT field of the DBCHECKORA table (transaction DB17).


For more information, see TOO_MANY_EXTENTS in BRCONNECT Default Conditions for Database Administration.


Action: Increase the MAXEXTENTS limit for the table or index using SQLPLUS with one of the following commands:


ALTER TABLE <name> STORAGE (MAXEXTENTS <number>);


ALTER INDEX <name> STORAGE (MAXEXTENTS <number>);


If you prefer segments with fewer allocated extents, you can use BRSPACE to reorganize the object.


Alternatively, use the –l|limit option of brconnect –f next.


The standard equivalent to this alert is Segments approaching MAX_EXTENTS in Space Management Alerts.





DBA Operations

The alerts in this section correspond to the checks stored in the DBCHECKORA table for database operations.



Last successful archive log backup too old [BRCONNECT] [NON-STANDARD]

Cause: The last successful backup of the offline redo log files with BRARCHIVE is too old. For more information, see ARCHIVE_TOO_OLD in BRCONNECT Default Conditions for Database Operations.


Action: Perform an offline redo log file backup.


The standard equivalent to this alert is Last successful archive log backup in Database Backup/Restore Alerts.




Last successful complete database backup too old [BRCONNECT] [NON-STANDARD]

Cause: The last successful complete backup of the database with BRBACKUP is too old. For more information, see BACKUP_TOO_OLD in BRCONNECT Default Conditions for Database Operations.


Action: Perform a complete database backup.


The standard equivalent to this alert is Last successful complete database backup in Database Backup/Restore Alerts.




Last archive log backup failed [BRCONNECT] [NON-STANDARD]

Cause: The last backup of the offline redo logs with BRARCHIVE has an invalid status. For more information, see LAST_ARCHIVE_FAILED in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat the BRARCHIVE run. For more information, see Command Options for BRARCHIVE.


The standard equivalent to this alert is Last brarchive run in Database Backup/Restore Alerts.




Last complete database backup failed [BRCONNECT] [NON-STANDARD]

Cause: The last complete database backup with BRBACKUP has an invalid status. For more information, see LAST_BACKUP_FAILED in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat the BRBACKUP run. For more information, see Command Options for BRBACKUP.


The standard equivalent to this alert is Last brbackup run in Database Backup/Restore Alerts.




Last operation failed [BRCONNECT]

Cause: The last DBA operation failed, which is identified by a function ID specified in the OBJECT field of the DBCHECKORA table. For more information, see LAST_OPERATION_FAILED in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat the operation. For more information, see the corresponding function in BR*Tools for Oracle Database Administration.




Last update statistics failed [BRCONNECT] [NON-STANDARD]

Cause: The last update of the optimizer statistics with BRCONNECT failed. For more information, see LAST_STATS_FAILED in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat brconnect -f stats. For more information, see Command Options for BRCONNECT.


The standard equivalent to this alert is Last brconnect -f stats run in Database Performance Alerts.




Last successful operation too old [BRCONNECT]

Cause: The last successful DBA operation, identified by a function ID specified in the OBJECT field of the DBCHECKORA table, is too old.. For more information, see OPERATION_TOO_OLD in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat the operation. For more information, see the corresponding function in the BR*Tools for Oracle Database Administration.




Last successful update statistics too old [BRCONNECT] [NON_STANDARD]

Cause: The last successful update statistics run is too old. For more information, see STATS_TOO_OLD in BRCONNECT Default Conditions for Database Operations.


Action: Correct the problem and repeat brconnect –f stats. For more information, see Command Options for BRCONNECT.


The standard equivalent to this alert is Last successful update statistics in Database Performance Alerts.





Oracle Messages

The alerts below correspond to the DBCHECKORA check conditions for database messages in the Oracle alert log. You can find the complete messages with time stamp and text in the message container of the corresponding Monitoring Tree Element (MTE) in the alert monitor.



Deadlock while waiting for resource [BRCONNECT] [NON_STANDARD]

Cause: There is the following message in the Oracle alert log:


ORA-00060: Deadlock detected while waiting for resource


Action: Check the Oracle log / trace file.


The standard equivalent to this alert is Deadlocked resource in Database Performance Alerts.




Error archiving log file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00255: Error archiving log


Action: Check the archive directory.




Archiver error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00257: Archiver error


Action: Check the archive directory.




Error creating archive log [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00270: Error creating archive log


Action: Check to determine whether the storage medium is functioning. Also check whether enough storage space is available.




Error writing archive log [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00272: Error writing archive log


Action: Check to determine whether the storage medium is functioning. Also check whether enough storage space is available.




Database file cannot be read [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00376: File cannot be read at this time


Action: Check the status of the file. Bring the file online if necessary. Contact SAP technical support for additional help, as there are multiple potential causes for this problem.




Fatal error in background process [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00447: Fatal error in background process


Action: Check the Oracle alert log / trace file.




LGWR process terminated with error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00470: LGWR process terminated with error


Action: Check the Oracle alert log / trace file.




DBWR process terminated with error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00471: LGWR process terminated with error


Action: Check the Oracle alert log / trace file.




PMON process terminated with error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00472: PMON process terminated with error


Action: Check the Oracle alert log / trace file.




ARCH process terminated with error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00473: ARCH process terminated with error


Action: Check the Oracle alert log / trace file.




SMON process terminated with error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00474: SMON process terminated with error


Action: Check the Oracle alert log / trace file.




Oracle internal error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00600: Internal error code


Action: Contact Oracle or SAP technical support.




Oracle server session terminated by fatal error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-00603: ORACLE server session terminated by fatal error


Action: Check the Oracle alert log / trace file.




I/O error writing database file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01114: IO error writing block to file Action: Check to determine whether the storage medium is functioning. Also check whether enough storage space is available.




I/O error reading database file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01115: IO error reading block from file


Action: Check to determine whether the storage medium is functioning.




File verification check failed [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01122: Database file failed verification check


Action: Make sure you are using the correct data file and control file for the database and check the last recovery or database copy.




Cannot shutdown – data file in backup mode [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01149: Cannot shutdown – file has online backup set


Action: Terminate the backup.




Snapshot too old [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01555: Snapshot too old


Action: Change the configuration of the rollback segments to enlarge them. Only execute this operation when the database load is low.




Failed to extend rollback [BRCONNECT] [NON_STANDARD]

Cause: There is the following message in the Oracle alert log:


ORA-01562: Failed to extend rollback segment


Action: Use BRSPACE to extend the tablespace PSAPROLL or PSAPUNDO.


The standard equivalent to this alert is Rollback segment extension failed in Space Management Alerts.




Database block corrupted [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01578: ORACLE data block corrupted


Action: Recover the database. Choosing a recovery strategy requires a careful analysis of the failure. We recommend you contact SAP technical support for help with this problem. For more information, see Restore and Recovery.




Max. extents reached for rollback segment [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01628: Max extents reached for rollback segment


Action: Increase the MAXEXTENTS value.




Max. extents reached saving undo for tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01629: Max extents reached saving undo for tablespace


Action: Increase the MAXEXTENTS value.




Max. extents reached in temp segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01630: Max. extents reached in temp segment in tablespace


Action: Increase the MAXEXTENTS value.




Max. extents reached in table [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01631: Max. extents reached in table


Action: Increase the MAXEXTENTS value.




Max. extents reached in index [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01632: Max. extents reached in index


Action: Increase the MAXEXTENTS value.




Unable to extend rollback segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01650: Unable to extend rollback segment in tablespace


Action: Extend the tablespace.




Unable to extend save undo segment for tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01651: Unable to extend save undo segment for tablespace


Action: Extend the tablespace.




Unable to extend temp segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01652: Unable to extend temp segment in tablespace


Action: Extend the tablespace.




Unable to extend table in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01653: Unable to extend table in tablespace


Action: Extend the tablespace.




Unable to extend index in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01654: Unable to extend index in tablespace


Action: Extend the tablespace.




Unable to extend cluster in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01655: Unable to extend cluster in tablespace


Action: Extend the tablespace.




Max. extents reached in cluster [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01656: Max. extents reached in cluster


Action:




Unable to extend lob segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01680: Unable to extend LOG segment in tablespace


Action: Extend the tablespace.




Max. extents reached in LOB segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01681: Max. extents reached in LOB segment in tablespace


Action: Increase the MAXEXTENTS value.




Unable to extend index partition [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01683: Unable to extend index partition


Action: Extend the tablespace.




Max. extents reached in table partition [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01684: Max. extents reached in table partition


Action: Increase the MAXEXTENTS value.




Max. extents reached in index partition [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01685: Max. extents reached in index partition


Action: Increase the MAXEXTENTS value.




Unable to extend table partition [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01688: Unable to extend table partition


Action: Extend the tablespace.




Unable to extend lob segment in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01691: Unable to extend lob segment in tablespace


Action: Extend the tablespace.




Unable to extend lob segment partition in tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01692: Unable to extend lob segment partition in tablespace


Action: Extend the tablespace.




Max. extents reached in lob segment [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01693: Max. extents reached in lob segment


Action: Increase the MAXEXTENTS value.




Max. extents reached in lob segment partition [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-01694: Max. extents reached in lob segment partition


Action: Increase the MAXEXTENTS value.




Exception encountered: core dump [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-07445: Exception encountered: core dump


Action: Call the hotline.




Destination not available for archiving log file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-16014: Log sequence not archived, no available destinations


Action: Check the archive destination.




Log file cannot be archived [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-16038: Log sequence cannot be archived


Action: Check the archive destination.




Write error on log file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-19502: Write error on file


Action: Check the archive destination.




Failed to create log file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-19504: Failed to create file


Action: Check the archive destination.




Failed to set size of blocks for file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-19510: Failed to set size of blocks for file


Action: Check the disk.




Unable to write the header block of file [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-27044: Unable to write the header block of file


Action: Check the disk.




Number of bytes read/written is incorrect [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-27063: Number of bytes read/written is incorrect


Action: Check the disk.




File I/O error [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-27072: I/O error


Action: Check the disk.




Unable to extend segment in undo tablespace [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


ORA-30036: Unable to extend segment in undo tablespace


Action: Extend the tablespace.




Checkpoint not complete [BRCONNECT] [NON-STANDARD]

Cause: There is the following message in the Oracle alert log:


Checkpoint not complete


Action: If this alert message occurs often, there is a database performance problem. To correct the problem, enlarge the online redo log files. For more information, see the Oracle documentation.


The standard equivalent to this alert is Checkpoint not complete in Database Performance Alerts.




Corrupt block [BRCONNECT]

Cause: There is the following message in the Oracle alert log:


Corrupt block: Database block is corrupted


Action: Check the consistency of database blocks.





Profile Parameters

The alerts in this section correspond to the checks stored in the DBCHECKORA table for the database profile. The parameters and the thresholds are contained in the DBCHECKORA table, and correspond to the SAP recommendations on delivery. However, we might later change the recommendations.


Only Oracle 10g profile parameters are shown here. For parameters relating to earlier Oracle releases, see previous versions of this documentation.



Recommendation Recommendation


If there are new recommendations, as specified in SAP Notes 124361 and 180605, change the DBCHECKORA table accordingly.


End of the recommendation.



compatible [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Database for compatibility with Oracle 10


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




control_file_record_keep_time [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Retention time for information on RMAN backups in the control file


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




cursor_space_for_time [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17x.


Database system uses more space for cursors


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




db_block_buffers [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Number of blocks in the database buffer cache


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




db_block size [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Size (bytes) of the Oracle database blocks


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




db_files [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Maximum number of data files


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




db_file_multiblock_read_count [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Number of blocks read during a complete table scan I/O operation


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




filesystemio_options [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


I/O operations on file system files


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




log_archive_start [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


The setting LOG_ARCHIVE_START = TRUE means that automatic archiving is activated when the Oracle instance is started.


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




log_buffer [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Size (bytes) of the redo log buffer in the SGA


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




log_checkpoints_to_alert [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Log checkpoint begin/end to alert file


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




max_dump_file_size [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Maximum size of the dump file


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




open_cursors [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Maximum number of open cursors per user process


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




optimizer_mode [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Controls how the optimizer behaves (for example, rule-based = RULE, or cost-based = CHOOSE).


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




parallel_execution_message_size [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Message buffer size for parallel execution


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




parallel_threads_per_cpu [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Number of parallel execution threads per CPU


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




recyclebin [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Disable recyclebin processing


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




remote_os_authent [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Allow remote clients to use auto-logon accounts


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




replication_dependency_tracking [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Tracking dependency for replication parallel propagation


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




shared_pool_size [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Size in bytes of the shared pool in the System Global Area (SGA)


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




star_transformation_enabled [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Enable the use of star transformation


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




statistics_level [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Statistics level


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




timed_statistics [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Generation of time-related statistics


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




trace_enabled [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Enable tracing


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




undo_management [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Enable automatic undo management


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.




undo_tablespace [BRCONNECT]

Cause: Current setting is outside the range of values preconfigured for this check in transaction DB17.


Undo tablespace name


Action: Verify that this value is set as intended. If so, readjust the preconfigured range of values in transaction DB17.







Không có nhận xét nào:

Đăng nhận xét