AppManager provides the following Knowledge Scripts for monitoring Oracle UNIX Real Application Clusters (RAC).
NOTE:Each Knowledge Script is configured to run at a specific interval. While you can change that interval to suit your needs, we recommend that you not use intervals of less than five minutes. Running at shorter intervals might negatively impact system performance.
After the successful discovery of Oracle RAC and while running the Knowledge Scripts if you receive the ssh_exchange_identification: Connection closed by remote host error, try to increase the value of MaxStartups in the file /etc/ssh/sshd_config.
From the Knowledge Script view of the Control Center Console, you can access more information about any Knowledge Script by selecting it and pressing F1.
Knowledge Scripts |
What It Does |
---|---|
Scans the Oracle RAC database instance, ASM instance, and cluster alert logs for specified entries. |
|
Monitors the ASM Disk IO statistics. |
|
Monitors the ASM Disk usage. |
|
Monitors the status of the Oracle RAC Clusterware daemon services including:
|
|
Monitors the size and usage Oracle RAC datafiles. |
|
Lists the files that have the most number of cold reads and cold writes. |
|
Monitors health for Oracle RAC. |
|
Monitors RAC Node CPU utilization. |
|
Monitors the Redo Log Contention, the number of Redo Log files that are not archived, and the Redo Log Space wait ratio for an Oracle RAC database. |
|
Retrieves statistics of a database instance from the V_$SYSSTAT table of the database. |
|
Monitors the amount of disk space available to the tablespace of an Oracle RAC database. |
|
Monitors the most resource intensive SQL statements. |
|
Monitors the resource usage of current user sessions. |
|
Monitors various user ratios. |
|
Monitors the voting disks status in an Oracle RAC. |
To run a Knowledge Script using SYSDBA authentication, ensure that the user account used to run the UNIX agent is a member of the Oracle Database Administrator (OSDBA) group.
To run all of the Knowledge Scripts in the OracleRACUNIX category, your account must grant you SELECT permissions for all of the following tables:
DBA_DATA_FILES
DBA_FREE_SPACE
DBA_JOBS
DBA_SCHEDULER_JOBS
DBA_SEGMENTS
DBA_TABLESPACES
DBA_TEMP_FILES
DBA_USERS
GV_$INSTANCE (for Oracle RAC monitoring only)
V_$ARCHIVE_DEST
V_$ASM_ALIAS
V_$ASM_DISK
V_$ASM_DISKGROUP
V_$ASM_FILE
V_$BGPROCESS
V_$DATABASE
V_$DATAFILE
V_$DIAG_INFO (for Oracle 11g and later)
V_$INSTANCE
V_$LIBRARYCACHE
V_$LOCK
V_$LOG
V_$OSSTAT
V_$PARAMETER
V_$PROCESS
V_$ROWCACHE
V_$SESSION
V_$SESSTAT
V_$SGASTAT
V_$SORT_SEGMENT
V_$SQLAREA
V_$STATNAME
V_$SYSSTAT
V_$VERSION
V_$WAITSTAT