DataPump OEM Jobs fail with "ERROR: No data pump job named "<jobname>" exists in the database. "
Last updated on MAY 03, 2018
Applies to:Enterprise Manager for Oracle Database - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 12.1 to 13.1]
Information in this document applies to any platform.
Unable to run repeating DataPump export jobs against 184.108.40.206 PDBs (pluggable databases) from OEM.
The scheduled jobs fail with:
ORA-01017: invalid username/password; logon denied
SP2-0640: Not connected
ERROR: No data pump job named "<jobname>" exists in the database.
even though preferred credentials are set correctly and non repeating export jobs work without error.
The issue reproduces with 220.127.116.11 & 18.104.22.168 DB Plugin against 12.1 PDB databases.
The step by step instructions to reproduce the error are:
- Targets -> Databases -> select a pluggable database
- Schema -> Database Export/Import -> Export to Export files
- Type : Schemas
-> Step 1 select a schema, Step 2 and 3 hit next
-> Step 4 select Start Later <date> / Repeat Interval <n>
-> Step 5 Submit Job
- When the job runs it will fail with:
Scheduling jobs would work in 11.2, but not for PDB databases such as 12.1 and 12.2
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms