Enable Diagnostics & Management for Oracle Cloud Databases
Before you enable Database Management Diagnostics & Management for Oracle Cloud Databases, you must:
- Complete the general Oracle Cloud Infrastructure prerequisite tasks listed in Perform General Oracle Cloud Infrastructure Prerequisite Tasks.
- Obtain the permissions required to enable Diagnostics & Management for Oracle Cloud Databases, as detailed in Permissions Required to Enable Diagnostics & Management for Oracle Cloud Databases.
- Complete the Oracle Cloud Database-specific prerequisite tasks listed in Oracle Cloud Database-related Prerequisite Tasks.
You can enable Diagnostics & Management for Oracle Cloud Databases on the Database Details page of the respective Oracle Database cloud solution or on the Administration Managed databases page in Database Management.
To enable Diagnostics & Management for Oracle Cloud Databases in Database Management:
You can verify if Database Management is successfully enabled on the following pages:
- Managed databases page in Database Management: On the left pane, select the compartment in which
the Oracle Cloud Database resides and select the appropriate option in the
Deployment type drop-down list. After Database Management is enabled, the Oracle Cloud
Database is listed as a Managed Database. You can click the
Actions icon () for the Oracle Cloud Database and perform the following tasks:
- View details: Click to go to the Database Details page in the Oracle Database cloud solution.
- Edit Database Management: Click to edit the connection information or the other details provided to enable Database Management for the Oracle Cloud Database.
- Disable Database Management: Click to disable Database Management.
- Set Session Credential: Click to set a session credential for that particular session and perform Diagnostics & Management tasks.
- Database Details page of the Oracle Cloud Database: Verify if the Enable option next to Database Management is replaced with Enabled. A Disable option is also displayed, which you can click to disable Database Management.
If you encounter issues when enabling Diagnostics & Management, see Errors Encountered When Enabling Database Management for Oracle Cloud Databases for likely causes and solutions.
About Management Options
Database Management Diagnostics & Management features for Oracle Cloud Databases in the Base Database Service and ExaDB-D are available as part of two management options. You can select either option when enabling Database Management.
- The Basic management option is not available for Oracle Cloud Databases in ExaDB-C@C.
- If you're enabling Diagnostics & Management for a PDB (in the Base Database Service and ExaDB-D), then you do not have the option of selecting a management option as PDB support is only available as part of the Full management option.
The two management options are:
- Full management: This option includes all Diagnostics & Management features at an additional service cost. The Full management option is available for the Oracle Database Enterprise Editions and the Oracle Database Standard Edition, however, for the Oracle Database Standard Edition, the Full management option does not include Performance Hub features and other features such as Alert Logs and AWR Explorer. For information on Diagnostics & Management feature availability, see Diagnostics & Management Feature Support Matrix for Oracle Databases.
- Basic management: This option is available for Oracle Cloud Databases in the Base Database Service and ExaDB-D at no additional cost.
Here's an overview of the features available in each management option.
Full management (Available at an additional cost) | Basic management (Free) |
---|---|
|
Note that the other Diagnostics & Management console features are not available with the Basic management option. |
For information on the metrics available with the management options, see Oracle Cloud Database Metrics.