after upgrading Oracle binaries,do i really need to run Catalog/Catproc.sql on databa
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: after upgrading Oracle binaries,do i really need to run Catalog/Catproc.sql on databa

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    Hi,

    I am just curious, after upgrading my Oracle from say 8.0.6 to 8.0.6.3 ,
    do I really have to bring up my database and run the catalog and catproc.sql on my database??

    thanks
    ngwh

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    You can easily run catalog.sql and catproc.sql after upgrading from Oracle 8.0.6 to Oracle 8.0.6.3 as it will again recreate the data-dictionary and add the plsql functionality

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi roh,

    thanks for ur reply.But if u read my posting actually I am asking if there's really
    ANY NEED to run catalog/catproc SQLs on my database? any impact should i choose
    not to run ??

    thank in advance
    ngwh

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It's totally dependent on the type of patch. Some changes in the executables may require new or modified columns in the data dictionary. If you don't run these scripts you're screwed.

    Basically, if the patch instructions say you should then I'd do it. Failure to follow installation/upgrade instructions leaves your database in an unsupportable state. This doesn't mean it won't work, just that Oracle can refuse to support your installation under the T&Cs of your Oracle license.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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