Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> IMPDP - ORA-31626: job does not exist
msmajhail
post Apr 3 2012, 06:04 PM
Post #1


Newbie
*

Group: Possible Spammers
Posts: 1
Joined: 20-September 10
Member No.: 43,877



I am trying to do a impdp using a network link and it fails with the ORA-31626: job does not exist.
It worked with a different database on the same server. The network link is there, data pump directory exists, the read and write privileges are granted to the oracle user.

There are no other data pump jobs running:

SQL> select JOB_NAME,STATE from DBA_DATAPUMP_JOBS;

no rows selected


My database details:

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production


The whole error is listed below:

omdx16dd$ impdp oracle@xtst080 SCHEMAS=BRM REMAP_SCHEMA=BRM:MBR_SLN CONTENT=METADATA_ONLY DIRECTORY=DATA_PUMP_DIR NETWORK_LINK=po02

Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 03 April, 2012 17:20:33

Copyright © 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
Go to the top of the page
 
+Quote Post
burleson
post Apr 4 2012, 12:40 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,431
Joined: 26-January 04
Member No.: 13



Hi,

This may be a bug. See MOSC note 549781.1 .


http://support.oracle.com

See http://www.dba-oracle.com/t_dba_datapump_jobs.htm

Also look at dba_datapump_jobs.

Start here and see if you have any hung or aborted jobs:

CODE
select
   owner_name,
   job_name,
   operation,
   job_mode,
   state,
   attached_sessions
from
   dba_datapump_jobs
where
   job_name not like 'BIN$%'
order by 1,2;


************************************************
>> CONTENT=METADATA_ONLY

The dump file does not eseem to match the remap statement.


ORA-31626: job does not exist

Cause:An invalid reference to a job which is no longer executing, is not executing on the instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification.


Action:
Start a new job, or attach to an existing job that has a valid Master Table.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st September 2014 - 06:27 PM