Translate this Page

 

In this article, I will share how to migration Oracle 10g DB From Linux 32bit to Linux 64bit. since both Linux 32bit and Linux 64bit have same Endian format, then at this time we only change the word size.
In the source environment :
- OS : Redhat AS 4.5 32bit
- DB : Oracle Database SE 10.2.0.2.0

In the destination environment :
- OS : Redhat AP 5.3 64bit
- DB : Oracle Database SE 10.2.0.4.0

The steps are :
1. Backup source datafile of the database.
We can use Cold Backup or Hot Backup method.
2. Copy the backup datafile to destination server.
3. Install the Oracle Software in destination server.
4. Install patchset 10.2.0.4.0 for Linux 64 bit (Patch# 6810189)
5. Do Cloning database, create control file
- startup nomount using pfile, assure you have sufficient resource memory, since upgrade process consume a lot of resource
- create control file in destination server
- recover using backup controlfile until cancel (if using Hot Backup method)
- open database upgrade:
SQL> alter database open resetlogs upgrade
6. Add temporary files to temporary tablespace.
7. Invalidate all pl/sql modules and recompile standard and dbms_standard
SQL> @?/rdbms/admin/utlirp
WARNING !!! if you not running this, you will get this error :
CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],[]
ORA-06553: PLS-801: internal error [56319]

8. running catupgrd.sql
SQL> @?/rdbms/admin/catupgrd
9. assure all component already valid
SQL> select comp_name, version, status from dba_registry.
10. shutdown and startup normally
11. Now your database already using new word size. congratz… :)

  2 Responses to “Migration Oracle 10g DB From Linux 32bit to Linux 64bit”

  1. Dear fah ,

    I follow ur stpes , I really appreciate that & thanks for your explaination , but I have small doubts , after running the scripts & get s succeed , and then I restart the database , then I perform this : sho parameter combatible , still it shows the old version , shall I changed manuall using:
    SQL> alter system set compatible =’ new version ‘ scope=spfile;

    Best Regards

  2. Hi,

    What is your old and new version? for compatible you can used once of them. sometimes after we doing upgrade, some queries will running in old version, and some queries can’t run in new version.

    Thanks,

    Fahmi Fahlevi

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

   
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha