Oracle Apps 11i with Database 10g R2 10.2.0.2

Database 10G Release 2 is now certified with Oracle Apps 11i , so today I am writing on overview of Upgrading your 8i, 9i database to 10.2.0.2 . For exact steps follow Metalink Note ID mentioned at bottom of this page.

Few Things you should note before starting database Upgrade with Apps 11i
1. Database 10.2.0.2 is currently certified only with 11.5.9 and 11.5.10 ; If you want to know which Apps version you are currently on ; check question “how to determine apps version”
http://www.teachmeoracle.com/interview10.html
2. As of date 27Aug2006 only 10.2.0.2 is certified in Database 10g R2 family .
3. If you are using Portal 3.0.9 with Apps 11i , portal 3.0.9 is not certified with 10gR2 so you have to upgrade Portal to 10g Application Server. (First configure 10G Application Server for Portal)
4. Base release of 10gR2 is 10.2.0.1 so first you have to Install 10.2.0.1 & then apply patchset 10.2.0.2 which is certified with Apps 11i (11.5.9 & 11.5.10)
5. Use natively compile PL/SQL code , Though metalink note mention its optional but 11i Initialization parameter says its mandatory parameter (I’ll confirm it once I go to init paramateres with 10.2.0.2) and for better performance use Native Compilation.

Why should I upgrade 11i database to 10.2.0.2 ?
-New features in 10.2.0.2
-Bug fixes from 9.2.0.6 or 10.1.x database

From which database versions direct 10.2.0.x supported ?
You can upgrade directly to 10.2.0.1 from following database version
8.1.7.4 , 9.2.0.4 or higher, 10.1.0.2 or higher

Where can I get 10.2.0.1 software & 10.2.0.2 patchset ?
–You can download 10.2.0.1 software from http://www.oracle.com/technology/software/products/database/oracle10g/index.html
You need companion CD as well so download companion CD as well from above location.
–10.2.0.2 is available as patch 4547817 which you can download from http://metalink.oracle.com or updates.oracle.com

Related Metalink Notes
These notes will be helpful during your 10.2.0.2 database Upgrade for Oracle Applications 11i.
–362203.1 Oracle Applications Release 11i with Oracle 10g Release 2
–216205.1 Database Initialization Parameters for Oracle Applications 11i

About tips to reduce downtime & other critical things during 10g R2 database upgrade with 11i, I’ll update tomorrow.

Leave your comments about this or any other post as well about look and feel of site as compared to previous look and feel.

Atul Kumar
Oracle Apps 11i DBA

Share This Post with Your Friends over Social Media!

About the Author AppsDBA

Leave a Comment:

34 comments
Anonymous says August 31, 2006

Hi Atul
Thanks,
Expecting more on this topic as soon as your time permits.
Wish you all best
Regards
KK

Reply
Atul Kumar says August 31, 2006

Sure KK,
I’ll do it tonight.

Atul

Reply
TJ says September 12, 2006

Hi
after you upgrade db to 10.2.0.2,
there will be an rapid clone error of on dbTier.It seems to be an bug.
Therefore when you clone dbTier, you better not use ‘dbTier’ option, but use ‘dbTechStack’ option to clone engine and manually create database with creating controfile.
cheers
TJ

Reply
Atul Kumar says September 12, 2006

TJ,
Thanks for sharing this with all of US. I suppose there is workaround available by changing one of template file , I’ll update you with more info on this soon.

Atul

Reply
TJ says September 12, 2006

Hi Atul
I have modified some template files,adlnkoh.sh etc, but error not fixed.
pls update this when you figure it out and hope we can share knowledge on APPS each other via your blog
cheers
TJ

Reply
Atul Kumar says September 12, 2006

TJ,
In my Instance changing tepltae file fixed issue . I’ll check it again & get back on this comment section in a day or two .

Atul

Reply
Arunkumar says October 18, 2006

Atul,
Can you elaborate more on this issue and the solution to fix it?
Thanks,
Arun

Reply
Atul Kumar says October 18, 2006

Arun,
Check Metalink Note 372256.1
perl adcfgclone.pl dbTier” failed on adlnkoh.sh Error: /lib/stubs/libc.so.tmp not found

because

Script adlnkoh.sh version 115.24 is not 10gR2 ( 10.2.0.X) compliant

Fix & symtoms are in note

Atul

Reply
Anonymous says November 13, 2006

Atul,

U said above that companion cd is also neede. What is the use of companion CD.
just we need 2 CD’s
(1) 10.2.0.1
(2) 10.2.0.2 patch set ..

Regards
Subbu

Reply
Anonymous says November 13, 2006

Hi Atul,

Above u said that, for 10g upgradation, Companion CD is required. will it be needed?
Only 2 are needed

(1) 10.2.0.1 CD

(2) 10.2.0.2 Patch Set

Regards
Rao

Reply
Anonymous says November 13, 2006

Hi Atul

For 10g Upgradation, Comapanion CD is required?

I think for metalink 2 are needed

(1) 10.2.0.1 CD

(2) 10.2.0.2 Patch Set

Regards
Rao

Reply
Atul Kumar says November 13, 2006

Yes Rao,
You need companion CD apart from 10.1.0.1 software & 10.1.2.0.2 patch

Atul

Reply
Atul Kumar says November 13, 2006

Subbu,
I don’t know if other Updates are alos your but Companion CD is required for

Knowledge Base & Ultraseach .

Atul

Reply
lac says November 29, 2006

Atul,
I am a new bee in oracle DBA. I have a doubt in applying archived redo logs.
1. We have our test database is running in archive log mode(for testing purpose)
2. Every day we take closed completed cold backup in the night
3. We are testing the recovery scenario in this database
4. For example at 12p.m we had some failures and we have decided to restore the database from previous night backup and apply the archived log files.
5. How can i achieve this?
a. Assume that there were arch1 – arch25 archived log files from yesterday. When the database is backed up yesterday night the last log was arch20 and the archived logs also got backed up upto arch20.
b. After that arch21,22,23,24,25 got generated until 12.pm today
c. current online log(at the time of failure) is arch25.
d. when restored from the backup i restored all datafiles,control files not redo logs(should not overwrite the online redo logs).
Now my question is:
1. What option i should use to recover my database? since my online logs are more recent than the control file .
2. After recovery how to apply the archived logs to make it complete recovery .
If i am confusing you, can you give me the clear picture of how to recover database from cold backup + applying archive logs up to the point

Reply
Atul Kumar says November 29, 2006

Iac,
I can understand what you are saying . When you say you had failure at 12PM what kind of failure is that ?

Do you have control file at 12 PM , time at which database failed ?

If yes then you use that control file to start backup server . AS controlfile recognize that datafile header (from previous night backups)are not matching with number in control file then your database will prompt your for recovery & it will ask you for archives/redo’s from 21 to 25.. provide these to database (You might miss online redo logs depending on if you have backup of those or not)

For more info on backup scenario check

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm

Reply
Anonymous says December 5, 2006

After 10gR2 upgrade, we encounter a lot of performance problems.
setting OPTIMIZER_FEATURES_ENABLED=9.2.0. improves the performance, but of course we wouldn’t want to do that.
Simple query:
select count(*) from dba_segments,dba_tables where segment_type = ‘TABLE’
and table_name = segment_name
and dba_segments.owner = dba_tables.owner;

Thanks!

Reply
Atul Kumar says December 5, 2006

Hi anonymous ,
Thanks for sharing this ifno with us . Could you please confirm if this is with apps & you have followed init file for 10g with Apps properly.
We also had this issue in past & later found one init parameter was wrongly configured .

Atul

Reply
Anonymous says December 13, 2006

Atul,

I am lac, This is the continuation of my previous post abt recovery. We have used “recover database using backup control file” and applied the archived logs from 21-25 + online redo log. Now when i try to open the database i am forced to use resetlogs. I know this is going to clear the current log and reset the archive log numbers to 1. We dont want to reset the logs. Can you please explain here how to continue with the archive numbers like 26,27… after recovery of database.
reg
lac

Reply
Atul Kumar says December 13, 2006

Iac,
There is very good explanation on this by Eric at

http://esemrick.blogspot.com/2006/02/backup-control-files-are-they-special.html

Regards
Atul Kumar

Reply
Anonymous says January 4, 2007

Atul,
I am following up your document for upgrading the database from 9.2.0.6 to 10gR2 on 11.5.10 .
1. I have downloaded oracle 10g 10201_database_linux32.zip from metalink
2. Installed oracle home software . The installation went fine.
3. As per document when i try to install the 10gR2 patchset (4547817). It says Installed and the reinstall option is enabled.
4. When i checked in installed products button and local inventory of oracle home using
opatch lsinventory, it shows the following :

Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
There are 2 products installed in this Oracle Home.
I am confused whether to proceed with patch set installation or proceed with db upgrade>

Reply
Atul Kumar says January 4, 2007

Hi Anonymous as you said that you applied 10gR2 patchset (4547817) and even Installed Top level products from oraInventory is showing both 10g R1 & R2 i.e. 10.1.2.0.2 you proceed with DB Upgrade .

You can proceed with DB upgrade.

Atul

Reply
Anonymous says January 24, 2007

Is 10.2.0.3 is certified with oracle apps 11.5.10CU2?

Reply
Atul Kumar says January 24, 2007

Not yet, but you might see it soon .

Atul

Reply
fhasweh says February 15, 2007

hi atul, a qustion plz in step 3. If you are using Portal 3.0.9 with Apps 11i…etc, how can i know if i am using oracle portal 3.0.9 or not.

fadi

Reply
Atul Kumar says February 15, 2007

Fadi,
Can you tell me which metalink note you are referring ?

Reply
Shashi Bhushan says March 6, 2007

Hi Atul,
I am using solaris 10 and fresh install 11.5.10.2 with 9i database. Now we want to upgrade the database with 10.2.0.2. Is is possible to direct install 10.2.0.2 oracle software instead of 10.2.0.1 and then apply patchset.

Please clarify as early as possible.

Regards

Shashi

Reply
Atul Kumar says March 6, 2007

Hi Sashi,
Unfortunately NO. base release for 10.2.0.2 is 10.2.0.1 so you have to first install 10.2.0.1 & then patch it to 10.2.0.2

Atul

Reply
Anonymous says March 15, 2007

Hi Atul,

we are on 11.5.10 with atg cu4 on a 9207 db, do we meet the pre-req to upgrade to 10gR2 or should we apply cu2 on top of 11.5.10

Kindly advise

Reply
Atul Kumar says March 15, 2007

Anonymous
11.5.10.2 is prereq so U still have to apply 11.5.10 CU2 patch

Reply
Saptarshi says June 26, 2007

hi Atul,

I have freshly installed
RELEASE_NAME
11.5.10.2
then upgraded the db to 10.2.0.1 applied patch, db is now 10.2.0.2.0.

but my problem is, whenever i am opening http://host:8006/oa_servlets/AppsLogin
its displaying a blank page.

but if i use http://host:8006
Logon Options for Oracle Applications 11i page is opening.
but on clicking “E-Business Home Page” link, its displaying blank page.

kindly reply at your earliest

Reply
Atul Kumar says June 26, 2007

For issues/problems raise them in forum at http://teachMeOracle.com/forum

Reply
Chelmella says August 22, 2007

hi Atul,
I am srinidhi.
I am very much impressed with your blog site, actually I have seen this site recently that is why I am late to the blog.
I have doubt …
In Oracle Applications 11i while migrating the database(9.2.0.5) from one platform to other platform what should be the target system like…the entire databse should be deleted or wat should be the structure of target databse …
please help me out in this…

Reply
Atul Kumar says August 22, 2007

Srinidhi,
Depending on your targeting operating system there are documented way to migrate apps database from one o.s. to other o.s. use metalink to check corresponding document

Reply
praveen says February 18, 2008

Hi Atul,
I am planning to Upgrade my appl & db tier from 11.5.9 to 11.5.10.2.when we are applying maintainence pack of 11.5.10.2 i.e patch 3180164(UPDATE APPLPROD.TXT TO ADD NEW PRODUCTS FOR 11.5.10 MAINTENANCE PACK)
This patch is applied before 6 hours,till now it is not completed,at this stage what we need to think about this ..Is the patching process going on internally or is it struck..
The system hanged at this place as showned below..
FAILED: file adsysapp2.sql on worker 1 for product admin username APPLSYS.
Deferred: file adsysapp2.sql on worker 1 for product admin username APPLSYS. (Deferment number 1 for this job)
FAILED: file adgrnp30.sql on worker 2 for product ad username APPLSYS.
Deferred: file adgrnp30.sql on worker 2 for product ad username APPLSYS. (Deferment number 1 for this job)
Assigned: file adsysapp2.sql on worker 1 for product admin username APPLSYS.
Assigned: file adgrnp30.sql on worker 2 for product ad username APPLSYS.

Plz reply me as early as possible.

Reply
Add Your Reply