Connecting Oracle SQL Developer to Oracle Autonomous Database Using Wallets

Published: 16 June 2024
on channel: ERPstuff
3,901
40

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


On this page of the site you can watch the video online Connecting Oracle SQL Developer to Oracle Autonomous Database Using Wallets with a duration of hours minute second in good quality, which was uploaded by the user ERPstuff 16 June 2024, share the link with friends and acquaintances, this video has already been watched 3,901 times on youtube and it was liked by 40 viewers. Enjoy your viewing!