Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Posts
    3

    Unanswered: moving back to 32 bit

    I'd tried to upgrade to 9.2.0.5 with a patch that was mis-labeled 32bit when it was instead 64bit. I have the db up and running but exports are failing with the following errors:
    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




    If I try just a schema I get the same results.
    I beleive that there is a problem with the DBMS_APPLICATION_INFO as when I log into sqlplus I am receiving the following messages:

    Enter user-name: tdoraserver
    Enter password:
    ERROR:
    ORA-06553: PLS-801: internal error [56319]


    ERROR:
    ORA-06553: PLS-801: internal error [56319]


    Error accessing package DBMS_APPLICATION_INFO

    Connected to:



    There is a program utlirp for moving to 64 bit is there something comparable for going back that could resolve my problem?

    Thanks in advance,

    Stephen

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    So, the first things that a patchset instructions advice you to do is to backup your actual software, did you do that ?

  3. #3
    Join Date
    Apr 2007
    Posts
    3
    Yes that is how I was able to get the installation back up and running as I have multiple instances of the oracle software running and backed up.

  4. #4
    Join Date
    Apr 2007
    Posts
    3
    Are you saying that copying the software would resolve this issue. The error looks to specific to the DB instance is why I'm not sure that this would resolve the issue.

    Thanks,

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    No, I meant that: If what you want is to go back to where it was BEFORE you applied the patch, then just rollback the change using the backup you did. If everything was working before, then it should once you restore your backup.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •