Connecting Using Oracle Cloud Infrastructure Explorer to Connect Without Using Credentials Files (Walletless)

If your Oracle Database is On-prem, then go to Connecting to Oracle Database. For additional help using the connection dialog, visit the connection dialog help.

Oracle Cloud Infrastructure Explorer makes connecting to your Autonomous Database easier by automatically obtaining the connection string pre-populating the connection dialog.

Follow the steps in the Creating and Managing Oracle Autonomous Databases (Oracle Cloud) and Configuring Walletless Connectivity and Network Access for Oracle Autonomous Databases (Oracle Cloud) to connect Oracle Cloud Infrastructure Explorer tree control to the Oracle Cloud, locate the Autonomous Database instance you wish to connect to and configure the Autonomous database for walletless access if necessary.

1. Right click on the Autonomous Database instance name and select Create Connection in Database Explorer. The Select Authentication and Connection String will open. If this dialog does not open but instead a Download Credentials Files dialog opens, this means that the database is not configured for walletless access.

2. Set Authentication to TLS(walletless), select a choice from the TNS Name (Service Level) drop down, and press OK.

   The connection dialog will open.

3. Select Default from the Role drop down list

4. Enter the username and password. (If you are new to Oracle Autonomous Database, use username ADMIN).

5. If you are using Proxy Authentication, check the Show more options checkbox and provide the proxy username and password.

   Note:

   For more details about connecting with a proxy, see Connecting Using a Proxy User.

6. If you want to use a different schema than the default schema associated with your username, check the Show more options checkbox and select the schema from the Current Schema dropdown.

7. Provide a connection name to be used to reference this connection in Database Explorer and elsewhere.

8. Click the Create Connection button.

9. If you are using macOS, and receive a Connection request timed out error when trying to connect, please update .NET Runtime to version 6.0.

Note:

Connection information and settings may be stored with a User, Workspace, or Folder Scope. For more information see Organizing Connections by User, Workspace, or Folder Scope.