how to run SAR report

how to run zdlra_sar.sql SAR report as oracle user cd /home/oracle/systemact OR cd /raacfs/raadmin/tools/sql/zdlra_sar.sql sqlplus rasys welcome1 spool zdlra_sar.log @zdlra_sar.sql

how to check PGA size in use

select name, ROUND(value/1024/1024) "SIZE MB" from v$pgastat where NAME in('aggregate PGA target parameter','total PGA inuse','total PGA allocated','maximum PGA allocated')

upgrade opatch

./opatch version OPatch Version: 12.2.0.1.30 OPatch succeeded. For Grid: AS root user cd /u01/app/19.0.0.0/grid/OPatch ./opatch version OPatch Version: 12.2.0.1.30 mv OPatch OPatch_bck_Jun07202022 cd /u01/app/oracle/patches cp /u01/app/oracle/patches/p6880880_210000_Linux-x86-64.zip /u01/app/19.0.0.0/grid/. cd /u01/app/19.0.0.0/grid/ unzip p6880880_210000_Linux-x86-64.zip chown -R odsora1:oinstall OPatch cd /u01/app/19.0.0.0/grid/OPatch ./opatch version For oracle: As odsora1: cd /u01/app/oracle/product/19.0.0.0/dbhome_1/ mv OPatch OPatch_bck_Jun07202022 cp /u01/app/oracle/patches/p6880880_210000_Linux-x86-64.zip /u01/app/oracle/product/19.0.0.0/dbhome_1/. unzip p6880880_210000_Linux-x86-64.zip ## IF NEEDED## chown -R odsora1:oinstall p6880880_210000_Linux-x86-64.zip unzip p6880880_210000_Linux-x86-64.zip cd /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch ./opatch version ./opatch lsinventory | grep 33872045 33872045 DOC ID 33872045.8

how to connect to ilom without ssh

how to connect to ilom without ssh #ipmitool sunoem cli show / Targets: HOST System SP Properties: Commands: cd show -> show /SP/network Targets: interconnect ipv6 test Properties: commitpending = (Cannot show property) dhcp_clientid = none dhcp_server_ip = none ipaddress = 10.83.169.78 ipdiscovery = static ipgateway = 10.83.168.1 ipnetmask = 255.255.252.0 link_state = up macaddress = 00:10:E0:EA:C3:D4 managementport = MGMT outofbandmacaddress = 00:10:E0:EA:C3:D4 pendingipaddress = 10.83.169.78 pendingipdiscovery = static pendingipgateway = 10.83.168.1 pendingipnetmask = 255.255.252.0 pendingmanagementport = MGMT pendingvlan_id = (none) sidebandmacaddress = 00:10:E0:EA:C3:D5 state = ipv4-only vlan_id = (none) Commands: cd set show ================================================= -> set ping=10.83.168.1 Ping of 10.83.168.1 succeeded ======================================

how to get to ilom of ibswitch

to get to the ilom of a switch. spsh

how to unzip if unzip command does not work

bzip2 -d filename

How to supress ASR's for specific ORA-0600 alerts:

How to supress ASR's for specific ORA-0600 alerts: Please revoke below changes provided by EM team: ------------- 1. Stop the agent that is monitoring the database $/AGENT_INST/bin/emctl stop agent 2. Modify the entry in the /sysman/config/emd.properties file from: adrAlertLogErrorCodeExcludeRegex=.*600.* This should filter all the ORA-600 errors. If the requirement is to filter only the "(ORA 700 [kskvmstatact: excessive swapping observed])" error, you can set: adrAlertLogErrorCodeExcludeRegex=.*kskvmstatact.* 3. Save the file. 4. Start the agent $/AGENT_INST/bin/emctl start agent Thus you can use above example to file the particular stack you want to filter. Note: replace .*kskvmstatact.* with the stack