Labels

Monday, September 24, 2012

Migration/Upgradation steps 10.2.0.4 to 11.2.0.1 from Microsoft Window(32-bit) to Windows 2003


Migration/Upgradation  steps 10.2.0.4 to 11.2.0.1 from Microsoft Window(32-bit) to Windows 2003
The Oracle Database is to be upgraded from 10.2.0.4 to 11.2.0.1 version.
The Operating system of Oracle 10.2.0.4 is : Microsoft Windows (32-bit) 2000
This is to be migrated to another server with Windows 2003 and Oracle 11.2.0.1 binaries installed.

Below are the high level steps

a. Perform full cold backup of source database

b. Install 11.2.0.1 database on Microsoft Windows 2003 server (target)

c. Copy the Database and configuration files from the source server to target server.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc..)
Create same directory structure in 11g as it was in 10g. 

d. Create the Oracle service , using the ORADIM command.

e. Run Sqlplus in target Oracle home :
Issue the command: startup upgrade

f. Run the CATUPGRD.SQL script.
Startup the target database in upgrade mode and run the script "catupgrd.sql"

1 comment:

  1. Hi Subhram,

    Could you please advice if the above steps applicable to below case...

    My 10.2.0.4 DB is on Windows 2003 R2 64 bit and my new 11.2.0.1 Oracle server is installed on Windows 2008 R2 64 bit.

    ReplyDelete