OraMatt: YABAOracle

Yet Another Blog About Oracle

Category: oracle

  • Running Docker on a M2 MacBook

    I’ve had relative success running Docker x86-64 containers on my M2 MacBook with the following procedure: Run docker on Apple Silcon with hacks Prerequisite /bin/bash -c “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)” Install…

  • Parsing the Oracle Inventory XML file

    I recently needed to dynamically set an environmental variable from reading the Oracle Inventory XML file. Typically you can find your Oracle Inventory location by looking here /etc/oraInst.loc on Linux…

  • Using DBMS_REDEFINITION

    Database design is hard…seriously… If you need to modify a table after you’ve rolled it into production DBMS_REDEFINITION can really save you! Here’s a little example that shows taking a…

  • Loading LOBs into a Table

    This is one of those topics that EVERYONE has a different take on and here’s mine! Using the LS_TABLE external table that you can find here you’ll be able to loop through…

  • Improved Oracle INIT script

    So….I was reviewing my INIT script that I posted here and I noticed there was no respect if a SID was marked as NO in /etc/oratab. I’ve adjusted the script…

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

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

  • 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

  • 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

Navigation

About

I’m Matt and I do Oracle things.