Pre-Setup for OAEA Datasource
Create new script from Original txk script and change as per below differene
##############################################
[applmgr@sjebsappuatg52 bin]$ diff $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl /dba/scripts/OAEAJDBCDS_Update.pl
439c439
trDirPathToBase($gCtxVars{$s_fndtop} . "/patch/115/bin/txkManageDBConnectionPool.py");
my $py_script = "OAEAJDBCDS_Update.py";
##############################################
[applmgr@sjebsappuatg52 bin]$ diff $FND_TOP/patch/115/bin/txkManageDBConnectionPool.py /dba/scripts/OAEAJDBCDS_Update.py
69a70,72
print '---------------------------------------------------------------------'
print 'Calling OAEA Script(Modifified) !!!'
print '---------------------------------------------------------------------'
204c207
< DATASOURCENAME = 'EBSDataSource'
DATASOURCENAME = 'OAEADatasource'
[applmgr@sjebsappuatg52 bin]$
Original Script
#*********************************************************************
mkdir -p $HOME/log
LOGFILE=/dba/scripts/logs/${TWO_TASK}<em>update_apps_weblogic</em>$(date +"%d_%b_%Y"-%H_%M).log;touch $LOGFILE
echo "……………………..The Log file for Session is Locate at $LOGFILE"
##### Script STARTS Here
read -s -p "Enter Current APPS Password: " APPS_PWD
echo $'\n'
read -s -p "Enter Current Weblogic Password: " WLS_PWD
echo $'\n'
read -s -p "Enter New Weblogic Password: " WLS_NEW_PWD
echo $'\n'
#
(echo "Current APPS Password is : $APPS_PWD";
echo "Current Weblogic Password is : $WLS_PWD"
echo "New Weblogic Password is : $WLS_NEW_PWD"
echo $'\n'
echo " ------------------------------------------------------------------"
echo " Starting Admin Server …….."
echo " ------------------------------------------------------------------"
cd $ADMIN_SCRIPTS_HOME
sh adadminsrvctl.sh start <<EOF
$WLS_PWD
$APPS_PWD
EOF
echo " Starting Admin Server …….. Completed"
echo $'\n'
echo " ------------------------------------------------------------------"
echo " Updating WLS Data Source"
echo " ------------------------------------------------------------------"
Updating WLS Data Source
cd $FND_TOP/patch/115/bin
perl txkManageDBConnectionPool.pl -options=updateDSPassword -contextfile=$CONTEXT_FILE <<EOF
$WLS_PWD
$APPS_PWD
EOF
Updating WLS OAEA Data Source --Custom
cd /dba/scripts/
perl OAEAJDBCDS_Update.pl -options=updateDSPassword -contextfile=$CONTEXT_FILE <<EOF
$WLS_PWD
$APPS_PWD
EOF
echo " ------------------------------------------------------------------"
echo " Changing the Weblogic Password"
echo " ------------------------------------------------------------------"
Change the Weblogic Password
cd $FND_TOP/patch/115/bin
perl txkUpdateEBSDomain.pl -action=updateAdminPassword -contextfile=$CONTEXT_FILE <<EOF
Yes
$WLS_PWD
$WLS_NEW_PWD
$APPS_PWD
EOF
echo "---------------------------------------------"
echo "Apps & Weblogic Password updated Successfully"
echo "Login into Admin Server and Verify the new weblogic passowrd"
echo "Start anyone of Managed server (oacore) ,Test DataSource."
echo "---------------------------------------------" )|tee -a $LOGFILE
echo "……………………..The Log file for Session is Locate at $LOGFILE"
##### Script ENDS Here
