Friday, February 8, 2013

Modifying OBIEE 11g configuration settings

OBIEE 11g has miltiple configuration files and stored redundantly in different location. Changing configurations manually through text editor can be challenging, and admins have to take care that setting are updated and in sync in all the locations. This is even worse if environment is set to be clustered or has redundancy built in.

A better way to manage configuration is through one of the following two tools:

- Fusion Middleware Control - Also called enterprise manager - this is a web based tool that allows OBIEE 11g monitoring and configuration of basic components, like cache, RPD deployment etc. Tool can be accessed using following URL:

http://localhost:7001/em

- Fusion Middleware Control MBean Browser - This is much advanced tool for modifying OBIEE server settings. It internally takes care of multiple instances of config files in diferent directories and redundant servers.

The Mbean Browser can be accessed from within the Fusion Middleware Control, by navigating as below:

Weblogic Domain > bifoundation_domain > AdminServer > Weblogic Server drop down > System Mbean Browser

To start modifying, first step would be to take an exclusive lock on settings by following link:

Application Defined MBean > oracle.biee.admin > Domain:bifoundation_domain > BIDomain > BiDomain > Operations > lock > invoke

After that, admins can make any necessary changes that are required, and hit 'Apply'. After all changes have been applied, it required to select Commit from same screen where lock was acquired. Fortunately we also have rollback option, incase we want to revert at last minute.

No comments:

Post a Comment