Database Admin

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
Share this:
Click to share on WhatsApp (Opens in new window)
Click to share on LinkedIn (Opens in new window)
Click to share on Twitter (Opens in new window)
Like this:
Like Loading...


	
Related