Internal Error 56319 Oracle
Contents |
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
Ora-06553: Pls-801: Internal Error [pklsdlp:dependency Verification]
error [56319]After searching a little bit, I found this is related migration error between ora-06553: pls-801: internal error [56327] 64 bit and 32 bit platform. The oracle suggestion is to run utlrp.sql in the process of migration.Well, a solution ora-06553 pls-801 internal error 55018 worked out for me perfectly:1. shutdown immediate2. startup upgrade3. @$ORACLE_HOME/rdbms/admin/utlirp.sql4. shutdown immediate5. startup6. @$ORACLE_HOME/rdbms/admin/utlrp.sql7. shutdown immediate8. startupMetalink document '272322.1 Difference between UTLRP.SQL - UTLIRP.SQL - UTLIP.SQL'recommends running utlirp.sql script which would do both regeneration of compiledcode of PL/SQL modules (which UTLIP.SQL does) and then recompiles all invalid PL/SQLmodules again (which UTLRP.SQL does). Posted by Jason at 4:15 PM 5 comments: sumeet said... Gr8 notes Than its resolved my problem 12/05/2011 7:14 AM Rob said... Thanks so much for this! Saved me a bunch of debugging. Worked like a charm. 1/31/2012 2:47 AM Tom said... Thanks , worked for me too, I had restore a 64 bit backup to a 32 bit system and this fixed the problem 12/17/2012 11:48 AM Songhu Yan said... I moved my datanbase from Windows 32 bit to LINUX 64 bit, Got same problem. This solution is worked perfictly!Thanks, 7/09/2013 12:21 PM Menusa said... great jobs... thx 12/16/2014 4:44 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2012 (1) ► July 2012 (1) ► 2011 (4) ► April 2011 (2) ► February 2011 (1) ► January 2011 (1) ► 2010 (3) ► September 2010 (1) ► August 2010 (1) ► February 2010 (1) ► 2009 (38) ► December 2009 (2) ► September 2009 (3) ► August 2009 (4) ► July 2009 (1) ► June 2009 (3) ► April 2009 (2) ► March 2009 (14) ► February 2009 (6) ► January 2009 (3) ▼ 2008 (33) ▼ December 2008 (5) Unregister Database From Catalog EXP-00056, ORA-31600 Recover Database with Only RMAN Hot Backup File ORA-06553: PLS-801: internal error [56319] Recompiling Invalid Schema Objects ► November 2008 (9) ► October 2008 (12) ► June 2008 (5) ► May 2008 (2) Awesome Inc. template. Powered by Blogger.
while connecting to a database which has word size (32-bit or 64-bit) different than the actual installation binaries (32-bit or 64-bit). It means that if database was created (and running) on a 64-bit platform and then you move/restore same database to a 32-bit platform, or vice versa, you will be facing this problem. You may also face this error if you have a standby database running on a platform which has Oracle http://jaycheunge.blogspot.com/2008/12/ora-06553-pls-801-internal-error-56319.html binaries different than the binaries of primary database platform, and you perform a switchover. After the switchover, you might be facing same error. Reason of this error is that PL/SQL objects (functions, procedures, packages) were compiled using a different word size (suppose 32-bit) when database was created/running, and now you restore/move this database to a 64-bit http://salmandba.blogspot.com/2015/03/ora-06553-pls-801-internal-error-56319.html platform and hence these objects code is inconsistent with the binaries. To solve this problem, you first need to invalidate all PL/SQL objects and then re-compile them so that new compiled code becomes consistent with the available binaries. 1. Startup database with STARTUP UPGRADE option 2. Invalidate the PL/SQL objects by running $ORACLE_HOME/rdbms/admin/utlip.sql 3. Validate the PL/SQL objects by running $ORACLE_HOME/rdbms/utlrp.sql 4. Shutdown the database 5. Startup the database at 9:14 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ORA-06553: PLS-801: internal error [56319] No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search Oracle Community Forums Search This Blog Salman Ahmed Qureshi I am from Pakistan, living and working in Singapore. Click Here to view my complete profile. Please click here for the complete list of my Articles Blog Archive ► 2016 (20) ► October (2) ► September (2) ► August (1) ► July (1) ► June (1) ► May (3) ► April (2) ► March