11.0.3/utl_file_dir parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: 11.0.3/utl_file_dir parameter

  1. #1
    Join Date
    Dec 2001
    Posts
    139
    Hi Guys,

    I'm trying to configure one of the instances for Oracle Applications 11.0.3 i.e. VD11.

    When I'm running autoinstall utitlity adaimgr. And want to activate all the installed products. I'm getting stuck at the point where it prompts for log/output directory.

    The message I'm getting

    "Some PL/SQL programs produce temporary log/output files. The directories used for this must be listed in the init.ora parameter utl_file_dir. The value for utl_file_dir for this database is "C:\oa\orant\plsql80\temp"

    This is the prompt
    Enter the directory for temporary log/output files from PL/SQL programs directory:

    I've checked the init.ora file for VD!! it has the parameter
    utl_file_dir=C:\oa\orant\plsql80\temp

    but when I'm entering the same value at the prompt it is not accepting it.
    Can somebody tell me what I'm doing wrong?
    How can I overcome this problem????????
    Do I have to create a new directory.
    Do I have to add the directory manually to the respective init.ora file???????
    As release 11.0.3 is using database version 8.0.5

    And in 8i we have the pl/sql package to add files. What about in Oracle applications. Gone thru tons of Info but couldn't figure it out
    Can some body list the steps or precautionary measures I've to take at this point.
    Can some body shed some light on utl_file_dir parameter too.
    I'M TRYING TO CONFIGURE VISION DATABASE with VD11 as its instance name.

    Or am i doing something wrong in autoinstall adaimgr utility
    ????????????????
    All tips and pointers would be greatly appreciated and admired

    Thanks in Advance.
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  2. #2
    Join Date
    Jul 2002
    Posts
    3
    Hi

    Please check the following entries in $APPL_TOP/TEST42.env
    file.
    #
    # APPLDCP tells the Concurrent Manager whether you are using
    # the Distributed Concurrent Processing feature.
    #

    APPLDCP="OFF"
    export APPLDCP

    APPLCSF="/test42exe/comn/temp"
    export APPLCSF

    #
    # APPLLOG and APPLOUT are the subdirectories in which
    # the Concurrent Manager puts log and output files.
    #

    APPLLOG="log"
    export APPLLOG

    APPLOUT="out"
    export APPLOUT

    #
    # APPLTMP is the directory in which Oracle Applications
    # temporary files are created.
    #

    APPLTMP="/test42exe/comn/temp"
    export APPLTMP

    #
    # APPLPTMP is the directory in which PL/SQL output files are created.
    #

    APPLPTMP="/test42exe/comn/temp"
    export APPLPTMP

    regards

    nutmut

  3. #3
    Join Date
    Dec 2001
    Posts
    139
    Hi Nutmut

    Thanx for ur help. Forgot to mention one thing that I'm configuring VD11 environment of 11.0.3 on Win 2000 OS

    And your posting looks like related to Unix environment. My question the directory hierarchy in Windows & Unix I suppose is same ???????????

    Would there be any differences in these two OS in relation to configuration of 11.0.3.

    Thanx
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  4. #4
    Join Date
    Jul 2002
    Posts
    3
    Hi

    Sorry, but i am not sure windows2000 file structre. But check
    your environment file, then modifiy the entries.

    regards
    ravi

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Shaan,

    Check out the permissions on utl_file_dir. Its just my guess. do you have any logs/output currently generated in utl_file_dir ? If so by what user/apps? and what permissions that particular user have ? try giving the same permissions on that dir for all the users/apps which use that dir.
    Reddy,Sam

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