Tuesday, November 10, 2009

Discoverer 4i to BI Discoverer 10g Migration

Oracle Corp. recently(one year back) decommissioned it's discoverer 4i and it's previous versions.
This triggered many companies to upgrade from Old versions of Discoverer to Discoverer 10g.
Some time back, I got an opportunity to lead such kind of project with one of my clients.
The objective of this paper is to upgrade the discoverer to the latest supported version.

This paper covers the following topics
Installation and configuration of Oracle Application Server 10g on apps environment
Application of required patches.
Import of existing reports into Discoverer 10g.

Important Notes:
1. Discoverer 10 can be implemented in two models.
a. Standalone Installation
b. Oracle 10g AS with Infrastructure

My client selected "Standalone" method. So my and papers talks about - Standalone, but not Oracle 10g AS with Infrastructure

2. Some companies use Noetix views and many companies may not have implemented Noetix.
a. If your client is not using Noetix views, you can ignore the step - "Noetix Upgrade" in this paper.
b. In my project, it involved Noetix upgradation also.

Steps In Brief
Noetix Upgrade [Optional]
Application Patches
Oracle Bi 10g Installation And Configuration
Configuration With E-Business 11i
Port Information
Patch Application On Oracle Bi 10g
EUL Migration
Pre-Installation Tasks
DB Schema Creation And Import
EUL Upgradation
Post-Installation Tasks
Audit Trail Reports
Rollback Plan

Follow complete documentation at the link below.

http://www.apps2fusion.com/at/40-cm/208-discoverer-4i-to-discoverer-10g-migration-steps

Write to me if you have any questions.


5 comments:

oraclefusion said...

Thanks for sharing the useful information about the oracle topic and really worth reading good points were stated in the blog for more information visit
CALFRE

oraclefusion SCM said...



it is informative blog.
Thanks for sharing such a wonder full information.
oracle fusion SCM on line training


oraclefusion H CM said...

This is very interesting blog .Thanks for sharing such a blog.


oracle fusion HCM on line training

ERP said...
This comment has been removed by a blog administrator.
Unknown said...
This comment has been removed by a blog administrator.