jpiwowar-zz

-- 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

jpiwowar-zz

# 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
--  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

-- 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

/* 
   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. ;-)

jpiwowar-zz

/*
   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)

jpiwowar-zz

#!/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)

jpiwowar-zz

#!/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)

jpiwowar-zz

# 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