Showing posts with label Oracle Clusterware 12c. Show all posts
Showing posts with label Oracle Clusterware 12c. Show all posts

November 26, 2018

Oracle oclumon utility/commands

oclumon (Oracle Cluster Health Monitor) in Oracle 11g / 12c RAC

oclumon -help
oclumon version

oclumon debug version 
oclumon debug [log daemon module:log_level] [version]
oclumon debug [log all/osysmond/ologgerd/client debuglevel] [0-3]
oclumon debug log osysmond CRFMOND:3
oclumon debug log ologgerd CRFLOGD:2
oclumon debug log client allcomp:1
oclumon debug log all allcomp:0

oclumon dumpnodeview [[-allnodes] | [-n node1 node2 ... noden] [-last "duration"] | [-s "time_stamp" -e "time_stamp"] [-i interval] [-v]] [-h]
oclumon dumpnodeview -n host01
oclumon dumpnodeview -n racnode2 -last "00:15:00"
oclumon dumpnodeview -n node1 node3 node5 -last "12:00:00"
oclumon dumpnodeview -allnodes -last "00:15:00" -i 30
oclumon dumpnodeview -v -allnodes -alert -last "01:00:00"
oclumon dumpnodeview -allnodes -s "2016-11-04 10:05:00" -e "2016-11-04 10:10:00"
oclumon dumpnodeview -allnodes -warning -v -s "2016-11-04 10:05:00" -e "2016-11-04 10:05:10"

oclumon manage -repos {{changeretentiontime time} | {changerepossize memory_size}} | -get {key1 [key2 ...] | alllogger [-details] | mylogger [-details]}
oclumon manage -get master                        # will give master node
oclumon manage -get master path
oclumon manage -get reppath
oclumon manage -get repsize
oclumon manage -get alllogger -details
oclumon manage -get mylogger
oclumon manage -repos changeretentiontime 86400
oclumon manage -repos changerepossize 6000
oclumon manage -repos reploc /nfs/orarac/chm
oclumon manage -db resize 43200

oclumon showtrail -n node1 -nicid eth0 effectivebw errors -c "red" "yellow" "orange" -last "00:15:00"
oclumon showtrail -n node1 -sys usagepc cpuqlen cpunumprocess memfree numrt numofiosps openfds -c "red" "yellow" "orange" -last "00:15:00" 

oclumon showobjects
oclumon showobjects -n racnode6 -time "2017-10-24 15:00:00"


Related Oracle Articles: What's new in Oracle 9i/10g/11g RAC      What's New in Oracle Database 12c Release1


January 8, 2018

Oracle RAC - racgons commands

RACGONS commands in Oracle RAC 12c / 11g

racgons add_config node_name:port [node_name:port] [node_name:port] ...

racgons add_config eg5242:4948

racgons add_config cell1:3333 cell08:4444 cell13:5555

racgons remove_config node_name[:port] [node_name[:port]] [node_name[:port]] ...

racgons remove_config lnx03

racgons remove_config lnx01 lnx04 lnx07:1234

Related Oracle RAC Articles:    cluvfy commands RAC    crsctl commands RAC    crs_stat commands RAC

June 4, 2017

TFA - Trace File Analyzer Collector in Oracle RAC

Trace File Analyzer Collector (tfactl commands) in Oracle 12c / 11g RAC

./tfactl -h

./tfactl diagcollect -h
./tfactl diagcollect
./tfactl diagcollect -crs
./tfactl diagcollect -asm -tag ASM_COLLECTIONS
./tfactl diagcollect -since 1h
./tfactl diagcollect -all -since 4h
./tfactl diagcollect -database hrdb,findb -since 1d
./tfactl diagcollect -crs -os -node node2,node3 -since 8h
./tfactl diagcollect -asm -node node7 -from Aug/12/2015 -to "Aug/14/2015 22:10:00"
./tfactl diagcollect -for Aug/23/2015
./tfactl diagcollect -for "Aug/23/2015 08:00:00"

./tfactl print -h
./tfactl print config
./tfactl print status
./tfactl print hosts
./tfactl print actions
./tfactl print repository

./tfactl analyze
./tfactl analyze -since 4h
./tfactl analyze -comp os -since 1d
./tfactl analyze -comp osw -since 5h
./tfactl analyze -search "ORA-" -since 3d
./tfactl analyze -search "/Starting/c"
./tfactl analyze -comp os -for "Aug/25/2015 08" -search "." 
./tfactl analyze -since 2h -type generic

./tfactl access -h

Related Oracle Articles: 
cluster name of Oracle RAC cluster     Oracle RAC Online Quiz