The PDBaaS pool operations that can be performed by SSA Admin are:
Deploy the Oracle Home from the subscribed image on the targets
emcli db_cloud_maintenance -performOperation -purpose="DEPLOY_DB_SOFTWARE/DEPLOY_RAC_SOFTWARE" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Deploy Patch OH for Pool" -target_type=oracle_home -description="Deploys the Patched Oracle home on target nodes" -input_file="data:/scratch/data_backup/deployoh.properties"
The contents of the deployoh.properties are:
NEW_ORACLE_HOME_LIST=/u01/app/oracle/product/patchedHome2
WORK_DIR_LOC=/tmp
DISPATCHER_LOC=/tmp
The following parameters can be added if the prerequisite checks need to be skipped during the Deploy operation:
SKIP_PREREQUISITE_CHECKS=true
SKIP_CVU_CHECK=true
This step retrieves the list of Oracle Homes associated with the CDB members of the pool and creates a new Oracle Home for each, using the software image provided and creates a Oracle Home Lineage.
Migrate the Listeners
Run the following command to migrate the listeners:
emcli db_cloud_maintenance -performOperation -purpose="MIGRATE_LISTENER" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Migrate Listeners" -description="Migrate the listeners to the new Oracle Home, if any"
Create / Deploy CDB
To create or deploy the CDB, run the following command:
emcli db_cloud_maintenance -performOperation -purpose="DEPLOY_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Deploy CDB" -target_type=rac_database -description="Deploy a new CDB on the new OH for every CDB on the Pool using the prefix " -db_prefix="racdb"
This step creates a new CDB for every CDB member of the pool by using the member CDBs structure only template. The new CDBs that are created will use the db_prefix for their names.
emcli db_cloud_maintenance -performOperation -purpose="DEPLOY_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Deploy CDB for a given target" -target_type=rac_database -description=" Deploy a new CDB on the new OH for the selected CDB target " -db_name="slspc" -target_list="sales.us.oracle.com"
This step creates a new CDB for the selected CDB member of the pool specified in the target_list option, using its structure only template. The new CDBs that are created will use the db_prefix for their db name.
The CDBs created using this command will be marked as Passive and will be part of the pool’s member list. There will also be a lineage created between the CDBs.
Activate CDB
emcli db_cloud_maintenance -performOperation -purpose="ACTIVATE_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Activate the CDBs" -target_type=oracle_database/rac_database -description="Activates the newly created CDBs"
This step marks all the new CDBs in the pool that were created in the above step as Active and the existing CDBs as Inactive. Any further SSA requests will be forwarded to the newly activated CDBs.
emcli db_cloud_maintenance -performOperation -purpose="ACTIVATE_CDB" -pool_name="PDB_POOL" -pool_type="pdbaas_pool" -name="Activate the CDBs" -target_type=oracle_database/rac_database -description="Activates the newly created CDBs" -target_list=”sales.us.oracle.com”
This step the given CDBs in the target_list as Active and is predecessor CDBs as Inactive. Any further SSA requests will be forwarded to the newly activated CDB.