The log file shows an error like below:
Entered into Begin.
l_path_value../usr/tmp
Invalid File Operation : ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
This is not due to the permission like read/write in the directory path /usr/tmp/
It is due to from one login say sysadmin submitted the program and generates the .csv or .txt file in /usr/tmp/ directory. The file will get saved in the directory. when one more time needs to submit from another user login then the error will throw in log file
Entered into Begin.
l_path_value../usr/tmp
Invalid File Operation : ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
At first needs to delete the .csv file in the /usr/tmp/ directory and then from another login can able to submit the program and generate the .csv file. Because my 2 test instances are commonly having /usr/tmp/ directory so from one test instance the file first generted then while running from another test instance the csv file won't get replaced the existing file permission denied will come through putty also we can't able to delete or replace the file from another login credentials.
There is another way one way is to delete the file and generate the file or
Needs to give permissions for the file in the directory by chmod 777 filename or winscp
so that from any login submitted the program it will replace the old file as of now it will be generated in read mode only.
No comments:
Post a Comment