Migration of Oracle 32-bit to 64-bit on same Windows host.

[Former Member]

Hi,

Title: Migration of Oracle 32-bit to 64-bit on same Windows host.

We have windows host x64 bit. Oracle is 10g 32 bit and we want to migrate it to 10g 64 bit. I would like to know the steps. Note 940811 is not clear enough.

Please help.

Many thanks,

Mohan.

[Former Member]

Duplicate post

Read and follow the forum rules

[Former Member]

Sorry Nick,

iam closing the ticket.

For Others - Please follow the thread in this post -

Regards,

Mohan

[sunny_pahuja2]

Hi,

I think SAP Note 940811 is not relevant to your case as far as I understand your case in your previous thread because you are already on oracle 10.2 and there is no upgrade required.

Please check SAP note 192822 and please check below extract from this note:

5. Can I switch to 64-bit, even though I already run the same oracle release on 32-bit?

Yes. The only thing that needs to be done is

• run del_ora.csh to delete the 32-bit software

• install the 64-bit software

• start the database.

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

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

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

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

Thanks

Sunny

[Former Member]

Hi,

I have some questions.

1. Can i delete the 32bit oracle software AFTER i install the 64bit software?

2. i dont find this del_ora.csh script in my Windows host. Perhaps it is in Unix host. Can i delete the 32bit software using Universal Installer?

3. When will the switch happen, i think i need to run some conversion program so that the DB switches from 32bit to 64bit. Did i miss something?

4. The above 2 scripts (utlip & utlrp) should be run from the 64bit software, right?

Many thanks,

Mohan.

[Former Member]

Hi,

Need Help.

We have installed the 64bit software.

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 get the new Oracle services??

Mohan.

[sunny_pahuja2]

Hi,

Best approach which I suggest is to do the system copy. As suggested by Markus as well.

Thanks

Sunny

[markus_doehr2]

> We have windows host x64 bit. Oracle is 10g 32 bit and we want to migrate it to 10g 64 bit. I would like to know the steps.

> Note 940811 is not clear enough.

Are you running a 32bit kernel?

The "safest" way would be

- take a backup

- delete the actual instance and software

- install the system new with the backup taken

Markus