oracle_data_appliance_oda
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| oracle_data_appliance_oda [2018/12/08 12:49] – created 0.0.0.0 | 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 |
| + | 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:// | ||
| - | Oracle Database Appliance (ODA) is a rack mounted " | + | ==== Patching Oracle Database Appliance (ODA) ==== |
| - | The 2 nodes talk to each other and to storage across an internal 40Gb/s InfiniBand network.< | + | * [[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.< | + | ==== Useful commands ==== |
| - | A whole new set of commands is used to interact with ODA - oakcli.< | + | * [[http:// |
| - | * [[https:// | + | === 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:// | + | |
| - | ====Is your ODA installation bare-metal or does it have a virtualised image installed?==== | + | |
| If virtual, the following command will show ' | If virtual, the following command will show ' | ||
| - | < | + | < |
| + | oakcli show env_hw | ||
| + | </ | ||
| gives... | gives... | ||
| - | < | + | < |
| + | VM-ODA_BASE ODA X4-2 | ||
| + | </ | ||
| - | ====Show server status==== | + | === Show server status === |
| Shows server details such as power consumption, | Shows server details such as power consumption, | ||
| - | < | + | < |
| - | ====How many processors are currently allocated to ODA?==== | + | oakcli show server |
| + | </ | ||
| + | === How many processors are currently allocated to ODA? === | ||
| Also shows total number of available CPUs | Also shows total number of available CPUs | ||
| - | < | + | < |
| + | oakcli show cpupool -node 0 | ||
| + | </ | ||
| - | ====Show installed ORACLE_HOMES==== | + | === Show installed ORACLE_HOMES === |
| - | < | + | < |
| - | ====Show installed databases==== | + | oakcli show dbhomes |
| - | < | + | </ |
| - | < | + | === Show installed databases === |
| + | < | ||
| + | oakcli show databases | ||
| + | </ | ||
| + | < | ||
| + | Name | ||
| + | ----- ------ | ||
| + | ANT5O RAC OraDb12102_home1 | ||
| + | PRJESS2 | ||
| + | DEVOTASO SINGLE | ||
| + | CHA5O RAC OraDb12102_home1 | ||
| + | TSTEV3ST SINGLE | ||
| + | OEMREP | ||
| + | </ | ||
| - | ====Deploy virtualised platform on ODA==== | + | === Deploy virtualised platform on ODA === |
| This will probably be a one-off per system! | This will probably be a one-off per system! | ||
| - | < | + | < |
| - | ====See history of installed patches==== | + | oakcli deploy |
| - | < | + | </ |
| - | ====Clean out old patches==== | + | === See history of installed patches === |
| - | Reference: Metalink [[https:// | + | < |
| - | Does not affect the inventory listing.<br /> | + | oakcli inventory -q |
| - | < | + | </ |
| + | === Clean out old patches === | ||
| + | Reference: Metalink [[https:// | ||
| + | Does not affect the inventory listing.\\ | ||
| + | < | ||
| + | cd / | ||
| + | du -hsx . | ||
| + | 16G . | ||
| + | </ | ||
| e.g. This cleans out old logs and patch files up to version 2.5.0.0.0 (probably in / | e.g. This cleans out old logs and patch files up to version 2.5.0.0.0 (probably in / | ||
| - | < | + | < |
| + | oakcli manage cleanrepo --ver 2.5.0.0.0 | ||
| + | </ | ||
| - | ====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:// | + | Use this tool to clean out general ODA log files. Available in [[https:// |
| Specify a general cleanup or individual components | Specify a general cleanup or individual components | ||
| - | < | + | < |
| + | Usage: | ||
| + | purgeODALog [[ -days <days> ]] | ||
| + | [[ -orcl < | ||
| + | [[ -osw < | ||
| + | [[ -extra '< | ||
| + | [[ -lsnr ]] | ||
| + | [[ -dryrun ]] | ||
| - | ====Deploy ODA_BASE on ODA==== | + | purgeODALog OPTIONS |
| - | <code>12@@</code> | + | |
| + | -orcl <days> Purge only GI/RDBMS logs & traces (Default 30 days) | ||
| + | -tfa <days> Purge only TFA repository older then # days (Default 30 days) | ||
| + | -osw < | ||
| + | -oak < | ||
| + | -extra '< | ||
| + | -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: |
| - | < | + | 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 / | ||
| + | </ | ||
| + | |||
| + | === Deploy ODA_BASE on ODA === | ||
| + | < | ||
| + | oakcli deploy oda_base | ||
| + | </ | ||
| + | |||
| + | === Create a database === | ||
| + | < | ||
| + | oakcli create database -d < | ||
| + | e.g. | ||
| + | oakcli create database -d prod | ||
| + | </ | ||
| + | === Create a new ORACLE_HOME === | ||
| For upgrades etc., you can create a new ORACLE_HOME like this | For upgrades etc., you can create a new ORACLE_HOME like this | ||
| - | < | + | < |
| + | create dbhome -version <RDBMS version> | ||
| + | e.g. | ||
| + | create dbhome -version 12.1.0.2 | ||
| + | </ | ||
| - | ====Upgrade 1 database to new version==== | + | === Upgrade 1 database to new version === |
| - | < | + | < |
| - | ====Upgrade all databases from a given ORACLE_HOME to new version==== | + | oakcli upgrade database -db < |
| - | < | + | e.g. |
| - | ====Show the available virtual machines==== | + | oakcli upgrade database -db prod -to 11r2_dbhome1 |
| - | < | + | </ |
| - | ====Configure a virtual machine to start on a particular cluster node==== | + | === Upgrade all databases from a given ORACLE_HOME to new version === |
| - | < | + | < |
| - | ====Start a virtual machine==== | + | oakcli upgrade database -from <source home name> -to < |
| - | < | + | e.g. |
| + | oakcli upgrade database -from 11r1_dbhome1 -to 11r2_dbhome1 | ||
| + | </ | ||
| + | === Show the available virtual machines === | ||
| + | < | ||
| + | oakcli show vm | ||
| + | </ | ||
| + | === Configure a virtual machine to start on a particular cluster node === | ||
| + | < | ||
| + | oakcli configure vm sdtcsynodadb3a -failover true -prefnode 0 | ||
| + | </ | ||
| + | === Start a virtual machine === | ||
| + | < | ||
| + | oakcli start vm sdtcsynodadb3a | ||
| + | </ | ||
| - | =====Useful queries===== | + | ==== Useful queries ==== |
| As seen on [[https:// | As seen on [[https:// | ||
| - | < | + | < |
| - | < | + | |
| - | < | + | prompt ------------------------------------------ |
| - | =====Package up useful diagnostic data when opening an SR at Oracle===== | + | prompt Patches applied to both the $OH and the DB |
| - | < | + | prompt ------------------------------------------ |
| - | =====Health check a RAC system on ODA===== | + | with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual) |
| - | * [[https:// | + | select x.patch_id |
| - | < | + | , x.patch_uid |
| + | , x.rollbackable | ||
| + | , s.status | ||
| + | , x.description | ||
| + | from a | ||
| + | , xmltable(' | ||
| + | passing a.patch_output | ||
| + | columns | ||
| + | | ||
| + | | ||
| + | | ||
| + | | ||
| + | ) x | ||
| + | , dba_registry_sqlpatch s | ||
| + | where x.patch_id = s.patch_id | ||
| + | and x.patch_uid = s.patch_uid | ||
| + | -- and s.bundle_series = ' | ||
| + | / | ||
| + | |||
| + | |||
| + | </ | ||
| + | < | ||
| + | |||
| + | 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(' | ||
| + | | ||
| + | | ||
| + | | ||
| + | | ||
| + | | ||
| + | ) x | ||
| + | minus | ||
| + | select s.patch_id | ||
| + | , s.patch_uid | ||
| + | , s.description | ||
| + | from | ||
| + | / | ||
| + | |||
| + | |||
| + | |||
| + | </ | ||
| + | < | ||
| + | |||
| + | 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 | ||
| + | minus | ||
| + | select x.patch_id | ||
| + | , x.patch_uid | ||
| + | , x.description | ||
| + | from a | ||
| + | , xmltable(' | ||
| + | passing a.patch_output | ||
| + | columns | ||
| + | | ||
| + | | ||
| + | | ||
| + | ) x | ||
| + | / | ||
| + | |||
| + | |||
| + | </ | ||
| + | ==== Package up useful diagnostic data when opening an SR at Oracle ==== | ||
| + | < | ||
| + | oakcli manage diagcollect | ||
| + | </ | ||
| + | ==== Health check a RAC system on ODA ==== | ||
| + | * [[https:// | ||
| + | < | ||
| + | oakcli orachk -h | ||
| + | </ | ||
oracle_data_appliance_oda.1544273361.txt.gz · Last modified: 2018/12/08 12:49 by 0.0.0.0