This chapter covers the database onboarding on DBaaS cloud feature. It contains the following sections:
Database as a Service supports Database Lifecycle Management operations like Database Creation/Deletion, Startup/Shutdown, Backup/Restore, Patching etc. via Self Service Portal.
Self Service users have been able to provision and manage new Database services using these operations.
While adopting Database as a Service, an existing Database can now be assigned to Self Service user owning the database, for management of DB from Self Service portal. This can be achieved by discovering an EM managed DB instance as an EM Cloud instance.
Target Oracle Database must be discovered in Enterprise Manager.
Database Host(s) must be added to a destination PaaS Infrastructure Zone.
Database Software Home(s) must be added to a destination Database Software Pool.
This section provides details on DB 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_TARGET_NAME=<EM Target name of the DB Target to be managed via Self Service Portal> DEST_TARGET_TYPE=<oracle_database|rac_database> DEST_POOL_NAME=<Name of the DB Software Pool which contains the target DB ORACLE_HOME> DEST_POOL_TYPE=oracle_cloud_zone DB_SERVICE_NAME=<Name of the new DB service that will be created for the DB Target> DEST_DB_CRED=<EM Named Credential for Target DB SYS user in the format CREDENTIAL_NAME:CREDENTIAL_OWNER> MASTER_USER_CREDS=<EM Named Credential for DB Master Account user in the format CREDENTIAL_NAME:CREDENTIAL_OWNER. Master account user will be created in the DB> SSA_USER=<Username of EM SSA user with EM_SSA_USER role privileges>
Note:
In case the target DB is in Dataguard Configuration, only primary DB will be discovered.
This is an administrator driven operation to be initiated by an EM administrator with EM_SSA_ADMINISTRATOR role privileges.