user_pwd_unlock.sh

echo "Reset password du user : "$4" avec le pwd : "$5
echo "Le pwd doit être de la forme : ABC;xyz!123"

export ORACLE_SID=$3
w_user=$4
w_pwd="$5"

sqlplus $1/$2 <<EOSQL
WHENEVER SQLERROR EXIT SQL.SQLCODE

alter user "${w_user}" identified by "${w_pwd}" account unlock;

EOSQL