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);

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