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 220.127.116.11.0 without doing any migration and then to apply patch set 18.104.22.168.1 and 22.214.171.124.3.
In the readme of 126.96.36.199.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 188.8.131.52.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 184.108.40.206.0 and then applied patches 220.127.116.11.1 and 18.104.22.168.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.
To handle yourself, use your head. To handle others, use your heart
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.
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.