1. Getting Started with Oracle Developer Tools for VS Code
  2. Getting Started with Oracle Developer Tools for VS Code
  3. Connecting to Oracle Autonomous Database (ADB)
  4. Connecting Using Credentials Files Obtained Elsewhere

Connecting Using Credentials Files Obtained Elsewhere

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.

The easiest way to connect to Autonomous Database is to use Oracle Cloud Infrastructure Explorer . Follow the steps described in Connecting Using Oracle Cloud Infrastructure Explorer to Automatically Download Credentials Files (Wallets) . However, if you have obtained the credentials files from another source, such as the Administration Console or from your administrator, follow these steps:

  1. Unzip the credentials files into the directory that is set as Config Files Folder in the Oracle Developer Tools for VS Code Extension Settings. By default this location is ~/Oracle/network/admin on Linux and Mac and %USERPROFILE%\Oracle\network\admin on Windows.

  2. To connect from Oracle Database Explorer, click the plus sign button

  3. To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown. Then select New Connection.

  4. A connection dialog will open. In the Connection Type dropdown, select TNS Alias

  5. Make sure the TNS Admin Location field is set to the directory containing your credentials files. If not, change it.

  6. Check the Use Wallet File checkbox

  7. Make sure the Wallet File Location field is set to the directory containing your credentials files. If not, change it.

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

  9. Select Default from the Role drop down list

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

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

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

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

  14. Click the Create Connection button

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

Parent topic: Connecting to Oracle Autonomous Database (ADB)