Skip to content

Instantly share code, notes, and snippets.

John Piwowar jpiwowar

Block or report user

Report or block jpiwowar

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
jpiwowar / 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 /
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 /
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 / 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 /
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 / 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 / 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.