SQL*Loader -522 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: SQL*Loader -522 error

  1. #1
    Join Date
    Jan 2006
    Posts
    39

    SQL*Loader -522 error

    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.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    Cool


    Check for Linux permissions and/or correct path where file_name.log is being created.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jan 2006
    Posts
    39
    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.

  4. #4
    Join Date
    Jul 2005
    Posts
    3
    Hi
    linux permissions as in the directory where you are writing the log file do you have write permission in that directory. go to the directory and type

    $ touch try.log

    if this file is created as 0 bytes then you have write permission, then try sqlldr again

    thanks
    MAX

  5. #5
    Join Date
    Jan 2006
    Posts
    39
    maxdbo:

    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?
    Last edited by traveller; 03-03-2006 at 02:15 PM.

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    Cool

    Quote Originally Posted by traveller
    ... 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.

    If path's are not specified, sqlloader will attemp to create the files (bad,dsc and log) on the current directory (from wherever it was launched).

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  7. #7
    Join Date
    Jan 2006
    Posts
    39
    Thank you all for your advice. I have solved the problem.

  8. #8
    Join Date
    Apr 2007
    Posts
    2
    I am seeing the same error but on a XP machine.
    All folders are read/write able.

    I searched for the log file and it does not exist.

    Any suggestion ?

  9. #9
    Join Date
    Apr 2007
    Posts
    2
    Never mind !! I just realized the sample control file I got from a site was inappropriate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width