Upgrade to 10g from 8i.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Upgrade to 10g from 8i.

  1. #1
    Join Date
    Jul 2000
    Posts
    147

    Upgrade to 10g from 8i.

    Iím in process of migrating eight 8.1.7 (old server) databases to 10gR2 (new server). These are fairly small database, but has lots of dblinks and synonyms. What would best approach to do it? Any suggestion would be greatly appreciate it.

    Thanks!

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I suppose you can afford a small downtime.

    1- Create new 10g database in new server.
    2- Do a full export on 8.1.7
    3- Do a full import on 10g
    4- Update TNSNAMES.ora file on 10g box to match what you have on 8.1.7 box
    5- Test dblinks

    Relax and enjoy.
    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.

  3. #3
    Join Date
    Jul 2000
    Posts
    147
    Thanks PAVB! That what I was planing. But not sure ......Export/Import will also take care the link and synonyms or I have manually create it?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    everything will move, even Public Synonyms and Public DBLinks if you do full exp/imp
    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