I tried to use sqlldr to load flat file to Oracle 10g on Linux. It come up a error message as ' SQL*Loader-522 Ifiopn failed for file(file_name.log). I checked SQL Loader error on Oracle documents. It tells me this is ' LFI failed to open the file, it either is OS error or memory problem'. Anyone know how to resolve this error. Thanks.
user was granted DBA, connect and resource roles. The target file exist. The path to file is correct. file_name.log is the same as control file. If I don't specify the path for log file, it will be created in the same path as control file. Am I right? But it still doesn't work and the same error still comes up.
Thanks. I run sqlldr as Oracle user. When I created Oracle user on linux, I grant Oracle user DBA privileges. My oracle home is: /u01/app/oracle/product/10.2.0/db_1. I put sqlldr control file in another directory: /u01/app/XXXX/xxxx/xxxxx/tcl/control_file.ctl. If I don't specify the path for log file, it suppose to be generated in the same directory as contril_file.ctl during sqlldr process.
What do you mean, in your post, that I need to make sure that Oracle account on linux has the OS privileges to generate log file on /u01/app/XXXX/xxxx/xxxxx/tcl directory? If I want to chane permissions on this directory, should I modify Oracle account or directly change file or directory permissions by using chmod?