How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows

Action Plan for Migrate.

1 Take a cold backup and export full db or important schema
2 Take a backup of 10g binaries (Oracle Home)
3 Take a control file backup using command
Alter database backup controlfile to trace;
4 Take a backup of init.ora file
5 Prepare the current oracle directory structure
6 Clone Prod to Prod (32 bit O/S)
7 Install 64 bit Win O/S
8 Create existing oracle directory structure
9 Install 10g (10.2.0.1 Base) oracle binaries(Software Only),Upgrade 10.2.0.4 If you use exp/imp install with database
10 Please follow the Scenario 1 or 2 or 3



Scenario 1:


Oracle 10.2.0.1(32 Bit) to Oracle 10.2.0.1(64 Bit)

1. Install Oracle 10.2.0.1.0 64bit, on Windows 2003 64bit (either AMD64 or EM64T processors).
2. The same directory structure was used for both machines.
NOTE: If a different directory structure will be used, then you will need to recreate the controlfiles, before starting the migration process.

Alter database backup controlfiles to trace;

3. Copy the Database files from the 32bit machine, to the 64bit machine.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc...)

4. Create the Oracle service on the 64bit system, using the ORADIM command.

(Eg, oradim –new –sid orcl –startmode auto –pfile

6.Run Sqlplus

sqlplus '/as sysdba'

SQL> startup upgrade

SQL>@$Oracle_Home\rdbms\admin\utlip.sql

SQL>@$Oracle_Home\rdbms\admin\utlrp.sql

SQL> shut immediate

SQL>startup

SQL>select name,platform_name,open_mode from v$database;


Scenario 2:


Oracle 10.2.0.1(32 Bit) to Oracle 10.2.0.4(64 Bit)


1. Install Oracle 10.2.0.1.0 64bit, on Windows 2003 64bit (either AMD64 or EM64T processors).

2. If you wish to apply a patchset, you can do that now. For this test, the 10.2.0.4 patchset was applied to the 64bit installation.

3. The same directory structure was used for both machines.
NOTE: If a different directory structure will be used, then you will need to recreate the controlfiles, before starting the migration process.

Alter database backup controlfile to trace;

4. Copy the Database files from the 32bit machine, to the 64bit machine.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc..)

5. Create the Oracle service on the 64bit system, using the ORADIM command.
(Eg, oradim –new –sid orcl –startmode auto –pfile
6.Run Sqlplus

sqlplus '/as sysdba'

SQL> startup upgrade

SQL>@$Oracle_Home\rdbms\admin\utlip.sql

SQL>@$Oracle_Home\rdbms\admin\catupgrd.sql

SQL>@$Oracle_Home\rdbms\admin\utlrp.sql

SQL> shut immediate

SQL>startup

SQL>select name,platform_name,open_mode from v$database;


Note: 403522.1:- How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows


Scenario 3:

Steps to migrate 32 bit oracle 9i database to 64 bit 10g database:

1, Make backups of 32 bit 10g database.
Cold backup, export.

You need to have export file for migration. You can use user system to export entire database.

2, Install 64 bit Oracle 10g.

3, Create required tablespace, users etc.

4, Import 10g export dump file to 10g (from user=user1 to user=user1).


Steps

CONN sys/password@SID_NAME AS SYSDBA

1. Create Schema Name

2. ALTER USER U_NAME IDENTIFIED BY PASSWD ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO ;

3. CREATE OR REPLACE DIRECTORY DIR_NAME AS '/u05/oradata/';

4. GRANT READ, WRITE ON DIRECTORY DIR_NAME TO SCHEMA_NAME;

step:2

Schema Exports/Imports

expdp USER_NAME/PASSWD@SID_NAME schemas=SCHEMA_NAME directory=DIR_NAME dumpfile=INV.dmp logfile=EXPINV.log

impdp USER_NAME/PASSWD@SID_NAME schemas=SCHEMA_NAME directory=DIR_NAME dumpfile=INV.dmp logfile=IMPINV.log


Full Database Exports/Imports

expdp sys/password@SID_NAME full=Y directory=DIR_NAME dumpfile=FULLDB.dmp logfile=FULLDB10G.log

impdp sys/password@SID_NAME full=Y directory=DIR_NAME dumpfile=FULLDB.dmp logfile=FULLDB10G.log

2 comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.