Register an Oracle Database on a Compute Instance
You can use the Oracle Databases on Compute wizard to register an Oracle Database on a compute instance as Oracle Data Safe target databases.
Use the Oracle Databases on Compute wizard to register the following databases:
- Oracle Database on a compute instance in Oracle Cloud Infrastructure
- Oracle Database on a compute instance in a non-Oracle cloud environment
Note:
Be sure to complete the preregistration tasks before using the wizard and the post registration tasks after using the wizard.Preregistration Tasks for an Oracle Database on Compute
The following table lists the preregistration tasks.
Task Number | Task | Link to Instructions |
---|---|---|
1 | In Oracle Cloud Infrastructure Identity and Access Management (IAM), obtain permissions to register an Oracle Database on Compute. | Permissions to Register an Oracle Database on Compute with Oracle Data Safe |
2 | Create an Oracle Data Safe service account on your target database and grant it Oracle Data Safe roles. Create the service account as the SYS
user.
|
Create an Oracle Data Safe Service Account on Your Target Database Grant Roles to the Oracle Data Safe Service Account on Your Target Database |
3 | (Optional) If you plan to connect to the target database via an Oracle Data Safe private endpoint and want to configure a TLS connection, create a wallet or certificate. | Create a Wallet or Certificates for a TLS Connection |
Run the Oracle Databases on Compute Wizard
In the wizard, you can choose an Oracle Data Safe private endpoint or an Oracle Data Safe on-premises connector to connect to your target database. Consider the following recommendations:
- For an Oracle Database on Compute in Oracle Cloud Infrastructure: Oracle recommends that you use an Oracle Data Safe private endpoint to connect your target database to Oracle Data Safe.
- For an Oracle Database on Compute in a non-Oracle cloud environment (for example, in Amazon Web Services or Azure): Oracle recommends that you use an Oracle Data Safe on-premises connector to connect your target database to Oracle Data Safe. You can use a private endpoint, however, to do so you need an existing FastConnect or VPN Connect set up between Oracle Cloud Infrastructure and your non-Oracle cloud environment. The private endpoint then needs to be created in the Virtual Cloud Network (in Oracle Cloud Infrastructure) that has access to your target database. Without this setup, Oracle recommends that you use an on-premises connector instead.
This is the registration workflow in the wizard:
Step 2: Connectivity Option
If you have FastConnect or VPN Connect set up between your on-premises network and a virtual cloud network (VCN) in Oracle Cloud Infrastructure, you can register an on-premises Oracle database with Oracle Data Safe by using an Oracle Data Safe private endpoint.
Step 3: Add Peer Database
If you're registering an Active Data Guard associated database then you can add the standby databases at this step. If you're not registering an Active Data Guard associated database, then skip this step by clicking Next.
- Click Add row on the Add additional
Data Guard peer database(s) (Optional) page.
It is also possible to register standby databases after the primary database has been registered. See Manage Peer Databases Associated with a Registered Active Data Guard Primary Database for more information.
- Enter the following information for the peer databases:
- Peer display name
- Database service name
- Database IP address
- Database port number
- TCP/TLS
- Add more peer databases by clicking Add row.
- Click Next.
If you selected
Private Endpoint
in Step 1, the wizard proceeds to Step 4: Add security rules.If you selected
On-Premises Connector
in Step 1, the wizard takes you directly to Step 5: Review and submit.
Step 3: Add Security Rule
In this step, add the required security rules. To allow communication from Oracle Data Safe to your database, you need to add two security rules:
- Ingress rule for the database: Allow the database to receive incoming traffic on its port from the private IP address of the Oracle Data Safe private endpoint (from any port).
- Egress rule for the Oracle Data Safe private endpoint: Allow the Oracle Data Safe private endpoint (from any port) to send requests to the database IP address(es) on the database's port.
The ingress and egress rules do not need to be stored within the same security list, network security group, or same compartment. If you already created the necessary security rules, you can choose to skip this step.
See Also:
For more information about security lists and network security groups, see Access and Security in the Oracle Cloud Infrastructure documentation.Step 4: Review and Submit
In this step, the wizard displays the configuration you entered in Step 1: Target Database Information, Step 2: Connectivity Option, and Step 3: Security Rules.
- Review the information on this page.
- If all of the settings are correct, click Register. If not, you can click Previous to redo any of the earlier steps, or click Cancel.
Step 5: Registration Progress
Important:
Do not click the Close button in the wizard, sign out of OCI, or close the browser tab until the wizard shows that all of the tasks listed are resolved. If you exit prematurely, then the information for all of the tasks that have not yet been completed is lost and the target database is not registered.After You Submit the Registration
The wizard presents the Target Database Details page when the registration submission is finished. On this page, you can again review the registration details. Here you can you also review the status of peer databases, add more peer databases, and update the configuration of the peer databases as needed.
The wizard displays the NEEDS_ATTENTION
icon if a task must be performed or corrected before the process is complete. A hint message indicates the pending task. You can make the necessary changes in the tabs that are available. When you save your changes, the UPDATING
icon is displayed. If there is no further work to do, the registration completes.
Post Registration Tasks for an Oracle Database on Compute
The following table lists the tasks you need to complete after you run the Oracle Databases on Compute wizard.
Task Number | Task | Link to Instructions |
---|---|---|
1 |
(If you are using an Oracle Data Safe on-premises connector) Download the install bundle for the on-premises connector and then install the on-premises connector on a host machine on your network. |
Create an Oracle Data Safe On-Premises Connector |
2 | (If you are using a TLS connection and an Oracle Data Safe on-premises connector) Configure a TLS connection between the on-premises connector and your target database. | Configure a TLS Connection Between the On-Premises Connector on Your Host Machine and Your Oracle Database |
3 |
(Optional) Change which features are allowed for the Oracle Data Safe service account on your target database by granting/revoking
roles from the account. You need to be the |
Grant Roles to the Oracle Data Safe Service Account on Your Target Database |
4 |
(Optional) Grant users access to Oracle Data Safe features with the target database by configuring policies in Oracle Cloud Infrastructure Identity and Access Management. |
Create IAM Policies for Oracle Data Safe Users |
5 | Make sure the firewall of the compute instance is configured to allow ingress traffic from the Oracle Data Safe private endpoint or Oracle Data Safe on-premises connector. | (none) |