This discussion is archived
4 Replies Latest reply: Nov 2, 2012 3:44 PM by User407588 RSS

How to use FNDCPASS in shell script

949850 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points