Oracle VM Templates – Oracle Business Intelligence Enterprise Edition 10.1.3.4.0 (http://bit.ly/eEyEyW)
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
Navigate to ‘<MIDDLEWARE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1’
select ‘Install this deployment as an application’ (default)
Under ‘Source accessibility’
Choose ‘I will make the deployment accessible from the following location’
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/’
When I was trying to export a schema out of an Oracle Database; 10g Release 10.2.0.1.0.
After a while I was faced with the following error; “EXP-00056: ORACLE error 932 encountered”
After a little bit of Googlin’ I found a solution on the Oracle OTN Forum. Thanks to ‘slappyjam’ I was able to solve my problem.
** Solution **
Run following scripts while connected as SYS user:
SQL> connect / as sysdba SQL> @?/rdbms/admin/catmetx.sql SQL> @?/rdbms/admin/utlrp.sql SQL> exit
The export ended succesfully; “Export terminated successfully without warnings”
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;
Choose to upgrade the RPD and the Presentation Catalog.
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
Provide the details (port and credentials) of your Weblogic server
If everything has been provided well so far the status will be ‘succeeded’
The summary shows the details. Now you are ready to upgrade.
If everything runs like expected, the status will be ‘succeeded’
You are finished.
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;
- 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.
- 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.
In a few days time, the new 11g version of Oracle BI EE will be launched commercially. Still John Minkjan wants to spent some time playing around with the 10g version.
If you like a challenge and some competition please join!
I will be one of the judges, so I am looking forward to your contributions.