I noticed on Steven Chan’s blog that Discoverer 10g 10.1.2.2 is now certified with E-Business Suite 11i & R12 so I decided to extend his post further with key points around 10.1.2.2 patchset and where to find documentation related to upgrade from 10.1.2.X to 10.1.2.2
Things you want to know about “Oracle Application Server and Oracle Developer Suite 10.1.2.2″
1. 10.1.2.2 is available as patch 4960210 (1.7GB)
2. This is not base release which means this is not complete software but patchset hence you can only apply on existing 10g Application Server (Portal, Discoverer/BI, Forms & Reports) software. For list of version on which this patchset can be applied, check “Introduction” section of patch read me.
3. Infrastructure Database , DB listener and OID should always be running if you are apply this patch set. If you are using any component without OID & Infrastructure DB (like j2ee only or disco without SSO support ignore this point)
4. If you have disabled OC4J, you have to enable it before applying this patch & disable after applying this patchset.
5. Apply patch using runInstaller under Disk1 on Infrastructure tier (if you have one) and Middle tier. Middle Tier & Infra Tier should be in different ORACLE_HOME (These two ORACLE_HOME can be on single machine or different machines)
6. If Application server which you are planning to upgrade contain portal, upgrade portal repository manually. Go to ORACLE_HOME/portal/upg/plsql (Make sure you have already applied software update to this oracle_home by running runInstaller as mentioned in previous step)
6.1 Run portal Upgrade first in precheck mode ORACLE_HOME/portal/upg/plsql/patch.sh -precheck
6.2 If you don’t hit any issues during precheck mode, Then finally upgrade portal by running ORACLE_HOME/portal/upg/plsql/patch.sh
7. If Application server which you are planning to upgrade contain wireless, upgrade wireless repository as well manually.
8. If you are using Business Intelligence/Discoverer component of Oracle Application Server, check Section 9.5, 9.6, 9.7, 9.8, 9.9 & 9.10 section of patch read me file (4960210)
Related Documents
==================
1. Read Me of Patch 4960210
2. http://blogs.oracle.com/schan/2007/10/09#a2147
Popularity: 11% [?]







Good hands-on exercises (installation, patching, cloning), very experienced trainer worth for Money 
8 users commented in " Upgrade Oracle Application Server 10.1.X to 10.1.2.2 "
Follow-up comment rss or Leave a TrackbackGreat additional notes, Atul. I look forward to reading about your experiences with this latest release.
Regards,
Steven Chan
Thanks for your comment
Atul
Dear Mr Steven
We have Discoverer 4i. We are not able to load in Win Vista PC. We get the following error message. Please help us.
Error message
While installing Oracle Discoverer Adminstrator and Desktop version
4.1.46.08 in windows vista os, error displed as “Smart heap error handler
recursively re-entered”
regards
P.Muthumaanickam
Check Bug No. 5845761
Atul
how to connect to server remotely?
location of pid file?
Hi,
I am trying to upgrade Oracle AS 9.0.4.3 to Oracle AS 10.1.2.0.2. When i do the upgrade on database portal schema, it failed as follows
./upgrade -precheck went successfully and there is no issue on SVU. But, the actual upgrade ./upgrade failed as follows ..
Any idea about this one
Solaris 5.9
Oracle DB : 10.1.0.5
Middleware,OID upgrade successfully
PORTAL failed as follows …
>>> Running upg/common/posttrge/siteptl.sql .
Portal SQL script started at Tue Apr 8 13:58:29 2008
Connected.
# Beginning outer script: common/posttrge/siteptl
—- Register Oracle Instant Portals Provider —-
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at “PORTAL.WWPRO_API_PROVIDER_REGISTRY”, line 402
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at “PORTAL.WWERR_API_EXCEPTION”, line 164
ORA-06512: at “PORTAL.WWPRO_PROVIDER_REG_PRIVATE”, line 1884
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at “PORTAL.WWPRO_API_PORTLET_REPOSITORY”, line 409
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at “PORTAL.WWERR_API_EXCEPTION”, line 164
ORA-06512: at “PORTAL.WWSBR_PORTLET_FOLDERDB”, line 2113
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at “PORTAL.WWSBR_PORTLET_FOLDERDB”, line 1694
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at “SYS.OWA_UTIL”, line 328
ORA-06512: at “SYS.HTP”, line 1322
ORA-06512: at “SYS.HTP”, line 1397
ORA-06512: at “SYS.HTP”, line 1689
ORA-06512: at “SYS.HTP”, line 150
ORA-06512: at “SYS.HTP”, line 154
ORA-06512: at “PORTAL.WWUI_API_STATUS”, line 31
ORA-0
Hi Atul,
In oracle application server , we generally see customer having both IAS DB and Infra DB.
Though IAS DB is optional , can you please tell me for what it is used and what exactly it is ?
Regards,
Ashwin
@Ashwin
For OAS (Oarcle application Server) 10.1.2.X and lower, There are three kind of middle tier
1. J2EE and Web Server
2. Portal & Wireless
3. Forms & BI
for first one (J2EE and Web Server) Infra DB is option where as for 2) & 3) infra DB is must .
Infradb is repository for Users, Groups and single sign-on .
iASDB is repository for user data.
Leave A Reply