My Oracle Support Banner

Datapatch for Datapump patch fails with "ORA-65100: missing or invalid path prefix" (Doc ID 2672864.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Generic UNIX

Symptoms

 Datapatch for datapump patch 28318139 fails with below error

Current state of interim SQL patches:
Interim patch 28318139 (ORA-31003 ERROR WHEN IMPORTING FULL DATABASE IN PARALLEL):
Binary registry: Installed
PDB CDB$ROOT: Applied successfully on <timestamp>
PDB PDB$SEED: Applied with errors on <timestamp>

28318139_apply_ DBNAME _PDBSEED _<timestamp>.log shows:
..
catdph.sql
1 row selected.
00000000.032 dpload processing prvtbpvi.plb
Session altered.
Grant succeeded.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
BEGIN
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P000
ORA-06512: at line 9
ORA-65100: missing or invalid path prefix - /$ORACLE_HOME /admin/DBNAME/dpdump/9EF366067B796072E0540010E0E1E8CF
ORA-06512: at "SYS.DBMS_DATAPUMP_UTL", line 465
ORA-06512: at "SYS.DBMS_DATAPUMP_UTL", line 629
ORA-06512: at line 2
PL/SQL procedure successfully completed.

 When reviewed dba_directories also fails with below error

SQL> select * from dba_directories ;
select * from dba_directories
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P000
ORA-65100: missing or invalid path prefix -
/$ORACLE_HOME /admin/DBNAME/dpdump/9EF366067B796072E0540010E0E1E8CF

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.