Urgent!!! Database migration from 805 to 817

Hi there,

I am in the middle of the process of migrating from Oracle 8.0.5 to 8.1.7 on NT. Finally, our Oracle Application 11.0.3 has to work on database 8i.

I am following metalink document 148902.1 for the same.

As per this document, first I have to install 8.1.7.0.0 without doing any migration and then to apply patch set 8.1.7.1.1 and 8.1.7.1.3.

In the readme of 8.1.7.1.1, it is mentioned that before applying the patch, you should have migrated the database.

It was real confusion. But still I followed the document of metalink. In the readme of 8.1.7.1.1, it was mentioned to run
catalog,catproc,catrep and utlrp SQLs but I did not run them because the database was still not migrated at that time.

Now, I have first installed 8.1.7.0.0 and then applied patches 8.1.7.1.1 and 8.1.7.1.3.


Now, I have a question.

When should I run catalog,catproc,catrep and utlrp SQLs? Just before starting migration process? I am doing manual migration.

Pl. reply ASAP.

Thanks in Adv.

catalog, catproc, and catrep are all scripts that create the system catalog. These should be run just AFTER the migration to 8.1.7. The utlrp script is a script that will recompile all your invalid packages after you run the cat* scripts. This should also be run just AFTER the migration to 8.1.7.

Thanks Jeff,

I am running u0800050.sql for migrating as per document A86632 using manual method.

In this document, it is written that u0800050.sql will also run catalog.sql and catproc.sql as part of migration process.

Still, do I have to run utlrp script?

Thanks a lot.

Run utlrp if you have invalid packages. You can check to see if you have any invalid packages by using a script like http://home.adelphia.net/~marist89/s...ow_invalid.htm

Jeff,

I'll do that.

Thanks,

Hi Jeff,

u0800050.sql was just completed.

What should I check in the spool file for errors if any.

Pl. suggest.

Thanks,

You should check to make sure no errors were reported.

Hi Jeff,

There were lot of errors and also total 2000 invalid objects in owner SYSTEM and totally about 13000 invalid objects. so I opened the TAR with Oracle.

They asked me to run catalog.sql, catproc.sql and utlrp.sql.

utlrp.sql is taking time forever. It is running for more than 1 hour.

Do you know why there could be so many invalid objects and why utlrp.sql should take so much of time.

Thanks,

When you run catalog & catproc, it invalidates any packages that depend on any system packages. By running utlrp, you are trying to recompile all packages tagged as invalid. This is thousands in an Oracle Applications Database. Depending on the speed of your hardware, it will take hours.

I think adadmin has an option to recompile the apps schema. I'm not sure if you can compile in parallel, though.

Jeff,

utlrp has just finished. Now, only 58 objects are invalid. Out of which, 3 of SYSTEM owner.

I have uploaded the file of invalid objects to Oracle.

Let's wait.

One advise is required.

Before running migration script, how if I turn off Archiving so that it does not unncessarily generate arch files. It might save some time too.

Thanks for your help.

Did you disable the system triggers before migrating? The best way to perform the migration is to migrate to the base version and then make sure that you were able to open the database and so, then proceed with the application of patch set to the migrated database.

I'm surpries that oracle had suggested the migration to the patched database instance directly. If you don't mind can you pass me the metalink doc id. Just curious to see.

My rule of thumb is first migrate to the base version and then make sure that the application can function, then proceed applying the patchset to the migrated database.

Sam

Hi Sam,

I fully agree with you but note 148902.1 suggest not to migrate at the time of installation. This note is interoperability note for Oracle apps 11.0.3 with Enterprise edition 8.1.7.

Secondly, I have other foll. questions.

1. Why it still shows 8.1.7.1.1 in v$version query inspite of migrated to 8.1.7.1.3.

2. I just read somewhere that we should also run catexp.sql and utlconst.sql just after running u080005.sql. Pl. tell me if I also need to run these scripts.

3. I have changed COMPATIBLE parameter from 8.0.5 to 8.1.7 in init.ora file and bounced the database. Database started perfectly OK but now when I gave command shutdown normal, it looks like it has got hung.

In alert.log, it shows waiting for logins to complete. Infact, there are no other logins to the database at present.

What should I do in this case.

Thanks,

Quote:

---

Originally posted by samdba

3. I have changed COMPATIBLE parameter from 8.0.5 to 8.1.7 in init.ora file and bounced the database. Database started perfectly OK but now when I gave command shutdown normal, it looks like it has got hung.

In alert.log, it shows waiting for logins to complete. Infact, there are no other logins to the database at present.

What should I do in this case.

---

Shutdown immediate.