Problem with Oracle directories on Windows and Oracle 21c
Oracle 21c (21.10.0.0), Windows Server 2019
Oracle Home on drive E:
Directories work fine if they are on drive E: but never work if they are elsewhere (drive F: for example). Oracle error is ORA-29283.
Same OS (visible) rights on E:\Jobs and F:\Jobs
------- Test Code :
CREATE DIRECTORY DD_JOBSM31TRACE AS 'E:\Jobs';
CREATE DIRECTORY DD_JOBSM31TRACE2 AS 'F:\Jobs';
set serveroutput on;
DECLARE
hFile UTL_FILE.FILE_TYPE;
BEGIN
BEGIN
hFile := UTL_FILE.FOPEN('DD_JOBSM31TRACE', 'debugoutils.txt', 'r', 4096);
UTL_FILE.FCLOSE(hFile);
dbms_output.put_line('DD_JOBSM31TRACE ok');
END;
BEGIN
hFile := UTL_FILE.FOPEN('DD_JOBSM31TRACE2', 'debugoutils.txt', 'r', 4096);