Saturday, June 17, 2017

Vertically scaling the Java Host component in OBIEE 12c

You can change the number of Oracle Business Intelligence system components and managed servers to suit capacity requirements.

You should first configure shared files and directories for clustered components to use
1. Setting up shared files and directories
2. Set up global cache in em console

You can change the number of BI System components to suit capacity requirements.

Adding System Components:
You can add BI System Components to a computer when the system is stopped (offline).

You must have appropriate file system permissions.
Ports are allocated from the Oracle Business Intelligence port range, unless otherwise specified.
Supported system component types are OBIPS (BI Presentation Server), OBICCS (Cluster Controller), OBIJH (BI JavaHost), and OBISCH (BI Scheduler).
OBIS is not scaled out because OBIS instances are managed as part of service instances.
You can only create two instances each of the component types OBICCS, OBISCH (one active, one passive). Therefore, if it is required to add another instance on another host, then an existing instance must first be removed.

Steps for Adding a System Component OBIJH :

1.       Now browse to $ORACLE_HOME/oracle_common/common/bin and run command
$ ./

2. Under wlst prompt run the below commands to add a new system component
wls:/offline> connect('weblogic', 'password', 't3://localhost:9600')

3. Now Run edit and start edit commands

4. Now run the below command to create system component

5. Save and activate the changes with below commands

6. Now start the servers using

7. Login to em console and check for the newly created component


  1. Replies
    1. Syntax:

      domainHome = DOMAIN_HOME for the domain
      instanceId = BI Component Instance ID (e.g. obips1 or obis4 etc)



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