Skip to content

Instantly share code, notes, and snippets.

@jpiwowar jpiwowar/gp_11_ff.sh
Created Sep 12, 2011

Embed
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
You can’t perform that action at this time.