Pre-Setup for OAEA Datasource
Create new script from Original txk script and change as per below differene ############################################## [applmgr@apps-server 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@apps-server 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