37 PDB Onboarding on DBaaS Cloud
This chapter covers the PDB Onboarding on DBaaS Cloud feature. It contains the following sections:
Introduction
Currently, Database as a Service for multitenant DB architecture supports Pluggable Database Lifecycle operations like Creation/Deletion, Start/Stop, Backup/Restore, Patching etc. With PDBaaS adoption in EM environments with existing Pluggable Database(s), an existing Pluggable Database can now be assigned to a Self Service user owning the database, for management of PDB from Self Service portal.
Pre-requisites
-
Target Pluggable Database must be discovered in Enterprise Manager
-
Pluggable Database Host(s) must be added to a destination PaaS Infrastructure Zone.
-
Parent Container Database(s) for Pluggable Database must be added to a destination Pluggable Database Pool.
PDB Onboarding on DBaaS Cloud: EMCLI Command and Input File Properties
This section provides details on PDB Onboarding on DBaaS Cloud using EMCLI command:
$ emcli db_cloud_maintenance -relocateService –discoverOnly=”true” –input_file=”data:<absolute_path_to_input_file>”
Input file properties:
DEST_PDB_NAME=<EM Target name of the Pluggable Database>
DEST_CDB_TARGET_NAME=<EM Target name of the destination Container Databas>
DEST_CDB_TARGET_TYPE=<oracle_database|rac_database>
PDBSERVICE_NAME=<Name of the service to be created for the target Pluggable Database>
DEST_CDB_POOL_NAME=<Destination Pluggable Database Pool name>
DEST_CDB_CRED=<EM Named Credential for Target Container Database SYS user in the format CREDENTIAL_NAME:CREDENTIAL_OWNER>
MASTER_USER_CREDS=<EM Named Credential for Master Account user to be created in Target Pluggable Database in the format CREDENTIAL_NAME:CREDENTIAL_OWNER>
PDBAAS_SSA_USER=<Username of EM SSA user with EM_SSA_USER role privileges>
Note:
This is an administrator driven operation to be initiated by an EM administrator with EM_SSA_ADMINISTRATOR role privileges.