Database Administration (MOSC)

MOSC Banner

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center