Showing posts with label EXADATA. Show all posts
Showing posts with label EXADATA. Show all posts

Monday, August 23, 2021

QFSDP Patching

Step1: Cell patching in rolling mode 

step2:  Downtime patching for below:

            First have IB Switches patching

            then GI home patch

            then ORACLE homes patching

            then yum upgrade

            then apply datapatch for all databases, if you face issue with automation script of oracle  for CDB databases, so please ran datapatch manually on all databases.

Saturday, August 21, 2021

EXADATA Handy

To check the OS version and details

 dcli -l root -g ~/dbs_group " cat /etc/redhat-release"

dcli -l root -g ~/dbs_group imageinfo | grep -i ' image version'

dcli -l root -g ~/dbs_group "ipmitool sunoem version"

dcli -l root -g ~/dbs_group "/opt/oracle.cellos/CheckHWnFWProfile -c strict"

dcli -l root -g ~/dbs_group "ipmitool sunoem cli 'show faulty'"

dcli -l root -g ~/ibswitch_lst "version |grep -i version"

dcli -l root -g ~/all_group 'for cable in `ls /sys/class/net/ |grep ^eth`; do printf "$cable: "; cat /sys/class/net/$cable/carrier ; done'

dcli -l root -g /root/dbs_group dbmcli -e list alerthistory where endTime=null and alertShortName=Hardware and alertType=stateful and severity=critical

dcli -l root -g ~/all_group "uptime"

dcli -l root -g ~/dbs_group "/u01/app/19.0.0.0/grid/bin/crsctl query crs softwareversion"

dcli -l root -g ~/dbs_group "/u01/app/19.0.0.0/grid/bin/crsctl query crs activeversion -f"

dcli -l root -g ~/dbs_group "/u01/app/19.0.0.0/grid/bin/crsctl query crs releasepatch"

dcli -l root -g ~/dbs_group "/u01/app/19.0.0.0/grid/bin/crsctl query crs releaseversion"

dcli -l oracle -g ~/dbs_group "/u01/app/19.0.0.0/grid/OPatch/opatch lspatches"

dcli -l oracle -g ~/dbs_group "/u01/app/oracle/product/12.1.0.2/DbHome_1/OPatch/opatch lspatches"

dcli -l oracle -g ~/dbs_group "/u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch lspatches"

dcli -l oracle -g ~/dbs_group "/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lspatches"

ssh hostname-ilom  -->then press enter

ls -ltr /proc/meminfo | grep -i huge

sh hugepages.sh --> this is for hugepages suggestion  --> This script will be provided by mosc doc 401749.1 where it is intended to compute the values for huge pages

dbmcl --> list alerthistory



FIG project queries

##### Service add & LOad Baclancing on Add Service ####### srvctl add service -s wcccdmt.farmersinsurance.com -r wcccdmtx1,wcccdmtx2,wcc...