Database Reference
In-Depth Information
automatically ignored]
Would you like to patch all the above homes: Y | N ? :Y
You either update all the Oracle Homes listed, or a particular home and associated databases. The OAK utility
will patch Oracle Homes and databases in a rolling fashion. At any single point in time, at least one database instance
is available in case you are using RAC or RAC one-node options. A single instance is stopped for the duration of the
patching session.
Upgrading One by One
If you would like to have more granular control over the databases that are going to be updated, you may want to
configure each database to be associated with a separate Oracle Home rather run all databases under one Oracle
Home. The following steps demonstrate how to upgrade one-by-one CAT and a DOG databases using OAK utility in a
fully automated way:
# Show all current Oracle Homes
oakcli show dbhomes -detail
Oracle HomeName Oracle Home Version Oracle HomeLocation
Database Name Database Type
---------------- --------------------- ---------------------------------------
--------------- -----------
OraDb11203_home1 11.2.0.3.7(16619892,16742216) /u01/app/oracle/product/11.2.0.3/dbhome_1
CAT RAC
OraDb11203_home2 11.2.0.3.7(16619892,16742216) /u01/app/oracle/product/11.2.0.3/dbhome_2
DOG RACOneNode
# Update dbhome_1 that executes CAT database
oakcli update -patch 2.7.0.0.0 --database
...
Would you like to patch all the above homes: Y | N ? :N
...
Please enter the comma separated list of database home_names that you do NOT want to patch:
OraDb11203_home2
...
........done
# At this stage the CAT database is updated to the latest version. The DOG database is still on the
previous version.
# Update dbhome_2 that executes DOG database
oakcli update -patch 2.7.0.0.0 --database
...
Would you like to patch all the above homes: Y | N ? :N
...
Please enter the comma separated list of database home_names that you do NOT want to patch:
OraDb11203_home1
...
........done
