Monday, September 24, 2012

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

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

Below are the high level steps

a. Perform full cold backup of source database

b. Install 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 DB is on Windows 2003 R2 64 bit and my new Oracle server is installed on Windows 2008 R2 64 bit.