Oracle Database already migrate 10g : Migration from 32-bits to 64-bits

[Former Member]

Hello,

I want to migrate an Oracle Database 10g (10.2) 32 bits to 64 bits.

I have already copied database on new system 64 bits but I think that I must launch a script to convert database.

Have you already make this ?

This note 940811 - Oracle Database 10g: Migration from 32-bits to 64-bits is not complete for me, because my database is already upgraded !!

Thanks by advance

[Former Member · Accepted solution]

Hi Jeremie,

The best you can do is follow Oracle Metalink Note 62290.1 (Changing between 32-bit and 64-bit Word Sizes).

Specially, be sure to run scripts utlirp.sql and catupgrd.sql.

Best Regards,

JC Llanes.

[former_member204746]

Bonjour Jérémie,

just try these steps:

sqlplus / as sysdba

startup upgrade;

@?/rdbms/admin/utlirp.sql

shutdown immediate;

startup

@?/rdbms/admin/utlrp.sql

this will recompile Oracle objects in 64-bit.