user12879396 wrote:This means that:
File does not exist or it is not accessible
I assume that there is no problem on database side.
CREATE OR REPLACE DIRECTORY DIR AS '/oracle/test/inst/apps/erp-server/logs/appl/conc/out'; GRANT EXECUTE, READ, WRITE ON DIRECTORY DIR TO APPS WITH GRANT OPTION; GRANT READ ON DIRECTORY DIR TO PUBLIC; GRANT EXECUTE, READ, WRITE ON DIRECTORY DIR TO SYS;
You should be able to list the file. Please post the output of this command.
ls -l /oracle/test/inst/apps/erp-server/logs/appl/conc/out/XXSUPPSTMTSTE_681129_1.PDF
cp /oracle/test/inst/apps/erp-server/logs/appl/conc/out/XXSUPPSTMTSTE_681129_1.PDF /oracle/test/inst/apps/erp-server/logs/appl/conc/out/TEST.PDF
user12879396 wrote:Which Unix user have you used? applprod or oracle?
* Connect to your Unix server with Oracle user (oracle most probably) and check the file with the command
-rwxrwxrwx 1 applprod dba 130344 Oct 25 2010 /oracle/PROD/inst/apps/PROD_ho-erp-p1/logs/appl/conc/out/XXSUPPSTMTSTE_681129_1.PDF
I am using apps user in sql developer while access the unix server from other user
but the you are showing another directory:
CREATE OR REPLACE DIRECTORY DIR AS '/oracle/test/inst/apps/erp-server/logs/appl/conc/out';
I got a bit confused.
Then, as I said before
SELECT * FROM all_directories WHERE directory_name='DIR'; SELECT grantee, table_name directory_name, privilege FROM user_tab_privs WHERE table_name = 'DIR';