Posts

How to Downgrade 19C Grid Infrastructure to 12.1.0.2

ENVIRONMENT DETAILS: 2 NODES – ambeth01 and ambeth02 Grid owner – oragrid 19C ORACLE_HOME(current) – > /u01/app/19.0.0.0/grid 12C ORACLE_HOME (old) -> /u01/app/12.1.0.2/grid/bin Check the current grid version:( check on both the nodes) [oragrid@ambeth01 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [oragrid@ambeth01 ~]$ crsctl query crs softwareversion -all Oracle Clusterware version on node [ambeth01] is [19.0.0.0.0] Oracle Clusterware version on node [ambeth02] is [19.0.0.0.0] [oragrid@ambeth01 ~]$ 1. As the first step for downgrade, remove the MGMTDB. Move the MGMTDB database on node1, if its running on node2. [oragrid@ambeth01 ~]$ ps -ef|grep pmon oragrid    952 21344  0 19:38 pts/0    00:00:00 grep --color=auto pmon oragrid   8102     1  0 14:32 ?        00:00:02 asm_pmon_+ASM1 oragrid   8609     1  0 14:33 ?        00:00:02 apx_pmon_+APX1 oracle    9025     1  0 14:33 ?        00:00:03 ora_pmon_depuat1 [oragrid@ambeth01

ASM disk resizing in supercluster

Steps : 1 # login the global DB domain as root user and verfiy the ASM disk size dcli -l root -g /root/cell_group "cellcli -e list griddisk attributes name,size where name like \'DATAC3.*\'" Steps 2: # login the global DB domain as a root user and verify the all griddisk status. dcli -l root -g /root/cell_group 'cellcli -e "list griddisk attributes name,asmmodestatus,asmdeactivationoutcome,status"' Steps 3: # check the physical disk size and free space. cellcli -e "list celldisk where name like 'CD.*' attributes name, size, freespace" # check particular asm diskgroup disk size. cellcli -e "list griddisk where name like 'DATAC3.*' attributes name, size" Steps 4: # resize the ASM LUN's node by node. Please check below attached output values. as root user. # ssh sscceladm01 # cellcli -e alter griddisk DATAC3_CD_00_sscceladm01,DATAC3_CD_01_sscceladm01,DATAC3_CD_02_sscceladm01,DATAC3_CD_03_sscceladm01,DATAC3_CD_04_s

Bare Metal Restore Procedure for Compute Nodes on an Exadata Environment

Remove the Failed Database Server from the Cluster 1. Disable the listener that runs on the failed database server: [oragrid@surviving ~]$ srvctl disable listener -n dm01db01 [oragrid@surviving ~]$ srvctl stop listener -n dm01db01 PRCC-1017 : LISTENER was already stopped on dm01db01 PRCR-1005 : Resource ora.LISTENER.lsnr is already stopped [oragrid@surviving ~]$ 2. Delete the Inactive Instance using DBCA via ( Instance management ) and Oracle Home from the Oracle inventory: [oracle@surviving ~]$ dbca ( vncserver ) [oracle@surviving ~]$ cd $ORACLE_HOME/oui/bin [oracle@surviving bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1 "CLUSTER_NODES=dm01db02" Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB.   Actual 23984 MB    Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /u01/app/oraInventory 'UpdateNodeList' was successful. [ora