Oracle RAC Assessment Report
|
Cluster Name | rac-cluster |
OS/Kernel Version | LINUX X86-64 OELRHEL 6 2.6.32-358.el6.x86_64 |
CRS Home - Version | /oracle/app/11.2.0/grid - 11.2.0.4.0 |
DB Home - Version - Names | /oracle/app/oracle/product/11.2.0/db - 11.2.0.4.0 - orcl |
Number of nodes | 2 |
Database Servers | 2 |
ORAchk Version | 12.2.0.1.4_20171212 |
Collection | orachk_rac1_orcl_012518_163134 |
Duration | 8 mins, 43 seconds |
Executed by | oracle |
Arguments | |
Collection Date | 25-Jan-2018 16:36:12 |
Note! This version of ORAchk is considered valid for 76 days from today or until a new version is available
Removing findings in page does not change the original html file. Please use browsers save page button (or press Ctrl+S) to save the report.
Check Id | Status | Type | Message | Status On | Details |
---|---|---|---|---|---|
F9519FD7525B4F01E04313C0E50AC339 | FAIL | OS Check | One or more network card used by clusterware do not have HOTPLUG=NO | All Database Servers | View Hide |
CB95A1BF5B1160ACE0431EC0E50A12EE | FAIL | SQL Check | Table AUD$[FGA_LOG$] should use Automatic Segment Space Management | All Databases | View Hide |
CCF6F44765861F7AE0431EC0E50A72AD | FAIL | OS Check | Operating system hugepages count does not satisfy total SGA requirements | All Database Servers | View Hide |
5C413530675BC12CE053D498EB0A3C84 | FAIL | OS Check | The RMAN snapshot controlfile location is NOT shared on all database nodes in the cluster | All Database Servers | View Hide |
E629958349EF3B7CE04313C0E50AC79D | FAIL | ASM Check | ASM_DISKSTRING parameter is either null or set to /dev/* | All ASM Instances | View Hide |
429C554ED92E4F54E0530D98EB0AE367 | FAIL | OS Check | Database parameter CLUSTER_INTERCONNECTS is not set to the recommended value | All Database Servers | View Hide |
03EB4F8789A15B34E05312C0E50A7AF2 | FAIL | OS Check | Bash is vulnerable to code injection (CVE-2014-6271) | All Database Servers | View Hide |
F7394F6EBAD73B84E04313C0E50A08FA | WARNING | SQL Check | Consider investigating the frequency of SGA resize operations and take corrective action | All Databases | View Hide |
F723B279BA9218A5E04313C0E50A1B01 | WARNING | SQL Check | Consider investigating changes to the schema objects such as DDLs or new object creation | All Databases | View Hide |
DC4495442D7A0CEBE04313C0E50A76E8 | WARNING | OS Check | Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed | All Database Servers | View Hide |
C1D1B240993425B8E0431EC0E50AFEF5 | WARNING | OS Check | Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed | All Database Servers | View Hide |
C1D0BD14BF4A3BCEE0431EC0E50A9DB5 | WARNING | OS Check | Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed | All Database Servers | View Hide |
ADA4E48033A57D05E040E50A1EC0320D | WARNING | OS Check | CSS log file size has not been increased from default (50 MB) . | All Database Servers | View Hide |
E1343A1CE2383400E04313C0E50A0F82 | WARNING | ASM Check | All disk groups should have compatible.asm attribute set to recommended values | All ASM Instances | View Hide |
53BAB95BC9B1D1D4E0530B98EB0AD1BA | WARNING | ASM Check | All disk groups should have compatible.advm attribute set to recommended values | All ASM Instances | View Hide |
3B36CD93FCE82634E0530C98EB0A543F | WARNING | ASM Check | All disk groups should have compatible.rdbms attribute set to recommended values | All ASM Instances | View Hide |
951C025701C65CC5E040E50A1EC0371F | WARNING | OS Check | OSWatcher is not running as is recommended. | All Database Servers | View Hide |
8C9D63D9441C1F52E040E50A1EC0211F | WARNING | OS Check | NIC bonding is NOT configured for public network (VIP) | All Database Servers | View Hide |
5EA8F4C6C6BDF8F0E0401490CACF067F | WARNING | OS Check | NIC bonding is not configured for interconnect | All Database Servers | View Hide |
CB94D8434AA02210E0431EC0E50A7C40 | WARNING | SQL Parameter Check | Database Parameter memory_target is not set to the recommended value | All Instances | View Hide |
856A9B77AF14DD9FE040E50A1EC00285 | WARNING | OS Check | SELinux is being Enforced. | All Database Servers | View Hide |
833F68D88AE57B7CE040E50A1EC02BE7 | WARNING | SQL Check | One or more redo log groups are not multiplexed | All Databases | View Hide |
833F12C25516ACAFE040E50A1EC020F7 | WARNING | SQL Check | Controlfile is NOT multiplexed | All Databases | View Hide |
7EDDA570A1827FBAE040E50A1EC02EB1 | WARNING | OS Check | $ORACLE_HOME/bin/oradism setuid bit is NOT set | All Database Servers | View Hide |
65414495B2047F26E0401490CACF0FED | WARNING | OS Check | OCR is not being backed up daily | All Database Servers | View Hide |
4826A4AB0A937E20E0530E98EB0ACBF3 | WARNING | Patch Check | Oracle patch 19855835 is not applied on RDBMS_HOME | All Homes | View Hide |
470D87B05DCBAFE5E0530E98EB0A11FD | WARNING | Patch Check | Oracle patch 20907061 is not applied on RDBMS_HOME | All Homes | View Hide |
46E9E21E3FDB771EE0530D98EB0A0202 | WARNING | Patch Check | Oracle patch 20476175 is not applied on RDBMS_HOME | All Homes | View Hide |
46E9C37D792A0073E0530A98EB0A4E6F | WARNING | Patch Check | Oracle patch 20879889 is not applied on RDBMS_HOME | All Homes | View Hide |
46E0AFAA5830BAFCE0530E98EB0A7EC1 | WARNING | Patch Check | Oracle patch 19174639 is not applied on RDBMS_HOME | All Homes | View Hide |
46D3EDCB2B3FCC87E0530D98EB0A46EF | WARNING | Patch Check | Oracle patch 24739928 is not applied on RDBMS_HOME | All Homes | View Hide |
4670602AF0A5AA5BE0530D98EB0AE0EB | WARNING | Patch Check | Oracle patch 18498878 is not applied on RDBMS_HOME | All Homes | View Hide |
467047CD7B6AE4F5E0530A98EB0AED0D | WARNING | Patch Check | Oracle patch 22113854 is not applied on RDBMS_HOME | All Homes | View Hide |
45E6969F6C7CE26DE0530C98EB0A8166 | WARNING | Patch Check | Oracle patch 23665623 is not applied on RDBMS_HOME | All Homes | View Hide |
07A76669BB985B6CE05313C0E50ADA40 | WARNING | SQL Check | There are some application objects with STALE statistics. | All Databases | View Hide |
018D62D990EE516DE05313C0E50A49DB | WARNING | OS Check | Cluster Health Monitor (CHM) repository does not provide recommended level of retention | All Database Servers | View Hide |
E850552FBF2B1871E04313C0E50AA887 | INFO | OS Check | Consider increasing the COREDUMPSIZE size | All Database Servers | View Hide |
DC3D819F5D2A50FEE04312C0E50AFF9F | INFO | OS Check | Parallel Execution Health-Checks and Diagnostics Reports | All Database Servers | View Hide |
BBB4357BF09B79D6E0431EC0E50AFB57 | INFO | OS Check | Information about hanganalyze and systemstate dump | All Database Servers | View Hide |
F1C3BD95DE041056E04313C0E50A84B8 | INFO | Patch Check | IMPORTANT: Oracle Database Patch 17478514 PSU is NOT applied to RDBMS Home | All Homes | View Hide |
5E4956EE574FB034E0401490CACF2F84 | INFO | OS Check | Jumbo frames (MTU >= 9000) are not configured for interconnect | All Database Servers | View Hide |
8914F5D0A9AB85BAE040E50A1EC04A31 | INFO | OS Check | Number of SCAN listeners is not equal to the recommended number of 3. | All Database Servers | View Hide |
8347749B14C41005E040E50A1EC03F2E | INFO | ASM Check | oracleasm (asmlib) module is not loaded | All ASM Instances | View Hide |
831B9FABDB6CFCB4E040E50A1EC034C0 | INFO | OS Check | audit_file_dest has audit files older than 30 days | All Database Servers | View Hide |
6890329C1FFFCEDDE040E50A1EC02FED | INFO | OS Check | At some times checkpoints are not being completed | All Database Servers | View Hide |
66EBC49E368387CAE040E50A1EC03B98 | INFO | OS Check | background_dump_dest has files older than 30 days | All Database Servers | View Hide |
66E6B013BAE3EFBEE040E50A1EC01F87 | INFO | OS Check | user_dump_dest has trace files older than 30 days | All Database Servers | View Hide |
6556EAA74E28214FE0401490CACF6C89 | INFO | OS Check | $CRS_HOME/log/hostname/client directory has too many older log files. | All Database Servers | View Hide |
12D2EC59B5677B0BE05312C0E50AAF78 | INFO | OS Check | Most recent ADR incidents | All Database Servers | View Hide |
0585FC662BC556DCE05312C0E50AB518 | INFO | OS Check | Important Storage Minimum Requirements for Grid & Database Homes | All Database Servers | View Hide |
02DE6186B8040599E05312C0E50A76F6 | INFO | ASM Check | Oracle Data Pump Best practices. | All ASM Instances | View Hide |
0257EE4166C43F08E05312C0E50A7D8E | INFO | OS Check | Important Automatic Storage Management (ASM) Notes and Technical White Papers | All Database Servers | View Hide |
E47ECDCFE09A122CE04313C0E50A35EC | PASS | OS Check | There are no duplicate parameter entries in the database init.ora(spfile) file | All Database Servers | View Hide |
2FE891F7E8F6F03AE0530D98EB0A1F67 | PASS | OS Check | Database parameter service_names is not defined in spfile | All Database Servers | View Hide |
F8BFFF523E81644EE04312C0E50A53BA | PASS | OS Check | kernel.panic_on_oops parameter is configured according to recommendation | All Database Servers | View Hide |
F733E8274650079DE04312C0E50AEF50 | PASS | SQL Check | No waiter sessions found currently for application users | All Databases | View Hide |
F723F251083F31B5E04312C0E50A6BFB | PASS | SQL Check | The database parameter session_cached_cursors is set to the recommended value | All Databases | View Hide |
F02293F7261D1BCAE04312C0E50A4118 | PASS | ASM Check | ASM disk permissions are set as recommended | All ASM Instances | View Hide |
F01E3FEDBD2B243EE04312C0E50A4DC5 | PASS | ASM Check | ASM disks have enough free space for rebalance | All ASM Instances | View Hide |
ED58D80CE0FA4B48E04313C0E50A91B9 | PASS | SQL Check | All optimizer related parameters are set to the default value (Parameter Set 2 of 3) | All Databases | View Hide |
ED57C07F184E4B79E04312C0E50AB237 | PASS | SQL Check | All optimizer related parameters are set to the default value (Parameter Set 3 of 3) | All Databases | View Hide |
ED4F493804CE75EBE04313C0E50ABCF8 | PASS | SQL Check | No obsolete initialization parameters are set | All Databases | View Hide |
EC1D5CE0B4371BB6E04312C0E50A5C3A | PASS | SQL Check | Database parameter OPTIMIZER_FEATURES_ENABLE is set to the current database version | All Databases | View Hide |
EC1BDA4542E327FDE04312C0E50A5BB6 | PASS | SQL Check | Database parameter NLS_SORT is set to BINARY | All Databases | View Hide |
E96A3ED23AC91994E04312C0E50ABD03 | PASS | OS Check | Online (hot) patches are not applied to CRS_HOME. | All Database Servers | View Hide |
E960DB20CA5A634FE04312C0E50A62E0 | PASS | SQL Check | Table containing SecureFiles LOB storage belongs to a tablespace with extent allocation type that is SYSTEM managed (AUTOALLOCATE) | All Databases | View Hide |
E94AC6ACDA502F3BE04312C0E50A290A | PASS | ASM Check | ASM memory_target is set to recommended value | All ASM Instances | View Hide |
E94589BC1AC24CFBE04312C0E50A3849 | PASS | OS Check | Online (hot) patches are not applied to ORACLE_HOME | All Database Servers | View Hide |
E84C19843A7E7CA2E04313C0E50A3ED0 | PASS | SQL Check | All optimizer related parameters are set to the default value (Parameter Set 1 of 3) | All Databases | View Hide |
E7E213A6D9151EEBE04312C0E50A85C3 | PASS | OS Check | Berkeley Database location points to correct GI_HOME | All Database Servers | View Hide |
E1DF2A6140395D42E04312C0E50A0A6C | PASS | ASM Check | All diskgroups from v$asm_diskgroups are registered in clusterware registry | All ASM Instances | View Hide |
E18D7F9837B7754EE04313C0E50AD4AA | PASS | OS Check | Package cvuqdisk-1.0.9-1-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
E12A91DC10F31AD7E04312C0E50A6361 | PASS | OS Check | pam_limits configured properly for shell limits | All Database Servers | View Hide |
E10E99868C34569BE04313C0E50A44C1 | PASS | OS Check | vm.min_free_kbytes is set as recommended. | All Database Servers | View Hide |
DCB4C2CB907F4C76E04312C0E50A7667 | PASS | OS Check | Linux transparent huge pages are disabled | All Database Servers | View Hide |
D348A289DD032396E0431EC0E50A26D5 | PASS | OS Check | OCR and Voting disks are stored in ASM | All Database Servers | View Hide |
D0C2640EBA071F73E0431EC0E50AA159 | PASS | OS Check | System clock is synchronized to hardware clock at system shutdown | All Database Servers | View Hide |
DC28F07D94FD1B10E04313C0E50A9FD8 | PASS | OS Check | TFA Collector is installed and running | All Database Servers | View Hide |
DBC2C9218542349FE04312C0E50AC1E9 | PASS | OS Check | No clusterware resource are in unknown state | All Database Servers | View Hide |
D9A5C0E2DE430A85E04312C0E50AC8B0 | PASS | ASM Check | No corrupt ASM header blocks indicated in ASM alert log (ORA-15196 errors) | All ASM Instances | View Hide |
D957C871B811597AE04312C0E50A91BF | PASS | ASM Check | No disks found which are not part of any disk group | All ASM Instances | View Hide |
D692927211732642E0431EC0E50A342B | PASS | OS Check | loopback address is configured as recommended in /etc/hosts | All Database Servers | View Hide |
D35CE19AE68165F3E0431EC0E50A4C09 | PASS | OS Check | Redo log write time is less than 500 milliseconds | All Database Servers | View Hide |
CB5BD768E88F7F71E0431EC0E50A346F | PASS | OS Check | Package libgcc-4.4.4-13.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
6B515A724AB85906E040E50A1EC039F6 | PASS | SQL Check | No read/write errors found for ASM disks | All Databases | View Hide |
C1D39B834AA46E44E0431EC0E50A5366 | PASS | OS Check | Package sysstat-9.0.4-11.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D39B834AA36E44E0431EC0E50A5366 | PASS | OS Check | Package libgcc-4.4.4-13.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D34D17A4F45402E0431EC0E50A5DD9 | PASS | OS Check | Package binutils-2.20.51.0.2-5.11.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D348AB978E3873E0431EC0E50A19F0 | PASS | OS Check | Package glibc-2.12-1.7.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D30E313A4C0B0BE0431EC0E50A1931 | PASS | OS Check | Package libstdc++-4.4.4-13.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D2A95C2BF31FE4E0431EC0E50AB101 | PASS | OS Check | Package libstdc++-4.4.4-13.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D29B4860DA19C2E0431EC0E50AFB36 | PASS | OS Check | Package glibc-2.12-1.7.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D29B4860D919C2E0431EC0E50AFB36 | PASS | OS Check | Package gcc-4.4.4-13.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1CC4D830F3B90E0431EC0E50A559F | PASS | OS Check | Package make-3.81-19.el6 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1CC4D830E3B90E0431EC0E50A559F | PASS | OS Check | Package libstdc++-devel-4.4.4-13.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1BA6C1CD213F9E0431EC0E50A8B9C | PASS | OS Check | Package libaio-devel-0.3.107-10.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1BA6C1CD013F9E0431EC0E50A8B9C | PASS | OS Check | Package libaio-0.3.107-10.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1B240991A25B8E0431EC0E50AFEF5 | PASS | OS Check | Package compat-libstdc++-33-3.2.3-69.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D1973D1B4C0EA1E0431EC0E50A9108 | PASS | OS Check | Package glibc-devel-2.12-1.7.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D15659D96376CBE0431EC0E50A74F5 | PASS | OS Check | Package glibc-devel-2.12-1.7.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D15659D96276CBE0431EC0E50A74F5 | PASS | OS Check | Package compat-libcap1-1.10-1-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D0EE98B4BC4083E0431EC0E50ADCB2 | PASS | OS Check | Package ksh-20100621-12.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1D0BD14BF493BCEE0431EC0E50A9DB5 | PASS | OS Check | Package libaio-0.3.107-10.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
C1D0BD14BF483BCEE0431EC0E50A9DB5 | PASS | OS Check | Package libstdc++-devel-4.4.4-13.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1CF431B59054969E0431EC0E50A9B88 | PASS | OS Check | Package gcc-c++-4.4.4-13.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1CF431B59034969E0431EC0E50A9B88 | PASS | OS Check | Package compat-libstdc++-33-3.2.3-69.el6-x86_64 meets or exceeds recommendation | All Database Servers | View Hide |
C1CEC9D9E9432BDFE0431EC0E50AF329 | PASS | OS Check | Package libaio-devel-0.3.107-10.el6-i686 meets or exceeds recommendation | All Database Servers | View Hide |
89130F49748E6CC7E040E50A1EC07A44 | PASS | OS Check | Remote listener is set to SCAN name | All Database Servers | View Hide |
65F8FA5F9B838079E040E50A1EC059DC | PASS | OS Check | Value of remote_listener parameter is able to tnsping | All Database Servers | View Hide |
D6972E101386682AE0431EC0E50A9FD9 | PASS | OS Check | No server-side TNSNAMES.ora aliases resolve using SCAN EZ syntax | All Database Servers | View Hide |
D6972E101384682AE0431EC0E50A9FD9 | PASS | OS Check | ezconnect is configured in sqlnet.ora | All Database Servers | View Hide |
BD7E4DDEE2B06BABE0431EC0E50AED9B | PASS | SQL Check | No Duplicate objects were found in the SYS and SYSTEM schemas | All Databases | View Hide |
BD53C41D0F1102DDE0431EC0E50A5B4C | PASS | SQL Check | No Invalid Registry Components were found | All Databases | View Hide |
B167E5248D476B74E0431EC0E50A3E27 | PASS | SQL Check | All bigfile tablespaces have non-default maxbytes values set | All Databases | View Hide |
AD6481CF9BDD6058E040E50A1EC021EC | PASS | OS Check | umask for RDBMS owner is set to 0022 | All Database Servers | View Hide |
A18401E2DDFF63D2E040E50A1EC077C4 | PASS | OS Check | ORA_CRS_HOME environment variable is not set for Grid infrastructure owner | All Database Servers | View Hide |
9EB883858764342DE040E50A1EC0359A | PASS | OS Check | Oracle database software owner hard stack shell limit is configured according to recommendation | All Database Servers | View Hide |
9EB848CDD040ACADE040E50A1EC01840 | PASS | OS Check | Oracle database software owner soft nofile shell limits is configured according to recommendation | All Database Servers | View Hide |
9EB84272626BFF6EE040E50A1EC02AF3 | PASS | OS Check | Oracle database software owner hard nproc shell limits is configured according to recommendation | All Database Servers | View Hide |
64DC3E59CB88B984E0401490CACF1104 | PASS | SQL Parameter Check | asm_power_limit is set to recommended value of 1 | All Instances | View Hide |
90DCECE833790E9DE040E50A1EC0750A | PASS | OS Check | CSS reboot time is set to the default value of 3 | All Database Servers | View Hide |
90DCB860F9380638E040E50A1EC07248 | PASS | OS Check | CSS disktimeout is set to the default value of 200 | All Database Servers | View Hide |
8E1B5EE973BAA8C6E040E50A1EC0622E | PASS | OS Check | ohasd Log Ownership is Correct (root root) | All Database Servers | View Hide |
8E1A46CB0BDA0608E040E50A1EC022CD | PASS | OS Check | ohasd/orarootagent_root Log Ownership is Correct (root root) | All Database Servers | View Hide |
8E197A76D887BAC4E040E50A1EC07E0B | PASS | OS Check | crsd/orarootagent_root Log Ownership is Correct (root root) | All Database Servers | View Hide |
8E19457488167806E040E50A1EC00310 | PASS | OS Check | crsd Log Ownership is Correct (root root) | All Database Servers | View Hide |
898E1DF96754C57FE040E50A1EC03224 | PASS | ASM Check | CRS version is higher or equal to ASM version. | All ASM Instances | View Hide |
8915B823FCEBC259E040E50A1EC04AD6 | PASS | OS Check | Local listener init parameter is set to local node VIP | All Database Servers | View Hide |
87604C73D768DF7AE040E50A1EC0566B | PASS | OS Check | All voting disks are online | All Database Servers | View Hide |
90E150135F6859C4E040E50A1EC01FF5 | PASS | OS Check | CSS misscount is set to the default value of 30 | All Database Servers | View Hide |
85F282CFD5DADCB4E040E50A1EC01BC9 | PASS | SQL Check | All redo log files are of same size | All Databases | View Hide |
8529D3798EA039F3E040E50A1EC07218 | PASS | OS Check | Public interface is configured and exists in OCR | All Database Servers | View Hide |
84C193C69EE36512E040E50A1EC06466 | PASS | OS Check | ip_local_port_range is configured according to recommendation | All Database Servers | View Hide |
84BE8B9C4817090DE040E50A1EC07DB8 | PASS | OS Check | kernel.shmmax parameter is configured according to recommendation | All Database Servers | View Hide |
84BE4DE1F00AD833E040E50A1EC07771 | PASS | OS Check | Kernel Parameter fs.file-max is configuration meets or exceeds recommendation | All Database Servers | View Hide |
841FD604C3C8F2B1E040E50A1EC0122F | PASS | OS Check | Free space in /tmp directory meets or exceeds recommendation of minimum 1GB | All Database Servers | View Hide |
841F0977B92F0185E040E50A1EC070BB | PASS | OS Check | Oracle database software owner soft nproc shell limit is configured according to recommendation | All Database Servers | View Hide |
841A3A9F4A74AC6AE040E50A1EC03FC0 | PASS | OS Check | Oracle database software owner hard nofile shell limit is configured according to recommendation | All Database Servers | View Hide |
83C301ACFF203C9BE040E50A1EC067EB | PASS | OS Check | Linux swap configuration meets or exceeds recommendation | All Database Servers | View Hide |
834835A4EC032658E040E50A1EC056F6 | PASS | OS Check | /tmp is on a dedicated filesystem | All Database Servers | View Hide |
8343C0D6A9D8702BE040E50A1EC045C8 | PASS | SQL Check | All data and temporary files are autoextensible | All Databases | View Hide |
7EDE9EBEC9429FBAE040E50A1EC03AED | PASS | OS Check | $ORACLE_HOME/bin/oradism ownership is root | All Database Servers | View Hide |
77029A014E159389E040E50A1EC02060 | PASS | SQL Check | Avg message sent queue time on ksxp is <= recommended | All Databases | View Hide |
770244572FC70393E040E50A1EC01299 | PASS | SQL Check | Avg message sent queue time is <= recommended | All Databases | View Hide |
7701CFDB2F6EF98EE040E50A1EC00573 | PASS | SQL Check | Avg message received queue time is <= recommended | All Databases | View Hide |
7674FEDB08C2FDA2E040E50A1EC0156F | PASS | SQL Check | No Global Cache lost blocks detected | All Databases | View Hide |
7674C09669C5BCE6E040E50A1EC011E5 | PASS | SQL Check | Failover method (SELECT) and failover mode (BASIC) are configured properly | All Databases | View Hide |
670FE09A93E12317E040E50A1EC018E9 | PASS | SQL Check | Avg GC CURRENT Block Receive Time Within Acceptable Range | All Databases | View Hide |
670FE09A93E02317E040E50A1EC018E9 | PASS | SQL Check | Avg GC CR Block Receive Time Within Acceptable Range | All Databases | View Hide |
66FEB2848B21DB24E040E50A1EC00A0C | PASS | SQL Check | Tablespace allocation type is SYSTEM for all appropriate tablespaces | All Databases | View Hide |
66EABE4A113A3B1EE040E50A1EC006B2 | PASS | OS Check | Alert log is not too big | All Database Servers | View Hide |
66EAB3BB6CF79C54E040E50A1EC06084 | PASS | OS Check | No ORA-07445 errors found in alert log | All Database Servers | View Hide |
66E70B43167837ABE040E50A1EC02FEA | PASS | OS Check | No ORA-00600 errors found in alert log | All Database Servers | View Hide |
66E59E657BFC85F4E040E50A1EC0501D | PASS | OS Check | core_dump_dest does not have too many older core dump files | All Database Servers | View Hide |
669862F59599CA2AE040E50A1EC018FD | PASS | OS Check | Kernel Parameter SEMMNS OK | All Database Servers | View Hide |
66985D930D2DF070E040E50A1EC019EB | PASS | OS Check | Kernel Parameter kernel.shmmni OK | All Database Servers | View Hide |
6697946779AC8AD3E040E50A1EC03C0E | PASS | OS Check | Kernel Parameter SEMMSL OK | All Database Servers | View Hide |
6696C7B368784A66E040E50A1EC01B92 | PASS | OS Check | Kernel Parameter SEMMNI OK | All Database Servers | View Hide |
66959FC16B423896E040E50A1EC07CDC | PASS | OS Check | Kernel Parameter SEMOPM OK | All Database Servers | View Hide |
6694F204EE47A92DE040E50A1EC07145 | PASS | OS Check | Kernel Parameter kernel.shmall OK | All Database Servers | View Hide |
6580DCAAE8A28F5BE0401490CACF6186 | PASS | OS Check | The number of async IO descriptors is sufficient (/proc/sys/fs/aio-max-nr) | All Database Servers | View Hide |
64C6C337366EA439E0401490CACF4D07 | PASS | SQL Check | There are no Invalid Java Objects in the database. | All Databases | View Hide |
6050196F644254BDE0401490CACF203D | PASS | OS Check | net.core.rmem_max is Configured Properly | All Database Servers | View Hide |
60500BAFB377E3ADE0401490CACF2245 | PASS | SQL Parameter Check | Instance is using spfile | All Instances | View Hide |
5F01FA5CCC69964DE053D298EB0A992B | PASS | ASM Check | ASM Audit file destination file count <= 100,000 | All ASM Instances | View Hide |
5E5B7EEA0010DC6BE0401490CACF3B82 | PASS | OS Check | Interconnect is configured on non-routable network addresses | All Database Servers | View Hide |
5DC831A764D8711BE0401490CACF7D52 | PASS | OS Check | OCR is mirrored using Oracle redundancy | All Database Servers | View Hide |
5DC7EBCB6B72E046E0401490CACF321A | PASS | OS Check | None of the hostnames contains an underscore character | All Database Servers | View Hide |
5ADE14B5205111D1E0401490CACF673B | PASS | OS Check | net.core.rmem_default Is Configured Properly | All Database Servers | View Hide |
5ADD88EC8E0AFF2EE0401490CACF0C10 | PASS | OS Check | net.core.wmem_max Is Configured Properly | All Database Servers | View Hide |
5ADCECF64757E914E0401490CACF4BBD | PASS | OS Check | net.core.wmem_default Is Configured Properly | All Database Servers | View Hide |
597839F837D44230E053D198EB0A7E73 | PASS | SQL Check | cluster_database_instances database parameter is set to default value | All Databases | View Hide |
596164523FF4C849E0401490CACF7EE3 | PASS | SQL Check | ARCHIVELOG mode is enabled | All Databases | View Hide |
4D0E759B219F24C3E0530A98EB0A6C08 | PASS | OS Check | None of the hostnames contains an underscore character | All Database Servers | View Hide |
4B8B98A9C9644FADE0401490CACF6528 | PASS | SQL Check | SYS.AUDSES$ sequence cache size >= 10,000 | All Databases | View Hide |
4B881724781BB7BEE0401490CACF59FD | PASS | SQL Check | SYS.IDGEN1$ sequence cache size >= 1,000 | All Databases | View Hide |
4AD656FDB01EAAE1E0530D98EB0A84CF | PASS | OS Check | OCR and OCR backup locations are not in the same path | All Database Servers | View Hide |
494DAA11615B67D6E0530D98EB0A34D3 | PASS | OS Check | Private and public network subnet configuration is correct in OCR | All Database Servers | View Hide |
39CE33CDAC4B81EDE0530C98EB0ACBAA | PASS | OS Check | Cluster nodes appear to be correctly numbered | All Database Servers | View Hide |
2F1499DF66C0C395E0530D98EB0AF121 | PASS | SQL Check | AWR Space consumption is less than 50% of total SYSAUX space | All Databases | View Hide |
2EBB3345399525E2E0530A98EB0AA27A | PASS | SQL Check | Failover method (SELECT) and failover mode (BASIC) are configured properly | All Databases | View Hide |
218A2D0660AD1EAAE0530C98EB0A1191 | PASS | OS Check | /boot has enough free space | All Database Servers | View Hide |
20FC8CAC7445DF10E0530E98EB0A09AF | PASS | OS Check | Oracle database software owner soft stack shell limit is configured according to recommendation | All Database Servers | View Hide |
1847B3947928D848E0530B98EB0ABBDA | PASS | SQL Check | None of the tablespaces have recyclebin objects consuming space more than 100 KB. | All Databases | View Hide |
1832702CA36E9A8BE0530B98EB0AB5A9 | PASS | SQL Check | None of the database users have more than 10 recyclebin objects in it. | All Databases | View Hide |
EC1C37C834BD3475E04312C0E50A7FEB | PASS | SQL Check | Database parameter DB_FILE_MULTIBLOCK_READ_COUNT is unset as recommended | All Databases | View Hide |
135F449E978C3B44E05313C0E50ABE53 | PASS | OS Check | PGA allocation for all databases is not more than total memory available on this system | All Database Servers | View Hide |
0EC55FAA1A0125FFE05312C0E50AE9E4 | PASS | OS Check | Hidden database initialization parameters are not set per best practice recommendations | All Database Servers | View Hide |
0EC203BA8AB807D4E05312C0E50A0FA8 | PASS | ASM Check | Hidden ASM initialization parameters are not set per best practice recommendations | All ASM Instances | View Hide |
0D13FFDA6C7F5E01E05313C0E50A4C97 | PASS | OS Check | Free space in /etc directory meets or exceeds recommendation of minimum 1GB | All Database Servers | View Hide |
0D12A9722FBA54F4E05313C0E50ACFDF | PASS | OS Check | Free space in /var directory meets or exceeds recommendation of minimum 1GB | All Database Servers | View Hide |
07A3E6A60EB103C7E05313C0E50A24DA | PASS | SQL Check | No non-default AWR settings found. | All Databases | View Hide |
078C3A95E8BF672CE05312C0E50A0501 | PASS | SQL Check | Non-AWR Space consumption is less than 50% of total SYSAUX space | All Databases | View Hide |
0582BF80C7D10AB5E05313C0E50A1584 | PASS | OS Check | free physical memory is at sufficient level on system | All Database Servers | View Hide |
0582515965486615E05313C0E50AA8F8 | PASS | OS Check | system is started with runlevel 3 or 5 | All Database Servers | View Hide |
05810A7A2BB35F1AE05313C0E50AB854 | PASS | OS Check | /boot is mounted | All Database Servers | View Hide |
0580BF75E8844B73E05312C0E50A2B65 | PASS | OS Check | /dev/shm is mounted as temporary file system | All Database Servers | View Hide |
03CAC195BC875E34E05313C0E50AC351 | PASS | SQL Check | TIMED_STATISTICS is set to recommended value. | All Databases | View Hide |
03C336799EEF3444E05313C0E50A0D3C | PASS | SQL Check | STATISTICS_LEVEL is set to recommended value. | All Databases | View Hide |
026DF829123D2136E05313C0E50AFE7B | PASS | SQL Check | AWR_FLUSH_EMERGENCY_COUNT value is equal to ZERO | All Databases | View Hide |
Outage Type | Check Id | Status | Type | Message | Status On | Details | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATABASE FAILURE PREVENTION BEST PRACTICES | PASS | [Updated: 03/09/17] Oracle database can be configured with best practices that are applicable to all Oracle databases, including single-instance, Oracle RAC databases, Oracle RAC One Node databases, and the primary and standby databases in Oracle Data Guard or Oracle GoldenGate configurations. Key HA Benefits: (1) Improved recoverability (2) Improved stability | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
COMPUTER FAILURE PREVENTION BEST PRACTICES | INFO | [Updated: 03/09/17] Oracle RAC and Oracle Clusterware allow Oracle Database to run any packaged or custom application across a set of clustered servers. This capability provides server side high availability and scalability. If a clustered server fails, then Oracle Database continues running on the surviving servers. When more processing power is needed, you can add another server without interrupting access to data.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATA CORRUPTION PREVENTION BEST PRACTICES | PASS | [Updated: 03/09/17] To achieve the most comprehensive data corruption prevention and detection , use Oracle Active Data Guard and configure DB_BLOCK_CHECKSUM,DB_LOST_WRITE_PROTECT and DB_BLOCK_CHECKING database initialization parameters on the primary database and all standby databases in a Data Guard environment. Workload specific testing is required to assess whether the performance overhead with especially DB_BLOCK_CHECKING is acceptable. Using ASM, RMAN, Exadata Storage and Zero Data Loss Recovery Appliance (Recovery Appliance) provide additional data protection checks and repair for Oracle databases and backups. Key HA Benefits
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LOGICAL CORRUPTION PREVENTION BEST PRACTICES | PASS | [Updated: 03/09/17] Oracle Flashback Technology enables fast logical failure repair. Oracle recommends that you use automatic undo management with sufficient space to attain your desired undo retention guarantee, enable Oracle Flashback Database, and allocate sufficient space and I/O bandwidth in the fast recovery area. Application monitoring is required for early detection. Effective and fast repair comes from leveraging and rehearsing the most common application specific logical failures and using the different flashback features effectively (e.g flashback query, flashback version query, flashback transaction query, flashback transaction, flashback drop, flashback table, and flashback database, and 12.2 flashback pluggable database (PDB)). Key HA Benefits:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATABASE/CLUSTER/SITE FAILURE PREVENTION BEST PRACTICES | INFO | [Updated: 03/09/17] Active Data Guard is the real-time data protection and availability solution that eliminates single point of failure by maintaining one or more synchronized physical replicas of the production database. If an unplanned outage of any kind impacts the production database, applications and users can quickly failover to a synchronized standby, minimizing downtime and preventing data loss. An Active Data Guard standby can be used to offload read-only applications, ad-hoc queries, and backups from the primary database or be dual-purposed as a test system at the same time it provides disaster protection. An Active Data Guard standby can also be used to minimize downtime for planned maintenance when upgrading to new Oracle Database patch sets and major database releases and for select migrations. For zero data loss protection and fastest recovery time, deploy a local Data Guard standby database with Data Guard Fast-Start Failover and integrated client failover. For protection against outages impacting the entire data center, or a broad geography, deploy a Data Guard standby database at a remote location. Oracle 12c Far Sync Standby can achieve zero data loss protection across Wide Area Network or across regions. Key HA Benefits:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CLIENT FAILOVER OPERATIONAL BEST PRACTICES | PASS | [Updated: 03/09/17] A highly available architecture requires the ability of the application tier to transparently fail over to a surviving instance or database advertising the required service. This ensures that applications are generally available or minimally impacted in the event of node failure, instance failure, or database failures. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ORACLE RECOVERY MANAGER(RMAN) BEST PRACTICES | PASS | [Updated: 03/09/17] Oracle Recovery Manager (RMAN) is an Oracle Database utility to manage database backup and, more importantly, the recovery of the database. RMAN eliminates operational complexity while providing superior performance and availability of the database.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ORACLE GOLDENGATE FAILURE PREVENTION BEST PRACTICES | INFO | [Updated: 03/09/17] Oracle GoldenGate is Oracle's strategic logical replication solution for data distribution and data integration. Unlike replication solutions from other vendors, Oracle GoldenGate is more closely integrated with Oracle Database while also providing an open, modular architecture ideal for replication across heterogeneous database management systems. This combination of attributes eliminates compromise, making Oracle GoldenGate the preferred replication solution for addressing requirements that span Oracle Database and non-Oracle Database environments. Key HA Benefits:
Oracle Active Data Guard and Oracle GoldenGate are essential components of the Gold and Platinum MAA tiers. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OPERATIONAL BEST PRACTICES | INFO | [Updated: 03/09/17] Operational best practices are an essential prerequisite to high availability. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATABASE CONSOLIDATION BEST PRACTICES | INFO | [Updated: 03/09/17] Database consolidation requires additional planning and management to ensure HA requirements are met. |
Patch | CRS | ASM | RDBMS | RDBMS_HOME | Patch-Description |
---|---|---|---|---|---|
22502505 | not-applied | n/a | not-applied | /oracle/app/oracle/product/11.2.0/db | ACFS PSU 11.2.0.4.160419 |
26392168 | not-applied | n/a | not-applied | /oracle/app/oracle/product/11.2.0/db | DB PSU 11.2.0.4.171017 (INCLUDES CPUOCT2017) |
26609929 | not-applied | n/a | not-applied | /oracle/app/oracle/product/11.2.0/db | OCW PSU 11.2.0.4.170814 |
Patch | RDBMS | ASM | Type | Patch-Description |
---|---|---|---|---|
26392168 | not-applied | n/a | merge | DB PSU 11.2.0.4.171017 (INCLUDES CPUOCT2017) |
26609929 | not-applied | n/a | merge | OCW PSU 11.2.0.4.170814 |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify no duplicate parameter entries in database init.ora(spfile) orcl2.__db_cache_size=230686720 orcl1.__db_cache_size=260046848 orcl2.__java_pool_size=4194304 orcl1.__java_pool_size=4194304 orcl2.__large_pool_size=16777216 orcl1.__large_pool_size=16777216 orcl1.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment orcl2.__pga_aggregate_target=314572800 orcl1.__pga_aggregate_target=306184192 orcl2.__sga_target=465567744 orcl1.__sga_target=473956352 orcl2.__shared_io_pool_size=0 orcl1.__shared_io_pool_size=0 orcl2.__shared_pool_size=201326592 orcl1.__shared_pool_size=180355072 orcl2.__streams_pool_size=0 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify service_names parameter is not defined in spfile orcl2.__db_cache_size=230686720 orcl1.__db_cache_size=260046848 orcl2.__java_pool_size=4194304 orcl1.__java_pool_size=4194304 orcl2.__large_pool_size=16777216 orcl1.__large_pool_size=16777216 orcl1.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment orcl2.__pga_aggregate_target=314572800 orcl1.__pga_aggregate_target=306184192 orcl2.__sga_target=465567744 orcl1.__sga_target=473956352 orcl2.__shared_io_pool_size=0 orcl1.__shared_io_pool_size=0 orcl2.__shared_pool_size=201326592 orcl1.__shared_pool_size=180355072 orcl2.__streams_pool_size=0 |
Status on rac1: |
DATA FROM RAC1 - VERIFY HOTPLUG ATTRIBUTE ON NETWORK CARDS USED BY CLUSTERWARE Contents of /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE="eth0" BOOTPROTO=none IPV6INIT="yes" NM_CONTROLLED="yes" ONBOOT="yes" TYPE="Ethernet" UUID="97ca30ff-3e7a-40b3-928d-0462fa2d35e0" HWADDR=00:0C:29:DB:C4:40 IPADDR=192.168.133.120 PREFIX=24 GATEWAY=192.168.133.1 DEFROUTE=yes IPV4_FAILURE_FATAL=yes IPV6_AUTOCONF=yes |
Status on rac1: |
DATA FROM RAC1 - KERNEL.PANIC_ON_OOPS 1 |
Status on orcl: |
DATA FOR ORCL FOR MONITORING SGA RESIZE OPERATIONS COMPONENT OPER_TYPE COUNT(1) ------------------------- ------------- ---------- DEFAULT buffer cache GROW 1 |
Status on orcl: |
DATA FOR ORCL FOR MONITORING WAITER SESSIONS Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR SESSION_CACHED_CURSORS PARAMETER SESSION_CACHED_CURSORS: Current Value = 50 Usage = 11 Percentage Usage = 22% |
Status on orcl: |
DATA FOR ORCL FOR MONITORING CHANGES TO SCHEMA OBJECTS OWNER OBJECT_NAME OBJECT_TYP CREATED LAST_DDL_ TIMESTAMP STATUS --------------- ------------------------- ---------- --------- --------- ------------------- ------- ORACLE_OCM MGMT_CONFIG_JOB JOB 24-AUG-13 24-JAN-18 2018-01-24:12:26:02 VALID EXFSYS RLM$SCHDNEGACTION JOB 24-AUG-13 24-JAN-18 2018-01-24:12:26:02 VALID EXFSYS RLM$EVTCLEANUP JOB 24-AUG-13 24-JAN-18 2018-01-24:12:26:01 VALID RYL TEST TABLE 23-JAN-18 23-JAN-18 2018-01-23:15:12:24 VALID ORACLE_OCM MGMT_STATS_CONFIG_JOB JOB 24-AUG-13 22-JAN-18 2018-01-22:10:16:59 VALID |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - VERIFY ASM DISK PERMISSIONS crw-rw----. 1 grid asmadmin 162, 3 Jan 25 16:44 /dev/raw/raw3 crw-rw----. 1 grid asmadmin 162, 1 Jan 25 16:44 /dev/raw/raw1 crw-rw----. 1 grid asmadmin 162, 2 Jan 25 16:43 /dev/raw/raw2 |
Status on rac1: |
DATA FROM RAC1 - VERIFY FREE DISK SPACE FOR REBALANCE DATA_0001|/dev/raw/raw3|776 DATA_0000|/dev/raw/raw2|773 OCR_0000|/dev/raw/raw1|628 |
Status on orcl: |
DATA FOR ORCL FOR OPTIMIZER PARAMETERS WITH NON-DEFAULT SETTINGS (CHECK 2) Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR OPTIMIZER PARAMETERS WITH NON-DEFAULT SETTINGS (CHECK 3) Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR OBSOLETE DATABASE PARAMETERS FOR 11.2 Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR OPTIMIZER_FEATURES_ENABLE PARAMETER Database Version = 11.2.0.4.0 optimizer_features_enable parameter = 11.2.0.4 |
Status on orcl: |
DATA FOR ORCL FOR NLS_SORT PARAMETER nls_sort parameter value from nls_database_parameters = BINARY nls_sort parameter value from nls_instance_parameters = nls_sort parameter value from nls_session_parameters = BINARY nls_sort parameter value from v$parameter = |
Status on rac1: |
DATA FROM RAC1 - VERIFY ONLINE (HOT) PATCHES ARE NOT APPLIED ON CRS_HOME ls: cannot access /oracle/app/11.2.0/grid/hpatch/: No such file or directory |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR TABLESPACE EXTENT MANAGEMENT ALLOCATION TYPE FOR SECUREFILES LOB STORAGE Query returned no rows which is expected when the SQL check passes. |
Status on rac1: |
DATA FROM RAC1 - ASM MEMORY_TARGET SIZE MEMORY_TARGET -------------------------------------------------------------- ASM memory_target = 1076M |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify online (hot) patches are not applied on ORACLE_HOME Patch File Name State ================ ========= No patches currently installed |
Status on rac1: |
DATA FROM RAC1 - SYSTEM CORE FILE LIMIT |
Status on orcl: |
DATA FOR ORCL FOR OPTIMIZER PARAMETERS WITH NON-DEFAULT SETTINGS (CHECK 1) Query returned no rows which is expected when the SQL check passes. |
Status on rac1: |
DATA FROM RAC1 - VERIFY BERKELEY DATABASE LOCATION FOR CLONED GI HOMES BDBLOC=default MYNAME=rac1 CLUSTERNAME=rac-cluster USERNAME=grid CRFHOME=/oracle/app/11.2.0/grid rac1 5=127.0.0.1 0 rac1 1=127.0.0.1 0 rac1 0=10.25.133.120 61020 rac1 2=10.25.133.120 61021 BDBSIZE=61511 rac2 5=127.0.0.1 0 rac2 1=127.0.0.1 0 rac2 0=10.25.133.121 61020 HOSTS=rac1,rac2 rac2 2=10.25.133.121 61021 STATE=mutated |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify control_file_record_keep_time value is in recommended range control_file_record_keep_time = 7 |
Status on orcl: |
DATA FOR ORCL FOR VERIFY RMAN CONTROLFILE AUTOBACKUP IS SET TO ON |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - REGISTERED DISKGROUPS IN CLUSTERWARE REGISTRY Diskgroups from v$asm_diskgroups:- DATA OCR Diskgroups from Clusterware resources:- DATA OCR |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation |
|
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - PAM_LIMITS CHECK #%PAM-1.0 auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so auth include system-auth account required pam_nologin.so account include system-auth password include system-auth # pam_selinux.so close should be the first session rule session required pam_selinux.so close session required pam_loginuid.so session optional pam_console.so # pam_selinux.so open should only be followed by sessions to be executed in the user context session required pam_selinux.so open session required pam_namespace.so session optional pam_keyinit.so force revoke session include system-auth -session optional pam_ck_connector.so |
Status on rac1: |
DATA FROM RAC1 - VERIFY VM.MIN_FREE_KBYTES Value in sysctl = 524288 Value in active memory (from /proc/sys/vm/min_free_kbytes) = 524288 |
Status on rac1: |
DATA FROM RAC1 - VERIFY TRANSPARENT HUGEPAGES ARE DISABLED Note:- Look for AnonHugePages: MemTotal: 3908984 kB MemFree: 769444 kB Buffers: 36420 kB Cached: 1598928 kB SwapCached: 0 kB Active: 1763956 kB Inactive: 831372 kB Active(anon): 1035768 kB Inactive(anon): 399276 kB Active(file): 728188 kB Inactive(file): 432096 kB Unevictable: 229156 kB |
Status on orcl: |
DATA FOR ORCL FOR VERIFY DATA FILES ARE RECOVERABLE Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - OCR AND VOTING FILE LOCATION Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3084 Available space (kbytes) : 259036 ID : 164243238 Device/File Name : +OCR Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured |
Recommendation | For every database, there will be a zip file of format <pxhcdr_DBNAME_HOSTNAME_DBVERSION_DATE_TIMESTAMP.zip> in ORAchk output directory. |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Parallel Execution Health-Checks and Diagnostics Reports left empty intentionally |
Recommendation |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - HARDWARE CLOCK SYNCHRONIZATION [ -x /sbin/hwclock -a -e /dev/rtc ] && action $"Syncing hardware clock to system time" /sbin/hwclock --systohc |
Status on rac1: |
DATA FROM RAC1 - TFA COLLECTOR STATUS -rwxr-xr-x. 1 root root 10437 Dec 1 2015 /etc/init.d/init.tfa -rw-r--r--. 1 root root 5 Jan 25 15:32 /oracle/app/11.2.0/grid/tfa/rac1/tfa_home/internal/.pidfile |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CLUSTERWARE RESOURCE STATUS Oracle Clusterware active version on the cluster is [11.2.0.4.0] Oracle Clusterware version on node [rac1] is [11.2.0.4.0] CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr ONLINE ONLINE rac1 |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - ORA-15196 ERRORS IN ASM ALERT LOG |
Recommendation |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - DISKS WITHOUT DISK GROUP no rows selected |
Status on rac1: |
DATA FROM RAC1 - LOCALHOST ENTRY IN /ETC/HOSTS 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Redo log file write time latency |
Recommendation |
|
Links |
|
Needs attention on | orcl |
Passed on | - |
Status on orcl: |
DATA FOR ORCL FOR PRIMARY DATABASE PROTECTION WITH DATA GUARD |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR LOCALLY MANAGED TABLESPACES dictionary_managed_tablespace_count = 0 |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR AUTOMATIC SEGMENT STORAGE MANAGEMENT Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR DEFAULT TEMPORARY TABLESPACE DEFAULT_TEMP_TABLESPACE TEMP |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR ARCHIVELOG MODE Archivelog Mode = ARCHIVELOG |
Status on orcl: |
DATA FOR ORCL FOR VERIFY AUD$ AND FGA_LOG$ TABLES USE AUTOMATIC SEGMENT SPACE MANAGEMENT AUD$ MANUAL FGA_LOG$ MANUAL |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Status on orcl: |
DATA FOR ORCL FOR ASM DISK READ WRITE ERROR 0 0 |
Recommendation | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR BLOCK CORRUPTIONS 0 block_corruptions found in v$database_block_corruptions |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Redo Log File Size SUCCESS: Redo logs are appropriately sized |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | instance. |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Remote listener set to scan name remote listener name = scan-ip scan name = scan-ip |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - tnsping to remote listener parameter TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 25-JAN-2018 16:42:54 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.140)(PORT=1521))) OK (0 msec) |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - SCAN TNSNAMES.ora resolution scan name = scan-ip /oracle/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora file is ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) pridb = |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - EZCONNECT CONFIGURATION IN SQLNET.ORA NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ADR_BASE = /oracle/app/grid |
Recommendation |
|
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR DUPLICATE SYS/SYSTEM OBJECTS Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR INVALID REGISTRY COMPONENT CHECK AMD OLAP Catalog VALID 11.2.0.4.0 APEX Oracle Application Express VALID 3.2.1.00.12 APS OLAP Analytic Workspace VALID 11.2.0.4.0 |
Recommendation |
|
Links |
|
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - HANG AND DEADLOCK MATERIAL left blank intentionally |
Status on orcl1: |
orcl1.recyclebin = on |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on orcl1: |
orcl1.fast_start_mttr_target = 0 |
Status on orcl1: |
orcl1.undo_retention = 900 |
Status on orcl: |
DATA FOR ORCL FOR VERIFY ALL "BIGFILE" TABLESPACES HAVE NON-DEFAULT "MAXBYTES" VALUES SET Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CLUSTERWARE STATUS -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.OCR.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.asm ONLINE ONLINE rac1 Started |
Status on orcl: |
DATA FOR ORCL FOR FLASHBACK DATABASE ON PRIMARY Flashback status = NO |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Database init parameter DB_BLOCK_CHECKING DB_BLOCK_CHECKING = FALSE |
Status on rac1: |
DATA FROM RAC1 - CSS LOG FILE SIZE CRS-4676: Successful get logfilesize 52428800 for Cluster Synchronization Services. |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - UMASK SETTING FOR RDBMS OWNER oracle user's umask = 0022 |
Status on orcl1: |
orcl1.db_lost_write_protect = NONE |
Status on rac1: |
DATA FROM RAC1 - ORA_CRS_HOME ENV VARIABLE FOR GRID INFRASTRUCTURE OWNER ORA_CRS_HOME environment variable not set |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER HARD STACK SHELL LIMITS oracle user's hard stack shell limit = unlimited |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER SOFT NOFILE SHELL LIMITS oracle user'ssoft nofile shell limit = 65536 |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER HARD NPROC SHELL LIMITS oracle user's hard nproc shell limit = 16384 |
Status on orcl1: |
orcl1.db_block_checksum = TYPICAL |
Status on rac1: |
DATA FROM RAC1 - ASM DISK GROUP COMPATIBLE.ASM ATTRIBUTE Oracle Clusterware active version on the cluster is [11.2.0.4.0] ASM DATA.compatible.asm = 11.2.0.0.0 ASM OCR.compatible.asm = 11.2.0.0.0 |
Status on rac1: |
DATA FROM RAC1 - ASM DISK GROUP COMPATIBLE.ADVM ATTRIBUTE (NON-ENGINEERED SYSTEMS) Oracle Clusterware active version on the cluster is [11.2.0.4.0] None of the diskgroups have compatible.advm attribute set |
Status on rac1: |
DATA FROM RAC1 - ASM DISK GROUP COMPATIBLE.RDBMS ATTRIBUTE lowest rdbms version = 112040 ASM DATA.compatible.rdbms = 10.1.0.0.0 ASM OCR.compatible.rdbms = 10.1.0.0.0 |
Recommendation |
|
Needs attention on | - |
Passed on | +ASM1 |
Status on +ASM1: |
+ASM1.asm_power_limit = 1 |
Recommendation |
|
Links |
|
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - JUMBO FRAMES CONFIGURATION FOR INTERCONNECT CPU Model = eth1 Link encap:Ethernet HWaddr 00:0C:29:DB:C4:4A inet addr:10.25.133.120 Bcast:10.25.133.255 Mask:255.255.255.0 inet6 addr: fe80::20c:29ff:fedb:c44a/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:82581 errors:0 dropped:0 overruns:0 frame:0 TX packets:69252 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:52633805 (50.1 MiB) TX bytes:35467010 (33.8 MiB) |
Status on rac1: |
DATA FROM RAC1 - OSWATCHER STATUS |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CSS REBOOT TIME CRS-4678: Successful get reboottime 3 for Cluster Synchronization Services. |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CSS DISKTIMEOUT CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services. |
Recommendation |
|
Links |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - OHASD LOG FILE OWNERSHIP total 6056 -rw-r--r--. 1 root root 6191426 Jan 25 16:41 ohasd.log -rw-r--r--. 1 root root 2379 Jan 25 15:32 ohasdOUT.log |
Status on rac1: |
DATA FROM RAC1 - OHASD/ORAROOTAGENT_ROOT LOG FILE OWNERSHIP total 3856 -rw-r--r--. 1 root root 3938253 Jan 25 16:41 orarootagent_root.log -rw-r--r--. 1 root root 5 Jan 25 15:33 orarootagent_root.pid -rw-r--r--. 1 root root 0 Dec 1 2015 orarootagent_rootOUT.log |
Recommendation |
|
Links |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CRSD/ORAROOTAGENT_ROOT LOG FILE OWNERSHIP total 5728 -rw-r--r--. 1 root root 5855160 Jan 25 16:41 orarootagent_root.log -rw-r--r--. 1 root root 5 Jan 25 15:35 orarootagent_root.pid -rw-r--r--. 1 root root 0 Jan 22 09:40 orarootagent_rootOUT.log |
Status on rac1: |
DATA FROM RAC1 - CRSD LOG FILE OWNERSHIP total 12272 -rw-r--r--. 1 root root 10514819 Jan 25 15:38 crsd.l01 -rw-r--r--. 1 root root 2035830 Jan 25 16:41 crsd.log -rw-r--r--. 1 root root 1740 Jan 25 15:35 crsdOUT.log |
Recommendation | |
Links | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - VIP NIC BONDING CONFIG. eth0 Link encap:Ethernet HWaddr 00:0C:29:DB:C4:40 inet addr:192.168.133.120 Bcast:192.168.133.255 Mask:255.255.255.0 inet6 addr: fe80::20c:29ff:fedb:c440/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:454713 errors:0 dropped:0 overruns:0 frame:0 TX packets:371690 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:560035305 (534.0 MiB) TX bytes:249682774 (238.1 MiB) |
Recommendation |
|
Links | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - INTERCONNECT NIC BONDING CONFIG. eth1 10.25.133.0 global cluster_interconnect |
Status on rac1: |
DATA FROM RAC1 - VERIFY OPERATING SYSTEM HUGEPAGES COUNT SATISFIES TOTAL SGA REQUIREMENTS |
Recommendation | MEMORY_TARGET |
Needs attention on | orcl1 |
Passed on | - |
Status on orcl1: |
orcl1.memory_target = 780140544 |
Status on rac1: |
DATA FROM RAC1 - CRS AND ASM VERSION COMPARISON CRS_ACTIVE_VERSION = 112040 ASM Version = 112040 |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Local listener set to node VIP Local Listener= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.130)(PORT=1521)) VIP Names=rac1-vip VIP IPs=192.168.133.130 |
Status on rac1: |
DATA FROM RAC1 - NUMBER OF SCAN LISTENERS SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 |
Status on rac1: |
DATA FROM RAC1 - VERIFY VOTING DISKS STATUS ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 06a3e4da34154f57bff7384023ec9f7d (/dev/raw/raw1) [OCR] Located 1 voting disk(s). |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - CSS MISSCOUNT CRS-4678: Successful get misscount 30 for Cluster Synchronization Services. |
Status on orcl: |
DATA FOR ORCL FOR SAME SIZE OF REDO LOG FILES 1 .048828125 2 .048828125 3 .048828125 4 .048828125 |
Status on rac1: |
DATA FROM RAC1 - SELINUX STATUS Enforcing |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - PUBLIC INTERFACE EXISTENCE eth0 192.168.133.0 global public eth1 10.25.133.0 global cluster_interconnect |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - IP_LOCAL_PORT_RANGE minimum port range = 9000 maximum port range = 65500 |
Status on rac1: |
DATA FROM RAC1 - KERNEL.SHMMAX NOTE: All results reported in bytes kernel.shmmax actual = 68719476736 total system memory = 4002799616 1/2 total system memory = 2001399808 |
Recommendation |
|
Links |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - /TMP DIRECTORY FREE SPACE Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 13G 2.3G 86% / |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER SOFT NPROC SHELL LIMIT oracle user's soft nproc shell limit = 16384 |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER HARD NOFILE SHELL LIMITS oracle user's hard nofile shell limit = 65536 |
Status on rac1: |
DATA FROM RAC1 - LINUX SWAP SIZE Total meory on system(Physical RAM - Huge Pagess Size) = Swap memory found on system = 4095992 Recommended Swap = 0 |
Status on rac1: |
DATA FROM RAC1 - /TMP ON DEDICATED FILESYSTEM Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda3 16307112 13169248 2309500 86% / |
Recommendation | |
Links | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - ASMLIB CHECK Look for oracleasm module Module Size Used by iptable_filter 2793 0 ip_tables 17831 1 iptable_filter bridge 79078 0 oracleacfs 1990406 0 oracleadvm 250040 0 oracleoks 427672 2 oracleacfs,oracleadvm 8021q 25317 0 garp 7152 1 8021q stp 2218 2 bridge,garp llc 5546 3 bridge,garp,stp ip6t_REJECT 4628 2 nf_conntrack_ipv6 8748 2 nf_defrag_ipv6 11182 1 nf_conntrack_ipv6 |
Status on orcl: |
DATA FOR ORCL FOR NON-AUTOEXTENSIBLE DATA AND TEMP FILES Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Needs attention on | orcl |
Passed on | - |
Status on orcl: |
DATA FOR ORCL FOR NON-MULTIPLEXED REDO LOGS 1 1 2 1 4 1 3 1 |
Recommendation | |
Needs attention on | orcl |
Passed on | - |
Status on orcl: |
DATA FOR ORCL FOR MULTIPLEXED CONTROLFILES +DATA/orcl/controlfile/current.260.897348927 |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Check audit_file_dest Number of audit files last modified over 30 days ago at /oracle/app/oracle/admin/orcl/adump = 39 |
Status on rac1: |
DATA FROM rac1 - /oracle/app/oracle/product/11.2.0/db DATABASE_HOME - oradism executable ownership -rwsr-x---. 1 root oinstall 71790 Aug 24 2013 /oracle/app/oracle/product/11.2.0/db/bin/oradism |
Status on rac1: |
DATA FROM rac1 - /oracle/app/oracle/product/11.2.0/db DATABASE_HOME - oradism executable permission -rwsr-x---. 1 root oinstall 71790 Aug 24 2013 /oracle/app/oracle/product/11.2.0/db/bin/oradism |
Recommendation |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR AVG MESSAGE SENT QUEUE TIME ON KSXP Query returned no rows which is expected when the SQL check passes. |
Recommendation |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR AVG MESSAGE SENT QUEUE TIME (MS) Query returned no rows which is expected when the SQL check passes. |
Recommendation |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR AVG MESSAGE RECEIVED QUEUE TIME Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR GC BLOCK LOST Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR SESSION FAILOVER CONFIGURATION Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Links | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Redo log Checkpoint not complete Checkpoint not complete messages in /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/alert_orcl1.log found 11 times |
Status on orcl: |
DATA FOR ORCL FOR AVG GC CURRENT BLOCK RECEIVE TIME avg_gc_current_block_receive_time_15ms_exceeded = 10 |
Status on orcl: |
DATA FOR ORCL FOR AVG GC CR BLOCK RECEIVE TIME avg_gc_cr_block_receive_time_15ms_exceeded = 10 |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR TABLESPACE ALLOCATION TYPE Query returned no rows which is expected when the SQL check passes. |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Old trace files in background dump destination files at background dump destination(/oracle/app/oracle/diag/rdbms/orcl/orcl1/trace) older than 30 days = 192 |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Alert log file size -rw-r-----. 1 oracle asmadmin 335957 Jan 25 15:44 /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/alert_orcl1.log |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Check ORA-07445 errors |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Check ORA-00600 errors |
Recommendation | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Check user_dump_destination 96 files found at /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace which are older than 30 days |
Recommendation |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Check core_dump_destination 0 files found at /oracle/app/oracle/diag/rdbms/orcl/orcl1/cdump which are older than 30 days |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
Status on rac1: |
Status on rac1: |
Status on orcl: |
DATA FOR ORCL FOR VERIFY SYS AND SYSTEM USERS DEFAULT TABLESPACE IS SYSTEM SYSTEM SYSTEM |
Recommendation |
|
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - MAXIMUM PARALLEL ASYNCH IO aio-max-nr = 1048576 |
Status on rac1: |
DATA FROM RAC1 - OLD LOG FILES IN CLIENT DIRECTORY IN CRS_HOME 21 files in /oracle/app/11.2.0/grid/log/rac1/client directory are older than 15 days |
Status on rac1: |
DATA FROM RAC1 - OCR BACKUP PROT-24: Auto backups for the Oracle Cluster Registry are not available |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR INVALID JAVA OBJECT CHECK Query returned no rows which is expected when the SQL check passes. |
Status on rac1: |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | orcl1 |
Status on orcl1: |
orcl1.spfile = +DATA/orcl/spfileorcl.ora |
Status on rac1: |
DATA FROM RAC1 - MANAGE ASM AUDIT FILE DIRECTORY GROWTH WITH CRON Number of audit files at /oracle/app/11.2.0/grid/rdbms/audit = 653 |
Status on rac1: |
DATA FROM RAC1 - NON-ROUTABLE NETWORK FOR INTERCONNECT eth0 192.168.133.0 global public eth1 10.25.133.0 global cluster_interconnect |
Status on rac1: |
DATA FROM RAC1 - OCR MIRRORING ocrconfig_loc=+OCR local_only=FALSE |
Status on rac1: |
DATA FROM RAC1 - HOSTNAME FORMATTING rac1 rac2 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify RMAN snapshot control file location is properly shared Snapshot Controlfile is not created because: select distinct value from v$rman_configuration where name='SNAPSHOT CONTROLFILE NAME' did not return any value. |
Status on rac1: |
Status on rac1: |
Status on rac1: |
Status on orcl: |
DATA FOR ORCL FOR VERIFY CLUSTER_DATABASE_INSTANCES DATABASE PARAMETER 1 cluster_database_instances TRUE |
Recommendation |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR ARCHIVE LOG MODE archive_log_mode_check = ARCHIVELOG |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - ASM_DISKSTRING ASM_DISKSTRING ------------------------------ |
Status on rac1: |
DATA FROM RAC1 - HOSTNAME FORMATTING rac1 rac2 |
Status on orcl: |
DATA FOR ORCL FOR AUDSES$ SEQUENCE CACHE SIZE audses$.cache_size = 10000 |
Recommendation | |
Links |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR IDGEN$ SEQUENCE CACHE SIZE idgen1$.cache_size = 1000 |
Status on rac1: |
DATA FROM RAC1 - OCR AND OCR BACKUP LOCATION ocr_loc = +OCR ocrbackup_loc = . |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - VERIFY PRIVATE AND PUBLIC NETWORK SUBNET CONFIGURATION IN ORACLE CLUSTERWARE REGISTRY oifcfg iflist output eth0 192.168.133.0 eth1 10.25.133.0 oifcfg getif output eth0 192.168.133.0 global public eth1 10.25.133.0 global cluster_interconnect |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1:/oracle/app/oracle/product/11.2.0/db: |
Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2018-01-25_16-37-33PM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2018-01-25_16-37-33PM.txt ------------------------------------------------------------------------------------------------------ Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - cluster_interconnects Cluster Interconnect Value from instance = Network card name and IP from oifcfg eth1 = 10.25.133.120 |
Status on rac1: |
DATA FROM RAC1 - 3RD PARTY CLUSTERWARE NODE NUMBERING rac1 1 rac2 2 |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR MONITORING AWR SPACE USAGE IN SYSAUX AWR components consume 8% of total SYSAUX space |
Status on orcl: |
DATA FOR ORCL FOR SESSION FAILOVER CONFIGURATION Query returned no rows which is expected when the SQL check passes. |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify alternate destination configuration for local archive desntination NAME TYPE ------------------------------ -------------------- DATA EXTERN OCR EXTERN |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify Non-Default Database Services Were Created for Each Database No services are configured for ORCL |
Status on rac1: |
DATA FROM RAC1 - VERIFY FREE SPACE ON /BOOT MOUNT POINT Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda3 16307112 13165348 2313400 86% / tmpfs 1954492 406928 1547564 21% /dev/shm /dev/sda1 297485 37229 244896 14% /boot |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATABASE SOFTWARE OWNER SOFT STACK SHELL LIMITS oracle user's soft stack shell limit = 10240 |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR MONITORING RECYCLEBIN BY SPACE CONSUMPTION Query returned no rows which is expected when the SQL check passes. |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR MONITORING RECYCLEBIN BY DATABASE USERS Query returned no rows which is expected when the SQL check passes. |
Status on orcl: |
DATA FOR ORCL FOR DB_FILE_MULTIBLOCK_READ_COUNT PARAMETER db_file_multiblock_read_count parameter value = 90 db_file_multiblock_read_count isdefault value = TRUE |
Status on rac1: |
DATA FROM RAC1 - VERIFY DATABASE MEMORY ALLOCATION IS NOT GREATER THAN PHYSICAL MEMORY INSTALLED ON DATABASE NODE Total memory on rac1 = 3817 MB Total memory allocated to hugepages = 0 MB Total available memory for PGA allocation = 3817 MB Memory allocated to all PGAs = 0 MB |
Recommendation |
|
Links | |
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM rac1 - /oracle/app/oracle/product/11.2.0/db DATABASE_HOME - Most recent ADR incidents ADRCI: Release 11.2.0.4.0 - Production on Thu Jan 25 16:38:29 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = "/oracle/app/oracle" adrci> ADR Home = /oracle/app/oracle/diag/rdbms/orcl/orcl1: ************************************************************************* 0 rows fetched adrci> |
Status on rac1: |
DATA FROM rac1 - orcl DATABASE - Verify Database Hidden Database Initialization Parameter Usage no rows selected |
Status on rac1: |
DATA FROM RAC1 - VERIFY HIDDEN ASM INITIALIZATION PARAMETER USAGE no rows selected |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - /ETC DIRECTORY FREE SPACE Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 13G 2.3G 86% / |
Recommendation | |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - /VAR DIRECTORY FREE SPACE Filesystem Size Used Avail Use% Mounted on /dev/sda3 16G 13G 2.3G 86% / |
Status on orcl: |
DATA FOR ORCL FOR MONITORING STALE STATISTICS APEX_030200 WWV_FLOWS 24-AUG-13 225640 10 CTXSYS DR$INDEX_VALUE 24-AUG-13 1967 6 OLAPSYS CWM$CLASSIFICATIONENTRY 24-AUG-13 1220 5 APEX_030200 WWV_FLOW_STEPS 24-AUG-13 1178 1754 APEX_030200 WWV_FLOW_LIST_TEMPLATES 24-AUG-13 800 105 APEX_030200 WWV_FLOW_CUSTOM_AUTH_SETUPS 24-AUG-13 500 11 APEX_030200 WWV_FLOW_ROW_TEMPLATES 24-AUG-13 400 54 PM ONLINE_MEDIA 24-AUG-13 400 9 MDSYS SDO_CS_SRS 24-AUG-13 353 4482 APEX_030200 WWV_FLOW_PAGE_PLUG_TEMPLATES 24-AUG-13 300 166 |
Status on orcl: |
DATA FOR ORCL FOR MONITORING AWR SETTINGS AWR Snapshot interval for DBID 1425129662 = 60 Minutes AWR Snapshot Retention for DBID 1425129662 = 8 Days |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | - |
Passed on | orcl |
Status on orcl: |
DATA FOR ORCL FOR MONITORING NON-AWR SPACE USAGE IN SYSAUX Query returned no rows which is expected when the SQL check passes. |
Status on rac1: |
DATA FROM RAC1 - STORAGE MINIMUM REQUIREMENTS FOR GRID & DATABASE HOMES intentionally left blank |
Status on rac1: |
DATA FROM RAC1 - FREE PHYSICAL MEMORY total used free shared buffers cached Mem: 3817 2979 837 0 33 1486 -/+ buffers/cache: 1460 2356 Swap: 3999 0 3999 Total: 7817 2979 4837 |
Recommendation | See the below referenced Oracle Document for System Run Level related information |
Links | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - SYSTEM RUN LEVEL runlevel= 5 |
Recommendation | |
Needs attention on | - |
Passed on | rac1 |
Status on rac1: |
DATA FROM RAC1 - /BOOT MOUNT Filesystem Size Used Avail Use% Mounted on /dev/sda1 291M 37M 240M 14% /boot |
Status on rac1: |
DATA FROM RAC1 - /DEV/SHM MOUNT tmpfs 1954492 402068 1552424 21% /dev/shm |
Status on rac1: |
DATA FROM RAC1 - BASH VULNERABILITY CVE-2014-6271 bash is vulnerable vulnerability tested |
Status on orcl: |
DATA FOR ORCL FOR DATABASE TIMED STATISTICS timed_statistics = TRUE |
Status on orcl: |
DATA FOR ORCL FOR DATABASE STATISTICS LEVEL statistics_level = TYPICAL |
Recommendation |
|
Links |
|
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - ORACLE DATA PUMP BEST PRACTICES |
Status on orcl: |
DATA FOR ORCL FOR ASH FLUSH STATUS 1 0 |
Recommendation | Benefit / Impact: |
Links |
|
Needs attention on | rac1 |
Passed on | - |
Status on rac1: |
DATA FROM RAC1 - ASM IMPORTANT INFO intentionally left blank |
Status on rac1: |
DATA FROM RAC1 - CLUSTER HEALTH MONITOR (CHM) REPOSITORY SIZE CHM repository size(hours) = Recommended size for CHM repository size(MB) = 5202 cluster node rac2 has least available space at of 463 MB |
NOTE: This information is primarily used for helping Oracle optimize the run time of ORAchk.
These timings are not necessarily indicative of any problem and may vary widely from one system to another.
Check Id | Name | Type | Target | Execution Duration |
---|---|---|---|---|
5ACC89B1D10CAF91E0401490CACF41F5 | Cluster interconnect (clusterware) | OS Collection | rac1:None | 13 secs |
078C3A95E8BF672CE05312C0E50A0501 | Monitoring Non-AWR space usage in SYSAUX | SQL Check | rac1:orcl | 12 secs |
B5191156EF114416E0431EC0E50AFBE0 | Patches for RDBMS Home | OS Collection | rac1:None | 7 secs |
DC3D819F5D2A50FEE04312C0E50AFF9F | Parallel Execution Health-Checks and Diagnostics Reports | OS Check | rac1:orcl | 7 secs |
5EA8F4C6C6BDF8F0E0401490CACF067F | Interconnect NIC bonding config. | OS Check | rac1 | 6 secs |
81DB99F842EE95C9E040E50A1EC03CC3 | NIC Bonding Mode for interconnect | OS Check | rac1 | 6 secs |
8529D3798EA039F3E040E50A1EC07218 | Public interface existence | OS Check | rac1 | 6 secs |
494DAA11615B67D6E0530D98EB0A34D3 | Verify private and public network subnet configuration in Oracle Clusterware registry | OS Check | rac1 | 6 secs |
C75507CE93A92E2EE0431EC0E50A187F | Subnet mask for cluster_interconnect NICS branch | OS Check | rac1 | 6 secs |
E1AB0C30BA3D0A78E04312C0E50AA0B6 | More than one card for interconnect? | OS Check | rac1 | 6 secs |