DBA Activities

below are some basic and usefull dba activities for oracle application environment -

1) To bounce the OA Core service
Solution -   cd   $ADMIN_SCRIPTS_HOME  or
                   cd   $INST_TOP/admin/scripts
stop and start script adoacorectl.sh to bounce and restore oa core. run status to check the oa core status-

2) Audit Sign On
Solution - There is a system level profile "Sign-On:Audit Level". Set this profile with following values -

                 1) None

                 2) User

                 3) Responsibility

                 4) Forms

After enabling this profile table "FND_LOGIN_RESP_FORMS" will capture the log in details

3) Hide password in unix

    echo "Write down Your Name"

    stty -echo

    read v_user_name

   stty echo

   echo " "use of stty will hide the user inputon screen.