將ORACLE 10g 32bit數據庫還原到測試機ORACLE 10g 64bit的數據庫實例上， 還原、恢復數據庫後，使用open resetlogs打開數據庫後，發現警告日志裡面有ORA-12012以及ORA-06553錯誤：
Sun Mar 8 13:31:08 2015
LOGSTDBY: Validation complete
Starting control autobackup
Control autobackup written to DISK device
handle '/u03/flash_recovery_area/backup/backupsets/ora_cfc-2179993557-20150308-00'
Completed: alter database open resetlogs
Sun Mar 8 13:31:09 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_j000_14891.trc:
ORA-12012: error on auto execute of job 41
ORA-06553: PLS-801: internal error [56319]
Sun Mar 8 13:31:09 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_j001_14893.trc:
ORA-12012: error on auto execute of job 21
ORA-06553: PLS-801: internal error [56319]
Sun Mar 8 13:31:09 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_j006_14903.trc:
ORA-12012: error on auto execute of job 42567
ORA-06553: PLS-ORA-06553: PLS-801: internal error [56319]
出現這個錯誤，是因為32bit和64bit數據庫的wordsize不同，需要執行以下步驟完成wordsize的轉換。具體可以參考How to Convert a 32-bit Database to 64-bit Database on Linux? (文檔 ID 341880.1)
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 3590324224 bytes
Fixed Size 2084296 bytes
Variable Size 1607467576 bytes
Database Buffers 1966080000 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlip.sql
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 3590324224 bytes
Fixed Size 2084296 bytes
Variable Size 1607467576 bytes
Database Buffers 1966080000 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlrp.sql
在執行腳本時，會報下面錯誤，官方解釋為Note:If you are changing wordsize for Oracle release10.1.x/10.2.x/11.1/11.2 32-Bit to 64-bit with OLAP enabled for DB then you may likely to see the error
Fri Jan 23 17:24:05 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_smon_9027.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [18], [13], [], [], [], [], []
Fri Jan 23 17:25:55 2015
Error 0 in kwqmnpartition(), aborting txn
Fri Jan 23 17:25:55 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:
ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319]
Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30
Doing block recovery for file 122 block 939
No block recovery was needed
Fri Jan 23 17:25:56 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:
ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319]
ORA-600 encountered when generating server alert SMG-3503
Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30
Doing block recovery for file 122 block 939
No block recovery was needed
Fri Jan 23 17:25:57 2015
Errors in file /u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:
ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], []
Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30
Doing block recovery for file 122 block 939
No block recovery was needed
參考資料：
http://blog.itpub.net/23135684/viewspace-757172
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=wo3y0s6qj_9&_afrLoop=209150676970938#GOAL
