datapatch fails with ORA-22288 and ORA-03113 error for prvt_emx.register_files(TRUE)

(Doc ID 2342091.1)

Last updated on DECEMBER 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

While running datapatch -verbose, datapatch fails for prvt_emx.register_files package / procedure.

For 12.1.0.2 database:

SQL> exec prvt_emx.register_files(TRUE);
BEGIN prvt_emx.register_files(TRUE); END;

*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.PRVT_EMX", line 735
ORA-06512: at "SYS.PRVT_EMX", line 222
ORA-06512: at "SYS.PRVT_EMX", line 425
ORA-06512: at line 1

 

 

For 12.2.0.1 database:

SQL> exec prvt_emx.register_files(TRUE);
BEGIN prvt_emx.register_files(TRUE); END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4260
Session ID: 17 Serial number: 2333

 

 

Changes

Applied proactive DB BP or PSU patch and executed datapatch.

Cause

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