Database: 10.2.0.2.0
OS: migration from RHEL 64bit to RHEL 32bit
I needed to restore a database onto RHEL 23 bit platform while the only thing I got in hand is a tar ball, which is a backup from the database on RHEL 64 bit platform.
After all the process, I could bring up the database running with the following error:
ORA-06553: PLS-801: internal error [56319]
After searching a little bit, I found this is related migration error between 64 bit and 32 bit platform. The oracle suggestion is to run utlrp.sql in the process of migration.
Well, a solution worked out for me perfectly:
1. shutdown immediate
2. startup upgrade
3. @$ORACLE_HOME/rdbms/admin/utlirp.sql
4. shutdown immediate
5. startup
6. @$ORACLE_HOME/rdbms/admin/utlrp.sql
7. shutdown immediate
8. startup
Metalink document '272322.1 Difference between UTLRP.SQL - UTLIRP.SQL - UTLIP.SQL'
recommends running utlirp.sql script which would do both regeneration of compiled
code of PL/SQL modules (which UTLIP.SQL does) and then recompiles all invalid PL/SQL
modules again (which UTLRP.SQL does).
6 comments:
Gr8 notes
Than its resolved my problem
Thanks so much for this! Saved me a bunch of debugging. Worked like a charm.
Thanks , worked for me too, I had restore a 64 bit backup to a 32 bit system and this fixed the problem
I moved my datanbase from Windows 32 bit to LINUX 64 bit, Got same problem. This solution is worked perfictly!
Thanks,
great jobs... thx
?I used to be more than happy to seek out this internet-site.I wished to thanks to your time for this glorious learn!! I undoubtedly having fun with each little bit of it and I've you bookmarked to check out new stuff you weblog post. online casinos for us players
Post a Comment