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.
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_18.104.22.168.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
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
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.
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
Choose the option to use the Metadata schemas you already created, and enter the database details
Choose your port range
I love this message, clean install or something else (dirty??)
And now we wait. I think it took about 40 minutes on my setup (12 cpu 32gbRAM)
All install steps are done
You should now see some lovely Analytics and DV and EM screens
This one takes ages!
Hopefully i get time to do a post on the next Step!
Til then, have fun!