Wednesday, April 12, 2006

connect and ORA-06553: PLS-801: internal error [56319] , After i duplicate database from 64bits to 32bits

I duplicate database from 64bit to 32bit for test
After
I connected to my database

sql>connect system/password
ERROR:
ORA-06553: PLS-801: internal error [56319]

Error accessing package DBMS_APPLICATION_INFO


Oh My god , How can i resolve this problem.

so
sql>connect / as sysdba
sql>shutdown immediate;
sql>startup migrate;
sql> @$ORACLE_HOME/rdbms/admin/utlirp.sql
sql>shutdown immediate;
sql> startup
sql>
sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql
sql> connect system/password

Oh I didn't find problem.

*** this case about Changing the Word Size 

Don't recommend ;)

reference
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:744625626787
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/migaftrm.htm#1008952

No comments: