System Copy/ Oracle Backup/Restore as part of migrating from 32 to 64-bit

79 Views

Source system (I386): R3E47 Ext Set 2.00 SAP_BASIS 620 Kernel 640 Windows 2000, Oracle 10.2.0.4, non-unicode

Target system (x86-64/AMD64): R3E47 Ext Set 2.00 SAP_BASIS 620 Kernel 640 Windows 2000 Oracle 10.2.0.4, non-unicode

Am using method System Copy/ Oracle Backup/Restore to migrate from 32 to 64 bit (HOM System Copy).

Actions on source system:

a) Upgrade from 9.2.0.7 to Oracle 10.2.0.4

b) Used ora_br_copy.bat to generate CONTROL.SQL and init<sid>.ora

c) Switched logfiles

d) Performed offline backup

Actions on target system:

a) Installed Oracle 10.2.0.1 and patched it to 10.2.0.4

b) Used CD 51033746 "6.20/6.40 based products Installation Master (Edition May 2008)" to install the CI

c) Started installation of the DB instance selecting System Copy/ Oracle Backup/Restore (same <SID> for source and target systems)

Relevant input parameters used:

Database schema: SAPR3

Database character set: US7ASCII

d) When SAPINST stopped to allow for restoring of datafiles, logs and init<sid.ora>:

- copied datafiles and logs to the usual place

- copied CONTROL.SQL (edited to include utilrp.sql and utlrp.sql for the migration from 32 to 64) to the DB-instance intallation . directory.

- copied generated init<SID>.ora to the <ORACLE_HOME>\database

e) Resumed SAPINST.

David Byrne in a previous post suggested: "check your oracle alert file in case there are errors there you may need to update the word size for the 64bit install. Errors like this in the oracle alert file would suggest that.,

ORA-12012

ORA-06544: PL/SQL: internal error, arguments: [ORA-06544: PL/SQL: internal error, arguments: 56319], [, ], [, ], [, ], [

ORA-06553"

Well, I am getting ORA-06553: PLS-801: internal error [56319] but then my edited CONTROL.SQL (which is mainly a CREATE CONTROLFILE as it would be obtained with a ...BACKUP CONTROLFILE TO TRACE) includes at the end this:

shutdown immediate

startup upgrade

spool utlirp.log

@?/rdbms/admin/utlirp.sql

spool off

Shutdown immediate

Startup

Spool utlrp.log

@?/rdbms/admin/utlrp.sql

Spool off

exit

which is supposed to do just that... (I think)

Help, anyone? 😉