Create a Handle for an External Database

This topic provides information about creating external database handles using the Console and API. The handle functions as a representation within OCI of an Oracle Database instance located outside of the Oracle Cloud.

Note

The following procedures are not used to create an Oracle Database instance outside of Oracle Cloud.

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don't have permission or are unauthorized, verify with your administrator what type of access you have and which compartment to work in.

For administrators: The policy in Let database admins manage Oracle Cloud external database resources lets the specified group do everything with databases and related database resources.

To create a or update a database connection using the TCPS connector, your user-group must have permissions to use secret-family/resources.

If you're new to policies, see Getting Started with Policies and Common Policies. For more information about writing policies for databases, see Policy Details for External Database.

Create a Handle to an External Pluggable Database

Perform the following steps to create a handle to an external pluggable database.

  1. Open the navigation menu, select Oracle Database, and then select External Database.
  2. Under External Database, select Pluggable Databases. The External databases list page opens.
  3. All external databases in the selected compartment are displayed in a table. To view the external databases in a different compartment, use the Compartment filter to switch compartments.
  4. Select Register external pluggable database.
  5. On the Register an external pluggable database page, enter the following details:
  6. Database display name: Provide a user-friendly name to help you easily identify the resource.
  7. Select an external container database to house the pluggable database.
  8. Compartment: Choose a compartment. By default, the database is created in your current compartment.
  9. Tags: 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. For more information, see Resource Tags.
  10. Select Register.

WHAT NEXT?

Create a Handle to an External Container Database

Perform the following steps to create a handle to an external container database.

  1. Open the navigation menu, select Oracle Database, and then select External Database.
  2. Under External Database, select Container Databases. The External databases list page opens.
  3. All external databases in the selected compartment are displayed in a table. To view the external databases in a different compartment, use the Compartment filter to switch compartments.
  4. Select Register external container database.
  5. On the Register an external container database page, enter the following details:
  6. Database display name: Provide a user-friendly name to help you easily identify the resource.
  7. Compartment: Choose a compartment. By default, the database is created in your current compartment.
  8. Tags: 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. For more information, see Resource Tags.
  9. Select Register.

WHAT NEXT?

Create a Handle to an External Non-container Database

Perform the following steps to create a handle to an external non-container database.

  1. Open the navigation menu, select Oracle Database, and then select External Database.
  2. Under External Database, select Non-Container Databases. The External databases list page opens.
  3. All external databases in the selected compartment are displayed in a table. To view the external databases in a different compartment, use the Compartment filter to switch compartments.
  4. Select Register external non-container database.
  5. On the Register an external non-container database page, enter the following details:
  6. Database display name: Provide a user-friendly name to help you easily identify the resource.
  7. Compartment: Choose a compartment. By default, the database is created in your current compartment.
  8. Tags: 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. For more information, see Resource Tags.
  9. Select Register.

WHAT NEXT?

Use the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use these API operations to create OCI external database handles:

  • CreateExternalContainerDatabase
  • CreateExternalPluggableDatabase
  • CreateExternalNonContainerDatabase

For the complete list of APIs for the Database service, see Database Service API.