| export failing [message #235019] |
Thu, 03 May 2007 14:52  |
scy65
Messages: 1
Registered: May 2007
|
Junior Member |
|
|
an attempt was made 2 months ago to upgrade the database from 9.2.0.1 to 9.2.0.5. Unfortunately the patch which was labeled 32 bit was 64 bit which messed things up originally but we were able to get the db running again but exports are failing with the below message. The issue now is that we need backups and cannot get this running. Oracle has told me that we would need to recreate the db which now is not an option due to the time that has lapsed. I'm not sure if anyone can help and we may indeed have to re-create the db and lose data but I thought I give this board a try.
Thanks,
Stephen
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_sysprivs_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_RMGR_PLAN_EXPORT.grant_sysprivs_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_EV_CTXS.grant_sysprivs_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.grant_sysprivs_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-801: internal error [56319]
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULE_SETS.grant_sysprivs_exp
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6544 encountered
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319]
EXP-00000: Export terminated unsuccessfully
|
|
|
|
| Re: export failing [message #235042 is a reply to message #235019] |
Thu, 03 May 2007 17:30  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> The issue now is that we need backups and cannot get this running.
Export is NOT a backup. It never was a backup solution.
It is meant to move data around.
So You appied a wrong patch and left the database as-it-is?
Generally, you are supposed to take a backup before applying patch. Did you do it?
THis appears to be a 32/64 bit word size problem.
Look into metalink Note:369644.1 especially where it talks about running utlirp.sql
and also look into Note:62290.1.
PS:
Take a backup before doing anything.
Backup you database and your binaries (if your ORACLE_HOME=/u01/.. , then backup everything under /u01.
Just a tar would do).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
