Installing Oracle BI 11g R1 – Windows Server 2008 R2 64bit

Recently I did an installation on a Windows Server 2008 R2 64bit. Reading through the documentation made me realize that it’s not possible to do a ‘Enterprise Install’. Check the following part in the manual:

1.4.3 Software Only Install

The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment. This install type is required to install Oracle Business Intelligence on an AIX operating system or with a 64-bit JVM, such as on a supported 64-bit operating system.”

Th following could be a guideline to install Oracle BI 11g on Windows Server 2008 R2 64bit:

Install RCU –> rcuHome\BIN\rcu.bat
Install JDK 64bit
Install Weblogic generic –> via the Command Line java -jar wls1033_generic.jar
Install Oracle BI11g –> ‘Software Only’
Run config.bat to configure Oracle BI11g –>C:\Oracle\Middleware\Oracle_BI1\bin\config.bat

Of course you need to check the manual for additional info. Next to that you have to perform a ‘Software Only’ install on 32bit machine to be able to use your client tools.

Check My Oracle Support for more details.

Deploy Custom content folder location in WLS

In an earlier post I ended up with problems with custom folders in Oracle BI 11g R1. It turned out that I had to make some additional steps to deploy a custom folder in the Weblogic Server. Thanks to the documentation of the SampleApp I was able to make this work.

I have been working on a demo. Therefore I have created an index site with links to custom images and custom documentation. When I migrated this demo from 10g to 11g, I had to copy the images and documents manually. This seemed not to be enough. I ended up with some red crosses.

You have to take the following steps to deploy custom folders to the Weblogic Server.

Login to the Weblogic Server
Navigate to te Deployments
Click on ‘Lock & Edit’ in the left pane to enable the ‘Install’-button


click ‘Install’

Navigate to ‘<MIDDLEWARE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1’

select ‘analyticsRes’
click ‘Next’

select ‘Install this deployment as an application’ (default)
click ‘Next’

Select ‘Deployment targets’
Choose ‘bi_server1’
click ‘Next’

Under ‘Source accessibility’

Choose ‘I will make the deployment accessible from the following location’
click ‘Finish’

Check the ‘Deployments’ to see whether the ‘analyticsRes’ is available.

click on ‘Activate Changes’

start the deployment; ‘analyticsRes’

Now I am able to add the required images and documents in custom folders just by referencing to the  ‘analyticsRes’- folder, eg.; ‘/analyticsRes/Documents/’

Upgrading from 10g to 11g (Repository and Webcat)

When I had installed the Oracle BI 11g R1 version, I thought it would be nice to see what happened when I migrate a simple 10g Repository and Catalog to 11g.

Migrating from 10g to 11g seems very straight forward.

Navigate to <MIDDLEWARE_HOME>\Oracle_BI1\bin\ and start ‘ua.bat’

You are presented with the following screens fill in the required values according to your site’s needs;

click ‘Next’

Choose to upgrade the RPD and the Presentation Catalog.

click ‘Next’

Choose the location of  the RPD file you want to migrate.
Fill in the credentials

In 11g you have to provide an additional password for your RPD.
Fill in the credentials

Choose the location of your catalog
Choose the Deliveries directory

click ‘Next’

Provide the details (port and credentials) of your Weblogic server

click ‘Next’

If everything has been provided well so far the status will be ‘succeeded’ 

 click ‘Next’

The summary shows the details. Now you are ready to upgrade.

click ‘Upgrade’

If everything runs like expected, the status will be ‘succeeded’ 

 click ‘Next’

You are finished.

click ‘Closed’

For some more/other details, please refer to Venkat’s post.

You can now check the ‘Enterprise Manager’. There you will see that the newly created Repository and Catalog are ‘active’.

In the end it seems that most of the functionality has been migrated succesfully to 11g. Two ‘major’ problems I experienced immediately;

  1. I used some custom folders in 10g. In 11g you have to take some additional steps to make custom  folders available. I will cover this topic in a next post.
  2. I used a ‘Narrative View’ with; ‘ ‘. This doesn’t work for all HTML Markup. It does work in the ‘Static View’. I do not have a solution for that yet.