OCI: Introducing Oracle Database Tools Service

Oracle has recently launched a new cloud service aimed at simplifying database connections and management for users of Oracle databases. This blog will provide a brief overview of the Oracle Database Tools Service, its features, and how to get started.

Key Features of Oracle Database Tools Service

• Simplified Database Connections: Easily create and manage database connections within your OCI account.
• Secure Credential Storage: Store database credentials securely in the OCI Vault.
• Private Endpoint Access: Access databases in private subnets without exposing them to the public internet.
• Integrated SQL Tools: Use SQL Worksheet and SQLcl for database management and queries.
• OCI Resource Integration: Manage database connections as OCI resources with fine-grained access control.

Getting Started with Oracle Database Tools Service

Note: Provision ATP Database as Private Endpoint Click Here

Step 1: Accessing Database Tools

1. Log in to your OCI account.
2. Navigate to Developer Services and select Database Tools.

Step 2: Creating a Database Connection

1. Click on "Create Connection"

2. Enter the connection details and select the database from your OCI tenancy

3. Securely store your credentials in the OCI Vault.

?Create the OCI Vault > Add Encryption Key > and Database ADMIN Password

4. If your database is in a private subnet, configure the private endpoint.

Step 3: Validating the Connection

1. After creating the connection, click "Validate".

2. Ensure the connection is successful and verify the database version.

Using SQL Tools

SQL Worksheet

1. Access the SQL Worksheet from the Database Tools interface.

2. Run SQL queries and scripts directly from the worksheet.

3. Save and load scripts from Object Store.

SQLcl

1. Launch SQLcl from the Database Tools interface.

2. Use the OCI Cloud Shell to connect to your database securely.

3. Run queries and manage your database using the full capabilities of SQLcl.

Managing Access and Security

• Resource-Based Access Control: Define policies to control access to database connections.
• Granular Permissions: Assign specific permissions to users or groups for database connections.
• Secure Connection Strings: Store connection strings securely in the OCI Vault to prevent unauthorized access.