External Database Service

You can manage and monitor Oracle Databases that are located outside of Oracle Cloud Infrastructure (OCI) using OCI's External Database service. External Database allows you use cloud-based tools such as Database Management with your external databases.

About the Database Management Service

As a Database Administrator, you can use the Oracle Cloud Infrastructure Database Management service to monitor and manage your Oracle Databases. Database Management supports Oracle Database versions 11.2.0.4 and later. Using Database Management you can:

  • Monitor the key performance and configuration metrics of your fleet of Oracle Databases. You can also compare and analyze database metrics over a selected period of time.
  • Group your critical Oracle Databases, which reside across compartments into a Database Group, and monitor them.
  • Create SQL jobs to perform administrative operations on a single Oracle Database or a Database Group.

For complete documentation on the Database Management service, see Database Management. The rest of the External Database section of the documentation covers only the creation and management of external database "handles" and the OCI external database connection resource that allows you connect your external database to a handle in OCI.

How the External Database Service Works

To manage an external database using OCI's External Database service, you create an OCI resource known as a "handle" that represents the external database within your tenancy. After creating a handle for your database, you create a second resource called a database connection. The connection stores the information required for your OCI tenancy to connect to the external database. After creating the connection resource and connecting the OCI handle to your external database instance, you can enable the Database Management service to monitor the health and performance of your database.

The OCI External Database Handle

You can create an OCI external database handle for the following types of external databases:

  • External container databases
  • External pluggable databases
  • External non-container databases

The handle stores a few pieces of metadata that allow you to manage your database instance within OCI. This metadata includes the following information related to managing the handle in OCI:

  • An OCID, which allows the external database instance to be identified and managed within OCI.
  • An OCI display name
  • Compartment assignment information (optional)
  • Tags (optional)

In addition to the OCI-related metadata, the handle stores metadata derived from the database instance. This includes the database unique name, the Oracle Database software edition and version, and other details. All of this information stored by the handle can be viewed in the OCI Console or retrieved using the API. Metadata derived from the external database instance (such as database unique name) is only populated in the handle after a database connection is established between the handle and the instance.

Scanning an External Container Database to Discover Pluggable Databases

After you create and connect an external container database handle, you can use the handle to scan the external container database and discover pluggable databases that have not been connected to OCI. If any pluggable databases are discovered that are not connected to Oracle Cloud Infrastructure, the connection details for these databases are listed in the work request generated by the scan operation. See To scan an external container database for pluggable databases for more information.

The OCI Database Connection Resource

The OCI database connection resource stores details about how a specific handle connects to an external Oracle Database instance. These details include the following:

  • Connection strings details (DNS hostname, port, service name, network protocol)
  • Connection type and OCI agent ID
  • User credentials and role

Prerequisites

To use the External Database service, you will need the following:

  • An Oracle Cloud Infrastructure (OCI) tenancy. See Setting Up Your Tenancy for information if you do not currently use OCI.
  • One or more external databases located outside of OCI. The External Database service supports container databases, pluggable databases, and non-container databases that use the following Oracle Database software versions: 11gR2, 12cR1, 12cR2, 18c, and 19c. You can use the External Database service with database clones and with high-availability / disaster recovery databases standby databases.
  • A Management Agent Cloud Service agent with source credentials. See the Management Agent documentation for details on creating this resource in OCI.