Thứ Năm, 9 tháng 1, 2020

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

ĐỌC NHIỀU

Trần Văn Bình - Oracle Database Master