Translate

Tuesday, 6 March 2012

Shahed

OBIEE 11.1.1.6 Installing BI Composer

Installing and Configuring BI Composer

You install BI Composer for an Oracle Business Intelligence installation by extending the Oracle WebLogic Server domain to include the BI Composer application and the BI Composer run-time implementation shared libraries, and by configuring the instanceconfig.xml file on the installed computer and on any scaled-out computers. The Oracle Fusion Middleware Configuration Assistant does not create a new domain for BI Composer. Rather, the Oracle Fusion Middleware Configuration Assistant adds BI Composer components to the WebLogic Server domain that you specify.

High Level installation steps

1. Stopped all BI services.

2. Extended BI domain with the oracle.bicomposer_template_11.1.1.jar template by invoking the config wizard in wlserver_10.3\common\bin.
The documentation had some issues through in this step as It says to skip some screens like 'Configure JDBC Data sources'. I noticed that the screens were populating wrong values and there were validation errors also when I try to skip it without correcting. So I had to correct these details before I went ahead.

3. Modifying the instanceconfig.xml to add the tag
<BIComposer>
<Enabled>true</Enabled>
</BIComposer>

4. Starting all the services .

5. Changing the preferences through MyAccount to use BIComposer instead of Editor.


Detailed Steps 11.1.1.6.2 +


Stop all OBIEE Services

$MW_HOME/instances/instance1/bin/opmnctl stopall
$MW_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1

ps -ef |grep Node|grep nodemanager |cut -c10-15

This will show the Node Manager process. Write down its PID. Then execute:

kill <NodeManager_PID>

$MW_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh


Once all services are stopped we want to launch the Config Wizard for OBIEE to extend the weblogic instance and add the BI Composer Template

So navigate to : $MW_HOME/wlserver_10.3/common/bin

Here you need to execute the config.sh file for Linux or config.exe for windows

We are on Linux so will render the GUI using xming on local pc.

To Render Graphics to Local PC
------------Start
1. export DISPLAY=169.12.19.999:0.0
2. /usr/X11R6/bin/xhost
------------ End

This will launch the Fusion Middleware Configuration Wizard




Click Extend an existing Weblogic Domain anc click Next

Select $MW_HOME/user_projects/domains/bifoundation_domain folder which has a different looking icon. Click Next

Click Entend my domain using an existing extension template
Browse:
MW_HOME/Oracle_BI1/common/templates/applications/
oracle.bicomposer_template_11.1.1.jar

Click NEXT

Nothing needed here just click Next

Nothing needed here just click Next


Dont click anything apart from Next.....


Click Extend.

Click Done.

Thats the GUI part done.

Now just 1 more setting needed in the instanceconfig.xml ( add the below setting between the server instance tags like below. for Versions below 11.1.1.6.2 . Change value from false to true

File Location:
$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml


<BIComposer>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<Enabled>true</Enabled>
</BIComposer>


Start All services
 
Then login to OBIEE goto My Account and


Login to OBIEE Application.
 
Go to My Account and click on Wizard(limited functionality)
under Analysis Editor option.


Older OBIEE 11g instances Detailed Steps

To extend an Oracle WebLogic Server domain by including the BI Composer application, the BI Composer run-time implementation shared libraries, and configuring the instanceconfig.xml file:

1.   Stop the Oracle Business Intelligence components using Fusion Middleware Control.

2.   Stop the Managed WebLogic Server.
The system will not include a Managed Server if the Simple Install type was selected during installation.
o   On Windows, open an MS-DOS window and change the directory to MW_HOME\user_projects\domains\bifoundation_domain\bin. Then, run the following command (which requires the administrator user name and password), for example:
o    stopManagedWebLogic.cmd bi_server1 http://:7001
You can also stop the Java components from the MS-DOS window in which they were started, if you press Ctrl+C.
o   On UNIX, open a shell prompt and change the directory to MW_HOME/user_projects/domains/bifoundation_domain/bin. Then, run the following command (which requires the administrator user name and password), for example:
o    ./stopManagedWebLogic.sh bi_server1 http://:7001
You can also use the process termination command for the operating system in use (for example, kill on UNIX). Java indicates on the console window that it is shutting down when it receives a shutdown signal.
3.   Stop the Oracle WebLogic Server.
o   On Windows, use one of the following methods:
§  Display the Start Menu, click All Programs, Oracle WebLogic, User Projects, and bifoundation_domain.
Select the Stop Admin Server for WebLogic Server Domain menu option.
An MS-DOS window indicates the progress of the processing steps of stopping the Administration Server.
§  Open an MS-DOS window and change the directory to MW_HOME\user_projects\domains\bifoundation_domain\bin. Then, run the following command (which requires the administrator user name and password):
§  stopWebLogic.cmd -stop
You can also stop the Java components from the MS-DOS window in which they were started, if you press Ctrl+C.
o   On UNIX, open a shell prompt and change the directory to MW_HOME/user_projects/domains/bifoundation_domain/bin. Then, run the following command (which requires the administrator user name and password):
o    ./stopWebLogic.sh
You can also use the process termination command for the operating system in use (for example, kill on UNIX). Java indicates on the console window that it is shutting down when it receives a shutdown signal.
4.  

5.   Start the Oracle Fusion Middleware Configuration Wizard.
Start the Oracle Fusion Middleware Configuration Wizard from the bin directory in the MW_HOME (default folder name is Middleware_Home):
UNIX commands:
cd MW_HOME/wlserver_10.3/common/bin
./config.sh
Windows commands:
cd MW_HOME\wlserver_10.3\common\bin
config.exe
6.   Select the Extend an existing WebLogic domain radio button.
7.   Select a WebLogic Domain Directory.
For example, select:
MWHOME/user_projects/domains/bifoundation_domain
8.   Click Next.
9.   In the Select Extension Source page select the Extend my domain using an existing extension template radio button.
10. Click Browse and then select the oracle.bicomposer_template_11.1.1.jar file in the following location:
MWHOME/BI_HOME/common/templates/applications/oracle.bicomposer_template_11.1.1.jar
11. Click OK.
12. Click Next to display the Configure JDBC Data Sources page.
You do not need to select any options on this page.
13. Click Next to display the Test JDBC Data Sources page.
You do not need to select any options on this page.
14. Click Next to display the Configure JDBC Component Schema page.
You do not need to select any options on this page.
15. Click Next to display the Select Optional Configuration page.
You do not need to select any options on this page.
16. Click Next to display the Configuration Summary page.
17. Click Extend.
18. Click Done when the process is complete.
19. Stop the Oracle Process Manager and Notification Server (OPMN).
a.            Go to the following directory that contains the OPMN command-line tool:
ORACLE_INSTANCE/bin
b.           Run the following command:
opmnctl shutdown
Stops OPMN and all Oracle Business Intelligence system components.
20. Add the BIComposer element to the Presentation Services instanceconfig.xml file.
 .             Open the instanceconfig.xml file for editing.
Note that if you scale out, you must also update the instanceconfig.xml file on the scaled out computer.
For example, on UNIX:
MW_HOME/ORACLE_INSTANCE/instancen/config/OracleBIPresentationServicesComponent/bi_component_name
For example:
/mw_home/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1
a.            Search for the ServerInstance section, in which you must add the BIComposer element.
b.           Include the elements as shown in the following example:

<ServerInstance>
.
  <BIComposer>
     <Enabled>true</Enabled>
  </BIComposer>
</ServerInstance>
       
21. Save the instanceconfig.xml file.
22. Start the Oracle WebLogic Server.

23. Start the Managed WebLogic Server.
The system does not include a Managed WebLogic Server if the Simple Install type was selected during installation.
o   On Windows, open an MS-DOS window and change the directory to MW_HOME\user_projects\domains\bifoundation_domain\bin. Then, run the following command (which requires the administrator user name and password), for example:
o    startManagedWebLogic.cmd bi_server1 http://:7001
o   On UNIX, open a shell prompt and change the directory to MW_HOME/user_projects/domains/bifoundation_domain/bin. Then, run the following command (which requires the administrator user name and password), for example:
o    ./startManagedWebLogic.sh bi_server1 http://:7001
o   
24. Start the Oracle Process Manager and Notification Server (OPMN).
 .    Go to the following directory that contains the OPMN command-line tool:
ORACLE_INSTANCE/bin
a.   Run the following command:
opmnctl startall
Starts OPMN and all Oracle Business Intelligence system components.
25. Start all Oracle Business Intelligence components using Fusion Middleware Control.

26.  (Optional) Display the Oracle WebLogic Server Administration Console.
27. (Optional) In the left pane, click Deployments.
The BI Composer application and shared libraries will be visible as follows:
o   bicomposer (11.1.1)
o   oracle.bi.composer (11.1.1,11.1.1)
o   oracle.bi.jbips (11.1.1,11.1.1)
Note that the stub libraries oracle.bi.composer (11.1.1,11.0.1) and oracle.bi.jbips (11.1.1,11.0.1) will always be present, but must not be confused with the deployed libraries shown above.

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts