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

Thread: Migration to 64 bit

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Migration to 64 bit

    We have a new 64 bit server.

    We want to move a test database
    from:
    Oracle 10.1.0.4.0 32 bit running on RHEL4
    to:
    Oracle 10.2.0.3 64 bit on Oracle entreprise Linux.


    Question:
    Anyone has Oracle entreprise Linux?
    Anyone has opinion on Oracle entreprise Linux vs RHEL4?
    Is there issue i need to be careful with or script i need to run to go from a 32bit database to a 64bit database?

    Plan:
    Install oracle "10.2.0.1" 64 bit on the new machine.
    Patch the new machine to 10.2.0.3.
    Copy the old database onto the new server.
    Run the migration assistant.

    Will the migration assistant do something special since the old database was 32bit?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by steeve123
    Anyone has Oracle entreprise Linux?
    Anyone has opinion on Oracle entreprise Linux vs RHEL4?
    My opinion is why have two different versions of Linux in your enterprise? I'm going to run my webservers on RHEL4 and my DB on OEL that I know will be a version behind? No thanks.
    Is there issue i need to be careful with or script i need to run to go from a 32bit database to a 64bit database?
    Plan:
    Install oracle "10.2.0.1" 64 bit on the new machine.
    Patch the new machine to 10.2.0.3.
    Copy the old database onto the new server.
    Run the migration assistant.
    You can do it that way.

    Will the migration assistant do something special since the old database was 32bit?
    Special, not really. The only thing that you have to do is rerun your catalog and recompile all your packages. The migration assistant basically takes care of this for you.
    Jeff Hunter

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there s a script (utlirp.sql) which changes wordsize from 32 bit to 64 bit, in 8i you had to run that mnaully but I think on 10g it's automatic

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    as a note, utlirp.sql invalidates your packages and recompiles everything. You still need to run catalog.sql and catproc.sql as some of the data dictionary structures change (like in v$session).
    Jeff Hunter

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    Will i have problem with the dbua?

    Since the source database is 10.1.0.4.0.
    and the new server has 10.2.0.3?

    My plan:
    install 10.2.0.1 on new machine
    patch to 10.2.0.3
    copy database
    run dbua

    Ive been told to to the following in case problems arise with the dbua:
    install 10.1.0.4.0 on new machine.
    copy the database
    install patch 10.2.0.3
    run dbua.

    The second path means il have 2 oracle home: not cool

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yup, you got to have both $OH for dbua to work. How about install 10.2.0.3 on your old box and do the upgrade there and then move it?
    Jeff Hunter

  7. #7
    Join Date
    Nov 2000
    Posts
    440
    i was not able to run dbua indeed.
    I ran catupgrd.sql instead and it went well.

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