DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: init.ora - UTL_FILE_DIR

  1. #1
    Join Date
    May 2002
    Posts
    108
    Hi,

    I have a problem while writing to a file using utl_file.

    utl_file_dir=/var/tmp,/abc/test,/DB/tests

    Documentation recommends to specify each directory in single line. I have changed it to

    utl_file_dir=/var/tmp,
    utl_file_dir=/abc/test
    utl_file_dir=/DB/tests

    And have bounced the DB. Still I get INVALID_PATH exception.

    Will the comma in the first line err out?

    Any help will be appreciated.

    Cheers,
    Nandu
    Never give up !

    Nanda Kumar - Vellore

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Note that all users can read or write all files specified in the UTL_FILE_DIR parameter(s).
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    May 2002
    Posts
    108

    Note that all users can read or write all files specified in the UTL_FILE_DIR


    Thanks Suresh. That is the expected behaviour.

    But my worry is, it is throwing an exception INVALID_PATH.

    I have a question !

    If the first path mentioned in the UTL_FILE_DIR is invalid and the consequtive paths are valid, what will happen?

    Pls. note that, for this database I don't have access to V$ views to check the values.

    Cheers,
    Nandu
    Never give up !

    Nanda Kumar - Vellore

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    find a dba/user that can access v$parameter

    issue the command

    show parameters utl;

    This will tell you values for parameters starting with utl.

    figure it out from there.

    Good Luck



    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  6. #6
    Join Date
    May 2002
    Posts
    108

    Thanks Sureshy!

    It's a shame ... I can't access the V$ views..

    Its not the DB I maintain... and it is just to help my team, as the DBA is not around.

    Anybody else, have ever been stuck up with INVALID_PATH?

    Help Please !

    Cheers,
    Nandu
    Never give up !

    Nanda Kumar - Vellore

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    Don't take this wrong, but are you sure the paths exist? Correct spelling? (You said it wasn't your database - maybe you were given some wrong info about directory locations.)

  8. #8
    Join Date
    May 2002
    Posts
    108
    Don't take this wrong, but are you sure the paths exist?

    Thats a very valid point u have made.

    I have checked with the path. Case sensitivity... etc.,

    Everything is fine.

    I still wonder if something is wrong with the Parameter setting itself... pls. see msg., above for how it looks like.

    Cheers,
    Nandu

    Never give up !

    Nanda Kumar - Vellore

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    Okay, who owns the directories? Should be oracle.

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    NANDU:

    According to Oracle "The directories that UTL_FILE can read from and write to need to have permissions of the Oracle instance owner and the user running the package."

    Run chmod 777 directory_name at the unix prompt and this might help.

    Something else:

    utl_file_dir=/var/tmp, utl_file_dir=/abc/test, utl_file_dir=/DB/tests

    should be enough for the init.ora
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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