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:
Sign in to the Oracle Cloud Infrastructure console.
At the top of the page, ensure that the region in which you want to enable
Diagnostics & Management is selected.
Note
Cross-region monitoring and
management of Oracle Databases is not available.
Open the navigation menu, click Observability &
Management. Under Database Management,
click Administration.
On the left pane, select a compartment in the
Compartment drop-down list and the Oracle Database
cloud solution in the Deployment type drop-down
list.
On the Managed databases page, click Enable Database
Management.
In the Enable Database Management panel:
Specify the following details to select a database:
Database type: Ensure that
the correct Oracle Database cloud solution is selected.
Depending on the option selected in the previous
step, one of the following options is displayed:
Database system (for Base Database
Service): Select the DB system in the Base Database
Service. By default, the compartment selected on the
Managed databases page is displayed, however,
you can click Change compartment
and select another compartment, if required.
VM cluster (for ExaDB-D and
ExaDB-C@C): Select the cloud VM cluster that provides a
link between the ExaDB-D or ExaDB-C@C resource and the
database. By default, the compartment selected on the
Managed databases page is displayed, however,
you can click Change compartment
and select another compartment, if required.
Database home: Select the
database home associated with the Oracle Cloud Database.
Pluggable database: Select
this check box if you're enabling Database Management for a PDB.
Note
For Oracle Cloud Databases, Database Management only supports the
monitoring and management of PDBs for Oracle
Database version 19c and later.
If you're enabling Database Management for a PDB, then it must first be
enabled on the associated CDB with the
Full management
option.
You can enable Database Management for a maximum of 10 PDBs
in one CDB. If you want to increase the PDB limit,
contact Oracle
Support.
Database name: Select the
Oracle Cloud Database. If you're enabling Database Management for a PDB, then you must select
the associated CDB in this field.
Pluggable database name:
Select the PDB. This field is only displayed if you're enabling
Database Management for a PDB.
Service name: The unique
service name in the
Database_Name.Host_Domain_Name format is
automatically displayed, however, you can edit it, if
required.
Protocol: Select either the
TCP or TCPS
protocol to connect to the Oracle Cloud Database. By default,
the TCP protocol is selected.
Note
If Oracle
Data Guard is enabled on a DB system in the Base Database
Service after Database Management
was enabled for it using the TCPS protocol, then TCPS will
have to be reconfigured. Enabling Data Guard is causing TCPS
configuration to be overwritten, and it's recommended that
TCPS is configured on the DB system after enabling Data
Guard.
Port: Enter the port number.
If TCP is selected in the
Protocol field, then port number
1521 is displayed by default and you can
change it, if required.
Database wallet secret: Select the secret
that contains the database wallet from the drop-down list. This
field is only displayed if TCPS is
selected in the Protocol field. If an
existing database wallet secret is not available, then select
Create new secret... in the drop-down
list. The Create database wallet secret
panel is displayed and you can create a new secret. For
information on database wallets and how to create a secret in
the Oracle Cloud Infrastructure Vault
service, see Oracle Cloud Database-related Prerequisite Tasks.
Note that a resource principal
policy is required to grant Managed Database resources the
permission to access the secret that contains the database
wallet. If the policy is not created, then A
policy is required... message is displayed
and you can click Add policy to view
and automatically add it. The Oracle Cloud Infrastructure IAM service creates the policy and
it's added to a collection of policies called
DBMgmt_Resource_Policy in the IAM
service.
Specify the database credentials for the connection to the
selected Oracle Cloud Database.
Database user name: Enter the
database user name.
Note
If you're
enabling Database Management for a
database in an Oracle Data Guard configuration that contains
a physical standby database in mounted state, you must
ensure that the monitoring user has the
SYSDG privilege.
User password secret: Select the secret that
contains the database user password from the drop-down list. If
the compartment in which the secret resides is different from
the compartment displayed, then click Change
compartment and select another compartment.
If an existing secret with the database user
password is not available, then select Create new
secret... in the drop-down list. The
Create password secret panel is
displayed and you can create a new secret. For information
on database monitoring user credentials and how to save the
database user password as a secret in the Vault service, see
Oracle Cloud Database-related Prerequisite Tasks.
Note that a resource
principal policy is required to grant Managed Database
resources the permission to access the secret that contains
the database user password. If the policy is not created,
then A policy is required... message
is displayed and you can click Add
policy to view and automatically add it. The
IAM service creates the policy and it's added to a
collection of policies called
DBMgmt_Resource_Policy in the IAM
service.
Depending on the database type (Oracle Database cloud
solution), select one of the following connection modes:
Private Endpoint (for Base Database Service
and ExaDB-D): Select the private endpoint that will act as a
representation of Database Management
in the VCN in which the Oracle Cloud Database can be accessed.
If the compartment in which the private endpoint resides is
different from the compartment displayed, then click
Change compartment and select another
compartment.
You must ensure that the
appropriate Database Management
private endpoint is available:
Private endpoint for single instance Oracle
Cloud Databases in the Base Database Service.
Private endpoint for RAC Oracle Cloud
Databases in the Base Database Service or ExaDB-D.
Select either Security
list or Network security
group depending on which security
feature you want to use to add security rules.
Note that the Network
security group radio button is only
displayed if the Database Management private endpoint and the Oracle
Cloud Database have an attached NSG.
Select one of the following options in the
Ingress rule section and
review the details of the ingress rule that will be
created:
If you've selected the
Security list option,
select a security list in the Oracle Cloud
Database's subnet.
If you've selected the
Network security group
option, select an NSG attached to the Oracle Cloud
Database.
Select one of the following options in the
Egress rule section and
review the details of the egress rule that will be
created:
If you've selected the
Security list option,
select a security list in the private endpoint's
subnet.
If you've selected the
Network security group
option, select an NSG attached to the private
endpoint.
Management Agent (for ExaDB-C@C and
ExaDB-D): Select the Management Agent in the
Management Agent ID drop-down list.
If the compartment in which the Management Agent resides is
different from the compartment displayed, then click
Change compartment and select another compartment.
Note
The same Management Agent that was used to enable
Database Management for a
CDB is used when enabling Database Management for its PDBs.
If using a Management Agent when enabling Database Management for
ExaDB-D, you cannot edit Database Management and select a different
Management Agent later.
If a Management Agent is not installed,
then you must first install one. For generic information,
see Install
Management Agents and for additional information
on how to install a Management Agent on Exadata Cloud to
enable Database Management, see
Observability & Management Support
For Exadata Cloud (Doc ID 3015115.1) in My Oracle
Support.
Select the appropriate management option.
Note
The Basic management option is not
available for Oracle Cloud Databases in ExaDB-C@C.
The Management options are not
displayed if you're enabling Database Management for a PDB.
A confirmation message with a link to the Oracle Cloud Database's
Work requests section on the Database
Details page is displayed. Click the link to monitor the progress of the
work request.
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.
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.
Note
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)
Database fleet monitoring
Single Managed Database monitoring
Performance Hub features, including advanced
features such as Exadata monitoring
RAC database monitoring
SQL Tuning Advisor
Database administration features
Oracle Data Guard monitoring
Dashboard features
15 database metrics such as
CpuUtilization,
StorageAllocated, and
UserCalls
ASH Analytics and SQL Monitoring in Performance
Hub
Dashboard features with the exception of certain
widgets in the Oracle-defined dashboards, which do not display
metric data for Oracle Cloud Databases enabled with
Basic management.
Note that the other Diagnostics & Management console
features are not available with the Basic
management option.