对于19C RAC集群部署完成后可以在 $ORACLE_HOME/suptools 找到orachk，但是版本比较旧
This version of orachk was released on 29-Apr-2020 and it is older than 180 days.
如果需要新版本的orachk，请参考文章：https://www.modb.pro/db/29328
关于orachk常用的几个参数
[root@rac1 ~]# /u01/app/oracle/product/19.0.0/db_1/suptools/orachk/orachk -h
-a All (Perform best practice check and recommended patch check)
-b Best Practice check only. No recommended patch check
-classicjson Generate valid json files with results, exceptions and recommendations
-cleanup
-clusternodes Specify a comma-delimited list of node names to run only on a subset of nodes.
-cvuhome A different Cluster Verification Utility (CVU) home can be specified with this parameter. When not specified, CVU from GRID home is executed.
-cvuonly When specified, runs only Cluster Verification Utility (CVU) related checks
-d Used for daemon related options.
-dball Runs the database checks on all databases discovered on the system. Does not prompt for database selection
-dbconfig Specify a comma-delimited list of database homes with corresponding names to run only on a subset of databases.
-dbnames Specify a comma-delimited list of database names to run only on a subset of databases.
-dbnone To skip all the database checks. Does not prompt for database selection.
-dbparallel Run SQL, SQL_COLLECT and OS Checks in parallel.
-dbserial Run SQL, SQL_COLLECT and OS Checks in serial.
-debug Run orachk in debug mode. Debug log will be generated
-diff Reports the difference between the two HTML reports.
-enableuser To enable orachk to run as non-root user(Database/Grid owners). This will enable orachk on all configured nodes.
-excludecheck To exclude specific set of checks, pass check_ids at command prompt
-excludecvu
-excludedbnames Specify a comma-delimited list of database names to be exclude.
-excludediscovery Excludes the discovered directories
-f Run Offline. Checks will be performed on data already collected from the system
-from The parameter specifies when to start collecting the logs and traces for storage server diagnostic package.
-javahome This option must be used with -acchk. It is used to specify the JAVA_HOME directory for a JDK8 installation.
-localonly To run checks only on the local node.
-localuser This option allows user to run root checks with user for which sudo has been configured and has ability to ssh on remote node.
-nopass Skip PASS'ed check to print in orachk report and upload to database.
-nordbms If CRS is installed but RDBMS is not installed still user wants to run orachk then user can specify this option.
-noupgrade User can specify this option if you do not want to be prompted for an upgrade even if a later version is available under the location specified by RAT_UPGRADE_LOC.
-p Patch checks only
-pdbnames Specify a comma-delimited list of pluggable database names to run only on a subset of pluggable databases.
-remoteuser Used to specify remote user to run orachk. This command is used in combination with command -remotehost
-silentforce Used to run orachk in non-interactive mode. Run will not prompt for inputs and hence consider default values.
-tag Appends <tagname> to Report Name. <Tagname> must contain only alphanumeric characters.
示例, dball检查所有数据库，localonly仅检查本节点，noupgrade不显示升级提示，silentforce非交互
[root@rac1 ~]# /u01/app/oracle/product/19.0.0/db_1/suptools/orachk/orachk -dball -localonly -silentforce -noupgrade
Clusterware stack is running from /u01/app/19.0.0/grid. Is this the correct Clusterware Home?[y/n][y]
Searching for running databases . . . . .
. .
List of running databases registered in OCR
1. orcl
2. None of above
. . . .
. .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . .
. . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
rac1 Yes Yes Yes Yes Yes orcl1
-------------------------------------------------------------------------------------------------------
Copying plug-ins
. .
. . . . . .
Either Cluster Verification Utility pack (cvupack) does not exist at /opt/oracle.ahf/common/cvu or it is an old or invalid cvupack
Checking Cluster Verification Utility (CVU) version at CRS Home - /u01/app/19.0.0/grid
*** Checking Best Practice Recommendations ( Pass / Warning / Fail ) ***
. .
Collections and audit checks log file is
/u01/app/grid/oracle.ahf/data/rac1/orachk/orachk_rac1_PDB_053021_120135/log/orachk.log
============================================================
Node name - rac1
============================================================
Collecting - ASM Disk Groups
Collecting - ASM Disk I/O stats
Collecting - ASM Diskgroup Attributes
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM diskgroup usable free space
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for orcl database
Collecting - Active sessions load balance for PDB database
Collecting - Archived Destination Status for orcl database
Collecting - Cluster Interconnect Config for orcl database
Collecting - Database Archive Destinations for orcl database
Collecting - Database Files for orcl database
Collecting - Database Files for PDB database
Collecting - Database Instance Settings for orcl database
Collecting - Database Parameters for orcl database
Collecting - Database Properties for orcl database
Collecting - Database Properties for PDB database
Collecting - Database Registry for orcl database
Collecting - Database Registry for PDB database
Collecting - Database Sequences for orcl database
Collecting - Database Sequences for PDB database
Collecting - Database Undocumented Parameters for orcl database
Collecting - Database Undocumented Parameters for orcl database
Collecting - Database Workload Services for orcl database
Collecting - Database Workload Services for PDB database
Collecting - Dataguard Status for orcl database
Collecting - Files not opened by ASM
Collecting - List of active logon and logoff triggers for orcl database
Collecting - List of active logon and logoff triggers for PDB database
Collecting - Log Sequence Numbers for orcl database
Collecting - Percentage of asm disk Imbalance
Collecting - Process for shipping Redo to standby for orcl database
Collecting - RDBMS Feature Usage for orcl database
Collecting - Redo Log information for orcl database
Collecting - Standby redo log creation status before switchover for orcl database
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS disktimout
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - Disk I/O Scheduler on Linux
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Interconnect network card speed
Collecting - Kernel parameters
Collecting - Linux module config.
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle executable attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Collecting - CRS Opatch version
Collecting - CRS user time zone check
Collecting - Custom rc init scripts (rc.local)
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - ORAchk Daemon/Scheduler configuration
Collecting - Root user limits
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check
Collecting - slabinfo
Collecting - umask setting for GI owner
Data collections completed. Checking best practices on rac1.
------------------------------------------------------------
INFO => Important Automatic Storage Management (ASM) Notes and Technical White Papers
INFO => Oracle Data Pump Best practices.
WARNING => Linux swap configuration does not meet recommendation
INFO => Most recent ADR incidents for /u01/app/oracle/product/19.0.0/db_1
INFO => Oracle GoldenGate failure prevention best practices
CRITICAL => RemoveIPC setting should be configured to "No" in /etc/systemd/logind.conf
WARNING => Shell limit hard nofile for GI is NOT configured according to recommendation
WARNING => OCR and OCR backup locations are the same path
WARNING => ARCHIVELOG mode is disabled for orcl
CRITICAL => The RMAN snapshot control file location is not shared on all database nodes in the cluster for orcl
INFO => Some tablespaces do not have allocation type as SYSTEM for PDB
INFO => At some times checkpoints are not being completed for orcl
WARNING => Some user sessions lack proper failover mode (BASIC) and method (SELECT) for orcl
CRITICAL => Temporary location is not configured for auto cleanup
WARNING => Controlfile is not multiplexed for orcl
WARNING => One or more redo log groups are not multiplexed for orcl
WARNING => kernel.shmmax parameter is NOT configured according to recommendation
WARNING => Primary database is not protected with Data Guard (standby database) for real-time data protection and availability for orcl
WARNING => Flashback on PRIMARY is not configured for orcl
INFO => Important Storage Minimum Requirements for Grid & Database Homes
CRITICAL => Operating system hugepages count does not satisfy total SGA requirements
WARNING => NIC bonding is not configured for interconnect
WARNING => NIC bonding is NOT configured for public network (VIP)
WARNING => RAC interconnect network card speed does not meet recommendation
WARNING => OSWatcher is not running as is recommended.
INFO => Jumbo frames (MTU >= 9000) are not configured for interconnect
WARNING => All disk groups should have compatible.rdbms attribute set to recommended values
WARNING => One or more pluggable database found in container database with saved state for orcl
CRITICAL => One or more log archive destination and alternate log archive destination settings are not as recommended for orcl
FAIL => Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on orcl1 instance
WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for orcl
INFO => Operational Best Practices
INFO => Database Consolidation Best Practices
INFO => Computer failure prevention best practices
INFO => Data corruption prevention best practices
INFO => Logical corruption prevention best practices
INFO => Database/Cluster/Site failure prevention best practices
INFO => Client failover operational best practices
WARNING => fast_start_mttr_target should be greater than or equal to 300. on orcl1 instance
INFO => Information about hanganalyze and systemstate dump
CRITICAL => Database control files are not configured as recommended for orcl
FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for orcl
FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for PDB
INFO => Database failure prevention best practices
WARNING => Database Archivelog Mode should be set to ARCHIVELOG for orcl
INFO => Parallel Execution Health-Checks and Diagnostics Reports for orcl
CRITICAL => Linux transparent huge pages are enabled
WARNING => One or more diskgroups from v$asm_diskgroups are not registered in clusterware registry
INFO => Oracle recovery manager(rman) best practices
WARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for orcl
WARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for PDB
WARNING => Consider increasing the value of the session_cached_cursors database parameter for orcl
WARNING => Consider investigating the frequency of SGA resize operations and take corrective action for orcl
Best Practice checking completed. Checking recommended patches on rac1
--------------------------------------------------------------------------------
Collecting patch inventory on CRS_HOME /u01/app/19.0.0/grid
Collecting patch inventory on ASM_HOME /u01/app/19.0.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/19.0.0/db_1
--------------------------------------------------------------------------------
1 Recommended CRS patches for 190000 from /u01/app/19.0.0/grid on rac1
--------------------------------------------------------------------------------
Patch# CRS ASM RDBMS RDBMS_HOME Patch-Description
--------------------------------------------------------------------------------
31304218yes yes yes /u01/app/oracle/product/19.0.0/db_1
31304218yes yes yes /u01/app/oracle/product/19.0.0/db_1
31304218yes yes yes /u01/app/oracle/product/19.0.0/db_1
31304218yes yes yes /u01/app/oracle/product/19.0.0/db_1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
1 Recommended RDBMS patches for 190000 from /u01/app/oracle/product/19.0.0/db_1 on rac1
--------------------------------------------------------------------------------
Patch# RDBMS ASM type Patch-Description
--------------------------------------------------------------------------------
31304218yes yes merge
31304218yes yes merge
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Clusterware patches summary report
--------------------------------------------------------------------------------
Total patches Applied on CRS Applied on RDBMS Applied on ASM
--------------------------------------------------------------------------------
1 1 1 1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
RDBMS homes patches summary report
--------------------------------------------------------------------------------
Total patches Applied on RDBMS Applied on ASM ORACLE_HOME
--------------------------------------------------------------------------------
1 1 1 /u01/app/oracle/product/19.0.0/db_1
--------------------------------------------------------------------------------
------------------------------------------------------------
CLUSTERWIDE CHECKS
------------------------------------------------------------
------------------------------------------------------------
Detailed report (html) - /u01/app/grid/oracle.ahf/data/rac1/orachk/orachk_rac1_PDB_053021_120135/orachk_rac1_PDB_053021_120135.html
UPLOAD [if required] - /u01/app/grid/oracle.ahf/data/rac1/orachk/orachk_rac1_PDB_053021_120135.zip
[root@rac1 ~]#
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
