Oracle 11g R2 64-bit backup restores to Oracle 11g R2 32-bit problem handling

Procedure: The source database is a 64-bit ORACLE11GR2 software that restores the database (including parameter files, data files, control files, log files) to the same name as the 32-bit ORACLE11GR2 database with Rman full backup.

Error behavior: ora-06553:pls-801 Internal Error

Error reason: The database was restored to a 32-bit system with a backup slice on a 64-bit system, which in turn would produce this error.

Solution: Run the script to recompile the kernel parameters with a 32-bit system

Concrete steps:sql> conn/as sysdba;

sql> shutdown immediate;
Sql> startup upgrade;

Sql> @?/rdbms/admin/utlirp.sql

Sql> @?/rdbms/admin/utlrp.sql

sql> shutdown immediate;

Sql> startup;

which

The role of Utlirp.sql is to compile all the relevant content on the 32bit platform.

The role of Utlrp.sql is to compile all failed objects.

Then reconnect, there will be no error.

Sql> Conn Xxx/xxx

Connected.

--end--