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_HOME

ORACLE_INSTANCE (for 11g only)

DOMAIN_HOME (for 11g, 12c only)

Run the below command:

rda.sh -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.

Creating Pluggable database using database configuration assistant

Launch Database Configuration Assistant

Select Manage Pluggable Databases and click on Next

Select Create a Pluggable Database and click on Next

Select database , provide username and password and click on Next

Click on Yes

Click on Next

Provide pluggable database name, location and user details and click on Next

Click on Yes

Click on Finish

Pluggable database created successfully, click on close

Steps for collecting OBIEE 12c diagnostic bundle

With this we can collect the below security files and logs as a bundle:

[DOMAINHOME]/bi/bilogs

[DOMAINHOME]/bi/config

[DOMAINHOME]/bi/servers

[DOMAINHOME]/bi/nodemanager

[DOMAINHOME]/bi/biupgrade

[DOMAINHOME]/bi/bin/setDomainEnv.sh

Collect a diagnostic bundle by running the following command:

[DOMAINHOME]/bitools/bin/diagnostic_dump.sh | .cmd [your path]/<zip file name>.

Click Enter

Archiving Catalog through Catalog Manager

Open Catalog Manager

Go to File and Click on Open Catalog

Provide the details below and click on ok

Type: Online

URL: http://hostname:9704/analytics/saw.dll?

User: weblogic

Password: ********

Locale: English

Click on Ok

Double click on Catalog Root and select the folder we want to Archive

Provide the path and select time stamps and permissions and click on ok

Click on OK

Archived catalog file

Code page mismatch Error While creating Informatica Integration Service

When trying to create informatica integration service, getting failed with below error:

Code page mismatch. Service process is running in code page [UTF-8 encoding of Unicode] whereas the service is configured in the Admin Console to run in code page [MS Windows Latin 1 (ANSI), superset of Latin1]

Click on View logs to check the error

Check for the Error message

Resolution:

To resolve this issue under Domain Navigator

Click on Integration Service

And then click on Processes

Select General Properties and click on Edit symbol

Change Code page value to Unicode as below and click on OK

Click on Properties

Restart the service

Click on OK

Issue resolved