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.
Create a Handle to an External Pluggable
Database 🔗
Perform the following steps to create a handle to an external pluggable
database.
Open the navigation menu, select Oracle
Database, and then select External Database.
Under External Database, select Pluggable
Databases. The External databases list page opens.
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.
Select Register external pluggable database.
On the Register an external pluggable database page, enter the following details:
Database display name: Provide a
user-friendly name to help you easily identify the resource.
Select an external container database to house the pluggable database.
Compartment: Choose a compartment. By
default, the database is created in your current compartment.
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.
Select Register.
WHAT NEXT?
After creating the external pluggable database resource (the
handle), you can configure the handle's connection to the external pluggable
database instance. For more information, see Create a Connection to an External Pluggable Database.
After connecting the handle to an
external database instance, you can enable associated services including
Database Management and Operations Insights. For more information, see Manage the Associated Services for External Database.
Create a Handle to an External Container Database 🔗
Perform the following steps to create a handle to an external container database.
Open the navigation menu, select Oracle
Database, and then select External Database.
Under External Database, select
Container Databases. The External databases list page
opens.
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.
Select Register external container database.
On the Register an external container database page, enter the following details:
Database display name: Provide a
user-friendly name to help you easily identify the resource.
Compartment: Choose a compartment. By
default, the database is created in your current compartment.
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.
Select Register.
WHAT NEXT?
After creating the external container database resource (the
handle), you can configure the resource's connection to a container database
located outside of OCI. For more information, see Create a Connection to an External Container Database.
After connecting the handle to an external container database, you
can perform a scan of the external container database to discover pluggable
databases. For more information, see Scan an External Container Database for Pluggable Databases.
After connecting the handle to an
external database instance, you can enable associated services including
Database Management and Operations Insights. For more information, see Manage the Associated Services for External Database.
Create a Handle to an External Non-container Database 🔗
Perform the following steps to create a handle to an external non-container database.
Open the navigation menu, select Oracle
Database, and then select External Database.
Under External Database, select
Non-Container Databases. The External databases list page
opens.
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.
Select Register external non-container database.
On the Register an external non-container database page, enter the following details:
Database display name: Provide a
user-friendly name to help you easily identify the resource.
Compartment: Choose a compartment. By
default, the database is created in your current compartment.
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.
Select Register.
WHAT NEXT?
After creating the external non-container database resource (the
handle), you can configure the handle's connection to the external database
instance. For more information, see Create a Connection to an External Non-Container Database.
After connecting the handle to an
external database instance, you can enable associated services including
Database Management and Operations Insights. For more information, see Manage the Associated Services for External Database.