steps to upgrade 10.2.0.3 to on new server 10.2.0.4
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: steps to upgrade 10.2.0.3 to on new server 10.2.0.4

  1. #1
    Join Date
    Aug 2008
    Posts
    118

    steps to upgrade 10.2.0.3 to on new server 10.2.0.4

    Hi,

    I am preparing for the upgrade on new server.

    I have RH Linux 4.X version and OS is upgrading to RH Linux 5.2. I am planning to install fresh oracle 10.2.0.4 on top.

    I have old server with Oracle 10.2.0.3 and want to upgrade to 10.2.0.4..

    What steps i need to follow? Please advise and guide!!

    Thanks
    Pat

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the upgrade guide would be a good start

  3. #3
    Join Date
    Aug 2008
    Posts
    118
    Hi,

    I am going through the guide but being new to this need some general steps to get the data file from old server to new server and how i can do with least amount of hassle.

    thanks
    Pat

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Moving from one server to another server is not an upgrade but a migration; two questions.

    - how big is the database?
    - do you have connectivity in between the two servers?
    Last edited by PAVB; 01-28-2010 at 01:03 PM. Reason: type
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Aug 2008
    Posts
    118
    Hi,

    yes i have connectivity with both server:

    But:

    Server 1 is on RH Linux 4.X and oracle 10.2.0.3

    Server 2 will be on RH Linuk 5.2 64 Bits and Oracle 10.2.0.4 64 bits.

    Thanks
    Pat
    Last edited by midora; 01-28-2010 at 03:11 PM.

  6. #6
    Join Date
    Aug 2008
    Posts
    118
    The database is about 20 G on old server.

    Thanks
    Pat

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Here is what I would do...

    1- Ask systems to lay out file systems on NEW server exactly as they are on OLD one.
    2- Install 10.2.0.4 on NEW server
    3- Create database on NEW server
    4- Export full=y on OLD server
    5- FTP dump file from OLD to NEW server
    6- Import full=y on NEW server
    7- Check constraints, etc are created - recompile invalid objects
    8- Gather fresh stats
    9- Setup backup strategy on NEW server
    10- Done.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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