orachk (Oracle Check)

orachk utility in Oracle

./orachk -v

./orachk -help

./orachk -h

./orachk -a -- all checks

./orachk -b -- only best practices checks

./orachk -c hacheck

./orachk -m -- exclude check for MAA

./orachk -p -- patch checks

./orachk -f -- works offline

./orachk -u -- upgrade

./orachk -o pre or post -- pre & post check, during upgrade

./orachk -u -o pre -f

./orachk -u -o pre -f -verbose

./orachk –u –o post

./orachk -a -o v

./orachk –s -- health checks including checks which require root access

./orachk –S -- health checks exclude checks which require root access

./orachk -d [start|stop|status]

./orachk -d start

./orachk -d stop

./orachk –d stop_client

./orachk –d status

./orachk –d info

./orachk –d nextautorun

./orachk –d ID –d nextautorun 

./orachk –daemon

./orachk –nodaemon

./orachk –initsetup

./orachk –initpresetup

./orachk –initcheck

./orachk –initrmsetup

./orachk -nopass

./orachk -noscore

./orachk -clusternodes node2,node5

./orachk -dbnames testdb2

./orachk -cells cellnames

./orachk -localonly

./orachk -local

./orachk -dball

./orachk –dbnone

./orachk -diff [-outfile] -- diff of two orachk reports

./orachk -diff orachk_host01_devdb_051716_223117 orachk_host01_devdb_052116_012043

./orachk -exadiff [-outfile] -- diff of two Exalogic reports

./orachk -merge zipfile1,zipfile2...

./orachk -debug

./orachk –set "option_1=option_1_value;option_2=option_2_value;option_n=option_n_value" 

./orachk –set "COLLECTON_RETENTION=60" 

./orachk –set "PASSWORD_CHECK_INTERVAL=1"

./orachk -set "AUTORUN_SCHEDULE=2 1 * *; NOTIFICATION_EMAIL=email_address"

./orachk -unset "AUTORUN_SCHEDULE"

./orachk –id id –set "option=value" 

./orachk –id dba –set "NOTIFICATION_EMAIL=dba@acompany.com;\ AUTORUN_SCHEDULE=4,12,20 * * *;AUTORUN_FLAGS=-profile dba –tag dba;\ COLLECTION_RETENTION=30"

./orachk -get

./orachk –get NOTIFICATION_EMAIL 

./orachk –get all

./orachk –id dba –get NOTIFICATION_EMAIL

./orachk -profile [asm|dba|clusterware|ebs|goldengate|hardware|storage|maa|em|emagent|emoms|compute_node|control_VM|el_extensive|el_lite|el_rackcompare|obiee|switch|sysadmin|timesten|virtual_infra|zfs]

./orachk –profile clusterware

./orachk –profile dba,clusterware 

./orachk –profile user_defined_checks 

./orachk -excludeprofile

./orachk –excludeprofile dba,clusterware,ebs 

./orachk –check 0829D67E8B1549AFE05312C0E50AD04F,CB95A1BF5B1160ACE0431EC0E50A12EE

./orachk –excludecheck 0829D67E8B1549AFE05312C0E50AD04F,CB95A1BF5B1160ACE0431EC0E50A12EE

./orachk -vmguest

./orachk -hybrid [-phy]

./orachk -ibswitches switchnames

./orachk -zfsnodes

./orachk –download 

./orachk –noupgrade

./orachk –output output_dir

./orachk –tag tag_name

./orachk -fileattr start -includedir "/root/home,/etc" 

./orachk -fileattr check -includedir "/root/home,/etc" 

./orachk -fileattr start -includedir "/root/home,/etc" -excludediscovery 

./orachk -fileattr check -fileattronly 

./orachk -fileattr check -baseline "/tmp/Snapshot" 

./orachk -fileattr start -tag "BeforeXYZChange" Generated snapshot directory- orachk_myserver65_20160329_052056_BeforeXYZChange

./orachk -dbserial

./orachk -dbparallel [n]

./orachk -dbparallelmax

./orachk -setdbupload all|variable_names

./orachk -setdbupload RAT_PATCH_UPLOAD_TABLE,RAT_PATCH_UPLOAD_TABLE

./orachk -unsetdbupload all|variable_names

./orachk -getdbupload

./orachk -checkdbupload

./orachk -checkfaileduploads

./orachk -uploadfailed all|list of failed collections

./orachk -uploadfailed "/home/oracle/orachk_racnode1_052016_132011.zip,/home/oracle/orachk_racnode1_052016_131732.zip" 

./orachk -syslog

export RAT_TMPDIR=/tmp

export RAT_OS=

export RAT_INV_LOC=oraInventory directory

export RAT_CRS_HOME=CRS_HOME directory

export RAT_ORACLE_HOME=ORACLE_HOME directory

export RAT_DB=11.2.0.4.0 

export RAT_ASM_HOME=ASM_HOME directory

export RAT_DBNAMES="ORCL ORADB" 

export RAT_SCOPY=path to scp

export RAT_SSHELL=path to ssh

export RAT_OUTPUT=output_dir

export RAT_UPLOAD_CONNECT_STRING=

export RAT_UPLOAD_USER=ORACHKCM

export RAT_UPLOAD_PASSWORD=

export RAT_UPLOAD_TABLE=

export RAT_ZIP_UPLOAD_TABLE=

export RAT_PATCH_UPLOAD_TABLE=

export RAT_UPLOAD_ORACLE_HOME=

export RAT_WALLET_LOC=

export RAT_COPY_EM_XML_FILES=1

export RAT_EXPECT_DEBUG=-d

export RAT_EXPECT_STRACE_DEBUG=strace

export RAT_TIMEOUT=

export RAT_ROOT_TIMEOUT=

export RAT_PASSWORDCHECK_TIMEOUT=

@ Trần Văn Bình - Founder of Oracle DBA AZ

#BossData #OraAz #OracleDBAAz #OracleTutorial #Quản_trị_cơ_sở_dữ_liệu_Oracle #OracleDBA #OracleDatabaseAdministration