Installing Analytics Server 2023 – Windows – Oracle Analytics by Adrian Ward

The installation steps are much the same as previous releases, Namely,

Choose and install an Operating System.
Install a Database – I used Oracle 19c for this
Install Java JDK.
Install Fusion Middleware
Install Analytics Server 2023 Software
Create the Metadata Repository Schemas (RCU)
Configure Your Domain
Set up for real use (not technically install but you need to do this)

For today I chose Windows Server 2022 operating system. I know Its not on the supported systems list, but I wanted to see if it works. Lets hope it gets on the list of supported OS’s soon because 2019 will be going out of date soon.

For the database i’m using a Oracle 19. Its just soo easy to install and use, especially on Windows. I will try the New Free database as soon as i can.

On the Java front we have had lots of issues with the 1.8 Update 361. So i’m sticking with Update 341 for now. You can download from the Java Archive | Oracle

I always download fresh versions of the software from eDelivery. I have no idea if the fmw package is updated, i doubt it, but just in case I get the latest.

Pre-requisites

For this blog we already have OS, Database and Java ready to go, we will focus here on step 4 to step 7.

I then put the software somewhere handy

Install Fusion Middldeware

This is really simple, just goto the folder where you downloaded the fmw jar file, and enter the command:

c:\Java\jdk_1.8.0_341\bin\java.exe -jar .\fmw_12.2.1.4.0_infrastructure.jar

I actually used powershell for this, but my advice is dont do that, just stick with cmd windows

Now we just have the usual screens to go through

I am not a fan of the standard install paths. There is probably a reason they did it, but there are just too many sub directories the navigate, without adding two more in the install. Therefore I just use c:\oas

Given that i am on Windows 2022, then i do get a warning:

but it can be ignored

Installing OAS 2023 Software

Using the same syntax to run the install

c:\Java\jdk_1.8.0_341\bin\java.exe -jar Oracle_Analytics_Server_2023Update_Win64.jar

Select the fmw home (C:\oas)

Ignoring the warning again

Done

Run the RCU

Now we have all the software in place, we can create the metadata schema.

Navigate to the oracle_common/bin folder

Set the JAVA_HOME variable

Then run rcu

rcu.bat

The first option includes creating the schema. You can use these screens to just create the sql scripts if you prefer ( i know i normally do!).

Enter your database details

I prefer to use generic prefixes. Some people like to use environment based prefixes. I don’t !

Make sure you select the “Business Intelligence Platform” option

You can choose One password for all

Or different passwords

You can customise the tablspaces too.

One of the advantages o just creating SQL scripts with this process is the amount of fine grained control you will get. It also means these scripts can be in any automated database creation process (yeh – devOps!)

After its done you will find the schema in your database:

Configure OAS 2023

The next step is to create a “Domain”. basically a folder where all your config will be kept. Although the system makes use of database tables to hold config info, it still relies heavily on the file system

Navigate to the oas\bi\bin folder, and run the config command.

config.cmd

Installing Publisher too

Ignoring the OS warning

Set your domain name. Just using bi is boring, get creative!
Also note that I dont like using the ootb username “weblogic” You can set this here to suit your security preferences