Connecting Using Oracle Cloud Infrastructure Explorer to Automatically Download Credentials Files (Wallets)

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.

Follow the steps in Create and Manage Oracle Autonomous Databases to connect Oracle Cloud Infrastructure Explorer tree control to the Oracle Cloud and locate the Autonomous Database instance you wish to connect to.

Oracle Cloud Infrastructure Explorer makes connecting to your Autonomous Database easier by automatically downloading credentials files if needed, and by pre-populating the connection dialog.

1. Right click on the Autonomous Database instance name and select Create Connection in Database Explorer. Depending on hour your database is configured, you may see a Select Authentication and Connection String dialog. If you do, Set Authentication to TLS(walletless), select a choice from the TNS Name (Service Level) drop down, and press OK.

2. When the Download Credentials Files dialog opens, verify the file path and press OK. A prepopulated connection dialog will open.

3. Select the alias name you wish to connect to, for example mydb_high, from the TNS Alias dropdown list.

4. Select Default from the Role drop down list

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

6. If you are using Proxy Authentication, check the Show more options checkbox and provide the proxy username and password. To guide you in entering the fields, note that in other tools, you may have connected using this format:

   proxyusername[username]/[proxypassword]

   Note:

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

7. 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.

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

9. Click the Create Connection button

10. 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.