OraMatt: YABAOracle

Yet Another Blog About Oracle

Category: shell

  • Copy File Contents to Clipboard with Finder

    This!!! This is SOOOOO simple and easy I’m really surprised it’s not part of Finder’s default Services. To install, download the file from here and let Automator install the workflow.…

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

  • Quick Lockdown Script

    Just a little script to lockdown default Oracle accounts and randomly change passwords

  • SGA Fiddling…

    Just a little script to mess with the SGA

  • DataPump — Export & Import Scripts

    Use these 2 scripts together and you should be good to go… Here’s the DataPump Export Script Here’s the DataPump Import Script

  • Hide OSX Desktop Icons

    Hi All, Another little Applescript app I wrote up to hide Desktop Icons. Useful prior to doing screenshots or before demos or presentations Just copy & paste into Applescript Editor…

  • Applescript for SSH-ing

    Hi All, I thought I’d share a little Applescript app I wrote up to help me in my day to day SSHing… I like to have my various connections to…

  • Using DataPump (aka expdp) to Export a Database

    I’ll write up a sister script to be used for import

  • Setup DBFS and mount DBFS

    For those who don’t know what DBFS (DataBase FileSystem) is, here’s a little snippet: The Oracle Database File System (DBFS) enables the database to be used as a POSIX-compatible file…

  • My oracle user bash_profile

    Use it…abuse it…don’t lose it…

Navigation

About

I’m Matt and I do Oracle things.