Access Database Management Administration

On obtaining the required permissions and completing the prerequisite tasks, you can access Database Management Administration and use the Managed databases page to perform the tasks pertaining to External Databases and External Database Systems.

To access the Managed databases page for the External Database ecosystem:

1. Sign in to the Oracle Cloud Infrastructure console.
2. Open the navigation menu, click Observability & Management. Under Database Management, click Administration.
3. Ensure that the correct compartment is selected in the Compartment applied filter.
4. Click inside the Search by database display name field, select Deployment type, select External, and then click Apply filter.

On the Managed databases page for the External Database ecosystem, you can:

• View the External Databases in the compartment, which were registered either in the Oracle Cloud Infrastructure External Database service or in Database Management. By default, the following information pertaining to External Databases is displayed:
  • Database name: The name of the database.
  • Type: The type of database that indicates if the database is a single instance or RAC database, and if it's a CDB, PDB, or non-CDB.
  • Deployment type: The deployment type of the database.
  • Diagnostics & Management: The enablement status for the Diagnostics & Management feature set.
  • Management status: The management or license option of the database.
  • Connection status: The connection status of the database.
  • Database System: The link to the associated Database System details page, if the External Database System is discovered.
  • Exadata: The link to the Exadata infrastructure details page, if the Exadata Infrastructure associated with the External Database System is discovered.

  On the Managed databases page for External Databases, you can:

  • Click inside the Search by database display name field to filter the External Databases listed on the Managed databases page. You can select a filter such as Database name, Type, and Deployment type, specify the filter value, and then click Apply filter.
  • Click Named Credentials under Administration to create a named credential or view the named credentials in the compartment. Named credentials are resources that contain user authentication information for Oracle Databases, namely, the database user name and the Oracle Cloud Infrastructure Vault service secret that contains the database user password. In the context of the External Database ecosystem, named credentials can be created and used to access the databases in the External Database System and perform Database Management tasks. For information on named credentials, see Create and Manage Named Credentials.
• Click Actions and click one of the following options:
  • Discover Database System: Click to discover and create an External Database System and add connections to the components. For information, see Discover and Connect to External Database Systems.
  • Discover Exadata infrastructure: Click to discover the Exadata Infrastructure associated with a discovered External Database System and add connections to storage servers. For information, see Discover and Connect to Exadata Infrastructure.
  • Register external database: Click to register an External Database. On registering the External Database, you can click the Actions icon () for an External Database, and:
    • Click Connect to add a connection to the External Database.
    • Click View features to enable Database Management features.

The following table lists tasks pertaining to External Databases, including registering and connecting to External Databases and enabling Database Management features, with links to more information.