Database Solutions

From Exadata oracle have replaced infini Switch with RoCE Switch. In this blog , We will show the steps to patch Exadata RoCE switch.  Pre-Check: Collect below information from the RoCE switches: show running-config show lldp neighbor dir bootflash: show interface status show version Patch RoCE Switch: Patch should be uncompressed by a non root user (dbmadmin in this example) and in a directory owned by the same non root user.  For this example /u01/install is used.Patchmanager should be executed by a non root user on pre  20.1.0.0.0 .  dbmadmin is used for this example.  1) Set up Directories owned by user "dbmadmin" and copy/unzip patch file. [root@node_name u01]#cd /u01 [root@node_name u01]# mkdir install [root@node_name u01]# chown dbmadmin install [root@node_name u01]# ls -l total 0 drwxr----- 2 root     root 6 Sep 24 11:42 crashfiles drwxr-xr-x 2 dbmadmin root 6 Jan 30 13:19 install [root@node_name u01]# cd install [root@node_name insta...

  As DMA its regular activity to patch exadata machine. There are two ways of patching Exadata box Rolling and Non-Rolling. In this blog, we will start with part 3 of the Exadata (Half Rack) Image Upgrade (Non-Rolling). Precheck: Exadata Image Upgrade  Oracle recommends to clear all the stateful alrts from all the cell nodes [root@abcxyzadm01 ~]# dcli -g  cell_group -l root "cellcli -e list alerthistory attributes name,beginTime,alertShortName,alertDescription,severity where alerttype=stateful and severity=critical" Based on Exachk report check if Oracle finds any hardware failure which much be fixed before you proceed for the patching. Compute Node/ DB Note / YUM Patch Plan (Non-Rolling)  Check image version dcli -l root -g dbs_group imageinfo -versio dcli -l root -g dbs_group imageinfo -status dcli -l root -g dbs_group uname -r Verify dbnodeupdate script version  Download latest version of dbnodeupdate script from patch 21634633 Download dbserver.patch.zi...

  As DMA its regular activity to patch exadata machine. There are two ways of patching Exadata box Rolling and Non-Rolling. In this blog, we will start with part 3 of the Exadata (Half Rack) Image Upgrade (Non-Rolling). Precheck: Exadata Image Upgrade  Oracle recommends to clear all the stateful alrts from all the cell nodes [root@abcxyzadm01 ~]# dcli -g  cell_group -l root "cellcli -e list alerthistory attributes name,beginTime,alertShortName,alertDescription,severity where alerttype=stateful and severity=critical" Based on Exachk report check if Oracle finds any hardware failure which much be fixed before you proceed for the patching. Cell Node/ Cell Server Patch Plan (Non-Rolling)  update using the patchmgr utility.Unzip the update. It will extract into the patch_XXXXXX directory. Stop agents if running (Non-Rolling) Check agents and restart if not running  ps -ef | grep agent | grep java | sed 's/\s\+/ /g' | cut -d " " -f 1,8 | sed 's/\/jdk.*//' ...

Oracle RAC - Apply patch with Standby in Configuration  DBAs have to apply patches quarterly as the PSU patch have been released. In order to make task easy, We have come up with steps to Patch RAC environment with standby in configuration.  Below are the steps and details:   Environment Details: Nodes to be Patched: Primary Node 1 - PRIMARYRAC01 Node 2 - PRIMARYRAC02 DB to be patched: test,abd Standby Node 3 - STDBYRAC01 Node 4 - STDBYRAC01 DB to be patched: ntulearndr,sbblearn Pre-Patch Installation Instruction: Validation of Oracle Inventory. a) Switch to Grid User # su – grid $ /u01/app/12.1.0.2/grid/OPatch/optach lsinventory >  /backup/patch/backup/Cluster_invn_bck.log b) Switch to Oracle User # su – oracle $ /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch/optach lsinventory > /backup/patch/backup/Cluster_invn_bck.log Collect each Database information using below command (Using sysdba): a) Create pfile for database SQL> create pfile='/b...