Category Uncategorized

VBoxManage & EULAs

Howdy y’all! If you ever need to import a VirtualBox image from the command line using vboxmanage and the image has a EULA that must be agreed to here’s the command: You DON’T need the switch just the . I…

SSH Tunnels & VNC Viewer…oh my…

I was working with a customer that REQUIRED all VNC connections go over an SSH Tunnel… After Googling around a bit, I found how to do it but I wanted to my a script to automate the process in case…

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…

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…

Easy External Table Creation

I just read this in this month’s Ask Tom article in Oracle Magazine. I didn’t know you could do this with SQL*Loader and I thought I’d share. For those who don’t know what SQL*Loader is, it was a utility that…