ORAchk:
ORAchk replaces the RACCheck utility. ORAchk extends health check coverage to the entire Oracle software stack, and identifies and addresses top issues reported by Oracle users.
ORAchk proactively scans for known problems with Oracle products and deployments, including the following:
- Standalone Oracle Database
- Oracle Grid Infrastructure
- Oracle Real Application Clusters
- Maximum Availability Architecture (MAA) Validation
- Upgrade Readiness Validations
- Oracle Golden Gate
Oracle is continuing to expand checks, based on customer requests.
Installation :
[root@ram orachk]# cp -r /home/oracle/Desktop/orachk.zip /u01/app/oracle/product/12.2.0.1/db_1/suptools/orachk
[root@ram orachk]# ls -lrt
total 418548
-rw-r--r--. 1 oracle oinstall 3879 Jun 10 2016 generate_guests_list.sh
-rw-r--r--. 1 oracle oinstall 11487 Jun 10 2016 cgrep
-rwxr-x---. 1 oracle oinstall 182 Jun 10 2016 UserGuide.txt
-rwxr-x---. 1 oracle oinstall 2201 Jun 10 2016 readme.txt
-rw-r--r--. 1 oracle oinstall 2888 Aug 10 2016 user_defined_checks.xsd
-rwxr-x---. 1 oracle oinstall 5906493 Aug 10 2016 rules.dat
-rwxr-x---. 1 oracle oinstall 2856776 Aug 10 2016 orachk
-rwxr-x---. 1 oracle oinstall 42423762 Aug 10 2016 collections.dat
-rw-r--r--. 1 oracle oinstall 2170483 Aug 10 2016 ORAchk_Health_Check_Catalog.html
-rw-r--r--. 1 oracle oinstall 4801825 Aug 10 2016 CollectionManager_App.sql
drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 templates
drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 exadiscover
drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 doc
-rw-r--r--. 1 oracle oinstall 32159 Oct 22 20:22 orachk_debug_20181022_202100.log
-rw-r--r--. 1 oracle oinstall 11540087 Oct 22 21:14 orachk_debug_20181022_203840.log
-rwxr--r--. 1 root root 358799048 Oct 23 02:22 orachk.zip
[root@ram orachk]# unzip orachk.zip
Archive: orachk.zip
replace collections.dat? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: collections.dat
replace rules.dat? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
inflating: rules.dat
replace .cgrep/versions.dat? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: .cgrep/versions.dat
inflating: .cgrep/profiles.dat
inflating: .cgrep/profiles/EF6C016813C51366E04313C0E50AE11F.prf
inflating: .cgrep/profiles/DA94919CD0DE0913E04312C0E50A7996.prf
inflating: .cgrep/profiles/D49C0FBF8FBF4B1AE0431EC0E50A0F24.prf
inflating: .cgrep/profiles/06889D8BB65E575CE05313C0E50ADFD3.prf
inflating: .cgrep/profiles/D8367AD6754763FEE04312C0E50A6FCB.prf
inflating: .cgrep/profiles/DF65D6117CB41054E04312C0E50A69D1.prf
inflating: .cgrep/profiles/579C1EAF1380DEC3E053D298EB0AB847.prf
inflating: .cgrep/profiles/06702DE980726771E05313C0E50ACF83.prf
inflating: .cgrep/profiles/42AEB5616C5A7648E0530C98EB0A4B18.prf
inflating: .cgrep/profiles/68A6BCC041C53A8FE053D398EB0AA546.prf
inflating: .cgrep/profiles/1B0907A7BA8EA932E0530C98EB0A0947.prf
inflating: .cgrep/profiles/20E3DAB976AD7377E0530A98EB0A9BCA.prf
inflating: .cgrep/profiles/398C70DD35E55DE9E0530E98EB0A880F.prf
inflating: .cgrep/profiles/E1BF012E8F210839E04313C0E50A7B68.prf
inflating: .cgrep/profiles/D462A6F7E9C340FDE0431EC0E50ABE12.prf
inflating: .cgrep/profiles/3E121C16D3714EE0E0530E98EB0A6C66.prf
extracting: .cgrep/profiles/638ED6170D1C053CE053D498EB0A65F6.prf
inflating: .cgrep/profiles/EA5EE324E7E05128E04313C0E50A4B2A.prf
inflating: .cgrep/profiles/3194E615F4BBEDD0E0530A98EB0A046E.prf
inflating: .cgrep/profiles/069273EAA9873FD1E05312C0E50A8953.prf
inflating: .cgrep/profiles/1C6E4AC8EF3674D0E0530D98EB0ACEC1.prf
inflating: .cgrep/profiles/E8DF76E07DD82E0DE04313C0E50AA55D.prf
inflating: .cgrep/profiles/206B850D83B1CE54E0530C98EB0A5C89.prf
inflating: .cgrep/profiles/53C6697D0F4E825DE0530D98EB0A38AF.prf
inflating: .cgrep/profiles/D49AD88F8EE75CD8E0431EC0E50A0BC3.prf
inflating: .cgrep/profiles/F32F44CE0BCD662FE04312C0E50AB058.prf
inflating: .cgrep/profiles/E2E972DDE1E14493E04312C0E50A1AB1.prf
inflating: .cgrep/profiles/12B66730A5161437E05312C0E50AABAB.prf
inflating: .cgrep/profiles/D49B218473787400E0431EC0E50A0BB9.prf
inflating: .cgrep/profiles/0A82EA8BF9646097E05313C0E50A26D6.prf
inflating: .cgrep/profiles/1B0907A7BA8DA932E0530C98EB0A0947.prf
inflating: .cgrep/profiles/F6AFECA37F177C3FE04313C0E50A56BF.prf
inflating: .cgrep/profiles/F9ED0179CCD8256BE04312C0E50A5399.prf
inflating: .cgrep/profiles/45E86D52410AC60AE0530E98EB0AA8EB.prf
inflating: .cgrep/profiles/4F59DD9703B8547CE0530C98EB0A9927.prf
inflating: .cgrep/profiles/177BBFEE0215240AE0530E98EB0AEBF7.prf
inflating: .cgrep/profiles/09DC8AC7C7974BDDE05313C0E50A2339.prf
inflating: .cgrep/profiles/4329C86BB3C356BFE0530B98EB0A4B22.prf
extracting: .cgrep/profiles/21A3C08B67727E6AE0530E98EB0AE59C.prf
inflating: .cgrep/profiles/165CCF84D4FE0342E0530A98EB0AAE6E.prf
inflating: .cgrep/profiles/D49BDC2EC9E624AEE0431EC0E50A3E12.prf
inflating: .cgrep/profiles/D49C0AB26A6D45A8E0431EC0E50ADE06.prf
inflating: .cgrep/profiles/70B251DD093D2F72E053D498EB0AD124.prf
inflating: .cgrep/profiles/D49C4F9F48735396E0431EC0E50A9A0B.prf
inflating: .cgrep/profiles/DFE9C207A8F2428CE04313C0E50A6B0A.prf
inflating: .cgrep/profiles/271BD73C756AE5EDE0530B98EB0A6A13.prf
inflating: .cgrep/profiles/DF65D0F7FB6F1014E04312C0E50A7808.prf
inflating: .cgrep/profiles/1B0907A7BA8CA932E0530C98EB0A0947.prf
inflating: .cgrep/profiles/178E758EB8CA06D8E0530D98EB0A7AC9.prf
inflating: .cgrep/profiles/270F37922A89B520E0530B98EB0ADDE9.prf
inflating: orachk
inflating: orachk.bat
inflating: orachk.pyc
inflating: CollectionManager_App.sql
inflating: Apex5_CollectionManager_App.sql
inflating: sample_user_defined_checks.xml
inflating: user_defined_checks.xsd
inflating: .cgrep/acchk.jar
inflating: .cgrep/utlu112i.sql
inflating: .cgrep/upgrade.oracle.jar
inflating: .cgrep/registry_validation.sql
inflating: .cgrep/acgrep
inflating: .cgrep/diff_collections.pl
inflating: .cgrep/lcgreps10
inflating: .cgrep/raw_data_browser.pl
inflating: .cgrep/checkvg.sh
inflating: .cgrep/Recursive.pm
inflating: .cgrep/checkDiagCollections.sh
inflating: .cgrep/scgrep
inflating: .cgrep/cluster_check_os_collect
inflating: .cgrep/filechecker.sh
inflating: .cgrep/parse_user_defined_checks.pl
inflating: .cgrep/idmhc_get_check_status.pl
extracting: .cgrep/dbsat.zip
inflating: .cgrep/scnhealthcheck.sql
inflating: .cgrep/reset_crshome.pl
inflating: .cgrep/host_specific_collections.pl
inflating: .cgrep/lcgrep4
inflating: .cgrep/checkFlashCache.sh
inflating: .cgrep/checkLocalDisks.sh
inflating: .cgrep/zonecores.sh
inflating: .cgrep/isc_summary.pl
inflating: .cgrep/lcgreps11
inflating: .cgrep/lcgrep5
inflating: .cgrep/checkHiddenParams.sh
inflating: .cgrep/validatePassword.sh
inflating: .cgrep/preupgrade122.jar
inflating: .cgrep/ocm_switch.py
inflating: .cgrep/checkDiskFGMapping.sh
inflating: .cgrep/parse_index.pl
inflating: .cgrep/append_merge_collections.pl
inflating: .cgrep/psqlplus
inflating: .cgrep/detect_custom_rpms.sh
inflating: .cgrep/ggdiscovery.sh
inflating: .cgrep/EM_NLSID_ID.dat
inflating: .cgrep/preupgrade19.jar
inflating: .cgrep/preupgrd.sql
inflating: .cgrep/get_zfs_checks.pl
inflating: .cgrep/discover_java_home.sh
inflating: .cgrep/pxhcdr.sql
inflating: .cgrep/preupgrade18.jar
inflating: .cgrep/discoverdbasm.pl
inflating: .cgrep/check_sysctl.awk
inflating: .cgrep/mineocr.pm
inflating: .cgrep/lcgreps9
inflating: .cgrep/zlcgrep6
inflating: .cgrep/utlusts.sql
inflating: .cgrep/readreg.pl
inflating: .cgrep/rac_main.pl
inflating: .cgrep/lcgrep3
inflating: .cgrep/check_reblance_free_space.sql
inflating: .cgrep/ogghc_11203.sql
inflating: .cgrep/lcgrep6
inflating: .cgrep/cgrepwin61
inflating: .cgrep/ofm_client.sh
inflating: .cgrep/auto_upgrade.pl
inflating: .cgrep/create_small_file.pl
inflating: .cgrep/vmpscan.sh
inflating: .cgrep/check_dom0_ocfs2.sh
inflating: .cgrep/checkDiskScheduler.sh
inflating: .cgrep/rac_lib.pm
inflating: .cgrep/asrexacheck
inflating: .cgrep/ra_check_version.pl
inflating: .cgrep/scgrepx86
inflating: .cgrep/load_checks_attributes.pl
inflating: .cgrep/oracle-upstarttmpl.conf
inflating: .cgrep/rack_comparison.py
inflating: .cgrep/hiacgrep
inflating: .cgrep/utluppkg.sql
inflating: .cgrep/top_consumers.pl
inflating: .cgrep/rac_file_checker.pl
inflating: .cgrep/merge_collections.pl
inflating: .cgrep/show_file_in_html.pl
inflating: .cgrep/wincgrep.exe
inflating: .cgrep/lcgrep6s
inflating: .cgrep/profile_collections.pl
inflating: .cgrep/create_version.pl
inflating: .cgrep/zfschecks/SoftringWorkflow
inflating: .cgrep/zfschecks/Datasets
inflating: .cgrep/zfschecks/ZSPrivateNetworkInterface
inflating: .cgrep/zfschecks/BlockSize
inflating: .cgrep/zfschecks/MirrorProfile
inflating: .cgrep/zfschecks/ZSPool
inflating: .cgrep/zfschecks/SnapshotVisibility
inflating: .cgrep/zfschecks/ZSIPMP
inflating: .cgrep/zfschecks/NFSDomain
inflating: .cgrep/zfschecks/Cluster
inflating: .cgrep/zfschecks/DNSConfiguration
inflating: .cgrep/zfschecks/ComputeZSServices
inflating: .cgrep/zfschecks/IlomHealth
inflating: .cgrep/zfschecks/Maintenance
inflating: .cgrep/zfschecks/ZSDIMM
inflating: .cgrep/zfschecks/StorageMemSize
inflating: .cgrep/zfschecks/ComputeAnalyticsRetentionPolicy
inflating: .cgrep/zfschecks/ExtShareDedup
inflating: .cgrep/zfschecks/ExtShadows
inflating: .cgrep/zfschecks/DiskTimeoutWarning
inflating: .cgrep/zfschecks/ZSPowerSupply
inflating: .cgrep/zfschecks/Shadows
inflating: .cgrep/zfschecks/ExtMirrorProfile
inflating: .cgrep/zfschecks/HeadStatus
inflating: .cgrep/zfschecks/ZSServices
inflating: .cgrep/zfschecks/ExtShareQuota
inflating: .cgrep/zfschecks/ComputeZSZillas
inflating: .cgrep/zfschecks/Lock
inflating: .cgrep/zfschecks/ZSFan
inflating: .cgrep/zfschecks/NISService
inflating: .cgrep/zfschecks/ComputeDatasets
inflating: .cgrep/zfschecks/ZSNTP
inflating: .cgrep/zfschecks/ZSVersion
inflating: .cgrep/zfschecks/ZSZillas
inflating: .cgrep/zfschecks/ZSRouting
inflating: .cgrep/zfschecks/NFSDelegation
inflating: .cgrep/zfschecks/Backend
inflating: .cgrep/zfschecks/ZSILOM
inflating: .cgrep/zfschecks/L2ARCHeader
inflating: .cgrep/zfschecks/NFS4LockObjectLeak
inflating: .cgrep/zfschecks/CommonCode
inflating: .cgrep/zfschecks/AnalyticsRetentionPolicy
inflating: .cgrep/zfschecks/ZSSlot
inflating: .cgrep/zfschecks/ZSCPU
inflating: .cgrep/zfschecks/ExtBlockSize
inflating: .cgrep/zfschecks/ShareDedup
inflating: .cgrep/zfschecks/ShareQuota
inflating: .cgrep/run_individual_checks.pl
inflating: .cgrep/diff_checks.pl
inflating: .cgrep/hugeSGAchecks.sh
inflating: .cgrep/ogghc_12101.sql
inflating: .cgrep/ogghc_11204.sql
inflating: .cgrep/combine_collections.pl
inflating: .cgrep/OVMMCheckChannels.py
inflating: .cgrep/cluster_check_os_check
inflating: .cgrep/cgrepwin63
creating: lib/
inflating: lib/debugger.pyc
inflating: lib/__init__.pyc
inflating: lib/fileattr.pyc
inflating: lib/utils.pyc
inflating: lib/mail.pyc
inflating: lib/command.pyc
inflating: lib/messages.pyc
inflating: lib/em_xml_template.pyc
inflating: lib/execute_checks.pyc
inflating: lib/wallet.pm
inflating: lib/logger.pyc
inflating: lib/constant.pyc
inflating: lib/help.pyc
inflating: lib/CM_UpgradeScript.sql
inflating: lib/autoscheduler.tmpl
inflating: lib/data_collections.pyc
inflating: lib/discover_env.pyc
inflating: lib/cleanup.pyc
inflating: lib/init.tmpl
inflating: lib/patch_recommendation.pyc
inflating: lib/mkstore.pyc
inflating: lib/autostart
inflating: lib/CM_Wrapper.sql
inflating: lib/oracle-upstarttmpl.conf
inflating: lib/generate_report.pyc
inflating: lib/winservice.pyc
inflating: lib/cm_lib.pl
creating: lib/wallet_jars/
inflating: lib/wallet_jars/ojpse.jar
inflating: lib/wallet_jars/osdt_core.jar
inflating: lib/wallet_jars/osdt_cert.jar
extracting: lib/wallet_jars/cwallet.sso
inflating: lib/wallet_jars/oraclepki.jar
inflating: lib/wallet_jars/ojmisc.jar
inflating: lib/dbconnection.pyc
inflating: lib/connection.pyc
inflating: lib/security.pyc
inflating: lib/watchdog.pyc
creating: build/
extracting: build/Python3_zlinux.zip
extracting: build/Python3_aix.zip
extracting: build/Python3_solaris_sparc.zip
extracting: build/Python3_solaris.zip
extracting: build/Python3_linux.zip
inflating: exadiscover/README
inflating: exadiscover/list_master_node.sql
inflating: exadiscover/list_all_ips.sql
inflating: exadiscover/list_all_ips_vars.sql
inflating: exadiscover/list_assets.sql
inflating: exadiscover/CHANGELOG
inflating: exadiscover/exadiscover.py
inflating: exadiscover/list_ovmm.sql
inflating: exadiscover/exadiscover.sh
inflating: templates/exachk_exalogic.conf.tmpl_quarter
inflating: templates/exachk_exalogic.conf.tmpl_half
inflating: templates/exachk_exalogic.conf.tmpl_full
inflating: templates/exachk_exalogic.conf.tmpl_eighth
creating: bash/
inflating: bash/psqlplus
inflating: bash/discoverdbasm.pl
inflating: bash/orachk
creating: web/
inflating: web/orachk.jar
inflating: web/setup_ords.sh
inflating: web/ords.war
inflating: .cgrep/orachk.pyc
extracting: build/.DIAGKIT.zip
inflating: ORAchk_Health_Check_Catalog.html
inflating: UserGuide.txt
inflating: readme.txt
inflating: doc/ORAchk_and_EXAchk_User_Guide.pdf
[root@ram orachk]#
[oracle@ram ~]$ cd /u01/app/oracle/product/12.2.0.1/db_1/suptools/ [oracle@ram suptools]$ ls -lrt total 12 drwxr-xr-x. 3 oracle oinstall 4096 Jun 19 10:33 tfa drwxr-xr-x. 6 oracle oinstall 4096 Jun 19 10:35 orachk drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:39 oratop [oracle@ram suptools]$ cd orachk/ [oracle@ram orachk]$ ls -lrt total 56848 -rw-r--r--. 1 oracle oinstall 3879 Jun 10 2016 generate_guests_list.sh -rw-r--r--. 1 oracle oinstall 11487 Jun 10 2016 cgrep -rwxr-x---. 1 oracle oinstall 182 Jun 10 2016 UserGuide.txt -rwxr-x---. 1 oracle oinstall 2201 Jun 10 2016 readme.txt -rw-r--r--. 1 oracle oinstall 2888 Aug 10 2016 user_defined_checks.xsd -rwxr-x---. 1 oracle oinstall 5906493 Aug 10 2016 rules.dat -rwxr-x---. 1 oracle oinstall 2856776 Aug 10 2016 orachk -rwxr-x---. 1 oracle oinstall 42423762 Aug 10 2016 collections.dat -rw-r--r--. 1 oracle oinstall 2170483 Aug 10 2016 ORAchk_Health_Check_Catalog.html -rw-r--r--. 1 oracle oinstall 4801825 Aug 10 2016 CollectionManager_App.sql drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 templates drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 exadiscover drwxr-xr-x. 2 oracle oinstall 4096 Jun 19 10:35 doc
[oracle@ram orachk]$ cat readme.txt
For full documentation on ORAchk including details on what's new in 12.1.0.2.7 see the ORAchk_and_EXAchk_User_Guide.pdf in the doc directory or the ORAchk and EXAchk User's Guide at http://docs.oracle.com/cd/E75572_01/index.html
Issues fixed in ORAchk 12.1.0.2.7
---------------------------------
23041776 lnx64-12.2-orachk: failed to use psqlplus
23193819 request orachk to check udev best practice on network configuration hotplug="n"
23147689 orachk 12.1.0.2.6 resource discovery fails for 10.2 databases
23144636 support anonymous pl/sql block in sql checks
23140046 check if compatible.asm and compatible.dbms should be advanced
23074512 problems parsing the values for autorun_schedule
23074163 daemon does not send diff report as email attachment
23071612 orachk to check that service_names parameter is not set in the spfile
23041743 lnx64-12.2-orachk:output not under oracle_base when run orachk not in its home
23014620 can not run orachk from stage directory due to permission issues
23012747 ac: application continuity - filter acchk output
23007768 orachk execution appends discovery name on path
22861038 orachk db discovery fails on linux 7
22746951 password visible in -setupload and -getupload
22721891 testemail does not validate address
22642844 orachk to warn if large amount of hugepage is free
22642302 provide centralized wallet for orachk cm uploads
21947833 orachk 12.1.0.2.4 - database prompt mismatch on standalone server
21773769 lnx64-12.2-oracheck: implement the file checker component for oracheck module
19161674 lnx64-12.1-orachk:orachk hit syntax error
18956483 lnx64-121-cmt: oakcli orachk hit warning sys.audses$ sequence cache size < 10000
18944821 solsp-12.1-utl-orachk:orachk give a wrong information about stack status
18944432 solsp-12.1-utl-orachk:tabular information isn't well aligned in orachk output
18789186 solsp-12.1-utl-orachk: remove/update log ownership check for orachk
18748527 solsp-12.1-utl-orachk:no need to ask non-gi user to set rat_output for -h option
Issues fixed in previous ORAchk releases
----------------------------------------
For a full list of ORAchk version history see ORAchk_EXAchk_Feature_Fix_History.pdf in the doc directory.
To check the version:
using the -v option.
[oracle@ram orachk]$ ./orachk -v
ORACHK VERSION: 12.1.0.2.7_20160526
To capture debug output:
[oracle@ram orachk]$ ./orachk –debug
Output : click here
Permission Problems:
You must have sufficient directory permissions to run Oracle ORAchk
Automatic start from TFA install
Oracle Trace File Analyzer root installations on Linux or Solaris on non-engineered systems will automatically setup and run the ORAchk daemon.
The daemon will be restarted at 1am every morning, in order to discover any environment changes. A full local ORAchk run will be performed at 2am every morning and a partial run of the most impactful checks will be run every 2 hours via the oratier1 profile.
Any collections older than 2 weeks will automatically be purged.
If ORAchk is installed in stand-alone mode Auto start can also be used for quick setup by running orachk -autostart, again only when run as root on Linux or Solaris on a non-engineered system.
Once auto start is enabled the daemon settings can be changed as per normal and auto start can be removed any time by using orachk -autostop or tfactl run orachk -autostop
Pre check:
[root@ram orachk]# ./orachk -u -o pre This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. Do you want to download latest version from my oracle support? [y/n][y]y updates.oracle.com is not reachable. Please establish connectivity to updates.oracle.com and try again. Do you want to continue running this version? [y/n][y]y Running older version... Running orachk ---------------------------------------------------------- PATH : /u01/app/oracle/product/12.2.0.1/db_1/suptools/orachk VERSION : 12.1.0.2.7_20160526 COLLECTIONS DATA LOCATION : /u01/app/oracle/orachk ---------------------------------------------------------- This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. Do you want to download latest version from my oracle support? [y/n][y]y updates.oracle.com is not reachable. Please establish connectivity to updates.oracle.com and try again. Do you want to continue running this version? [y/n][y]y Running older version... Enter upgrade target version (valid versions are 11.2.0.3.0, 11.2.0.4.0, 12.1.0.1.0 and 12.1.0.2.0):- Invalid upgrade target version format or upgrade version not yet supported. Enter upgrade target version (valid versions are 11.2.0.3.0, 11.2.0.4.0, 12.1.0.1.0 and 12.1.0.2.0) 2 tries left:- 12.1.0.2.0 This computer is for [S]ingle instance database or part of a [C]luster to run RAC database [S|C] [C]:S RDBMS binaries found at /u01/app/oracle/product/12.2.0.1/db_1/ and ORACLE_HOME not set. Do you want to set ORACLE_HOME to /u01/app/oracle/product/12.2.0.1/db_1/?[y/n][y]y Checking for prompts for root user on all nodes... 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 ------------------------------------------------------------------------------------------------------- ram No No Yes No No No ------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------- Installed components summary --------------------------------------------------------------------------------------------------------------------------------- GI_HOME ORACLE_HOME Database Names --------------------------------------------------------------------------------------------------------------------------------- Checking for prompts for oracle user on all nodes... Source vesrsion (122010) is higher than Target version (121020). orachk is exiting...
To avoid problems while running the tool from terminal sessions on a network attached workstation or laptop, consider running the tool using VNC.
If there is a network interruption, then the tool continues to process to completion.
If the tool fails to run, then re-run the tool. The tool does not resume from the point of failure.
Running Health Checks On-Demand:
To start on-demand health check runs, log in to the system as an appropriate user, and then run an appropriate tool.
Specify the options to direct the type of run that you want.
[root@ram orachk]# ./orachk This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. Do you want to download latest version from my oracle support? [y/n][y]y updates.oracle.com is not reachable. Please establish connectivity to updates.oracle.com and try again. Do you want to continue running this version? [y/n][y]y Running older version... Running orachk ---------------------------------------------------------- PATH : /u01/app/oracle/product/12.2.0.1/db_1/suptools/orachk VERSION : 12.1.0.2.7_20160526 COLLECTIONS DATA LOCATION : /u01/app/oracle/orachk ---------------------------------------------------------- This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. Do you want to download latest version from my oracle support? [y/n][y]y updates.oracle.com is not reachable. Please establish connectivity to updates.oracle.com and try again. Do you want to continue running this version? [y/n][y]y Running older version... Checking for prompts for oracle user on all nodes... List of running databases 1. clone 2. test 3. All of above 4. None of above Searching out ORACLE_HOME for selected databases. . . . . Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS . . . . . . . . . . . . Checking for prompts for root user on all nodes... . . . . . . . . . . . . ------------------------------------------------------------------------------------------------------- Oracle Stack Status ------------------------------------------------------------------------------------------------------- Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name ------------------------------------------------------------------------------------------------------- ram No No Yes No No Yes clone test ------------------------------------------------------------------------------------------------------- Copying plug-ins . . . . . . . . . *** Checking Best Practice Recommendations (PASS/WARNING/FAIL) *** Collections and audit checks log file is /u01/app/oracle/orachk/orachk_ram_test_102318_001148/log/orachk.log Checking for prompts in /root/.bash_profile on ram for root user... . . ============================================================= Node name - ram ============================================================= . . . . . Collecting - Database Parameters for test database Collecting - Database Undocumented Parameters for test database Collecting - RDBMS Feature Usage for test database Collecting - CPU Information Collecting - DiskMount Information 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 - Memory Information Collecting - OS Packages Collecting - Operating system release information and kernel version Collecting - Patches for RDBMS Home Collecting - Table of file system defaults Collecting - number of semaphore operations per semop system call Collecting - Disk Information Collecting - Linux Operating system health check using vmpscan.sh Collecting - Root user limits Collecting - Verify no database server kernel out of memory errors Data collections completed. Checking best practices on ram. -------------------------------------------------------------------- FAIL => Bash is vulnerable to code injection (CVE-2014-6271) WARNING => Linux Swap Configuration does NOT meet Recommendation WARNING => physical memory is not sufficient INFO => Important Storage Minimum Requirements for Grid & Database Homes INFO => Most recent ADR incidents for /u01/app/oracle/product/12.2.0.1/db_1 INFO => Oracle GoldenGate failure prevention best practices INFO => user_dump_dest has trace files older than 30 days for test FAIL => Operating system hugepages count does not satisfy total SGA requirements WARNING => OSWatcher is not running as is recommended. WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for test 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 => Duplicate objects were found in the SYS and SYSTEM schemas for test WARNING => Oracle clusterware is not being used WARNING => RAC Application Cluster is not being used for database high availability on test instance WARNING => DISK_ASYNCH_IO is NOT set to recommended value for test FAIL => Flashback on PRIMARY is not configured for test INFO => Database failure prevention best practices WARNING => fast_start_mttr_target has NOT been changed from default on test instance FAIL => Primary database is NOT protected with Data Guard (standby database) for real-time data protection and availability for test FAIL => Active Data Guard is not configured for test INFO => Oracle recovery manager(rman) best practices INFO => Consider increasing the COREDUMPSIZE size WARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for test WARNING => Consider investigating the frequency of SGA resize operations and take corrective action for test Best Practice checking completed.Checking recommended patches on ram. --------------------------------------------------------------------------------- Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1 --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- 0 Recommended RDBMS patches for 122010 from /u01/app/oracle/product/12.2.0.1/db_1 on ram --------------------------------------------------------------------------------- Patch# RDBMS ASM type Patch-Description --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- RDBMS homes patches summary report --------------------------------------------------------------------------------- Total patches Applied on RDBMS Applied on ASM ORACLE_HOME --------------------------------------------------------------------------------- 0 0 0 /u01/app/oracle/product/12.2.0.1/db_1 --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- Detailed report (html) - /u01/app/oracle/orachk/orachk_ram_test_102318_001148/orachk_ram_test_102318_001148.html UPLOAD(if required) - /u01/app/oracle/orachk/orachk_ram_test_102318_001148.zip [root@ram orachk]#
Database Server Details
After i run the ORAchk utility i got few output from my server which i added below.
- ram (Server Name)
For detailed report click here
Top Consumers :
ORAchk Assessment Report:
For detailed report click here
Post Upgrade:
After upgrading, run the post-upgrade checks:
[root@ram orachk]# ./orachk -u -o post
Running On-Demand With or Without the Daemon
When running on-demand, if the daemon is running, then the daemon answers all prompts where possible including the passwords.
To run health checks on-demand if the daemon is running, then use:
[root@ram orachk]# ./orachk
To avoid connecting to the daemon process, meaning the tool to interactively prompt you as required, use the -nodaemon option:
[root@ram orachk]# ./orachk -nodaemon
Daemon mode is supported only on the Linux and Solaris operating systems.
Sending Results by Email
Optionally email the HTML report to one or more recipients using the -sendemail option.
[oracle@ram orachk]$ ./orachk -sendemail "NOTIFICATION_EMAIL=support@gmail.com"
Few Commands:
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba FBGroup:https://www.facebook.com/groups/894402327369506/ FBPage: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba