INSTALLATION DOCUMENTS BY RAVI

Monday, November 21, 2022

 Opatch reports 'Cyclic Dependency Detected' error when patching ODI 


Issue:

When applying a Patch Set Update (PSU) to WebLogic Server 12.2.1.3 on Linux platforms, it fails with "ApplySession::apply failed: oracle.glcm.opatch.common.api.install.HomeOperationsException"

Error:

java.lang.RuntimeException: ApplySession failed in system modification phase... 'ApplySession::apply failed: oracle.glcm.opatch.common.api.install.HomeOperationsException: A failure occurred while processing patch: <PATCH_ID>'

Cause:

The Linux 'ulimit' open process limit may be set too low.

Resolution:

We need to add user limits in /etc/security/limits.conf file as root user

vi /etc/security/limits.conf

*          soft    nproc           65536

*          hard    nproc           65536

*          soft    nofile          65536

*          hard    nofile          65536


Note: "*" represents all users, if you want to add limits for specific user replace "*" with user name.

Example:

oracle          soft    nproc           65536
oracle          hard    nproc           65536
oracle          soft    nofile          65536
oracle          hard    nofile          65536

Wednesday, July 20, 2022

Perfect order of ODI export and import

 Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are taken along and it's possible to skip the Topology when importing.

If the Smart Export / Import is not used, the objects should be imported in a specific order to avoid missing references :

1.     Projects : Empty

2.     Variables (as even the Physical Topology can use variables)

3.     If not existing : Physical Topology

4.     If not existing : Logical Topology

5.     Projects Folders, KMs, Sequences, User Functions

6.     Models

7.     Interfaces and Procedures

8.     Packages

9.     Scenario and Load Plans

How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules

 How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules


Regardless of the version of ODI 12c used, component-style (built-in) KMs can be refreshed by executing the following SDK command from the ODI Studio Groovy editor:


OdiAdapter.getInstance(odiInstance).refreshRepositorySeededObjects (odiInstance, true);

Friday, May 1, 2020

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query.


select SCEN_NAME,TASK_NAME3,DEF_TXT from snp_scen_task snp_scen_task,

snp_scen

where

snp_scen_task.SCEN_NO=snp_scen.SCEN_NO

AND DEF_TXT like '%OdiSendMail%';
























Run the below SQL query to get the load plan name and load plan step name with the corresponding scenario name.

SELECT SNP_LOAD_PLAN.LOAD_PLAN_NAME,SNP_LP_STEP.LP_STEP_NAME,SCEN_NAME

FROM SNP_LP_STEP,SNP_LOAD_PLAN

WHERE SNP_LOAD_PLAN.I_LOAD_PLAN=SNP_LP_STEP.I_LOAD_PLAN

AND SCEN_NAME IN (SELECT SCEN_NAME--,TASK_NAME3,DEF_TXT

FROM SNP_SCEN_TASK SNP_SCEN_TASK,SNP_SCEN

WHERE 1=1

AND SNP_SCEN_TASK.SCEN_NO=SNP_SCEN.SCEN_NO

AND DEF_TXT LIKE '%OdiSendMail%');



















Sunday, April 26, 2020

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"

















Sunday, April 19, 2020

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









































Fusion Middleware Control







































BI Publisher









































DV

























































  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...