DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Migrating from 9.0.1.1.0 to 9.0.1.4.0

  1. #1
    Join Date
    Jan 2002
    Posts
    36

    Migrating from 9.0.1.1.0 to 9.0.1.4.0

    I have a database in an oracle_home that is 9.0.1.1.0 and can not at the moment patch the home to 9.0.1.4.0 yet. I have another oracle_home that is 9.0.1.4.0 so I am planning on moving this particular database over. Because the major builds are the same, differences being the patchset, is it safe to shut the database down, move files to the new home, change environment variables, and bring it back online in the new home. If so, which scripts if any do I need to run against the database once it is back online?

    Thanks
    Steven
    soestx@aol.com
    OCP DBA 8, 8i; MCDBA; MCSE

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Do a startup migrate and run catpatch.sql.

    Read the README that came along with the patch for more details...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2002
    Posts
    36
    So basically by moving the datafiles to the other home, I am just going to skipp the installing of the new binaries step, and once the database is opened, start with the catpatch.sql script as instructed in the readme and all other necessary scripts in the following steps? It sounds easy enough....am I missing anything?
    Steven
    soestx@aol.com
    OCP DBA 8, 8i; MCDBA; MCSE

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Don't forget to startup with migrate option and just complete all the pre-requisites mentioned in the README file. Thats all.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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