oracle database upgrade issues

Posted on 2007-10-21
Last Modified: 2013-12-19
while doing manaula oracle database upgrade to i am getting following errors:

      ERROR at line 1:
  1081  ORA-06502: PL/SQL: numeric or value error: character string buffer too s
  1082  ORA-06512: at "SYS.STANDARD", line 595
  1083  ORA-06512: at line 5

ERROR at line 1:
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
in the end of the file i am getting
Oracle Database 10.2 Upgrade Status Utility           10-21-2007 15:28:21
Component                                Status         Version  HH:MM:SS
Oracle Database Server                  INVALID  01:20:14
how to resolve these issues
Question by:narendrabv
    LVL 9

    Accepted Solution


    Author Comment

    i dont understand why i have to run these scripts in the upgrade process?  I am following the metalink document 316889.1
    in this document after upgrade you database status should be valid.  if you get the errors, you have fix them and rerun the script.  On my old database i.e on oracle 9i i ran these scripts?

    Do you want to me ran these scripts to fix the issue?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now