#!/bin/bash
#
# Change passwords on an 11i instance.
#

while [ -z $ORACLE_SID ]
do
    echo -n "Enter the ORACLE_SID:  "
    read ORACLE_SID
done

while [ -z $SYSTEM_PASS ]
do
    echo -n "Enter current password for SYSTEM:  "
    read SYSTEM_PASS
done

while [ -z $NEW_SYSTEM ]
do
    echo -n "Enter new password for SYSTEM [manager]:  "
    read NEW_SYSTEM
    if [ -z $NEW_SYSTEM ]
    then
        NEW_SYSTEM=manager
    fi
done

while [ -z $APPS_PASS ]
do
    echo -n "Enter current password for APPS:  "
    read APPS_PASS
done

while [ -z $NEW_APPS ]
do
    echo -n "Enter new password for APPS [apps]:  "
    read NEW_APPS
    if [ -z $NEW_APPS ]
    then
        NEW_APPS=apps
    fi
done

while [ -z $NEW_SYSADMIN ]
do
    echo -n "Enter new password for SYSADMIN [sysadmin]:  "
    read NEW_SYSADMIN
    if [ -z $NEW_SYSADMIN ]
    then
        NEW_SYSADMIN=sysadmin
    fi
done

while [ -z $NEW_PASS ]
do
    echo -n "Enter new password for all Oracle Application schemas [password]: "
    read NEW_PASS
    if [ -z $NEW_PASS ]
    then
       NEW_PASS=password
    fi
done

sqlplus system/$SYSTEM_PASS@$ORACLE_SID << EOF
whenever sqlerror exit failure

ALTER USER system IDENTIFIED BY $NEW_SYSTEM;
EXIT

EOF

FNDCPASS apps/$APPS_PASS 0 Y system/$NEW_SYSTEM SYSTEM APPLSYS $NEW_APPS
FNDCPASS apps/$NEW_APPS 0 Y system/$NEW_SYSTEM USER SYSADMIN $NEW_SYSADMIN
FNDCPASS apps/$NEW_APPS 0 Y system/$NEW_SYSTEM ALLORACLE $NEW_PASS