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 Without Using Credentials Files

Connecting Without Using Credentials Files

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. See Connecting Using Oracle Cloud Infrastructure Explorer to Connect Without Using Credentials Files (Walletless). However, if you have obtained the connection string from another source, such as the Administration Console or from your administrator, and the database is configured for walletless connectivity, perform the following steps.

  1. You can connect to the Oracle Database using one of the following ways:

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

      Or,

    • To connect from Oracle Database Explorer, click the plus (+) sign:

  2. A connection dialog will open. In the Connection Type dropdown, select Advanced

  3. Paste the connect string into the Connect String box.

  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, then 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. For information on how to enable walletless connectivity from Visual Studio Code, go to Configuring Walletless Connectivity and Network Access for Oracle Autonomous Databases (Oracle Cloud).

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)