Connecting Oracle SQL Developer to Oracle Autonomous Database Using Wallets

Connecting Oracle SQL Developer to Oracle Autonomous Database Using Wallets

Prerequisites:

Oracle Cloud Account: Ensure you have access to an Oracle Autonomous Database.
Oracle SQL Developer: Download and install it on your local machine.
Wallet File: Download from Oracle Cloud console for your Autonomous Database.
Steps:

Download the Wallet File:

Log in to the Oracle Cloud Console.
Navigate to your Autonomous Database instance.
Click on "DB Connection" and "Download Wallet".
Enter a password, click "Download", save, and extract the zip file.
Configure Oracle SQL Developer:

Open SQL Developer and add a new connection.
Fill in connection details:
Connection Name: Any meaningful name.
Username and Password: Your database credentials.
Connection Type: Choose "Cloud Wallet".
Configuration File: Select the tnsnames.ora file from the wallet.
Service: Choose the appropriate service name.
For more details:
Manage Concurrency and Priorities on Autonomous Database

https://docs.oracle.com/en/cloud/paas...