Urgent!!! Database migration from 805 to 817
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Urgent!!! Database migration from 805 to 817

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Angry

    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.








    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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.



    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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 Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Jeff,

    I'll do that.

    Thanks,

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  6. #6
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Jeff,

    u0800050.sql was just completed.

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

    Pl. suggest.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You should check to make sure no errors were reported.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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,


    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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 Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width