Oracle Database Appliance  takes advantage of Oracle Database in an easy-to-deploy and manage system that supports high-availability database and huge applications workloads.

Yes its great working hardware + software combination but there are always a milestones.

 This is why I am starting the ODA survival kit as open for updates HOW TO.

1. Start point of managing your ODA box is to know its serial number. Believe me you will need this command …Don’t ask why

To get ODA serial number:

 

as root:

 

dmidecode -t 1 | grep "Serial Number"

 

2. Patching the ODA Software :

 

Step 1 – Download:

 

1. From an external client machine, log on to My Oracle Support and access note 888888.1 at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=888888.1
2. Under Patch Search, select Oracle Database Appliance from the Product list.
3. Select the patch release number from the Select a Release list.
4. Click Search.
5. Select the patch or patches and click Download.

 

 Step 2 - Copy and Unpack the Patch Bundle:

 

1. Copy the patch files (p21645601_121250_Linux-x86-64_1of2.zip and p21645601_ 121250_Linux-x86-64_2of2.zip) into the /tmp directory on each node.
2. Run the following

oakcli unpack -package commands:

 

AS ROOT!

On Node 0:

 

 # oakcli unpack -package /tmp/p21645601_121250_Linux-x86-64_1of2.zip

 # oakcli unpack -package /tmp/p21645601_121250_Linux-x86-64_2of2.zip

 

 

On Node 1:

 

# oakcli unpack -package /tmp/p21645601_121250_Linux-x86-64_1of2.zip

# oakcli unpack -package /tmp/p21645601_121250_Linux-x86-64_2of2.zip

 

 

Step 3 – Validate the patch to identify any possible problems:

 

AS ROOT!

<code>oakcli validate -c ospatch -ver 12.1.2.5.0

 

Step 4: Patch the Infrastructure (INFRA)

 

To patch the Infrastructure, start the patching process by running the following command ONLY on Node 0.

The command will patch both nodes at the same time:

 

         AS ROOT!

      #/opt/oracle/oak/bin/oakcli update -patch 12.1.2.5.0 –infra

 

 

Step 5: Patch the Grid Infrastructure

 

The Grid Infrastructure patching process is a rolling upgrade that automatically patches Node 1 after patching Node 0.

        AS ROOT! 

         #/opt/oracle/oak/bin/oakcli update -patch 12.1.2.5.0 --gi

      

Step 5: Patch the Database:

 

     AS ROOT!

<strong>   </strong>#oakcli show databases

     Run the oakcli update command, on Node 0 only:

       #oakcli update -patch 12.1.2.5.0 –database

 

     Verify the patch :

      #oakcli show databases

 

TO BE CONTINIUED .. PART 2 Managing ODA storage components.