datapatch fails with ORA-22288 and ORA-03113 error for prvt_emx.register_files(TRUE)
(Doc ID 2342091.1)
Last updated on OCTOBER 24, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
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 |
| Changes |
| Cause |
| Solution |