Differences

This shows you the differences between two versions of the page.

--- oracle_data_appliance_oda [2018/12/06 21:05] – created 91.177.234.129
+++ oracle_data_appliance_oda [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== 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.\\
+The 2 nodes talk to each other and to storage across an internal 40Gb/s InfiniBand network.\\
+It can be virtualised or bare-metal. You can setup single instance databases, RAC-One (active-passive) or RAC (active-active) databases.\\
+A whole new set of commands is used to interact with ODA - oakcli.\\
+  *  [[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1417713.2|Oracle Database Appliance Information Centre]]
-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 />
+==== Patching Oracle Database Appliance (ODA) ====
-The 2 nodes talk to each other and to storage across an internal 40Gb/s InfiniBand network.<br />
+  *  [[Patching Oracle Database Appliance (ODA)]]
-It can be virtualised or bare-metal. You can setup single instance databases, RAC-One (active-passive) or RAC (active-active) databases.<br />
+==== Useful commands ====
-A whole new set of commands is used to interact with ODA - oakcli.<br />
+  *  [[http://n23haveyoursay.blogspot.be/2015/12/oda-basic-commands-list.html|oda basic commands list (and concise patch instructions)]]
-  * [[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1417713.2|Oracle Database Appliance Information Centre]]
+=== Is your ODA installation bare-metal or does it have a virtualised image installed? ===
-<br />
-=====Patching Oracle Database Appliance (ODA)=====
-  * [[Patching Oracle Database Appliance (ODA)]]
-=====Useful commands=====
-  * [[http://n23haveyoursay.blogspot.be/2015/12/oda-basic-commands-list.html|oda basic commands list (and concise patch instructions)]]
-====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.
-<code>0@@</code>
+<code>
+oakcli show env_hw
+</code>
 gives...
-<code>1@@</code>
+<code>
+VM-ODA_BASE ODA X4-2
+</code>
-====Show server status====
+=== Show server status ===
 Shows server details such as power consumption, temperature and ILOM IP address
-<code>2@@</code>
+<code>
-====How many processors are currently allocated to ODA?====
+oakcli show server
+</code>
+=== How many processors are currently allocated to ODA? ===
 Also shows total number of available CPUs
-<code>3@@</code>
+<code>
+oakcli show cpupool -node 0
+</code>
-====Show installed ORACLE_HOMES====
+=== Show installed ORACLE_HOMES ===
-<code>4@@</code>
+<code>
-====Show installed databases====
+oakcli show dbhomes
-<code>5@@</code>
+</code>
-<code>6@@</code>
+=== Show installed databases ===
+<code>
+oakcli show databases
+</code>
+<code>
+Name     Type       Storage   HomeName             HomeLocation                                       Version
+-----    ------     --------  --------------       ----------------                                   ----------
+ANT5O    RAC                  OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+PRJESS2  RAC        ASM       OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+DEVOTASO SINGLE               OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+CHA5O    RAC                  OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+TSTEV3ST SINGLE     ASM       OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+OEMREP   RAC        ASM       OraDb12102_home1     /u01/app/oracle/product/12.1.0.2/dbhome_1          12.1.0.2.160419(22291127,21948344)
+</code>
-====Deploy virtualised platform on ODA====
+=== Deploy virtualised platform on ODA ===
 This will probably be a one-off per system!
-<code>7@@</code>
+<code>
-====See history of installed patches====
+oakcli deploy
-<code>8@@</code>
+</code>
-====Clean out old patches====
+=== See history of installed patches ===
-Reference: Metalink [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1681062.1|Note: 1681062.1]]<br />
+<code>
-Does not affect the inventory listing.<br />
+oakcli inventory -q
-<code>9@@</code>
+</code>
+=== Clean out old patches ===
+Reference: Metalink [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1681062.1|Note: 1681062.1]]\\
+Does not affect the inventory listing.\\
+<code>
+cd /opt/oracle/oak/pkgrepos
+du -hsx .
+G  .
+</code>
 e.g. This cleans out old logs and patch files up to version 2.5.0.0.0 (probably in /opt/oracle/oak/pkgrepos)
-<code>10@@</code>
+<code>
+oakcli manage cleanrepo --ver 2.5.0.0.0
+</code>
-====ODA (Oracle Database Appliance): Cleanup trace and log files Using purgeODALog Tool (Doc ID 2081655.1)====
+=== 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 [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=2081655.1|this note]]<br />
+Use this tool to clean out general ODA log files. Available in [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=2081655.1|this note]]\\
 Specify a general cleanup or individual components
-<code>11@@</code>
+<code>
+Usage:
+purgeODALog [[ -days <days> ]]
+            [[ -orcl <days> ]] | [[ -tfa <days> ]] |
+            [[ -osw <days> ]] | [[ -oak <days> ]] |
+            [[ -extra '<folder>':<days> | [[, '<folder>':<days>]] ]]
+            [[ -lsnr ]]
+            [[ -dryrun ]]
-====Deploy ODA_BASE on ODA====
+purgeODALog OPTIONS
-<code>12@@</code>
+  -days <days> Purge components logs & traces older then # days
+  -orcl <days> Purge only GI/RDBMS logs & traces (Default 30 days)
+  -tfa <days> Purge only TFA repository older then # days (Default 30 days)
+  -osw <days> Purge only OSW archives older then # days (Default 30 days)
+  -oak <days> Purge only OAK logs and trace older then # days (Default 30 days)
+  -extra '<folder>':<days> Purge only files in user specified folders (Default 30 days)
+  -lsnr It will force the cleanup of listeners log independently by the age
+  -dryrun It will show the purge commands w/o execute them
+  -h Display this help and exit
-====Create a database====
+Example:
-<code>13@@</code>
+  purgeODALog
-====Create a new ORACLE_HOME====
+  purgeODALog -days 20
+  purgeODALog -orcl 50
+  purgeODALog -orcl 50 -lsnr
+  purgeODALog -tfa 50
+  purgeODALog -osw 20 -oak 10
+  purgeODALog -orcl 20 -osw 20 -oak 10
+  purgeODALog -orcl 20 -osw 20 -oak 10 -extra /tmp:10,/var/log:20
+</code>
+=== Deploy ODA_BASE on ODA ===
+<code>
+oakcli deploy oda_base
+</code>
+=== Create a database ===
+<code>
+oakcli create database -d <database name>
+e.g.
+oakcli create database -d prod
+</code>
+=== Create a new ORACLE_HOME ===
 For upgrades etc., you can create a new ORACLE_HOME like this
-<code>14@@</code>
+<code>
+create dbhome -version <RDBMS version>
+e.g.
+create dbhome -version 12.1.0.2
+</code>
-====Upgrade 1 database to new version====
+=== Upgrade 1 database to new version ===
-<code>15@@</code>
+<code>
-====Upgrade all databases from a given ORACLE_HOME to new version====
+oakcli upgrade database -db <dbname> -to <destination home name>
-<code>16@@</code>
+e.g.
-====Show the available virtual machines====
+oakcli upgrade database -db prod -to 11r2_dbhome1
-<code>17@@</code>
+</code>
-====Configure a virtual machine to start on a particular cluster node====
+=== Upgrade all databases from a given ORACLE_HOME to new version ===
-<code>18@@</code>
+<code>
-====Start a virtual machine====
+oakcli upgrade database -from <source home name> -to <destination home name>
-<code>19@@</code>
+e.g.
+oakcli upgrade database -from 11r1_dbhome1 -to 11r2_dbhome1
+</code>
+=== Show the available virtual machines ===
+<code>
+oakcli show vm
+</code>
+=== Configure a virtual machine to start on a particular cluster node ===
+<code>
+oakcli configure vm sdtcsynodadb3a -failover true -prefnode 0
+</code>
+=== Start a virtual machine ===
+<code>
+oakcli start vm sdtcsynodadb3a
+</code>
-=====Useful queries=====
+==== Useful queries ====
 As seen on [[https://www.pythian.com/blog/oracle-database-12c-patching-dbms_qopatch-opatch_xml_inv-and-datapatch/|Pythian]]
-<code>20@@</code>
+<code>
-<code>21@@</code>
-<code>22@@</code>
+prompt ------------------------------------------
-=====Package up useful diagnostic data when opening an SR at Oracle=====
+prompt Patches applied to both the $OH and the DB
-<code>23@@</code>
+prompt ------------------------------------------
-=====Health check a RAC system on ODA=====
+with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
-  * [[https://support.oracle.com/epmos/faces/DocContentDisplay?id=1268927.2|Metalink note 1268927.2]]
+select x.patch_id
-<code>24@@</code>
+,      x.patch_uid
+,      x.rollbackable
+,      s.status
+,      x.description
+from   a
+,      xmltable('InventoryInstance/patches/*'
+          passing a.patch_output
+          columns
+             patch_id number path 'patchID',
+             patch_uid number path 'uniquePatchID',
+             description varchar2(80) path 'patchDescription',
+             rollbackable varchar2(8) path 'rollbackable'
+       ) x
+,      dba_registry_sqlpatch s
+where  x.patch_id = s.patch_id
+and    x.patch_uid = s.patch_uid
+--       and s.bundle_series = 'PSU'
+/
+</code>
+<code>
+prompt --------------------------------------------------------
+prompt Patches installed into the $OH but not applied to the DB
+prompt --------------------------------------------------------
+with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
+select x.patch_id
+,      x.patch_uid
+,      x.description
+from   a
+,      xmltable('InventoryInstance/patches/*'
+         passing a.patch_output
+         columns
+           patch_id number path 'patchID',
+           patch_uid number path 'uniquePatchID',
+           description varchar2(80) path 'patchDescription'
+       ) x
+minus
+select s.patch_id
+,      s.patch_uid
+,      s.description
+from   dba_registry_sqlpatch s
+/
+</code>
+<code>
+prompt --------------------------------------------------------
+prompt Patches applied to the DB but not installed into the $OH
+prompt --------------------------------------------------------
+with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
+select s.patch_id
+,      s.patch_uid
+,      s.description
+from   dba_registry_sqlpatch s
+minus
+select x.patch_id
+,      x.patch_uid
+,      x.description
+from   a
+,      xmltable('InventoryInstance/patches/*'
+          passing a.patch_output
+          columns
+             patch_id number path 'patchID',
+             patch_uid number path 'uniquePatchID',
+             description varchar2(80) path 'patchDescription'
+       ) x
+/
+</code>
+==== Package up useful diagnostic data when opening an SR at Oracle ====
+<code>
+oakcli manage diagcollect
+</code>
+==== Health check a RAC system on ODA ====
+  *  [[https://support.oracle.com/epmos/faces/DocContentDisplay?id=1268927.2|Metalink note 1268927.2]]
+<code>
+oakcli orachk -h
+</code>