ODA (Oracle Database Appliance): Best Practice Checks Before an Infrastructure or Grid Home Update

Asset ID:	1-79-2090643.1
Update Date:	2015-12-28
Keywords:

Solution Type Predictive Self-Healing Sure

Solution 2090643.1 : ODA (Oracle Database Appliance): Best Practice Checks Before an Infrastructure or Grid Home Update

Applies to:

Oracle Database Appliance Software
Oracle Database Appliance
Information in this document applies to any platform.

Purpose

Provide the best practice steps/checks before an Oracle Database Appliance (ODA) infra/GI patching phase.

Scope

Basic ODA (Oracle Database Appliance) knowledge is required.

Details

Best Practice steps before an infra/gi update - The steps

1. Run oracheck to verify major not compliant setup

oakcli orachk

2. Check for sufficient file system free space under /u01, /opt, / (root) and /tmp

3. Check for disk status, all them must be in "good" status

oakcli show disk
oakcli show diskgroup data
oakcli show diskgroup reco
oakcli show diskgroup redo

4. Check what will be updated

oakcli update -patch <new version> --verify

5. Check disk from ASM point of view, login as user grid on node0, you could issue the following command:

export ORACLE_SID=+ASM1
asmcmd lsdsk -p

The correct working disk status should be CACHED; MEMBER; ONLINE; NORMAL

Check for negative Usable_file_MB, issuing the command:

asmcmd lsdg

if Usable_file_MB is negative check for the reason before to proceed

6. Check that no ASM rebalance of disk are running

grid> asmcmd lsdg (check if value for REBAL column is Y)

or executing the following query:

SQL> select GROUP_NUMBER, OPERATION, STATE, ACTUAL, SOFAR, EST_MINUTES from gv$asm_operation;

7. Review MOS note 888888.1 for known issues and workarounds for the release you are upgrading to.

References

<NOTE:888888.1> - Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues

Attachments

This solution has no attachment