Re: DBAShell - Open Source project for Oracle DBA's

carkbster_at_gmail.com wrote:
> 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

Thankyou for a very valuable set of scripts.

Vivek Received on Tue Aug 01 2006 - 02:33:29 CDT