Oracle Cloud Infrastructure Documentation

Connecting to an Autonomous Database

This topic describes the following actions related to connecting client applications to an Autonomous Database:

  • Connecting a client to an Autonomous Database
  • Obtaining the credentials and information you need to create a connection
  • Obtaining access URLs for Oracle Application Express (APEX) and Oracle SQL Developer Web

About Connecting to Autonomous Databases

Applications and tools connect to Autonomous Databases by using Oracle Net Services (also known as SQL*Net). SQL*Net supports a variety of connection types to Autonomous Databases, including Oracle Call Interface (OCI), ODBC drivers, JDBC OC, and JDBC Thin Driver.

To support connections of any type, you'll need to download the client security credentials and network configuration settings required to access your database. You'll also need to supply the applicable TNS names or connection strings for a connection, depending on the client application or tool, type of connection, and service level. You can view or copy the TNS names and connection strings in the DB Connection dialog for your Autonomous Database. For detailed information about the TNS names, see Predefined Database Service Names for Autonomous Transaction Processing and Predefined Database Service Names for Autonomous Data Warehouse.

Connecting from a VCN

To connect to Autonomous Databases from a VCN, the VCN must be configured with one of the following gateways:

Make sure to configure the subnet's route table with a rule that sends the desired traffic to the specific gateway. Also configure the subnet's security lists to allow the desired traffic.

About Downloading Client Credentials

The client credentials .zip that you download contains the following files:

  • cwallet.sso - Oracle auto-login wallet
  • ewallet.p12 - PKCS #12 wallet file associated with the auto-login wallet
  • sqlnet.ora - SQL*Net profile configuration file that includes the wallet location and TNSNAMES naming method
  • tnsnames.ora - SQL*Net configuration file that contains network service names mapped to connect descriptors for the local naming method
  • Java Key Store (JKS) files - Key store files for use with JDBC Thin Connections
Important

Wallet files, along with the database user ID and password, provide access to data in your Autonomous Database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.

Access URLs for Application Express (APEX) and SQL Developer Web

Note

The Console currently provides URLs for these applications only for Autonomous Databases with dedicated deployments.

The URLs for Application Express (APEX) and SQL Developer Web provided in the Oracle Cloud Infrastructure Console only work from browsers within the same VCN as the Autonomous Database being accessed by the applications. Therefore, to use these URLs, you will need to open a browser running on a computer that meets one of the following conditions:

  • The computer is a Compute instance is provisioned in the VCN of the Autonomous Database.
  • The computer has a direct connection to the VCN of the Autonomous Database

To access APEX or SQL Developer Web, paste the appropriate access URL into the browser's address field, and then provide the Autonomous Database username and password when prompted. For more information on APEX, see the APEX documentation. For more information on SQL Developer Web, see Oracle SQL Developer Web.

Before You Begin

The Autonomous Database is preconfigured to support Oracle Net Services (a TNS listener is installed and configured to use secure TCPS and client credentials.) The client computer must be prepared to use Oracle Net Services to connect to the Autonomous Database. Preparing your client includes downloading the client credentials. See the following links for steps you might have to perform before you access the client credentials and connection information for your Autonomous Database

Using the Oracle Cloud Infrastructure Console

To access the client credentials and connection information for your Autonomous Database
To obtain access URLs for Oracle Application Express (APEX) and Oracle SQL Developer Web

Using the API

Use the GenerateAutonomousDatabaseWallet API operation to download the client credentials for your Autonomous Database.

Use the AutonomousDatabase API operation to get the access URLs for Application Express (APEX) and SQL Developer Web.

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.

What's Next

For information and instructions on making secure connections to your database, see Connecting to Autonomous Transaction Processing and Connecting to Autonomous Data Warehouse.

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.