Thank you to Suresh Sangaran for providing the information in this post!
Topic: Accessing the Oracle APEX, ORDS and Database Actions from the Private Autonomous Database Using the OCI Bastion Service – Part 2
Introduction:
Welcome to Part 2 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, Oracle APEX, ORDS(Oracle REST Data Services and Database Actions.
Part 1 – Covers the steps for creating the Network, Autonomous Database and Bastion Service to work with tools – SQLplus, SQL Developer, SQL Developer for VS code, and SQLcl.
Part 2 – In this blog, we cover the steps using the existing setup in Part 1 and access the Inbuilt Autonomous Database tools like Oracle APEX, ORDS(Oracle REST Data Services), and Database Actions.
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. To demonstrate and run Part 2 in this blog, it is expected that Part 1 steps is already completed. If this has not been completed, please visit the Part 1 blog link in the Introduction section and follow the attached steps in the presentation.
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 2 focuses on the below topics. Follow along with the attached document Blog_Client_Tools_ADB_Bastion_Part2.pdf containing detailed screenshots for the step-by-step instructions.
1. Add new NSG Rules for port 443(default HTTPs port)
2. Create new SSH Port Forwarding session for port 443.
3. Run the SSH command line to port forward the OCI Bastion locally.
4. Connecting and working with Inbuilt Autonomous Database client tools below
• Oracle APEX
• ORDS(Oracle REST Data Services)
• Database Actions(Formerly SQL Developer Web)
For any queries please contact the Oracle Support Services or the below MOSC communities
https://community.oracle.com/mosc/categories