Migration of Oracle 32-bit to 64-bit

[Former Member]

Hi,

We have windows host x64 bit. Oracle is 10g 32 bit and we want to migrate it to 10g 64 bit.

1. We have installed the 64bit oracle software.

2. Then we uninstalled the 32bit software. With the uninstallation, the oracle services have also disappeared.

Now, there are no Oracle services seen under My Computer - Manage - Services, how to create the new Oracle services??

Please help.

Many thanks,

Mohan.

[markus_doehr2]

> 1. We have installed the 64bit oracle software.

> 2. Then we uninstalled the 32bit software. With the uninstallation, the oracle services have also disappeared.

>

> Now, there are no Oracle services seen under My Computer - Manage - Services, how to create the new Oracle services??

The "new Oracle Service" is a database, you would need to have followed the system copy guides and having the sql trace file to recreate the database again ('alter database backup controlfile to trace'). This is why I proprosed to follow the system copy guides.

Markus

[Former Member]

Hello Markus,

Thank you for your reply. We have managed to re-create the Oracle Services in other way as mentioned below. May be useful for other users:

1. Stop the DB, stop listener, stop other oracle processes.

2. Install the new DB software in a different home + Patch

3. Only after that, delete the old software.

4. Set the Environment variables $ORACLE_HOME and $PATH

(Nicht alle Variablen waren sauber gesetzt)

5. copy the files present under $ORACLE_HOME/database from old DB to new DB.

6. Create the Listener - Service with $ORACLE_HOME/bin/netca

7. Create the SID - Service with oradim ($ORACLE_HOME/bin)

oradim -NEW -SID FFF -STARTMODE auto -SRVCSTART system

8. start the database using sqlplus.

9. As the wordsize changes with 64-bit, all pl-sql-predures should be recompiled.

Therefore please run the following two scipts on db-level:

sqlplus sys as sysdba

sql> @$ORACLE_HOME/rdbms/admin/utlip.sql -invalidates all plsql-procedures

sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql -recreates the plsql-procedures with the new word size.

10. Offline - Backup with brbackup.

Many thanks,

Mohan.