DBAShell News

I was invited to the Fall 2006 Conference of the Midwest Oracle Users Group (MOUG) in Chicago by Rich Niemiec to give a speaking presentation on DBAShell.

Powerpoint slides were produced for the event and I felt it went really well with the crowd and I got some good questions on it.

The presentation can be downloaded from the MOUG website or from here directly.

Links:

Presentation: http://dbashell.sourceforge.net/presentations/moug2006-dbashell.zip
Main Project: http://dbashell.sourceforge.net/
MOUG Homepage: http://www.moug.org/... read more

DBAShell is a project based around Shell functions and scripts designed to make it easy for DBA's to use Databases in a command line environment. Currently supported is Oracle with ksh and bash on AIX, Solaris, Linux. The code base itself is 3 years old and has been in use in Production environments all of that time.

Features include:

* Automatic setting of all environment variables based on SID requested.
* Manage PATH's and other path like variables for each ORACLE_HOME needed.
* Run scripts with stored passwords (no more hard-coding of passwords!!)
* Automatically set SID based on Script location (makes it easier to share scripts between SID's)
* manage temporary script output and check for oracle errors in output
* check database status and versions from scripts
* stop/start databases in parallel (faster startup)
* compile all database objects
* analyze objects in parallel (Faster analyzes)
* set aliases and variables for common SID areas, etc..
* many helpful commands for common Oracle tasks ... read more

DBAShell is a new project based around Shell functions and scripts designed to make it easy for DBA's to use Databases in a command line environment. Currently supported is Oracle with bash on AIX, Solaris, Linux. The code base itself is 3 years old and has been in use in Production environments all of that time.

Features include:

* Automatic setting of all environment variables based on SID requested.
* Manage PATH's and other path like variables for each ORACLE_HOME needed.
* Run scripts with stored passwords (no more hard-coding of passwords!!)
* Automatically set SID based on Script location (makes it easier to share scripts between SID's)
* manage temporary script output and check for oracle errors in output
* check database status and versions from scripts
* stop/start databases in parallel (faster startup)
* compile all database objects
* analyze objects in parallel (Faster analyzes)
* set aliases and variables for common SID areas, etc..
* many helpful commands for common Oracle tasks... read more

This is the start of the open-sourcing of Production level shell script code that has been in use for over 3 years at my company, written by Oracle DBA's for Oracle DBA's.

First line of business is to package up the existing code and place it SourceForge's Subversion system and then do an initial release of the code. This version will be labeled: dbashell-0.80

A roadmap document will then be drawn up outlining where this project is going to reach 1.0 status.
The basic outline is to re-architect the code in a more modular manner to support multiple database systems (mysql, informix, db2, etc..), ksh support (currently it's bash based), multiple OS's (beyond current Solaris, AIX, Linux), multiple password encryption schemes (currently it's simplistic uuencode obfuscation), multiple directory layout schemes for databases (currently it supports two custom variations of OFA compliant directory layouts)