This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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: $?" | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
ebs_def_setprof.sql | |
Contact/blame: John Piwowar | |
Purpose: Braindead wrapper for setting site and user-level profile options | |
with fnd_profile.save. | |
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. ;-) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
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 | |
----------------------------- -------------------- | |
USER_NAME VARCHAR2(100) | |
APP_SHORTNAME VARCHAR2(50) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# 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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Kickstart file automatically generated by anaconda. | |
#version=DEVEL | |
install | |
cdrom | |
lang en_US.UTF-8 | |
keyboard us | |
network --onboot yes --device eth0 --bootproto static --ip 192.168.58.17 --netmask 255.255.255.0 --noipv6 --nameserver 8.8.8.8 --hostname breen.local.org | |
network --onboot yes --device eth1 --bootproto dhcp --noipv6 | |
rootpw --iscrypted $6$I2avXM9g1aZ5Q$lbfUJL48tv4qnHjyP3m7PVfkgeKwgIOtmFTylnFrbGuqvjvYzNYtyncmNV8XOZoKIS1 |