Skip to content

Instantly share code, notes, and snippets.


John Piwowar jpiwowar-zz

View GitHub Profile
jpiwowar-zz / OEL6.4-kickstart.cfg
Last active Jun 3, 2019
Supporting files for a blog post ( covering quick start for an EBS 12.2 Vision install.
View OEL6.4-kickstart.cfg
# Kickstart file automatically generated by anaconda.
lang en_US.UTF-8
keyboard us
network --onboot yes --device eth0 --bootproto static --ip --netmask --noipv6 --nameserver --hostname
network --onboot yes --device eth1 --bootproto dhcp --noipv6
rootpw --iscrypted $6$I2avXM9g1aZ5Q$lbfUJL48tv4qnHjyP3m7PVfkgeKwgIOtmFTylnFrbGuqvjvYzNYtyncmNV8XOZoKIS1
jpiwowar-zz /
Last active Dec 20, 2015
Build a pair of Vbox VMs for 12c RAC, using the OVM templates from Oracle Edelivery. More context is required to use it correctly, see this G+ thread:
# Author/Blame: John Piwowar
# Purpose: Build a pair of Vbox VMs for 12c RAC.
# Performs: 1) Creation of node 1
# 2) Conversion of OVM .img files to .vdi format
# 3) Clone of node 1 to node 2
# 4) Attaches shared storage to both VMs
# Assumes: 1) Disk images from OVM templates already unzipped
# 2) VBoxManage command already in path
# 3) Sufficient disk space for all operations (script does not check)
jpiwowar-zz /
Created Sep 12, 2011
Script to grab patches needed for 11i Vision upgrades
# 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)
View ebs_bulkresp.sql
Contact: John Piwowar
Purpose: Add 1+ responsibilities to 1+ users
Requires: desired action (validate or apply) as script argument
Table xxrespload, of the format:
Name Type
----------------------------- --------------------
View ebs_def_setprof.sql
Contact/blame: John Piwowar
Purpose: Braindead wrapper for setting site and user-level profile options
Notes: * Call as part of the declare section of an anon PL/SQL block.
That's my sad attempt at reusability without creating stored procs
* Assumes a great many things, including that you're running as
a user with exec privileges on FND_PROFILE, and that you don't
need fancy error reporting if things go wrong. ;-)
jpiwowar-zz / prof_frag.sql
Created Jun 6, 2011
More EBS profile options scripts. Code recycling FTW!
View prof_frag.sql
-- prof_frag.sql
-- Author: John Piwowar
-- Purpose: Find EBS system profile option values without launching the
-- ever-popular Forms interface, based on a fragment of the
-- user-readable value of the profile option name
-- Notes: * Retrieves options at all levels
-- * May need additional tweaking for multi-language installations
-- * Will get pretty noisy if you're not careful
-- * How many times am I going to re-use this query and just mod the
-- where clause? Oh, lots.
jpiwowar-zz /
Last active Sep 24, 2015
Download oracle patches from My Oracle Support using wget
# Function to retreive patches from Metalink/My Oracle Support via wget
function getOraPatch {
[[ $mosUser ]] || read -p "Oracle Support Userid: " mosUser;
[[ $mosPass ]] || read -sp "Oracle Support Password: " mosPass;
fname=`echo $1 | awk -F"=" '{print $NF;}'`;
wget --no-check-certificate --http-user $mosUser --http-passwd $mosPass $1 -O $fname -nv;
echo "Completed with status: $?"
jpiwowar-zz / last_profile_changes.sql
Created Jan 24, 2011
Find the most recent changes to E-Business Suite profile options
View last_profile_changes.sql
-- last_profile_changes.sql
-- Author: John Piwowar
-- Purpose: Lists EBS profile options, in descending order of date set
-- Notes: Prompts for number of items to display
-- May need additional tweaking for multi-language installations
-- You'll probably want to change linesize and column widths to
-- something a more sane.
set pagesize 9999
set linesize 80
set verify off
jpiwowar-zz / check_ebs_trace_profs.sql
Created Jan 22, 2011
Horrendously hacky script for identifying potentially performance-affecting Oracle E-Business Suite profile option settings. Could probably be tightened up, but I kinda stopped tweaking it when it worked well enough to generate results. :)
View check_ebs_trace_profs.sql
-- check_ebs_trace_profs.sql
-- Author: John Piwowar
-- Purpose: Identify E-Business Suite system profile option settings that may
-- be related to performance-degrading debug/trace activity
-- Notes: Prompts for a cutoff date for when profile options were set
-- May need additional tweaking for multi-language installations
set pagesize 9999
set linesize 120
set verify off
col "Profile Option" for a25
You can’t perform that action at this time.