ORA-29283: invalid file operation

Recently, due to the need to migrate the Oracle database, UTL_FILE_DIR settings (oracle11g, linux) are involved ). It is mainly used to output logs for executing stored procedures.

At that time, the following operations were done:

Create directory PROC_LOG_DIR as '/ispay/ispay_dblog ';
Grant read, write on directory PROC_LOG_DIR to public;

However, when executing the stored procedure, the following error is reported:

ORA-29283: invalid file operation
ORA-06512: In "SYS. UTL_FILE", line 41
ORA-06512: In "SYS. UTL_FILE", line 512
ORA-29283: invalid file operation
ORA-06512: In "ISPAY. PROC_TICKET_INVALID", line 47
ORA-06512: In line 1

If the specified path is already created, make sure that there is no misspelling. Oracle users do not have read and write permissions on ispay/ispay_dblog. After the root user of the company modifies the permission, the operation is normal.