Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81

    Unanswered: problem during executing loader

    On AIX is running Oracle 9.
    Executing the loader i gives me this error message:
    ----------
    Record 77390: Rejected - Error on table MY_TABLE_NAME.
    ORA-01116: error in opening database file 24
    ORA-01110: data file 24: '/arch/oradata/undotbs1.dbf'
    ORA-27092: skgfofi: size of file exceeds file size limit of the process
    Additional information: 625000
    Additional information: 1024001
    --------------

    Before posting this new thread i searched the forum for possible solution that people may have posted before. The only one i found has to do with the file initSID.ora where i should comment the AIO. I checked these file but i didn't find any AIO string to comment. I am new on DB administration, so anyone can give me aa opinion?

    thanks in advance,
    ducasio

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I guess you could start with checking ulimit for the oracle user.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    the result for user oracle is:
    ------------------
    $ ulimit -a

    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) unlimited
    stack(kbytes) unlimited
    memory(kbytes) unlimited
    coredump(blocks) 2097151
    nofiles(descriptors) 2000
    -----------------------------

    and for the user i execute the sqlloader is:
    -----------------------
    $ ulimit -a

    time(seconds) unlimited
    file(blocks) 10000000
    data(kbytes) unlimited
    stack(kbytes) unlimited
    memory(kbytes) unlimited
    coredump(blocks) 2097151
    nofiles(descriptors) 2000
    --------------------------

    but the problem is not on the file size limit of the unix user account. I can execute the loader without problems pointing to another DataBase. So i can't understand wich is the difference between these two DBs, wich parameter should i change.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Is the OS file size limit 2GB & is the resultant file close to that size?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    No, the filesize limit of the OS is unlimited and the file to load is about 300Mb. I don't think it is a problem of the OS or of the unix user. When i try to load from the same unix user to another DataBase, i do not have problems.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ORA-27092 skgfofi: size of file exceeds file size limit of the process
    Cause
    An attempt was made to open a file that exceeds the process's file size limit (ulimit), additional information shows the current limit (logical blocks) and the size of the file (logical blocks).

    Action
    increase the processes file size limit (ulimit) and retry.
    >ORA-27092: skgfofi: size of file exceeds file size limit of the process
    >Additional information: 625000
    >Additional information: 1024001
    IMO, these indicate problem at OS level.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    i have read the oracle error documentation and i did the relative controls before putting the answer in this forum. Anyway i have posted here the parameters i get from ulimit -a command as well. And after all, how can i explain that from the same unix user i can load to one db(oracle_sid1) and not to the other db(oracle_sid2)?

Posting Permissions

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