piecemeal upgrade 8.1.6 t0 8.1.7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: piecemeal upgrade 8.1.6 t0 8.1.7

  1. #1
    Join Date
    Jul 2000
    Posts
    1

    piecemeal upgrade 8.1.6 t0 8.1.7

    I am trying to upgrade a database from 8.16.0.0 to 8.1.7. The problem is i am limited with space, so i cannot have 2 oracle homes. I do not want to completely overwrite the oracle 8.1.6.as i have been told that this is not a very good idea although oracle manual says you can. is there a method to actualy do a piecemeal upgrade on just the necessary components without corrupting the whole process. I would really aprreciate some response on this matter.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    This post is in the wrong place. when I do an upgrade I get a full export as system, uninstall Oracle. Then I install and configure the new version of Oracle. Including the creation of locally managed tablespaces and then I do a full import as system ignore=y commit=y buffer=102400 etc. As long as you have room to store the export that is the way I would go.

  3. #3
    Join Date
    Oct 2000
    Posts
    467

    Thumbs up

    No problem when upgrading with a single oracle_home. The universal installer will itself deinstall the 816 before starting installing the 817. Once done, run the ODMA utility or run u0801060.sql as
    SYS.
    Make sure the init.ora parameter job_queue_process is set to 0 before u migrate the DB after installation of the binaries.
    There is also 1 more parameter - _system_enabled_trig to b taken care of, Not sure whether its true of false. Suggest you check it out. Its easy but ensure you have some backups before u proceed.
    Vinit

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