As you all know oracle has de-supported oracle discoverer 4i on apps 11i, therefore all DBA's will have at some point to upgrade their discoverer from 4i to 10g. Below are the steps I used to do that.
Kindly note that you have to refer to note 313418.1 in order to do that upgrade and not to my posts, my post will just give you a direct hint on what to do.
Steps are as follow based on note 313418.1:
-Install Oracle Business Intelligence Server 10g Release 2 (10.1.2.0.2). This installation type does not require installation and association to Oracle Application Server 10g Release 2 (10.1.2.0.2) Infrastructure. (You can choose this option if you are not planning to use features Discoverer Connection Management, Discoverer Portlet Provider, and Oracle SSO).
- Create secure directory under $Disco_ORACLE_HOME/discoverer
-cp the $FND_SECURE/
-Update tnsnames.ora file in $Disco_ORACLE_HOME to include connect to your Oracle E-Business database Use the same entry as exists in the tnsnames.ora file on your Oracle E-Business application tier server node.
-Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.
-Set Applications Profile Options for Discoverer using AutoConfig
-open your xml file and specify variables as listed in the table below:
After that you have to run autoconfig
-Verify Applications profile options in Oracle Applications
Log into Release 11i with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.
Verify the following ICX profile options in Oracle Applications
When you open the discoverer EUL using the Discoverer 10g Desktop/Admin it will ask you if you want to upgrade your EUL and you have to choose yes.
To start/stop the new discoverer do the following:
$Disco_ORACLE_HOME/opmn/bin/opmnctl stopall (to stop).
$Disco_ORACLE_HOME/opmn/bin/opmnctl startall (to start).
If you have any question please leave at comments part