Integrate Discoverer 10g with Oracle Applications 11.5.10.2

High Level Steps
1> Install Infra Oracle Application Server, OID – Refer my earlier document
2> Install Middleware components including discoverer and portal
3> Upgrade the database of the infra from 10.1.0.4 to 10.1.0.5
4> Apply patch 5861907 to upgrade the apps server from 10.1.2 to 10.1.2.2
5> Connect to Discoverer viewer/Plus
6> Configure Discoverer Desktop and Discoverer Admin Edition on Windows XP
Assumptions
Server Name: linux1
Oracle Applications 11.5.10.2
Red Hat 4.0 – update 4
Vision Instance
Server Name: linux2 – Current Installation
Discoverer 10g (Infra and middleware)
Red Hat 4.0 – update 4
Install Middleware discoverer and portal
su – asmid
./runInstaller
cd /usr/app/oracleAS
chmod -R 777 oraInventory
Register with Oracle Internet Directory
Host:linux2.com
Port:389
welcome1
Instance Name: middemo1
Ias_admin_password=welcome1
Confirm password=welcome1
Upgrade the database of the infra from 10.1.0.4 to 10.1.0.5
Download the patch
Stop the middle tier components
Stop all the infra components
Apply database patch p4505133_10105_LINUX
Sqlplus “/as sysdba”
1. Enter the following SQL*Plus commands:
2. SQL> STARTUP UPGRADE
3. SQL> SPOOL patch.log
4. SQL> @?/rdbms/admin/catpatch.sql
5. SQL> SPOOL OFF
6. Restart the database:
7. SQL> SHUTDOWN
8. SQL> STARTUP
9.
10.Run the utlrp.sql script to recompile all invalid PL/SQL packages now
instead of when the packages are accessed for the first time. This step is
optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql
Apply patch 5861907 to upgrade the application server from 10.1.2 to 10.1.2.2
All infra components should be started including datatabase, OID
Upgrade application server from 10.1.2 to 10.1.2.2
Change the oracle_home accordingly – will need to toggle couple of times
Click ok
welcome1
welcome1
Oracle
Click ok
Apply the patch on middle tier
Check that all the services on the middle tier are stopped
su – asmid
./runInstaller
http://linux2.com:7777/pls/orasso – login using orcladmin/welcome1
http://linux2.com:7777/oiddas – login using orcladmin/welcome1
Click Directory
orcladmin/welcome1