Yet Another Oracle Init Script
I’ve used this script a bunch in the past for instance startup and when I’m only dealing with 1 ORACLE_HOME. This new init script uses UNIX cat and cut to parse the /etc/oratab (linux only) to set the ORACLE_SID &…
Get IP Address with VBoxManage
Thought I’d share this little VBox hack… If you’ve ever started a VirtualBox image and quickly needed to figure out the IP address of the image issue this command: vboxmanage (or VBoxManage) is located in /usr/bin on *nix systems and…
12c Data Redaction (DBMS_REDACT ) Demo
Oracle 12c introduced A TON of new features and options. One of the COOLEST (IMHO) is the Data Redaction packages. For those not in the know here’s what the Data Redaction Packages do: () Oracle Data Redaction enables you to…
Create Random Data & Bulk Insert from Nested Table
Sometimes I need to create random datasets to explore how queries will run, so I whipped up this little sample procedure as a way to do it. This is basically just in case I forget… enjoy Create a quick test…
Some 12c Multitenant commands
Here are some useful commands I use when working with the new 12c Multitenant option. Open ALL Pluggable Databases (PDBs): As sysdba Switch to a PDB: Switch back the ROOT Container (CDB$ROOT): Connecting to a Specific PDB with a Specific…
Import and Update Plug-ins with emcli – OEMCC 12c
Here’s a quick script to import downloaded plug-ins, if you are running in an off-line mode, into your OEMCC 12c system. Tested with 12.1.0.3
Oracle Enterprise Manager 12c Cloud Control & Ops Center Startup Script
Set up email notifications in OEM
12c Multitenant Database…make a bunch of PDBs
Here’s a quick, simple little script to create a bunch of new PDBs in the 12c Multitenant architecture. Enjoy! Matt
Toggle Function Keys — Mac OSX
I use a MacBook (shocker…) and I really use it for like programming and stuff. Given that sometimes I need to toggle the function keys on my keyboard from the nifty volume controls or keyboard lighting to something a tad…