odahost-01@oracle[]/opt/oracle/oak/odachk> ./odachk -a -o verbose CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0.3/grid?[y/n][y] Checking ssh user equivalency settings on all nodes in cluster Node odahost-02 is configured for ssh user equivalency for oracle user Searching for running databases . . . . . . . . . . . . . List of running databases registered in OCR 1. tstdb1 2. MCL2DB 3. MCL3DB 4. MCL4DB 5. MCL5DB 6. MCL6DB 7. MCL7DB 8. MCLDB 9. All of above 10. None of above Select databases from list for checking best practices. For multiple databases, select 9 for All or comma separated number like 1,2 etc [1-10][9]. Searching out ORACLE_HOME for selected databases. . . . . . . . . . . . . . . . . Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ------------------------------------------------------------------------------------------------------- Oracle Stack Status ------------------------------------------------------------------------------------------------------- Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name ------------------------------------------------------------------------------------------------------- odahost-01 Yes Yes Yes Yes Yes Yes tstdb11 MCL2DB1 MCL3DB1 MCL4DB1 MCL5DB1 MCL6DB MCL7DB1 MCLDB1 odahost-02 Yes Yes Yes Yes Yes Yes tstdb12 MCL2DB2 MCL3DB2 MCL4DB2 MCL5DB2 MCL7DB2 MCLDB2 ------------------------------------------------------------------------------------------------------- 86 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which require root privileged data collection can be skipped. 1. Enter 1 if you will enter root password for each host when prompted 2. Enter 2 if you have sudo configured for oracle user to execute root_odachk.sh script 3. Enter 3 to skip the root privileged collections 4. Enter 4 to exit and work with the SA to configure sudo or to arrange for root access and run the tool later. Please indicate your selection from one of the above options[1-4][1]:- Is root password same on all nodes?[y/n][y] Enter root password :- *** Checking Best Practice Recommendations (PASS/WARNING/FAIL) *** Log file for collections and audit checks are at /opt/oracle/oak/odachk/odachk_081512_092757/odachk.log ============================================================= Node name - odahost-01 ============================================================= Collecting - ASM Diskgroup Attributes Collecting - ASM initialization parameters Collecting - Database Parameters for tstdb1 database Collecting - Database Parameters for MCL2DB database Collecting - Database Parameters for MCL3DB database Collecting - Database Parameters for MCL4DB database Collecting - Database Parameters for MCL5DB database Collecting - Database Parameters for MCL6DB database Collecting - Database Parameters for MCL7DB database Collecting - Database Parameters for MCLDB database Collecting - Database Undocumented Parameters for tstdb1 database Collecting - Database Undocumented Parameters for MCL2DB database Collecting - Database Undocumented Parameters for MCL3DB database Collecting - Database Undocumented Parameters for MCL4DB database Collecting - Database Undocumented Parameters for MCL5DB database Collecting - Database Undocumented Parameters for MCL6DB database Collecting - Database Undocumented Parameters for MCL7DB database Collecting - Database Undocumented Parameters for MCLDB database Collecting - Kernel parameters Collecting - Maximum number of semaphore sets on system Collecting - Maximum number of semaphores on system Collecting - Maximum number of semaphores per semaphore set Collecting - OS Packages Collecting - Patches for Grid Infrastructure Collecting - Patches for RDBMS Home Collecting - number of semaphore operations per semop system call Preparing to run root privileged commands odahost-01. root@odahost-01's password: Collecting - Firmware and software versions Collecting - Network and Bonding Interfaces Status Collecting - OS Disk Storage Status Collecting - System Component Status Collecting - Validate Shared storage Data collections completed. Checking best practices on odahost-01. -------------------------------------------------------------------------------------- PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for tstdb1 PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL2DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL3DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL4DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL5DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL6DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCL7DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for MCLDB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for tstdb1 PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL2DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL3DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL4DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL5DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL6DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCL7DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for MCLDB PASS => net.core.wmem_default Is Configured Properly PASS => net.core.wmem_max Is Configured Properly PASS => net.core.rmem_default Is Configured Properly PASS => None of the hostnames contains an underscore character PASS => Kernel Parameter SEMOPM OK PASS => Kernel Parameter SEMMNI OK PASS => Kernel Parameter SEMMSL OK PASS => Kernel Parameter SEMMNS OK PASS => All tablespaces are locally manged tablespace for tstdb1 PASS => All tablespaces are locally manged tablespace for MCL2DB PASS => All tablespaces are locally manged tablespace for MCL3DB PASS => All tablespaces are locally manged tablespace for MCL4DB PASS => All tablespaces are locally manged tablespace for MCL5DB PASS => All tablespaces are locally manged tablespace for MCL6DB PASS => All tablespaces are locally manged tablespace for MCL7DB PASS => All tablespaces are locally manged tablespace for MCLDB PASS => All tablespaces are using Automatic segment storage management for tstdb1 PASS => All tablespaces are using Automatic segment storage management for MCL2DB PASS => All tablespaces are using Automatic segment storage management for MCL3DB PASS => All tablespaces are using Automatic segment storage management for MCL4DB PASS => All tablespaces are using Automatic segment storage management for MCL5DB PASS => All tablespaces are using Automatic segment storage management for MCL6DB PASS => All tablespaces are using Automatic segment storage management for MCL7DB PASS => All tablespaces are using Automatic segment storage management for MCLDB PASS => Kernel Parameter net.core.rmem_max OK PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for tstdb1 PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL2DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL3DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL4DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL5DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL6DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCL7DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for MCLDB PASS => $ORACLE_HOME/bin/oradism setuid bit is set PASS => $ORACLE_HOME/bin/oradism ownership is root PASS => Linux Swap Configuration meets or exceeds Recommendation PASS => ip_local_port_range is configured according to recommendation PASS => All voting disks are online PASS => Local listener init parameter is set to local node VIP for tstdb1 PASS => Local listener init parameter is set to local node VIP for MCL2DB PASS => Local listener init parameter is set to local node VIP for MCL3DB PASS => Local listener init parameter is set to local node VIP for MCL4DB PASS => Local listener init parameter is set to local node VIP for MCL5DB WARNING => Local listener init parameter is not set to local node VIP for MCL6DB PASS => Local listener init parameter is set to local node VIP for MCL7DB PASS => Local listener init parameter is set to local node VIP for MCLDB PASS => CRS version is higher or equal to ASM version. PASS => NIC bonding is configured for public network (VIP) PASS => NIC bonding mode is not set to Broadcast(3) for public network PASS => crsd Log Ownership is Correct (root root) PASS => crsd/orarootagent_root Log Ownership is Correct (root root) PASS => ohasd/orarootagent_root Log Ownership is Correct (root root) PASS => ohasd Log Ownership is Correct (root root) PASS => OSWatcher is running PASS => All disk groups have allocation unit size set to 4MB PASS => All disk groups have compatible.asm parameter set to recommended values PASS => Shell limit soft nofile for GI is configured according to recommendation PASS => Shell limit soft nproc for GI is configured according to recommendation PASS => Shell limit hard nofile for GI is configured according to recommendation PASS => Shell limit hard nproc for GI is configured according to recommendation PASS => Shell limit hard nproc for DB is configured according to recommendation PASS => Shell limit hard nofile for DB is configured according to recommendation PASS => Shell limit hard stack for DB is configured according to recommendation PASS => Shell limit soft nproc for DB is configured according to recommendation PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on tstdb11 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL2DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL3DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL4DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL5DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL6DB instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL7DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCLDB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on tstdb11 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL2DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL3DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL4DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL5DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL6DB instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL7DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCLDB1 instance PASS => Database parameter db_recovery_file_dest_size is set to recommended value for tstdb1 PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL2DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL3DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL4DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL5DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL6DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL7DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCLDB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for tstdb1 PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL2DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL3DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL4DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL5DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL6DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL7DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCLDB PASS => All software and firmware versions are up to date with OAK repository. PASS => Shared storage checks successful PASS => System component checks successful PASS => OS Disk Storage checks successful PASS => All bigfile tablespaces have non-default maxbytes values set for tstdb1 PASS => All bigfile tablespaces have non-default maxbytes values set for MCL2DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCL3DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCL4DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCL5DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCL6DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCL7DB PASS => All bigfile tablespaces have non-default maxbytes values set for MCLDB PASS => ASM parameter MEMORY_TARGET is set according to recommended value. PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on tstdb11 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL2DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL3DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL4DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL5DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL6DB instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL7DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCLDB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on tstdb11 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL2DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL3DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL4DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL5DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL6DB instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL7DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCLDB1 instance PASS => pam_limits configured properly for shell limits PASS => The number of async IO descriptors is sufficient (/proc/sys/fs/aio-max-nr) WARNING => One or more warnings for network and bonding interface checks PASS => Database Parameter parallel_execution_message_size is set to the recommended value on tstdb11 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL2DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL3DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL4DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL5DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL6DB instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL7DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCLDB1 instance PASS => Value of remote_listener parameter is able to tnsping for tstdb1 PASS => Value of remote_listener parameter is able to tnsping for MCL2DB PASS => Value of remote_listener parameter is able to tnsping for MCL3DB PASS => Value of remote_listener parameter is able to tnsping for MCL4DB PASS => Value of remote_listener parameter is able to tnsping for MCL5DB PASS => Value of remote_listener parameter is able to tnsping for MCL7DB PASS => Value of remote_listener parameter is able to tnsping for MCLDB PASS => Remote listener is set to SCAN name for tstdb1 PASS => Remote listener is set to SCAN name for MCL2DB PASS => Remote listener is set to SCAN name for MCL3DB PASS => Remote listener is set to SCAN name for MCL4DB PASS => Remote listener is set to SCAN name for MCL5DB PASS => Remote listener is set to SCAN name for MCL7DB PASS => Remote listener is set to SCAN name for MCLDB Best Practice checking completed.Checking recommended patches on odahost-01. --------------------------------------------------------------------------------- Collecting patch inventory on CRS HOME /u01/app/11.2.0.3/grid Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0.3/dbhome_1 ============================================================= Node name - odahost-02 ============================================================= Collecting - Kernel parameters Collecting - Maximum number of semaphore sets on system Collecting - Maximum number of semaphores on system Collecting - Maximum number of semaphores per semaphore set Collecting - OS Packages Collecting - Patches for Grid Infrastructure Collecting - Patches for RDBMS Home Collecting - number of semaphore operations per semop system call Preparing to run root privileged commands odahost-02. root@odahost-02's password: Collecting - Firmware and software versions Collecting - Network and Bonding Interfaces Status Collecting - OS Disk Storage Status Collecting - System Component Status Collecting - Validate Shared storage Data collections completed. Checking best practices on odahost-02. -------------------------------------------------------------------------------------- PASS => net.core.wmem_default Is Configured Properly PASS => net.core.wmem_max Is Configured Properly PASS => net.core.rmem_default Is Configured Properly PASS => None of the hostnames contains an underscore character PASS => Kernel Parameter SEMOPM OK PASS => Kernel Parameter SEMMNI OK PASS => Kernel Parameter SEMMSL OK PASS => Kernel Parameter SEMMNS OK PASS => Kernel Parameter net.core.rmem_max OK PASS => $ORACLE_HOME/bin/oradism setuid bit is set PASS => $ORACLE_HOME/bin/oradism ownership is root PASS => Linux Swap Configuration meets or exceeds Recommendation PASS => ip_local_port_range is configured according to recommendation PASS => Local listener init parameter is set to local node VIP for tstdb1 PASS => Local listener init parameter is set to local node VIP for MCL2DB PASS => Local listener init parameter is set to local node VIP for MCL3DB PASS => Local listener init parameter is set to local node VIP for MCL4DB PASS => Local listener init parameter is set to local node VIP for MCL5DB PASS => Local listener init parameter is set to local node VIP for MCL7DB PASS => Local listener init parameter is set to local node VIP for MCLDB PASS => CRS version is higher or equal to ASM version. PASS => NIC bonding is configured for public network (VIP) PASS => NIC bonding mode is not set to Broadcast(3) for public network PASS => crsd Log Ownership is Correct (root root) PASS => crsd/orarootagent_root Log Ownership is Correct (root root) PASS => ohasd/orarootagent_root Log Ownership is Correct (root root) PASS => ohasd Log Ownership is Correct (root root) PASS => OSWatcher is running PASS => Shell limit soft nofile for GI is configured according to recommendation PASS => Shell limit soft nproc for GI is configured according to recommendation PASS => Shell limit hard nofile for GI is configured according to recommendation PASS => Shell limit hard nproc for GI is configured according to recommendation PASS => Shell limit hard nproc for DB is configured according to recommendation PASS => Shell limit hard nofile for DB is configured according to recommendation PASS => Shell limit hard stack for DB is configured according to recommendation PASS => Shell limit soft nproc for DB is configured according to recommendation PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on tstdb12 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL2DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL3DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL4DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL5DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCL7DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on MCLDB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on tstdb12 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL2DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL3DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL4DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL5DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCL7DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on MCLDB2 instance PASS => Database parameter db_recovery_file_dest_size is set to recommended value for tstdb1 PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL2DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL3DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL4DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL5DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCL7DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for MCLDB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for tstdb1 PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL2DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL3DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL4DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL5DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCL7DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for MCLDB PASS => All software and firmware versions are up to date with OAK repository. PASS => Shared storage checks successful PASS => System component checks successful PASS => OS Disk Storage checks successful PASS => ASM parameter MEMORY_TARGET is set according to recommended value. PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on tstdb12 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL2DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL3DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL4DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL5DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCL7DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on MCLDB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on tstdb12 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL2DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL3DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL4DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL5DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCL7DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on MCLDB2 instance PASS => pam_limits configured properly for shell limits PASS => The number of async IO descriptors is sufficient (/proc/sys/fs/aio-max-nr) WARNING => One or more warnings for network and bonding interface checks PASS => Database Parameter parallel_execution_message_size is set to the recommended value on tstdb12 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL2DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL3DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL4DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL5DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCL7DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on MCLDB2 instance PASS => Value of remote_listener parameter is able to tnsping for tstdb1 PASS => Value of remote_listener parameter is able to tnsping for MCL2DB PASS => Value of remote_listener parameter is able to tnsping for MCL3DB PASS => Value of remote_listener parameter is able to tnsping for MCL4DB PASS => Value of remote_listener parameter is able to tnsping for MCL5DB PASS => Value of remote_listener parameter is able to tnsping for MCL7DB PASS => Value of remote_listener parameter is able to tnsping for MCLDB PASS => Remote listener is set to SCAN name for tstdb1 PASS => Remote listener is set to SCAN name for MCL2DB PASS => Remote listener is set to SCAN name for MCL3DB PASS => Remote listener is set to SCAN name for MCL4DB PASS => Remote listener is set to SCAN name for MCL5DB PASS => Remote listener is set to SCAN name for MCL7DB PASS => Remote listener is set to SCAN name for MCLDB Best Practice checking completed.Checking recommended patches on odahost-02. --------------------------------------------------------------------------------- Collecting patch inventory on CRS HOME /u01/app/11.2.0.3/grid Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0.3/dbhome_1 --------------------------------------------------------------------------------- CLUSTERWIDE CHECKS --------------------------------------------------------------------------------- PASS => Private interconnect interface names are the same across cluster PASS => RDBMS software owner UID matches across cluster PASS => Public network interface names are the same across cluster PASS => Timezone matches for current user across cluster. PASS => Clusterware active version matches across cluster. PASS => OS Kernel version(uname -r) matches across cluster. PASS => Time zone matches for GI/CRS software owner across cluster PASS => Time zone matches for root user across cluster PASS => All nodes are using same NTP server across cluster PASS => RDBMS software version matches across cluster. PASS => RDBMS home /u01/app/oracle/product/11.2.0.3/dbhome_1 has same number of patches installed across the cluster. --------------------------------------------------------------------------------- Detailed report (html) - /opt/oracle/oak/odachk/odachk_MCLDB_081512_092757/odachk_MCLDB_081512_092757.html UPLOAD(if required) - /opt/oracle/oak/odachk/odachk_MCLDB_081512_092757.zip