Discover RDS Database on OCI Database Management
This article describes the steps required to discover the RDS database on OCI database management.
- The first one is Amazon Relational Database Service for
Oracle
Amazon RDS for Oracle is a cloud-based database service offered by Amazon Web Services (AWS). It allows users to set up, operate, and scale Oracle relational databases in the cloud without the need to manage the underlying infrastructure. This is a non-container database.
- Amazon Relational Database Service Custom
Amazon RDS Custom a managed database service for legacy, custom, and packaged applications that require access to the underlying OS and DB environment. Amazon RDS Custom is now available for Oracle Database. Amazon RDS Custom for Oracle automates setup, operation, and scaling of databases in the cloud while granting access to the database and underlying operating system to configure settings, install patches, and enable native features to meet the dependent application's requirements. This can be a container database (CDB) with pluggable databases (PDB).
You can discover both the databases using OCI Database Management service, the first one as non-container database and the second one as container database.
To discover these databases, first you need to create database connector handles to discover the databases in an OCI external database.
Create a Non-Container Database Handle
First, you need to create a non-container database handle. Used this procedure:
- Open the navigation menu and select Oracle Database then External Database.
- Under External databases, select Container databases.
- Select your Compartment. A list of external databases appears.
- Click Register external container database. The Register an external container database dialog opens.
- Choose a compartment. By default, the database is created in your current compartment.
- In Database display name, provide a user-friendly name to help you easily identify the resource.
- Click Show advanced options. If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. If you are not sure whether to apply tags, skip this option (you can apply tags later) or ask your administrator.
- Click Register.
Create a Container Database Handle
Next, use this procedure to create a container database handle.
- Open the navigation menu. Select Oracle Database then External Database.
- Under External databases, select Container databases.
- Select your Compartment. A list of external databases appears.
- Click Register external container database. The Register an external container database dialog opens.
- Choose a compartment: By default, the database is created in your current compartment.
- In Database display name, provide a user-friendly name to help you easily identify the resource.
- Click Show advanced options to specify the options for the database. If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. If you are not sure whether to apply tags, skip this option (you can apply tags later) or ask your administrator.
- Click Register.
Connect to the Container External Database
Use this procedure to create a connection to an external container database.
Enable OCI Database Management
This topic describes two ways you can enable OCI Database Management. You can also use either of these procedures to enable Non-Container and Pluggable Databases (PDBs).
- Open the navigation menu and select Oracle Database. Under Oracle Database, click External Databases.
- On the left pane, select the Container Databases.
- Click the Container Database where you want OCI Database Management enabled.
- On the container database's home page, note the section labeled Associated Services.
- Under the Associated Services, click Enable Database Management.
- Choose the database container and the associated billing information and click Enable.
You can us this same procedure to enable non-CDB and PDBs. To get started, on the External Database menu, navigate to the Pluggable databases, then select the pluggable database and enable database management under Associated services. Then follow the steps above to enable the databases.
Enable OCI Ops Insights for Databases
OCI Ops Insights service can be enabled for the PDBs only. To enable OCI Ops Insights for the PDBs discovered externally, use this procedure.
- Open the navigation menu, click Oracle Database and, under Oracle Database, click External Database.
- On the left pane, select the Pluggable Databases.
- Click the pluggable database where you want the Ops Insights enabled.
- On the pluggable database home page, note the section, Associated Services.
- Under the Associated Services, click Enable under Ops Insights.
- Choose the Database Container and click Enable.
Enable OCI Ops Insights for Database Hosts
OCI Ops Insights service can be enabled for the hosts that runs the databases on AWS. To enable the hosts for OCI Ops Insights capacity planning, use this procedure.
- Open the OCI navigation menu and select Observability and Management.
- Select Ops Insights then Administration.
- On the Administration menu, select Host Fleet.
- Click Add Hosts then choose the Telemetry as OCI Management Agent.
- Choose the compartment, then select the AWS hosts to enable Ops Insights.
- Select the destination compartment in case of the Ops Insights in different compartment.
- To add the hosts to Ops Insights, click Add Hosts.
Enable OCI Stack Monitoring for External Database
OCI Stack Monitoring service can be enabled for all the discovered CDB/PDB and non-CDB databases. To enable stack monitoring, use this procedure.
- Open the navigation menu and select Oracle Database.
- Under Oracle Database, click External Database.
- On the left pane, select the Container Databases.
- Click the container database where you want Stack Monitoring enabled.
- On the container database home page, note the section Associated Services.
- Under Associated Services, under Stack Monitoring, click Enable.
- Choose the database connector and click Enable.
Note:
There are other ways to enable OCI Stack Monitoring for the external databases. See "Resource Discovery and Promotion" in the OCI documentation for more details on the various methods by which you can enable a stack monitoring service (see "Explore More").Enable OCI Stack Monitoring for Hosts
To enable OCI Stack Monitoring for the hosts that host the AWS databases, use this procedure.