Showing posts with label expdp. Show all posts
Showing posts with label expdp. Show all posts
Thursday, August 18, 2022
ORA-31626: job does not exist
dsvmofs> expdp system/XXXXX parfile=auexpfulltts.dat
Export: Release 11.2.0.4.0 - Production on Wed Aug 17 05:29:16 2022
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-00372: file 7 cannot be modified at this time
ORA-01110: data file 7: '/OFSSITDATA2/oradata/owad01.dbf'
dsvmofs> cat auexpfulltts.dat
directory=dmpdir
metrics=y
dumpfile=xttsfulltts%U.dmp
filesize=1048576000
full=y
exclude=STATISTICS
logfile=expfulltts.log
parallel=8
transportable=always
version=12
dsvmofs>
Root cause : Customer has SYS related tables in OWAPUB Tablespace, We made OWAPUB readonly as pert of TTS Activity.
Solution : Moved the SYS related tables from OWAPUB tablespace to SYS.
Other alternative solutions
1. Before restarting the expdp check if there are orphan Data Pump jobs left in database. Use << Note 336014.1 >>
2. After clearing the orphaned jobs if you still see the errors, Upload output of below queries.
connect as sysdba
spool boxa.html
set pagesize 9999
set markup html on
select name from v$database;
SELECT * from v$version ;
SELECT distinct(length(addr)*4) "Word Size" from v$process;
SELECT owner,object_name,object_type,status from dba_objects where status = 'INVALID';
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;
SELECT SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, modified,
SUBSTR(comp_name,1,30) comp_name, substr(schema,1,15) as schema
FROM dba_registry order by comp_id;
select * from registry$history;
Subscribe to:
Posts (Atom)
Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)
Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...
-
In this Document Goal Ask Questions, Get Help, And Share Your Experiences With This Article Solution 12c TDE FAQ documentation Quick...
-
This document describes how to develop and deploy customizations in an Oracle E-Business Suite Release 12.2 environment. Follow thes...
-
This document also provides links to two presentations on the subject: Oracle OpenWorld presentation "Technical Upgrade Best Practice...