How are OBIEE Metadata files stored ?

The metadata for an OBIEE Instance is stored both as Database tables and as Physical files.

Metadata in Database tables are stored in the Metadata Schema's

MDS (Metadata Services Schema)

BIPLATFORM 

The Physical metadata files for OBIEE are the

• Repository (RPD)
• Catalog Files

The repository file can be found at the following location and will have the extension .rpd. 

MW_HOME/instance/instance1/config/OracleBIServerComponent/coreapplication_obips

The currently active RPD name can be checked from EM or from the instanceconfig.xml file. The repository file contains the details of Physical Tables, Physical and logical mappings, Presentation tables etc. 

The catalog files are located the physical directory below,

MW_HOME/instance/instance1/config/OracleBIPresentationServiceComponent/coreapplication_obips1

The catalog contains Metadata for reports,prompts, dashboards etc and their permissions. The physical directory for the latest catalog displayed can be found from the EM.

What is OPMN and it's functions ?

OPMN stands for Oracle Process Management and Notification System that acts as a management service for different oracle components. In an OBIEE instance, the OPMN is responsible for controlling the different Oracle BI 11g components.

Functions of OPMN are the following

• Start and stop the OBIEE components separately or at once. 

Oracle BI 11g system components

• Restart an OBIEE component upon failure.

The different Oracle BI components that OPMN works on are the following

1. BI Presentation Services
2. BI Server
3. BI Schedulers
4. BI Cluster Control
5. BI JavaHosts

The OPMN batch file can be accessed from the below location from the Middleware Home folder.

FMW_HOME/instances/instance1/opmnctl.bat

You perform the following operations using the opmnctl batch file,

1. Start All
2. Stop All
3. Start Procedure
4. Restart Procedure 
5. Stop Procedure
6. Status

eg CMD scripts:

• Start all - opmnctl startall
• Stop all - opmnctl stopall
• Startproc - opmnctl startproc ias-component=OracleBIServerComponent
• Restart process - opmnctl restartproc ias-component=OracleBIServerComponent
• Stop process - opmnctl stopproc ias-component=OracleBIServerComponent
• Status - opmnctl status You can also invoke the OPMN services from Enterprise Manager.

Oracle 11g: Get a list of all Indexes defined for table/schema

This is how you can get a list of all indexes defined on a particular table or the number of indexes on tables inside a particular schema.

For a particular table,

SELECT * FROM ALL_INDEXES WHERE TABLE_NAME='YOUR_TABLE_NAME'

For a particular schema,

SELECT * FROM ALL_INDEXES WHERE TABLE_OWNER='YOUR_SCHEMA_NAME'

Find folder paths of $PM Informatica variables

This is where you can find the paths of $PM variables used in Informatica.

Log in to Informatica Administration console and go to the Integration service you are using. In the Integration service go to Process and you will be able to all the paths.

Informatica Administration Console > Integration Service > Process

[Solved]Informatica Integration service initialization failed - SF_34004 and LM_44229

We were facing the below error while trying to create and configuring a new Integration service for Informatica 910.

We checked the log and found that the error was because of the credentials provided. We had used the Informatica Repository Schema username and password instead of the Informatica Administrator password.

Go to Integration service > Associated Repository and correct the username and password. 

Once you have changed the password, Re-enable the integration service.