1. Error occurs only when reading a file using UTL_FILE. ERROR at line x: ORA-29284: file read error ORA-06512: at line x Where x can be any line number. 2. Truss file shows a block of file is read and subsequent blocks cannot be read or corrupted because of NLS (ORA_NLS10) ...
2. It is our understanding that DIRECTORY at DB and OS are having correct settings because the write or read file error can also occur because of incorrect directory settings. If not, please check and make sure the DIRECTORY settings are fine. For example: SQL> create directory TESTDIR as ...
SEVERE: Oct 12, 2019 3:25:09 AM oracle.assistants.dbua.prereq.PreUpgradeDriverJob call SEVERE: ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to: ORA-06512: at "SYS.UTL_FILE", line 106 ORA-06512: at "SYS.UTL_FILE", line 746 ORA-06512: at "S...
alter system set events '1403 trace name errorstack level 3'; NOTE: In databases that are heavy loaded, setting this event will produce many trace files. It is recommended to set this when the database is not intensively used. Then re-run the DataPump export/import to reproduce the error ...