Upgrading discoverer 4i to 10g for 11i

Upgrading oracle discoverer 4i to Oracle Application server middle-tier 10g discoverer Component for oracle applications 11i

As you all know oracle has de-supported oracle discoverer 4i on applications 11i, therefore all DBA's will have at some point to upgrade their discoverer from 4i to 10g.

Refer to note 313418.1 in order to do that upgrade, 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
cd /u07/discoverer_home/discoverer
(mkdir secure)

-cp the $FND_SECURE/.dbc , $FND_SECURE/_.dbc TO your $Disco_ORACLE_HOME/discoverer/secure directory.

-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.
$Disco_ORACLE_HOME/bin/eulapi -CONNECT /@ -AUTO_UPGRADE

-Set Applications Profile Options for Discoverer using AutoConfig
-open your xml file and specify variables as listed in the table below:
s_disco_standalone=true
s_disco_machine=for example: srpora03.us.oracle.com
s_disco_port=for example: 7778
s_disco_protocol=http https
s_disco_ver_comma=10,1,2
s_disco_eul_prefix=EUL

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

ICX_DISCOVERER_LAUNCHER=http://:/discoverer/plus?Connect=[APPS_SECURE]
ICX_DISCOVERER_VIEWER_LAUNCHER=http://:/discoverer/viewer?Connect=[APPS_SECURE]
ICX_DISCOVERER_RELEASE=10
ICX_DISCOVERER_USE_VIEWR=Y N
ICX_DEFAULT_EUL=EUL
ICX_DISCOVERER_EUL_LANGUAGE=US
ICX_DISCOVERER_PARAMETERS=exitURL=http://:/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

Note:
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).