Re: Data Pump error

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?

[Quoted] 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 Received on Tue Oct 03 2006 - 18:01:29 CEST