Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Script to grab patches needed for 11i Vision upgrades
#!/bin/bash
# gp_11i_ff.sh
# Contact/blame: John Piwowar
# Purpose: Grab patches necessary to "fast-forward" an 11i Vision instance
# to a more up-to-date techstack and database tier
# Notes: Revisit the reference notes; even 11i requirements change over time.
# Especially for the dearly beloved Forms 6i software
# References:
# Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
# (Doc ID 216550.1)
# Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2
# (11.2.0.2) (Doc ID 881505.1)
# Using J2SE Version 6 with Oracle E-Business Suite 11i
# (Doc ID 401561.1)
# Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle
# E-Business Suite 11i (Doc ID 290807.1)
# Upgrading Developer 6i with Oracle Applications 11i
# (Doc ID 125767.1)
# Known Issues On Top of 11i.ATG_PF.H.delta.7 (RUP7) - 6241631
# (Doc ID 858801.1)
getOraPatch ()
{
log=../gp_11i_ff.log
[[ -n $mosUser ]] || read -p "Oracle Support Userid: " mosUser;
[[ -n $mosPass ]] || read -sp "Oracle Support Password: " mosPass;
fname=`echo $1 | awk -F"=" '{print $NF;}'`;
wget -a $log -nv --no-check-certificate --http-user $mosUser --http-passwd $mosPass $1 -O $fname
[[ $? = 0 ]] || echo "### WARNING: non-zero exit status for $fname" >> $log
}
# Create subdirs if they don't already exist. Not bothering to check
# for non-directory files first; make life easy on yourself and clean up
# beforehand.
for dir in db apps forms_and_stuff
do
[[ -d $dir ]] || mkdir $dir
done; #mkdirs
# Batch these up a bit...
cd db
#9.2.0.8
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p4547809_92080_LINUX.zip?file_id=18114144&aru=8695761&patch_file=p4547809_92080_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5495695_92080_LINUX.zip?file_id=18442156&aru=8796814&patch_file=p5495695_92080_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6880880_101000_LINUX.zip?file_id=26541725&aru=11817464&patch_file=p6880880_101000_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5391326_92080_LINUX.zip?file_id=18509631&aru=8823188&patch_file=p5391326_92080_LINUX.zip'
#11gR2
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10098816_112020_LINUX_1of7.zip?file_id=34840499&aru=13149166&patch_file=p10098816_112020_LINUX_1of7.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10098816_112020_LINUX_2of7.zip?file_id=34840557&aru=13149166&patch_file=p10098816_112020_LINUX_2of7.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10098816_112020_LINUX_6of7.zip?file_id=34840571&aru=13149166&patch_file=p10098816_112020_LINUX_6of7.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10149223_112020_LINUX.zip?file_id=34162623&aru=13069334&patch_file=p10149223_112020_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10229719_112020_LINUX.zip?file_id=35009970&aru=13158111&patch_file=p10229719_112020_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9776940_112020_LINUX.zip?file_id=39303277&aru=13537040&patch_file=p9776940_112020_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p10165223_112020_LINUX.zip?file_id=40294411&aru=13738766&patch_file=p10165223_112020_LINUX.zip'
cd ../apps
#Interops
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9935935_11i_GENERIC.zip?file_id=31508570&aru=12782727&patch_file=p9935935_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5622511_11i_LINUX.zip?file_id=18622200&aru=8866742&patch_file=p5622511_11i_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p8815204_11i_LINUX.zip?file_id=28384957&aru=11753858&patch_file=p8815204_11i_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6863618_11i_GENERIC.zip?file_id=22287816&aru=9989530&patch_file=p6863618_11i_GENERIC.zip'
#AD, Autoconfig, and friends
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p7429271_11i_LINUX.zip?file_id=26279006&aru=10949191&patch_file=p7429271_11i_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6241631_11i_LINUX.zip?file_id=26306409&aru=10958855&patch_file=p6241631_11i_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9535311_11i_LINUX.zip?file_id=34553609&aru=12616012&patch_file=p9535311_11i_LINUX.zip'
#Other prereqs and fixups
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9094950_11i_GENERIC.zip?aru=12051986&file_id=29184463&patch_file=p9094950_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5977502_11i_GENERIC.zip?file_id=19233886&aru=9091882&patch_file=p5977502_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p3218526_11i_GENERIC.zip?file_id=10687311&aru=6082277&patch_file=p3218526_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p4206794_11i_GENERIC.zip?file_id=13966471&aru=7177217&patch_file=p4206794_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9835302_11i_GENERIC.zip?file_id=31201339&aru=12759116&patch_file=p9835302_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p7456837_11i_LINUX.zip?file_id=25236523&aru=10562332&patch_file=p7456837_11i_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5644137_11i_GENERIC.zip?file_id=18551248&aru=8839636&patch_file=p5644137_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p7721754_11i_GENERIC.zip?file_id=31452359&aru=10999742&patch_file=p7721754_11i_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6400762_11i_GENERIC.zip?file_id=20419151&aru=9544107&patch_file=p6400762_11i_GENERIC.zip'
cd ../forms_and_stuff
#JDK6
wget http://download.oracle.com/otn-pub/java/jdk/6u27-b07/jre-6u27-windows-i586.exe -O jre-6u27-windows-i586.exe
wget http://download.oracle.com/otn-pub/java/jdk/6u27-b07/jdk-6u27-linux-i586-rpm.bin -O jdk-6u27-linux-i586-rpm.bin
#Developer 6i
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6194129_60828_LINUX.zip?aru=9347149&file_id=19893950&patch_file=p6194129_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6125732_60828_LINUX.zip?aru=10129782&file_id=23019690&patch_file=p6125732_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6857221_60828_LINUX.zip?aru=10332696&file_id=24177414&patch_file=p6857221_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5232832_60828_LINUX.zip?aru=10036966&file_id=22538760&patch_file=p5232832_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p8888184_60828_LINUX.zip?aru=11805667&file_id=28517832&patch_file=p8888184_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p7329300_60828_LINUX.zip?aru=10794185&file_id=26412258&patch_file=p7329300_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p6747939_60828_LINUX.zip?file_id=30502279&aru=12612634&patch_file=p6747939_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p7552880_60828_LINUX.zip?file_id=30494040&aru=12609215&patch_file=p7552880_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p12667746_60828_GENERIC.zip?file_id=42086611&aru=13913590&patch_file=p12667746_60828_GENERIC.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p9876919_60828_LINUX.zip?file_id=31870280&aru=12823872&patch_file=p9876919_60828_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p5571663_60828_LINUX.zip?file_id=33625117&aru=13007065&patch_file=p5571663_60828_LINUX.zip'
#806 ORACLE_HOME
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p2832275_8063_LINUX.zip?file_id=34347313&aru=13096275&patch_file=p2832275_8063_LINUX.zip'
getOraPatch 'https://updates.oracle.com/Orion/Download/process_form/p3830807_8063_LINUX.zip?file_id=19699635&aru=6547583&patch_file=p3830807_8063_LINUX.zip'
cd ..
echo "Whew. Done. Hope you logged all of that."
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment