Oracle Apps 11i with Database 10g R2 10.2.0.2

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

Sure KK,
I’ll do it tonight.

Atul

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

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

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

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

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

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

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

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

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

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

Atul

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

Knowledge Base & Ultraseach .

Atul

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

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

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!

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

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

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

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>

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

Is 10.2.0.3 is certified with oracle apps 11.5.10CU2?

Not yet, but you might see it soon .

Atul

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

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

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

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

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

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

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

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

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…

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

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.