Thank you to Suresh Sangaran for providing the information in this post!
Topic: Using the Oracle Client Development Tools to Connect Private Autonomous Database Using OCI Bastion Service – Part 1
Introduction:
Welcome to Part 1 of this two series blog which demonstrates creating and using the privately deployed Autonomous database services, with Oracle Bastion deployed in a Private Network of the OCI VCN. Using the Bastion SSH forwarding the database connection is obtained in the Database Client Development tools like SQLplus, SQL Developer, SQL Developer for VS code, and SQLcl.
Disclaimer:
The examples(s) provided are for demonstration and knowledge purposes only and represent a sample demo. Any similarity to actual data or websites is purely coincidental and not indented in any manner. For any queries, please contact the Oracle Support Services.
Prerequisite:
We assume you have hands-on knowledge of the Oracle Cloud and Networking with full access to the OCI console and to deploy and use the OCI components and services.
Purpose:
You are new to the OCI cloud and exploring or doing POC with the Autonomous database and its deployment, and connections options. This blog demonstrates step-by-step instructions with screenshots for you to understand and gather experience with the Standard OCI or a Production ready architecture. For more architecture please follow the below links:
https://www.oracle.com/cloud/architecture-center/
https://docs.oracle.com/solutions/
Summary:
Below is the OCI architecture diagram used in this blogs demonstration
Part 1 focuses on the below topics. Follow along with the attached PDF document Blog_Client_Tools_ADB_Bastion_Part1.pdf containing detailed screenshots for the step-by-step instructions.
1. Creating a VCN with 2 Private Subnets
2. Provisioning an Autonomous Database
3. VCN changes for Autonomous Database
4. Downloading and configuring Autonomous database wallet
5. Provisioning a OCI Bastion Service
6. Creating an SSH tunnel from the Bastion Service
7. Launching the SSH tunnel for the local port forwarding
8. Connecting with different Oracle database client tools below
• SQLplus
• SQL Developer
• SQL Developer for VS Code
• SQLcl
For any queries please contact the Oracle Support Services or the below MOSC communities
https://community.oracle.com/mosc/categories
————————————————————————————————————————————————————————————————–
Note: For Part 2 series of this blog, please review Accessing the Oracle APEX, ORDS and Database Actions from the Private Autonomous Database Using the OCI Bastion Service – Part 2