4 Replies Latest reply: Nov 2, 2012 5:44 PM by User407588 RSS

    How to use FNDCPASS in shell script

    949850
      Hi,

      My environment is 11.5.10.2 with 10gR2 db on OEL.

      I am trying to use FNDCPASS in shell script to change the password. The shell script looks like

      NEWPASS=`grep apps APPS_INFO | awk -F= '{print $2}'`
      SYSPASS=`grep system APPS_INFO | awk -F= '{print $2}'`
      CURRPASS=`grep sec APPS_INFO | awk -F= '{print $2}'`

      FNDCPASS apps/$CURRPASS 0 Y system/$SYSPASS SYSTEM APPLSYS $NEWPASS

      If I echo the shell variables, it outputs the correct values, but FNDCPASS fails with the error

      APP-FND-01564: ORACLE error 1017 in AFPCOA
      Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied.
      The SQL statement being executed at the time of the error was: and was executed from the file .

      FNDCPASS is not accepting $variable_name.

      Any help in making this work will be usefull as I am trying to automate password changes.

      Thanks,
      Jagadish