Oracle Analytics Server 5.9 - Silent Install

Oracle Analytics Server 5.9 is now out and is available via the software delivery site of Oracle. I just want to quickly take you through the installation steps using silent mode.

Before we proceed, there are some pre-requisites which needs to be met. 

• Database for hosting metadata schemas 
• RPM packages 
• Software Zip files
• OS user with required permissions
• JDK version

Let's get to it. I will outline high level steps here a more detailed steps were documented in my GitHub repo.

Step 1: Directories 

We need to host the Oracle Fusion Middleware and Oracle Analytics Server domain, Ideal way to this is in two different folders 

• OAS_HOME
• oracle_home - for FMW and OAS software 
• domain_home - for bi domain configuration

Step 2 : FMW installation

Below is the simple command to install the fusion middleware infrastructure using a response file. You can find the sample response files in the Git repository.

java -jar /u01/app/oas/softwares/fmw_12.2.1.4.0_infrastructure.jar -silent -responseFile /u01/app/oas/resposefiles/fmw.response

Step 3 : FMW Patch Installation

Move the patch zip file to [ORACLE_HOME]/OPatch and unzip it there. change into the newly created path folder for ex cd 30657796. To apply patch use the below command.

[ORACLE_HOME]\OPatch\opatch apply -silent

Step 4 : OAS Installation

Unzip the Oracle Analytics Server installer zip file (~3.5GB). Modify the oas.response file to the oracle_home path as per previous step.

java -jar /u01/app/oas/softwares/Oracle_Analytics_Server_Linux_5.9.0.jar -silent -responseFile /u01/app/oas/resposefiles/oas.response

Step 5 : Domain Configuration

Update the config.respose to include details of the domain_home, Database details (hostname,port, servicename and SYS details) and port information etc.

[ORACLE_HOME]/bi/bin/config.sh -silent -responseFile /u01/app/oas/resposefiles/config.response

Install VNC Server on Oracle Cloud Infrastructure - Compute VM's

 This will be a simple and straight guide to install vnc server on Oracle Linux on Oracle Cloud Infrastructure Compute VM's.

This post outlines the steps to install and enable tiger vnc on Oracle Linux 7.

Step 1 : Install the necessary System Group Lists 

yum group install -y "Server with GUI"

Step 2 : Install tigervnc Server

yum install -y tigervnc-server

Step 3 : Create a service file and edit for a User

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@\:1.service
vi /etc/systemd/system/vncserver@\:1.service

Once the file is open replace the <USER> with a OS linux user like opc/root or oracle and save the file

Step 4 : Enable and Start Vnc Server

systemctl daemon-reload
systemctl enable vncserver@\:1.service
systemctl start vncserver@\:1.service

Step 5 : Set VNC Password 

Login as the user with which we will use vnc server and use vncpasswd to set a new password.

vncpasswd

Step 6 : Open ports on Machine and Security Lists

firewall-cmd --permanent --zone=public --add-port=5901-5905/tcp
firewall-cmd --reload
firewall-cmd --permanent --zone=public --list-ports

In the Security List of your VCN, make sure to open ports 5901-5905 to access the vnc server from a vnc client like vncviewer etc.

Now from your client try the vnc server using <IP_ADDRESS>:<PORT> and Password as set in Step 5.

If you dont know on which port the vncserver is running, type vncserver it will display :1,:2 etc. For :1 the port is 5901, for :2 the port is 5902 and so on.

Add SWAP size while installing a Oracle Database 19c on Oracle Linux

 Below is the error message I received while I was trying to install Oracle Database 19c on Oracle Linux 7.

PRVF-7573 : Sufficient swap size is not available on node

As per my error on the installer screen I needed 16GB of SWAP space where as my system has just 4GB. So I need to add a swap file for the installation to continue. 

Below steps will outline the steps for the same.

dd if=/dev/sdb of=/tmp/swap01 bs=1K count=16M
chmod 600 /tmp/swap01
mkswap /tmp/swap01
swapon /tmp/swap01

Make sure the bs (*) count is equal to your required SWAP space. Also, the /dev/sdb has enough storage as needed