Upgrade Oracle Application Server 10.1.X to 10.1.2.2

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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

11 comments
Steven Chan says October 10, 2007

Great additional notes, Atul. I look forward to reading about your experiences with this latest release.

Regards,
Steven Chan

Reply
Atul says October 10, 2007

Thanks for your comment

Atul

Reply
P.Muthumaanickam says January 21, 2008

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

Reply
Atul Kumar says January 21, 2008

Check Bug No. 5845761

Atul

Reply
rudra says February 23, 2008

how to connect to server remotely?
location of pid file?

Reply
kal says April 10, 2008

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

Reply
asiyer says June 9, 2009

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

Reply
Atul Kumar says June 9, 2009

@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.

Reply
sanjeev kumar nanda says November 13, 2012

Hi Atul,

Can you tell me for applying patch in 10g Application server we have to use opatch or adpatch.

Regards
Sanjeev

Reply
Atul Kumar says November 14, 2012

@ sanjeev kumar nanda,
ADPATCH is for Oracle E-Business Suite patches. For Technology Stack (Tech Stack) patches like 10g AS or Databases you use opatch

Reply
rahil says December 4, 2012

HI

i have 20 forms & 30 reports developed in 6i developer version, i want to upgrade this forms & reports in to advance version (10g or 11g) in EBS.
how can i do? & which version is best to upgrade?
please give me brief knowledge or step by step methods.

Thanks in Advance
Rahil

Reply
Add Your Reply

Not found