Urgent!!! Database migration from 805 to 817

[samdba]

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.

[marist89]

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.

[samdba]

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.

[marist89]

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

[samdba]

Jeff,

I'll do that.

Thanks,

[samdba]

Hi Jeff,

u0800050.sql was just completed.

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

Pl. suggest.

Thanks,

[marist89]

You should check to make sure no errors were reported.

[samdba]

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,

[marist89]

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.

[samdba]

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.