ADB App Store - Oracle autonomous database App store and how to deploy application

 

The ADB App store: is an application launchpad for Oracle supported applications. Using ADB app store, tenants can install and manage the life cycle of these applications. 

Currently below applications can be deployed using ADB App store..

Ask Oracle: This app translates the user text input to SQL and run queries against the database.

Data Visual Studio: is a visualization tool for the analytics data.

OCI Cost & Usage Analytics: Monitor and manage OCI resource consumption.

OCI Log Analytics: give insights about the logs created in oci for services like VCN, load balancers etc. For now this app only supports logs for VCN service.

Workload Analytics & Reports (WAR): a visualization tool for AWR.

More applications are in pipeline....

Pre-requisite: Should have autonomous database deployed in OCI.

Installation:

Connect to ADB using SQL*Plus as ADMIN user and run below script to install ADB App store

SQL> set define off;

SQL> @adb_app_store_install.sql

You can find all scripts at this Oracle GitHub repository https://github.com/oracle-samples/adbs-tools 

Once App store installed successfully, run below script to get the ADB App store application URL .

SQL> @adb_app_store_get_URL.sql

We can use the URL from above output to login ADB APP store.

For credentials, We can use the default database user "ADB_APP_STORE" which exists in all Autonomous Databases.

We just need to unlock this user and set the new password to use it.

 

 

Now I can access the App store using above username/password and URL.

From here you can click on any application and you will see the details on how to install and what are the pre-requisites etc. For example I click on "OCI Cost & Usage Analytics" to see the details.

For this app I need to be in root compartment to set some policies. For now let me use "Workload Analytics & Reports (WAR)" app, as this does not need any Pre-requisite if you see below.

So I just click on Install button and its installed, in above screenshot its already installed, that's why you see uninstalled and open button.

Let me click on open button, you will get below screen.

I used my ADMIN user to login and see below screen.

Here we can analyze AWR dataset and investigate performance issues. I click on Analyze button.

We can do many things here to investigate issue and can also generate AWR reports.

Same way we can install other app from ADB App store and take benefits. 

Hope you like this blog!