./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. TEST1DB 2. TEST2DB 3. TEST3DB 4. TEST4DB 5. All 6. None Select respective number to choose databases for checking best practices. For multiple databases, select 5 for All or comma separated number like 1,2 etc [1-6][5]. 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 TEST1DB1 TEST2DB1 TEST3DB1 TEST4DB1 odahost-02 Yes Yes Yes Yes Yes Yes TEST1DB2 TEST2DB2 TEST3DB2 TEST4DB2 ------------------------------------------------------------------------------------------------------- Identifying checks for LINUXX8664OELRHEL5_112030-.... . . . . . . . . . . . . . . . . . . . . . . 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_052212_155742/odachk.log ============================================================= Node name - odahost-01 ============================================================= Collecting - ASM Diskgroup Attributes Collecting - ASM initialization parameters Collecting - Database Parameters for TEST1DB database Collecting - Database Parameters for TEST2DB database Collecting - Database Parameters for TEST3DB database Collecting - Database Parameters for TEST4DB database Collecting - Database Undocumented Parameters for TEST1DB database Collecting - Database Undocumented Parameters for TEST2DB database Collecting - Database Undocumented Parameters for TEST3DB database Collecting - Database Undocumented Parameters for TEST4DB 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 grep: ERROR: Failed to get Oracle Inventory Location. Exiting.../ContentsXML/inventory.xml: No such file or directory -bash: /OPatch/opatch: No such file or directory grep: ERROR: Failed to get Oracle Inventory Location. Exiting.../ContentsXML/inventory.xml: No such file or directory /bin/ls: /u01/app/oracle/product/11.2.0/dbhome_1/u01/app/oracle/agent11g: No such file or directory -bash: /u01/app/oracle/product/11.2.0/dbhome_1/u01/app/oracle/agent11g/OPatch/opatch: No such file or directory 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 TEST1DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for TEST2DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for TEST3DB PASS => SYS.IDGEN1$ sequence cache size >= 1,000 for TEST4DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for TEST1DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for TEST2DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for TEST3DB PASS => SYS.AUDSES$ sequence cache size >= 10,000 for TEST4DB PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST1DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST2DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST3DB1 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST4DB1 instance PASS => None of the hostnames contains an underscore character PASS => Value of remote_listener parameter is able to tnsping for TEST1DB PASS => Value of remote_listener parameter is able to tnsping for TEST2DB PASS => Value of remote_listener parameter is able to tnsping for TEST3DB PASS => Value of remote_listener parameter is able to tnsping for TEST4DB PASS => All tablespaces are locally manged tablespace for TEST1DB PASS => All tablespaces are locally manged tablespace for TEST2DB PASS => All tablespaces are locally manged tablespace for TEST3DB PASS => All tablespaces are locally manged tablespace for TEST4DB PASS => All tablespaces are using Automatic segment storage management for TEST1DB PASS => All tablespaces are using Automatic segment storage management for TEST2DB PASS => All tablespaces are using Automatic segment storage management for TEST3DB PASS => All tablespaces are using Automatic segment storage management for TEST4DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for TEST1DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for TEST2DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for TEST3DB PASS => Failover method (SELECT) and failover mode (BASIC) are configured properly for TEST4DB 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 => All voting disks are online PASS => Remote listener is set to SCAN name for TEST1DB PASS => Remote listener is set to SCAN name for TEST2DB PASS => Remote listener is set to SCAN name for TEST3DB PASS => Remote listener is set to SCAN name for TEST4DB PASS => CRS version is higher or equal to ASM version. PASS => NIC bonding is configured for public network (VIP) 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.rdbms parameter set to 11.2.0.2 or higher PASS => All disk groups have compatible.asm parameter set to 11.2.0.2 or higher 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 => uid of GI owner is less than 7 digits long PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST1DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST2DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST3DB1 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST4DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST1DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST2DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST3DB1 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST4DB1 instance PASS => ASM processes parameter is set to recommended value PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST1DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST2DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST3DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST4DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST1DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST2DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST3DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST4DB FAIL => One or more software or firmware versions are NOT up to date with OAK repository. PASS => Shared storage checks successful PASS => System component checks successful FAIL => One or more errors or warnings for network and bonding interface checks PASS => OS Disk Storage checks successful PASS => All bigfile tablespaces have non-default maxbytes values set for TEST1DB PASS => All bigfile tablespaces have non-default maxbytes values set for TEST2DB FAIL => Some bigfile tablespaces do not have non-default maxbytes values set for TEST3DB PASS => All bigfile tablespaces have non-default maxbytes values set for TEST4DB PASS => ASM parameter MEMORY_TARGET is set according to recommended value. PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST1DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST2DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST3DB1 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST4DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST1DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST2DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST3DB1 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST4DB1 instance PASS => Kernel parameter net.core.rmem_max OK WARNING => pam_limits NOT configured properly for shell limits PASS => The number of async IO descriptors is sufficient (/proc/sys/fs/aio-max-nr) PASS => VKTM is running in real time scheduling class for TEST1DB PASS => VKTM is running in real time scheduling class for TEST2DB PASS => VKTM is running in real time scheduling class for TEST3DB PASS => VKTM is running in real time scheduling class for TEST4DB PASS => All disk groups have allocation unit size set to 4MB PASS => All disk groups have compatible.rdbms parameter set to 11.2.0.2 or higher PASS => All disk groups have compatible.asm parameter set to 11.2.0.2 or higher 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/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 grep: ERROR: Failed to get Oracle Inventory Location. Exiting.../ContentsXML/inventory.xml: No such file or directory -bash: /OPatch/opatch: No such file or directory grep: ERROR: Failed to get Oracle Inventory Location. Exiting.../ContentsXML/inventory.xml: No such file or directory /bin/ls: /u01/app/oracle/product/11.2.0/dbhome_1/u01/app/oracle/agent11g: No such file or directory -bash: /u01/app/oracle/product/11.2.0/dbhome_1/u01/app/oracle/agent11g/OPatch/opatch: No such file or directory 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 => Database Parameter parallel_execution_message_size is set to the recommended value on TEST1DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST2DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST3DB2 instance PASS => Database Parameter parallel_execution_message_size is set to the recommended value on TEST4DB2 instance PASS => None of the hostnames contains an underscore character PASS => Value of remote_listener parameter is able to tnsping for TEST1DB PASS => Value of remote_listener parameter is able to tnsping for TEST2DB PASS => Value of remote_listener parameter is able to tnsping for TEST3DB PASS => Value of remote_listener parameter is able to tnsping for TEST4DB 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 => Remote listener is set to SCAN name for TEST1DB PASS => Remote listener is set to SCAN name for TEST2DB PASS => Remote listener is set to SCAN name for TEST3DB PASS => Remote listener is set to SCAN name for TEST4DB PASS => CRS version is higher or equal to ASM version. PASS => NIC bonding is configured for public network (VIP) 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 => uid of GI owner is less than 7 digits long PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST1DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST2DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST3DB2 instance PASS => Database parameter DB_LOST_WRITE_PROTECT is set to recommended value on TEST4DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST1DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST2DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST3DB2 instance PASS => Database parameter GLOBAL_NAMES is set to recommended value on TEST4DB2 instance PASS => ASM processes parameter is set to recommended value PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST1DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST2DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST3DB PASS => Database parameter db_recovery_file_dest_size is set to recommended value for TEST4DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST1DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST2DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST3DB PASS => Database parameter Db_create_online_log_dest_n is set to recommended value for TEST4DB FAIL => One or more software or firmware versions are NOT up to date with OAK repository. PASS => Shared storage checks successful PASS => System component checks successful FAIL => One or more errors or warnings for network and bonding interface checks 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 TEST1DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST2DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST3DB2 instance PASS => Database parameter DB_BLOCK_CHECKING is set to the recommended value on TEST4DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST1DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST2DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST3DB2 instance PASS => Database parameter DB_BLOCK_CHECKSUM is set to recommended value on TEST4DB2 instance PASS => Kernel parameter net.core.rmem_max OK WARNING => pam_limits NOT configured properly for shell limits PASS => The number of async IO descriptors is sufficient (/proc/sys/fs/aio-max-nr) PASS => VKTM is running in real time scheduling class for TEST1DB PASS => VKTM is running in real time scheduling class for TEST2DB PASS => VKTM is running in real time scheduling class for TEST3DB PASS => VKTM is running in real time scheduling class for TEST4DB 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/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/dbhome_1 has same number of patches installed across the cluster. --------------------------------------------------------------------------------- Detailed report (html) - /opt/oracle/oak/odachk/odachk_TEST4DB_052212_155742/odachk_TEST4DB_052212_155742.html UPLOAD(if required) - /opt/oracle/oak/odachk/odachk_TEST4DB_052212_155742.zip