DBAShell - Open Source project for Oracle DBA's

From: <carkbster_at_gmail.com>
Date: 24 Jul 2006 10:52:50 -0700
Message-ID: <1153763570.603358.122070@h48g2000cwc.googlegroups.com>

I’'ve been an Oracle DBA for quite some time (since 7.0.13) and a developer for many years. One of the things I’'ve always wished for was an easier way to set up environment variables for different Oracle Home’s and a way to provide passwords to scripts without embedding them in plain-view.

About 3 years ago, I started a set of functions and scripts at my company that did exactly just that and provided many more functions for things like checking database status, running scripts quietly unless errors are detected, running actions in parallel (like fast shutdowns at once, or multiple analyzes), restarting databases in a guaranteed fashion, aliases to common folder locations, etc..

About a month ago, after putting all this time and effort into these scripts and using them in production all this time, I realized I wanted more out of the scripts like support for other databases and thought that it would be best if I gave it new life as an Open Source project.

So that is how http://sourceforge.net/projects/dbashell/ was started. Now it’s in a second release (DBAShell 0.85) that is more modular and would allow other people to easily add support for other OS’s, other Shells, and other Databases.

Here is a description of the project from the latest news item:

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

Over a thousand people have already downloaded the prior release and more are downloading every hour.

I'm seeking feedback from anybody that would be willing to take a look at the project, trying it out, give me any feedback you have on it, and perhaps even direct me to where I could best promote this project.

I wrote a tutorial that shows at a glance some of the more useful features of DBAShell:

http://sourceforge.net/docman/display_doc.php?docid=34041&group_id=170224

Main site:
http://sourceforge.net/projects/dbashell/

Documentation:
http://sourceforge.net/docman/display_doc.php?docid=33704&group_id=170224

Download:
http://prdownloads.sourceforge.net/dbashell/dbashell-0.85.tar.gz?download Received on Mon Jul 24 2006 - 12:52:50 CDT