Migration from Oracle 32-bit to 64-bit on Windows

[Former Member]

Hi,

Currently we have Oracle 32bit 10.2.0.2 on Windows 64-bit.

We want to convert oracle to 10.2.0.2 64 Bits on the same machine.

The procedure is quite simple but if we want to keep the same Oracle home it become complicated.

The Oracle 32 bit is installed on /oracle/SID/102 if we want to keep the home directory after the migration we have to install the oracle 64-bit software on /oracle/SID/102.

1. Can we install 64-bit binaries over 32-bit binaries on the same directory.

2. Do we have to deinstall first 32-bit binaries

3. Can we simply empty the /oracle/SID/102 and install 64-bit binaries and start the DB and run the conversion script ?

Thank you for you help.

Chak

[stefan_koehler]

Hello Chak,

> 1. Can we install 64-bit binaries over 32-bit binaries on the same directory.

No.

> 2. Do we have to deinstall first 32-bit binaries

Yes .. if you don't know howto deinstall the RDBMS software - check sapnote #392800

> 3. Can we simply empty the /oracle/SID/102 and install 64-bit binaries and start the DB and run the conversion script ?

No, deinstall the 32-bit software like described in sapnote #392800, install 64-bit binaries and run the needed scripts.

Regards

Stefan

[Former Member]

Hello Stefan.

Thank you for your quick reponse.

Note 392800 describe how to de-install old oracle version after the complete installation of the new software which will be not our case because we want to de-install the oracle software before installing the 64-bit.

Normally the steps will be as follow

1. Use OUI to deinstall Oracle 32-bit

2. Install 10g 64-bit and 10.2.0.2 64-bit

3. Open the DB and run the conversion script

Is this procedure described in an SAP note ot at least supported by SAP ?

Another question : I guess when we d-install oracle using OUI it removes only the binaries not the DB or *.ora files (init, tnsnames,...).? what about the Oracle services, are they removed too ?

Thanks,

Chak

[stefan_koehler]

Hello Chak,

> which will be not our case because we want to de-install the oracle software before installing the 64-bit.

Yes, that doesn't matter. I posted that sapnote, because of the procedure with runInstaller.

> Is this procedure described in an SAP note ot at least supported by SAP ?

For sure. It is still just an oracle database

> I guess when we d-install oracle using OUI it removes only the binaries

All that stuff that is located in ORACLE_HOME (including services), so i would copy the spfile and SQL*Net configuration files before de-installing. Database files are not touched.

Regards

Stefan

[Former Member]

Hello Stefen,

Can you please check if the following steps are correct.

I) Remove 32 bits

1. run OUI and de-install the 32 bit binaries

2. check if services are not removed and remove them using the windows command sc

3. check windows registries and delted any entry related to Oracle

4. Check is some files under ORACLE_HOME still exite and delete them

5. delete the oracle directory under c:\programfiles

II) install 10g 64 bit

1) install 10.2.0.1 64bit

2)install 10.2.0.4 64 bit

3) install collection and generic patches

5) recreate services using oradim command

III) upgrade and conversion

startup upgrade

run utlip.sql : to invalidate all object

run catupgrade.sql : to upgrate the DB

run utlrp.sql to compile

Thanks Chak