Friday, May 31, 2019

Collecting Diagnostic Information for OBIEE Security Issues Analysis using RDA utility

Important information:
Ensure you are logged on to the host machine experiencing the problem as the Operating System user that owns the files to be collected.
If your issue involves multiple processes distributed across different hosts, follow the instructions for each host machine.

Run RDA:
Navigate to ORACLE_HOME/oracle_common/rda

Set the below environment variables:
ORACLE_INSTANCE (for 11g only)
DOMAIN_HOME (for 11g, 12c only)

Run the below command: -s OutputFileName  -v -p FM12c_Bi

Note: We may get this issue due to older rda version and resolution is to upgrade the rda utility to newer version.

Checking rda version:

Upgrading RDA:
Download and stage the Patch set 29687335 as below

Backup the current rda folder and replace it with rda folder from downloaded patch.

Check the version now:

Collecting diagnostic information:

Note: Upload this zip file to oracle support if we raise any service request.


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,DE...