Setting up Multiple OBIEE systems/Instances on 64-bit windows server 2003

2011-05-02T22:44:00.001-04:00

Installation and Configuration of the BI System can be found here. This is the continution and creation of another instance/BI system.

Generally, I see two ways of doing this, where we are not talking about clustering. Depending on the requirement and resource availability decide on the best approach.

- We can have a new instance of the BI system with in the same Oracle Home
(Two Instances)
- or We can do a complete new install of the BI system on the same server
(Two Oracle BI homes)

(we need to do a simple install on 32-bit system where as we need to do the software only install on 64-bit machines and then configure the system )
Based on your requirement and reqresource availability select the specific option. Both options go in almost same lines. So, here I am working on the First option on a 64-bit machine.

Pre-requisites :
Setting up BI schemas: you need to run RCU and deploy the schemas MDS and BIPLATFORM (with a different prefix) as we did for the other BI system, as the same schemas can’t be shared by two systems.

Ports Configuration: There are two ways to configure ports for new instance (as the existing system has the default ports in use we cant use them again)

1. Running the configuration Wizard for creating new BI System while the existing BI system is available. Make sure you have the other installed BI system up and running, that way BI system automatically increments the ports for the new system.
Note: All the services should be up and running along with presentation services.

2. Select ’specify ports using config file’ where you need to provide the system with staticports.ini file to declare the ports for new BI system.
You need to use the Staticports.ini file format supplied to the configuration wizard to specify specific ports.
Both these options are good and anyone can be followed. But in option 1, you dont have a way to specify any ports and configurationwizard automatically assigns them by incrementing or random selection based on availability.

Configuration steps for New BI System.

Start the configuration Wizard from exixting Oracle Home -> bin->config.bat command
Click next and when the Create or Scale out BI system option shows up, Click on Create BI system and then provide details as shown below…..

Make sure you click on "Create New BI System" and then enter the details as shown above for new BI system. Make sure you create a new domain (XXX_bifoundation_domain) apart from the existing domain. Click next..........

Here Leave the Middleware home and Oracle home and Weblogic server home same as the default values (previous install values) and for instance home and instance change default name to a custom name as shown above.
Click next
Review the products that you want to include in this BI system.

On the Database connection screen, give the details for database connection as shown above and also BIPLATFORM schema username and password which were created earlier (as described in the Pre-Requisite step) for this New BI system
(MERBI_MDS, MERBI_BIPLATFORM)
Click next to go to port configuration screen

****NOTE: On the port configuration, you have two ways of declaring the ports as discussed earlier so that there will no conflict between ports between two systems. Here I used the option 1, selecting the Auto port configuration, while I have all the existing BI services up and running.
After declaring the ports by any of the method stated above, continue by clicking next

Review and save the file if required which defines configuration for this New BI system.

Monitor the progress of the configuration as shown above....
Note: This configuration wizard will create different opmn windows service for different instances providing the flexibility to manage them separately.

After completion of the configuration process, click next.....

On the complete screen, review and save the post-configuration details screen as it holds the new ports and URLs for the new BI system. Click Finish to complete the configuration of the new BI System.
Issues: As of now, I noticed a scenario where two instances do not co-exist on the same webpage/client. And this is with all three Weblogic console, EM and Presentation services URLs.

Comments and Suggestions are welcome till next time...................

OBIEE 11G 64-Bit - Microsoft Windows 2003 R2 SP2 X64 Server Installation

2011-04-19T11:23:00.031-04:00

Guys
This is the detailed installation of OBIEE11G on a 64bit Machine. This is my first post, so let me know of any suggestions or questions.

Server Configuration
OS: Microsoft Windows 2003 R2 SP2 X64
Database: Oracle 11gR2 X64 (11.2.0.1)
Java JDK: Java JDK 6u24 X64 Windows and JRE 6u24 X64 Windows
Weblogic Server: WLS 10.3.3 X64 (Generic Version)
RCU: OFM RCU WIN 32 11.1.1.3.3 (available only in 32 bit)
OBIEE 11G: OBIEE 11g R1 x86-64 (11.1.1.3) - Software only install
OBIEE 11G Client Tools Install: OBIEE 11G client Tools Installation 32bit (It doesn’t have Catalog Manager)

****Install Microsoft Visual C++ 2005 SP1 Redistributable Package (x64) prior to the installation of Oracle BI on Microsoft Windows X64.
Java JDK 6u24 X64 Windows and JRE 6u24 X64 Windows installation steps
JDK and JRE are available at http://www.oracle.com/technetwork/java/javase/downloads/index.html
Run jre-6u24-windows-x64.exe
Choose the destination folder if required. After the successful completion of the installation close the window.

Now, Run jdk-6u24-windows-x64.exe

Click Next ....

If JDK comes with JRE, then no need of doing the first step. All the above shown features will be installed.
Change the destination folder for Java JDK (if necessary). Click Next.....

Click finish to complete the Java JDK installation. Also add the Java path in Environment Variables.

After the installation, you should have them available at the specified location on the drive as shown above.
Weblogic Server 10.3.3 X64 (Generic Version) installation steps
Product available at: http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html
Use Generic Version for 64-bit JVM support and is the supported installation for OBIEE 11
Prerequisite: For 64 bit operating systems, the Weblogic installation program does not install a JDK. Filenames for these installation programs end in .jar. To run these .jar programs, you must have appropriate version of JDK installed on your system, and include bin directory of JDK at the beginning of the PATH variable definition.

Before Starting the Installation:
- Create a Middleware_Home directory which holds all the weblogic server components along with the OBIEE components.
- The installation program uses the Temporary directory into which it extracts files that are needed to install the software on the Target System. By Default, installer uses the directory that is referenced by the TMP variable. If you do not have enough space to run the installation program you need to set the Temporary directory as described in Tale 2-2 of the Oracle Fusion Middleware Weblogic Server Installation Documentation.
URL: http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/prepare.htm#i1183981
- Do not include any spaces in the name of Middleware Home directory.
Weblogic Server Installation - Graphical mode
Run wls1033_generic.jar to start the installation

Click next on the Welcome Screen...

Select the new Middleware Home Directory (C:’MW_HOME)and Click Next.....
Click next to continue to next screen..........

Choose Typical Installation by default (or Custom installation for specific products) and click next.....

In this screen, as we are using Generic version where JDK and JRE are not bundled Browse for the Local JDK and select as shown above and click next...................

Choose product installation directories and click next.....
Note: It is recommended to have all the products within the Middleware home directory.

Select the All Users option and Click Next......

Review the Summary screen and Click Next..........

Installation progress screen.................

This completes the installation of Weblogic server. Check Run Quick start if you want to see some sample domains and online documentation.
OFMRCU WIN 32 11.1.1.3.3 installation steps
Run RCU from Windows 32-bit client for OBIEE 11G 64-bit installations
Open rcuHome -> bin -> rcu.bat file from 32-bit Windows Client

Double click to run it or open it from Command prompt

Click Next…..

Select CREATE and click Next…..

Provide the Database connection details for the server and Click Next…..

The screen above will provide the pre-requisite check and after its ‘operation completed’ dialogue click OK….

Select the prefix (default DEV) - MARBI
Select the Schemas that need to be deployed on the database (MDS and BIPLATFORM) as shown above.
The given prefix will be added to the Schemas as shown above.
Then Click Next……

Complete the Pre-Requisites checker and click ok…….

Provide the passwords for the schemas. It is recommended to have same password for both the schemas…. Click Next for Manage Table Spaces Screen…..

Click Next to create table spaces and deploy these Schemas……….click ok for any warnings/pop-ups….

Click OK to continue…….

Review the summary screen and click ‘CREATE’ to create the schemas….
Progress Screen….

This is the Summary Screen showing the completion of the creation of the Schemas on the database OBIEE. Click close to complete.
You can verify the schemas using the following command on server
SQL> SELECT username FROM all_users ORDER BY username;

Here we have the schemas MARBI_MDS and MARBI_BIPLATFORM.
OBIEE 11g R1 x86-64 (11.1.1.3) - Software only install Steps
Extract the whole OBIEE 11G 64bit Package to a location where the path doesn’t have any spaces as shown below

After Extracting the Zip files to a directory, Go to
$$BI11G$$’bi_windows_x86_111130_64_disk1_1of2’bishiphome’Disk1
and double click on Setup.exe to start the Universal installer.

This will bring the following screen.........

Welcome Screen....

Click Next to continue.......

On the Select Installation Type Screen Select "SOFTWARE ONLY INSTALL" Type and click Next........

On the above Pre-requisite checks screen, make sure everything passed without any errors. If an error message appears it is recommended to try to fix the error before proceeding further with the installation.
Note: Your Installation might not function properly if you continue the pre-requisite check screen errors or warning messages without resolving them......
e
Select the Oracle Middleware Home same as the Middle ware home where the weblogic server was installed and select the name for Oracle Home Directory for Oracle _BI installation.
By default Oracle Home Directory will be Oracle_Bi1, which was changed in the above installation to Oracle_MARBI. The Middleware Home is selected same as weblogic server home C:’MW_HOME.
Then Click Next.....
Specify My Oracle Account support account for security updates...

On the Summary screen, verify the details and save the response file (optional) and click Next to start the installation...

On the installation Progress screen, monitor the installation process and if you need to stop the installation, click Cancel.

Note: Provide the path for Disk 2,3,4 (disk1_2 of 2) location to continue with the install as shown below till ’stage ’. or it is always good to have all the discks copied into a single directory which doesn’t have any spaces.
Path: $BI11G$’bi_windows_x86_111130_64_disk1_2of 2’bishiphome’Disk2’stage

and do it for disk 3, disk 4 and continue with the installation...

After completing the SOFTWAR ONLY INSTALL....Click Next to continue for completion summary screen.........
Click Finish to Exit OBI11G installer and complete the installation.
This Completes the installation, and now we need to perform the Post installation tasks related to the Software only Install.
After Installation

Post - Installation Tasks:
Configuring Oracle Business Intelligence with Configuration Script
With Oracle Business Intelligence configuration script you can configure BI software that was installed through software only install.
Limitation: You cannot extend the domain using the OFM Configuration Wizard. You cannot add more OBI components to a existing BI domain using this Wizard. And also you cannot add OBI components to an existing domain created by Weblogic server or any other product.
****Pre-Reqs:
It is strongly recommended to use static IP address on the server. Check for these before starting the Configuration Wizard from Command Prompt:
nslookup hostname
nslookup hostname.domainname
nslookup IPaddress
Running Configuration Script:
Start the script from
ORACLE _HOME (BI HOME): ’’MW_HOME’Oracle_MARBI (Oracle_bi1)’bin
Run Config.bat command

Welcome screen for the Configuration Wizard..........Click Next....

Complete the pre-requisite check and click next......

On Create or Scale out BI system screen, click create new BI System and enter the
username: MARBI
Password: *****
Domain Name: MAR_bifoundation_domain
Note: Make sure no BI domain of the same name already exists.
as shown above and click next to continue........

On the Specify Installation Location Screen, All the values will be by default, (optionally Change them),
Instance Home: c:’MW_HOME’instances’MARBI
Instance name: MARBI (default: instance1)

On Configure Components Screen, Select the components that you want to be installed.
After you make selections.......click next........

On the Database details screen, Enter the database connection details as shown above.
Connect String format: Host:Port:Service_name
Enter the BIPLATFORM Schema username with prefix that you declared while setting up schemas and password. Click Next to continue...........

Configuration script automatically configures the ports, unless you want them to be configured manually using a configuration file such as Staticports.ini. Configuration Wizard automatically assigns Node Manager Port 9556 by default, unless specified.
Note: If configuring OBI in a shared Middleware where Node Manager is installed, OBI script uses the existing Node Manager and its Port Number.

Review the summary screen and save the file (optional). Click Configure to run the Configuration Script.

Monitor the Configuration process and check for any errors or warnings....
Click Abort to stop the configuration process.

ion of
This Screen Shows the completion of the Configuration process without any errors.

Complete Screen, Gives the details of the installed products and also the Configured components. Save this file for future review.
Go to the URL, Specified in the Configure components section above for Business Intelligence Enterprise Edition
http://Hostname:Port/analytics

Login with the Credentials that you entered earlier while setting up the Configuration Wizard for Username and Password. This will bring the following screen

Client Tools Installation
As we have noticed we don’t have any Client tools available with this installed BI System. Please refer to the Other document for the instructions on the installation of Client tools.
After the installation of the client tools either on the server or on the client (as the mater release of client tools package is made compatible with 64bit systems also) we need to create system DSN for the OBI server as follows

Click Add to add the data System DSN for server.

Select "Oracle BI server 1" and click finish. This opens a wizard to configure the DSN as follows.

Assign the values as given while doing the installation of the OBI server.

Choose relevant options. Make sure you provide the correct port number as available from the Configuration wizard details screen. (or saved file).

Here you have the option to select the default subject area, language, and regional settings and database. Select appropriate values. Click finish to complete the creation of system DSN.
Administration Tool:
Open the administration tool from Start -> Oracle Business Intelligence Enterprise Edition Plus Client -> BI Administration

Admin Tool
Provide the details for
Repository Password: Admin123 (default - for sampleAppLite)
User: MARBI (Admin User)
Password: Admin pass

Here we can see the Admin tool with online RPD for SampleAppLite.rpd.
Note: Please see the Client tools Document for the details regarding DSN changes that may need to be made for 64-bit systems and other client tool related topics.
This completes the installation of OBIEE 11G on Microsoft Windows 2003 X64 system.
****NOTE: you can install multiple OBIEE installs on a single server (into separate Oracle Homes). You just have to make sure the ports do not conflict and you have the appropriate OS resources (cpu/memory) and there are no port conflicts
Two ways to avoid port conflicts are:
Option1: Have env 1 running and when installing env 2 use autoport. It will detect used ports and increment
or option 2: use staticports.ini to manually configure ports

Additional Screenshots
ORACLE WEBLOGIC ADMIN CONSOLE
URL: http://venkat-62e03a94:7001/console

ORACLE BI Enterprise Manger
URL: http://Hostname:7001/em

Comments and Suggestions are welcome........ till next time.........

OBI SCRAPS

Setting up Multiple OBIEE systems/Instances on 64-bit windows server 2003

OBIEE 11G 64-Bit - Microsoft Windows 2003 R2 SP2 X64 Server Installation