0 Replies Latest reply: Jul 25, 2013 8:48 PM by SusanJK RSS

    ora-20100 not working!

    SusanJK

      Hi All,

       

      I did a bit of research within OTN but my life isn't getting any peace because i cant resolve it ..

       

      Alright i got 2 application nodes r 12.1.3 and 2 database tiers 11.2.0.2

       

      application nodes context_file entry for applptmp, appltmp and applcsf is correct i.e. /applptmp/EBSUAT/apps/tmp

      database nodes for utl_file_dir is as following :

      SQL> show parameter utl_file_dir;

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      utl_file_dir                         string      /applptmp/EBSUAT/apps/tmp, /ap

                                                       plptmp/EBSUAT/apps,  /tmp, /us

                                                       r/tmp

       

      i have given chmod 777 to the tmp directory :

      drwxrwxrwx 6 applebsuat oinstall73728 Jul 26 08:42 tmp

       

       

      /applptmp/EBSUAT/apps/tmp --> is a shared file directory between the application nodes and database nodes and i can view them touch files from each node as required.

      yet i get the following error:

       


      SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
      BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;

      *
      ERROR at line 1:
      ORA-20100: Error: FND_FILE failure. Unable to create file, o0720419.tmp in the
      directory, /applptmp/EBSUAT/apps/tmp.
      You will find more information in the request log.
      ORA-06512: at "APPS.FND_FILE", line 417
      ORA-06512: at "APPS.FND_FILE", line 526
      ORA-06512: at line 1

      Please do note i am having this issue after post clone!!!

      if anyone could shed some light this way it will be really appreciated

      regards
      Susan