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. From that point you can highlight a file in Finder,…
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 on Linux or here on Solaris. You should see the inventory_loc…
Just a little script to lockdown default Oracle accounts and randomly change passwords [sourcecode language=”bash”] function lock_default_oracle_accounts() { export RANDPWD=`date +%s | sha256sum | base64 | head -c 12` sqlplus / as sysdba <<EOF spool select username from DBA_USERS_WITH_DEFPWD;…
Just a little script to mess with the SGA [sourcecode language=”bash”] #!/bin/bash #=================================================================================== # # FILE: Increase_SGA # # USAGE: Run it.. # # DESCRIPTION: Script to increase SGA # OPTIONS: # REQUIREMENTS: # AUTHOR: Matt D # CREATED: August…
Use these 2 scripts together and you should be good to go… Here’s the DataPump Export Script [sourcecode language=”bash”] #!/bin/bash #=================================================================================== # # FILE: expdp_helper.sh # # USAGE: Run from command line # # DESCRIPTION: DataPump Export of database #…
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 and Save As an Application or whatever Enjoy [sourcecode language=”text”]…
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 different severs color coded to help me know which system…
I’ll write up a sister script to be used for import [sourcecode language=”bash”] #!/bin/bash #=================================================================================== # # FILE: expdp_helper.sh # # USAGE: Run from command line # # DESCRIPTION: DataPump Export of database # OPTIONS: # REQUIREMENTS: # AUTHOR: Matt…
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 system on Linux. This feature includes a PL/SQL package on…
Use it…abuse it…don’t lose it… [sourcecode language=”bash”] # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:/sbin:$HOME/bin export PATH #ORACLE_SID=grid;export ORACLE_SID ORACLE_BASE=/u01/app ; export ORACLE_BASE…