Apply Database PSU 11.2.0.3.2

Download the latest OPatch version Version: 11.2.0.3.0

opatch versionOPatch Version: 11.2.0.3.0

Create OCM configuration file $ <ORACLE_HOME>/OPatch/ocm/bin/emocmrsp

sudo opatch auto /apps/oracle/software/11.2.0.3/psu -oh /apps/oracle/product/11.2.0.3/RACDB -ocmrf /tmp/ocm.rsp

Note:  /apps/oracle/software/11.2.0.3/psu is the PSU software location.

[sudo] password for oracle:
Executing /usr/bin/perl /apps/oracle/product/11.2.0.3/RACDB/OPatch/crs/patch112.pl -patchdir /apps/oracle/software/11.2.0.3 -patchn psu -oh /apps/oracle/product/11.2.0.3/RACDB -ocmrf /tmp/ocm.rsp -paramfile /apps/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /apps/oracle/product/11.2.0.3/RACDB/OPatch/crs/../../cfgtoollogs/opatchauto2012-07-15_14-26-50.log
Detected Oracle Clusterware install
Using configuration parameter file: /apps/11.2.0/grid/crs/install/crsconfig_params
patch /apps/oracle/software/11.2.0.3/psu/13696251/custom/server/13696251  apply successful for home  /apps/oracle/product/11.2.0.3/RACDB
patch /apps/oracle/software/11.2.0.3/psu/13696216  apply successful for home  /apps/oracle/product/11.2.0.3/RACDB

Exadata X2-2 Summary


Quarter        Half       Full
Servers 2 4 8
Cores 24 48 96
Storage Servers 3 7 14
Number of disks 36 84 168
SAS (Small and Fast)  TB 21 50 100
SATA (Big and slower) TB 72 168 336
Infiniband 2 3 3
IOPS Flash  375000 750000 1500000

How to shutdown Exadata Storage Server

It’s necessary to shutdown the cell  when performaing maintenance on the Exadata Storage Server.  It’s also important to verify that taking Exadata Storage server offline will not impact Oracle ASM disk group and database availability depends on the ASM redundancy and mirror copies of data.  Below are the high level of how to shutdown Exadata Storage Server

CellCLI> list griddisk attributes name where asmdeactivationoutcome !='Yes'
If any grid disks are returned (like below), then it’s not safe to take the storage offline
                data_CD_1_ancell05
                data_CD_2_ancell05
                data_CD_3_ancell05
                data_CD_4_ancell05
                data_CD_5_ancell05
                data_CD_6_ancell05
                data_FD_00_ancell05
                data_FD_01_ancell05
                data_FD_02_ancell05A
                data_FD_03_ancell05
                reco_CD_7_ancell05
                reco_CD_8_ancell05
                reco_CD_9_ancell05
                reco_CD_disk10_ancell05
                reco_CD_disk11_ancell05
                reco_CD_disk12_ancell05


Inactivate the grid disks before bring Exadata Storage server offline
CellCLI> alter griddisk all inactive
GridDisk data_CD_1_ancell05 successfully altered
GridDisk data_CD_2_ancell05 successfully altered
GridDisk data_CD_3_ancell05 successfully altered
GridDisk data_CD_4_ancell05 successfully altered
….
….

Cellcli > list griddisk where status != ‘inactive’
If all grid disks are inactive, you can power down the exadata storage server

To power off Exadata Storage Servers
shutdown -h -y now