http://onlineAppsDBA.com

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

 

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

 

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

 

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 Saptarshi,

Most probably your Jserv is not starting up. Check these directories for errors:

$IAS_ORACLE_HOME/Apache/Jserv/logs
$IAS_ORACLE_HOME/Apache/Jserv/logs/jvm

- Vikram

 

Hello Atul,

Is it possible to install 11.5.10 fresh install directly to an empty 10gR database. I am trying to look for some workaround

Thanks for the help

Kishore

 

No, Its not possible to install 11i on 10g R2 directly

 

Why shouold I upgrade to 11.5.10?
Answer will not be sufficient as every one knows there should be enhancements with upgradation. could you give a brief introduction about the new features which were introduced in release 11.5.10

 

hi atul,

I have an apps 11.5.8 version running on db 8.1.7.4. We are looking forward to move to 9.2.0.8. What are the broad steps to this db upgrade? Can we move to 10.2.0.2, is 11.5.8 supported on this version of DB?

tia,
Barkha