1 Reply Latest reply on Apr 29, 2016 3:37 PM by Bashar.

    Shell script to check ftp connection is established and folder permissions are in place

    2739125

      Hi All,

       

      in Oracle R12:

      I'm using the below shell script saved in a file XXEXTRACTTMT, which imports the files from remote server SFTPTDA120FTP into our Oracle application.server.

       

      i am running this file thru concurrent program in Oracle and I see the files are getting loaded in to Oracle.

       

       

      !ftp -i -n SFTPTDA120FTP

      user amaran K!ka@123

      ascii

       

      cd Forms

      cd Reprots

      lcd /d90/oracle/PROD/apps/apps_st/appl/EXTRACT/files

      mget timesheet*

      bye

       

       

      now the requirement is :

      I want to test the below

      > check whether the remote connection is established ?

      ex: when we running the conc program, if the program is failed to connect the remote server( say password is changed)

      then I should get some log messages in my conc request log.

       

      > check whether the user has required permissions to retrieve the files in folder: Forms/Reports/

       

       

      Can some one help me to modify the code and add the conditions based on the requirement provided ?




      -Kartheek B