How to configure the Oracle Analytics Server after installation

We saw how to install the Oracle Analytics Server 6.4 in an Oracle Linux 8.5 VirtualBox VM in a previous post. Now that is has been installed successfully, we are now going to see how to configure it, and once again I have documented all the steps in this page.

Oracle Analytics Server Configuration
Oracle Analytics Server Configuration

This product requires an installation of the Oracle Fusion Middleware Infrastructure as well as a supported database. We are now going to execute the Configuration Assistant script to configure the Oracle Analytics Server Domain.

The “config.sh” script is located in the “ORACLE_HOME/bi/bin” directory, it is located in “/home/oracle/Oracle/Middleware/Oracle_Home/bi/bin” directory in this VM. I used the cd command to change to this directory and I executed the “config.sh” script:

Execution of the Configuration Assistant script
Execution of the Configuration Assistant script

After a few seconds, the Configuration Assistant appeared with a Welcome message (Step 1). I clicked the “Next” button to navigate to Step 2:

Step 1/10: Configuration Assistant Welcome Message
Step 1/10: Configuration Assistant Welcome Message

Step 2 allowed to select the components to configure, I selected both “Oracle Analytics Server” and “Oracle Analytics Publisher” and I clicked the “Next” button:

Step 2/10: Select components to include
Step 2/10: Select components to include

Step 3 did some prerequisite checks and as they were all successful, I clicked the “Next” button:

Step 3/10: Prerequisite Checks
Step 3/10: Prerequisite Checks

Step 4 asked for the new domain parameters, I used the default domains directory, I chose “BI” for the domain name and accepted the default domain home. I used the default “weblogic” username for the administrator account and I entered and confirmed a password before clicking the “Next” button:

Step 4/10: Define Domain
Step 4/10: Define Domain

Step 5 offered a choice between either to create new database schemas or to use existing ones created with the RCU tool. I chose the first option and I provided the connect string (oraclelinux:1521:orclpdb1 here) and the credentials of the database account that had privileges to create the new schemas. I chose “BI” for the schemas prefix, I provided a schema password and I clicked the “Next” button:

Step 5/10: Database Schema creation
Step 5/10: Database Schema creation

Step 6 asked about the port numbers range that Oracle Analytics and Weblogic server could use, I kept the default port range (9500-9999) and I clicked the “Next” button.

Step 6/10: Specify ports range
Step 6/10: Specify ports range

Step 7 asked to specify whether to set up a default installation (with no content) or to start with content exported from another Oracle Analytics or Oracle BI Enterprise Edition installation. I chose the first option and I clicked the “Next” button.

Step 7/10: Initial Content
Step 7/10: Initial Content

Step 8 was a summary of the configuration and offered the possibility to save the configuration into a response file that could be used during a silent installation for instance. I saved the response file and I clicked the “Configure” button.

Step 8/10: Configuration summary
Step 8/10: Configuration summary

Step 9 did the configuration of the Oracle Analytics Server.

Step 9/10: Oracle Analytics Configuration
Step 9/10: Oracle Analytics Configuration

The process took a while and appeared to be stuck at the “Start all Servers” step…

Step 9/10: Configuration Process - Start All Servers
Step 9/10: Configuration Process – Start All Servers

But, after something like 20 minutes, the configuration finally concluded with a success and I clicked the “Next” button to navigate to the last Configuration Assistant screen.

Step 9/10: Configuration Success
Step 9/10: Configuration Success

Step 10 was a summary of the successful configuration and I allowed to save that information into a file. I clicked the “Save” button to save the information and the “Finish” button to close the Assistant.

Step 10/10: Configuration Complete
Step 10/10: Configuration Complete

I tried to connect to the Enterprise Manager using the “http://oraclelinux.localdomain:9500/em” URL. I entered the weblogic credentials in the login page, and after something like two minutes I was finally connected. There was a message recommending to enable the discovery cache and/or to improve the application server performance. That’s definitively something that I would have to do, two minutes to establish a connection was clearly too much. We will see how to enable the discovery cache in an other tutorial.

Oracle Enterprise Manager connected to the BI domain
Oracle Enterprise Manager connected to the BI domain

I tried to connect to Oracle Analytics using the “http://oraclelinux.localdomain:9502/analytics” URL and it worked too.

Oracle Analytics connexion
Oracle Analytics connexion

finally, I had a working Oracle Analytics Server VM, now it was a good time to backup the VM.

Disclaimer

The information contained in this Website is for general information purposes only. We try to keep this information up to date and correct but we make no warranties of any kind about the completeness, accuracy, reliability with respect to the website, the information or the graphics contained on the website for any purpose. Any reliance you place on such information is strictly at your own risk. In no event will we be liable for any loss or damage whatsoever from the use of this Website.

The post How to configure the Oracle Analytics Server after installation appeared first on MyBIJourney

All trademarks are properties of their respective owners.
FacebookTwitterPinterestWhatsAppMail