Migration to 10g Linux
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Migration to 10g Linux

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Migration to 10g Linux

    Presently we are using oracle 8.1.7 on windows NT.

    We are planning to migrate to oracle 10g on Linux

    Which is the best method for migration??

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    If you've got time, export/import. Otherwise, there is a product called SharePlex that'll do the switchover in a few minutes .. cool, but it's expensive.

    Another option is to upgrade in place to 10g, then use transportable tablespaces to migrate the db's files.

    We recently migrated a bunch of db's from 8.1.7 on HP to 10g on Linux. We used export/import over a weekend. In one case we opened a source db in read-only while we migrated.

    Are you using United Linux or Red Hat? We've had fewer problems with our servers running UL 1.0 (SuSE 8). One RHEL 3.0 box freezes up if we run Grid Control (emctl) on it. Still working with support to figure that one out.

    Good luck.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks for your reply

    We are planning for ReadHat. exp/imp will be good option.

    Is there any installation problem in installing 10g on RedHat linux ES 3 standard (x86).

    such as pathches etc.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by bhattnirav


    such as pathches etc.
    yes, but it's all laid out in the installation guide and metalink notes.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yes, definately read the pre-install stuff real carefully. Don't skip a single step.

    The only outstanding issue I know of is if you're using ASM, the standard auto-startup script (dbora) does not work. I've been wrestling with support on this issue for a while (~ a month).
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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