Moneycontrol Brokerage Recos

Monday, September 23, 2019

Single-Click APEX startup on Oracle Autonomous Database



One of the very exciting feature for Oracle Cloud Administrators and Developers to manage and user the Oracle APEX, now you can start APEX with just a single click, that too running on Oracle Autonomous Database Cloud Services in Gen 2 Oracle Cloud Infrastructure Services.

Here in this article, I would step you through to get an overview how you can do it in its simplest way as it is designed.

Cloud Administrator or ATP Database Administrator can login to the Autonomous Transaction Processing Database instance it wants to startup the APEX Framework for and click on the "Development" at left side in the panel  > then click on the "Oracle APEX" which directly opens up an new browser/tab to login to APEX framework or you copy the URL from the "RESTful Services and SODA" and paste it in the another tab/browser to go to the APEX login page .


Clicked in the "Oracle APEX" and its "Administration Services" login page appears, since it is our brand new ATP instance and first time opening the APEX so we need to login as ADMIN user to create developer users and workspaces in there to be used by them.



After Login as Admin, it welcomes to "Create Workspace"



Click on the "Create Workspace" and give new or existing database user to use with your new workspace, if there users already in the database then you can click at right side of the "Database User" box to get the list of users and select one. I am just creating the new one here.



Once all information provided, click on the "Create Workplace" and creates in seconds.




Now, log off from Administration account and login back with development user name : USER01




APEX Framework homepage opens.






SQL Worksheet tab:



Team Development Tab :




App Gallery:

From the "App Gallery" you can install any available application you want instantly just by clicking on it, look at followed screenshot after it.

















Application Installed:




Open the application by clicking the Play icon right next to the "Manage" button to start using the application.










Hope it helps, thanks for reading, please subscribe to this blog to stay updated with latest news on Oracle Autonomous Database Cloud Services and new articles.

Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/


No comments:

Post a Comment