Invalid directory patch

[latifa]

Hi Erman,

I have the follwoing error message and I don't know what's wrong:

Request.log:

CONSTRUCTION_XML 010 : WRITETOFILE : /data/flf/files/DBOFINP1_BALANCE/data/out/ORDER_4836762_20200925102056.xml
Erreur procedure CONSTRUCTION_XML :CONSTRUCTION_XML 010 : WRITETOFILE : /data/flf/files/DBOFINP1_BALANCE/data/out/ORDER_4836762_20200925102056.xml
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "XDB.DBMS_CLOBUTIL", line 166
ORA-29280: invalid directory path
ORA-29280: invalid directory path
Erreur procedure CONSTRUCTION_XML.


PS:
AS SYSDBA@SYS@DBOFINP11 >show parameter utl

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines               string
utl_file_dir                         string      /usr/tmp/DBOFINP1, /usr/tmp, /
                                                 data/flf/files/DBOFINP1/data/o
                                                 ut
 and the is a ling from DBOFINP1_BALANCE to DBOFINP1.

Thank you in advance for your help.

Latifa

[ErmanArslansOracleBlog]

You  are probably hitting this one -> "Does the UTL_FILE Package Support Symbolic Link Files? (Doc ID 1179287.1)"

Please review and update me.

[latifa]

I can't find this parameter in pfile

[latifa]

Hi Erman,

temporarely, we decided to define that directory with direct path without link which means Instance_name only wothout BALANCE and it works.
We should find what has changed because It was working fine before !!

Thank you again for your help :)

Regards,
LD

[ErmanArslansOracleBlog]

Yes! that's the fix. sure..
That parameter, however; is a workaround. That parameter, I mean utl_file_follow_symlinks is a hidden parameter, so you can't directly see it in your pfile.. You normally set it and check it using a hidden-parameter aware sql.
A query like the following;

SELECT
  ksppinm,
  ksppstvl
FROM
  x$ksppi a,
  x$ksppsv b
WHERE
  a.indx=b.indx
AND
  substr(ksppinm,1,1) = '_'
ORDER BY ksppinm
/