10g 32bit to 64bit Linux rhel 4.6
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 10g 32bit to 64bit Linux rhel 4.6

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    10g 32bit to 64bit Linux rhel 4.6

    Hi Dearest of Friends,

    Can you help me what steps to do in migrating or upgrading a 10g DB?

    This is the current scenario:

    1. We have a TEST server 32bit Sunfire, and with 32bit rhel 4.6 OS, and with 32bit Oracle 10g DB (with instance name TEST).

    2. We have a PROD server 64bit Sunfire, and with 64bit rhel 4.6 OS, and with 64bit Oracle 10g DB (with instance name PROD).

    My question is, how do I migrate my TEST DB to PROD server?

    Do I have to physically copy all .dbf (datafile,controlfile,logfile) of my TEST DB
    to the PROD server and perform an upgrade using DBCA?

    Please tell me if my concept is correct.


    Thanks a lot

    Krissy
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Do a cold backup of the 32-bit database. Copy the datafiles, controlfiles, redo logs and the init file of the 32-bit database to the 64-bit system. Then, after setting up the appropriate environment variables, perform the following on the 64-bit system:

    Code:
    SQL> startup upgrade
    SQL> @?/rdbms/admin/utlirp.sql
    SQL> shutdown immediate
    SQL> startup
    SQL> @?/rdbms/admin/utlrp.sql
    This process is assuming the same directory structure on both systems. You mentioned upgrade, but I'm assuming you simply meant upgrade from 32-bit to 64-bit ?

    HTH

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Oh Thanks a lot Ebrian, you are so nice
    Behind The Success And Failure Of A Man Is A Woman

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