Re: Data Pump error
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 02 Oct 2006 08:08:06 -0700
Message-ID: <1159801685.931659_at_bubbleator.drizzle.com>
>> 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
>>
>
[Quoted] > If I just installed Oracle Express, what is the password for SYSDBA?
Date: Mon, 02 Oct 2006 08:08:06 -0700
Message-ID: <1159801685.931659_at_bubbleator.drizzle.com>
[Quoted] 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
>>
>
[Quoted] > If I just installed Oracle Express, what is the password for SYSDBA?
SYSDBA doesn't have a password ... SYS does. SYSDBA is a role. What precisely are you using to log in ... all of it ... as you are typing it into the prompts?
-- Daniel Morgan University of Washington Puget Sound Oracle Users GroupReceived on Mon Oct 02 2006 - 17:08:06 CEST