Re: Data Pump error

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 6 Oct 2006 08:26:10 -0700
Message-ID: <1160148366.585076.199390_at_m7g2000cwm.googlegroups.com>


Ron Schuster wrote:
> Vladimir M. Zakharychev wrote:
> > Ron Schuster wrote:
> >> Vladimir M. Zakharychev wrote:
> >>> Ron Schuster wrote:
> >>>> I'm getting the following error trying to do a data pump export in 10g
> >>>> Express. I'm basically just trying to follow the example in the help.
> >>>>
> >>>> C:\Documents and Settings\eheard>expdp SYSTEM/dbo SCHEMAS=hr
> >>>> DIRECTORY=dmpdir DUMPFILE=schema.dmp LOGFILE=expschema.log
> >>>>
> >>>> Export: Release 10.2.0.1.0 - Production on Thursday, 28 September, 2006
> >>>> 11:27:58
> >>>>
> >>>> Copyright (c) 2003, 2005, Oracle. All rights reserved.
> >>>>
> >>>> Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 -
> >>>> Production
> >>>> ORA-31626: job does not exist
> >>>> ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
> >>>> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> >>>> ORA-06512: at "SYS.KUPV$FT_INT", line 600
> >>>> ORA-39080: failed to create queues "KUPC$C_1_20060928112759" and "" for
> >>>> Data Pump job
> >>>> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> >>>> ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
> >>>> ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
> >>>> ORA-06508: PL/SQL: could not find program unit being called:
> >>>> "SYS.DBMS_AQADM_SYS"
> >>> This one is particularly alerting: ORA-04063: package body
> >>> "SYS.DBMS_AQADM_SYS" has errors. Looks like something's not right with
> >>> your database. Try connecting AS SYSDBA and re-running
> >>> _at_?/rdbms/admin/catqueue.sql to redo AQ initialization. If you will hit
> >>> any errors during this script execution and won't be able to fix them
> >>> yourself, post them here. If there will be no errors, try your export
> >>> again and see if the original problem persists.
> >>>
> >>> Hth,
> >>> Vladimir M. Zakharychev
> >>> N-Networks, makers of Dynamic PSP(tm)
> >>> http://www.dynamicpsp.com
> >>>
> >> If I just installed Oracle Express, what is the password for SYSDBA?
> >
> > You should be able to login without password from the host where Oracle
> > runs using this sequence:
> >
> > at the OS command prompt type
> >
> > sqlplus /nolog
> >
> > then at the SQL*Plus prompt
> >
> > connect / as sysdba
> >
> > This should connect you to the instance as SYS with SYSDBA role using
> > operating system authentication (so you must be member of ORA_DBA group
> > on OS level.) Then you can run suggested script (just paste or type the
> > command I gave in my previous post in SQL*Plus.) You may want to spool
> > its output to a file for further review. To do this, type
> >
> > spool path/to/the/filename.txt
> >
> > at SQL*Plus prompt before actually running the script. When the script
> > is done, type
> >
> > spool off
> >
> > to turn off spooling. Then review the filename.txt file looking for any
> > errors and try to fix them, or, if you can't, post them here.
> >
> > Reading through the 2 Day DBA guide will surely be helpful, too. Pay
> > close attention to sections describing how to manage database using SQL
> > commands - some things can't be done from the GUI and (I think) running
> > database creation/upgrade scripts is one of them, so you should really
> > get yourself familiar with SQL*Plus.
> >
> > Regards,
> > Vladimir M. Zakharychev
> > N-Networks, makers of Dynamic PSP(tm)
> > http://www.dynamicpsp.com
> >

>
>

> The script runs with errors. This appears multiple times in the log:
>

> ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
> ORA-06508: PL/SQL: could not find program unit being called:
> "SYS.DBMS_AQADM_SYS"
Strange. In SQL*Plus, type

SHOW ERRORS PACKAGE BODY SYS.DBMS_AQADM_SYS and see why it doesn't want to compile (or post the errors here.)

Regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Fri Oct 06 2006 - 17:26:10 CEST

Original text of this message