This is an old revision of the document!
Table of Contents
Oracle_Data_Appliance_(ODA)
Oracle Database Appliance (ODA) is a rack mounted “all-in-one” box supplied by Oracle. It contains 2 nodes, 2 networks, 2 power supplies and 1 or 2 storage (magnetic disk or SSD) units accessible to both nodes.<br /> The 2 nodes talk to each other and to storage across an internal 40Gb/s InfiniBand network.<br /> It can be virtualised or bare-metal. You can setup single instance databases, RAC-One (active-passive) or RAC (active-active) databases.<br /> A whole new set of commands is used to interact with ODA - oakcli.<br />
<br />
Patching Oracle Database Appliance (ODA)
Useful commands
Is your ODA installation bare-metal or does it have a virtualised image installed?
If virtual, the following command will show 'VM-…' followed by the hardware model used.
0@@
gives…
1@@
Show server status
Shows server details such as power consumption, temperature and ILOM IP address
2@@
How many processors are currently allocated to ODA?
Also shows total number of available CPUs
3@@
Show installed ORACLE_HOMES
4@@
Show installed databases
5@@
6@@
Deploy virtualised platform on ODA
This will probably be a one-off per system!
7@@
See history of installed patches
8@@
Clean out old patches
Reference: Metalink Note: 1681062.1<br /> Does not affect the inventory listing.<br />
9@@
e.g. This cleans out old logs and patch files up to version 2.5.0.0.0 (probably in /opt/oracle/oak/pkgrepos)
10@@
ODA (Oracle Database Appliance): Cleanup trace and log files Using purgeODALog Tool (Doc ID 2081655.1)
Use this tool to clean out general ODA log files. Available in this note<br /> Specify a general cleanup or individual components
11@@
Deploy ODA_BASE on ODA
12@@
Create a database
13@@
Create a new ORACLE_HOME
For upgrades etc., you can create a new ORACLE_HOME like this
14@@
Upgrade 1 database to new version
15@@
Upgrade all databases from a given ORACLE_HOME to new version
16@@
Show the available virtual machines
17@@
Configure a virtual machine to start on a particular cluster node
18@@
Start a virtual machine
19@@
Useful queries
Package up useful diagnostic data when opening an SR at Oracle
23@@