Installing Oracle Data Gateway on Windows

Download data gateway software from the below location.

https://www.oracle.com/middleware/technologies/oac-downloads.html

Extract the downloaded file as below

Open the extracted folder and double click on the datagateway.exe file

It will open the analytics gateway configuration wizard

How to check whether port is open or not in Linux

Syntax:

echo > /dev/tcp/[host]/[port] && echo "Port is open"
echo > /dev/udp/[host]/[port] && echo "Port is open"

Example:

echo > /dev/tcp/172.16.11.45/7091 && echo "Port is open"

 echo > /dev/tcp/172.16.11.45/7091 && echo "Port is open"

Installation and Configuration of Oracle Analytics server

JDK Installation

1.       Download and extract the recommended JDK version.

Fusion Middleware Installation

1.       Start the Fusion middle ware installation

$JAVA_HOME/java -jar fmw_12.2.1.4.0_infrastructure.jar

In welcome screen, click on Next

Select “Skip Auto Updates”, click on Next

Provide “Oracle Home” path and click on Next

Select “Fusion Middleware Infrastructure” and click on Next.

If Prerequisite Checks completed successfully, click on Next

Click on Install

Click on Next

Click on Finish

Apply Patch set

After installing, we need to apply the 30657796 patch which was downloaded from e-delivery
Navigate to downloaded patch directory, set ORACLE_HOME and PATH environmental variables and run opatch apply command

OAS Installation

Start Oracle Analytics Server Installation as shown below

On welcome screen, click on Next

Select “Skip Auto Updates”, click on Next

Provide “Oracle Home” and click on Next

If Prerequisite Checks completed, click on Next

Click on Install

Click on Next

Click on Finish

RCU Configuration

Navigate to oracle_common/bin directory, run RCU as shown below

On Welcome screen, click on Next

Select “Create Repository”, click on Next

Enter the Database details and click on Next

Click on OK

Select Create new prefix as per “Best Practices” and select Oracle Business Intelligence. Click on Next

Click on OK

Enter password for newly created Schema’s, click on Next

Click on Next

Click on OK

Click on OK

Click on Create

Click on Close

OAS Configuration

1.       Next step is to configure OAS, for this we need to run

cd $ORACLE_HOME/bi/bin

./config.sh

On Welcome screen, click on Next

Select below options and click on Next

If Prerequisite checks completed, click on Next

Provide Domain Directory details and click on Next

Enter database schema details, click on Next

Click on Next

Select Clean State, click on Next

Click on Configure

Click on Next

Click on Finish

Accessing Oracle Analytics services

Weblogic console

http://172.16.11.180:9500/console

Fusion Middleware Control

http://172.16.11.180:9500/em

BI Publisher

http://172.16.11.180:9502/xmlpserver

DV

http://172.16.11.180:9502/dv/ui

Analytics

http://172.16.11.180:9502/analytics