DBAShell 0.85 - Shell Functions and Scripts for DBA's 10-July-2006
What is DBAShell?
DBAShell is a framework of functions and scripts designed to make it easy for Database Administrators to use Databases in a command line environment by offering automatic setting of environment variables, functions to run scripts, store and provide script passwords, check database status, stop/start databases, run script commands in a parallel, compile all database objects, etc...
DBAShell was originally called internally the 'oraframework' as it was designed only to work with Oracle (8i and 9.2). It has been in use for over 3 years interally here at my job by myself, 3 other co-workers and a couple of consultants. over time I've realized that this set of functions and scripts could be more useful to the world of all DBA's and would have a better life in the Open Source world than being trapped on our company servers forever.
DBAShell currently runs for the following environments:
Database: Oracle 8i, 9.2, 10gR2
Shell: bash, ksh
OS: AIX 5.3 & 5.2, Solaris 9, RedHat Enterprise Linux 2.1 & 3 & 4
The above list only consists of environments that it has been known to run on and has been tested against. The OS list in particular is very flexible and should be able to run on almost any version of AIX, Solaris, Linux.
What are the plans and goals for DBAShell?
The process has been started to make DBAShell functions modular and support the idea of working with more Database Engines (DB2, Informix, MySQL, Postresql), more OS support (HPUX, etc..), and allow for alternative File/Directory layouts that better match a particualar site's needs, and additional password encryption schemes. This process will continue.
More traditional features of any opensource project will also be added like man pages, html documentation, etc..
All along, additional functions and features will be added to make command line work easier and more robust.
The main project goals are to make this a full-featured set of functions and scripts that can be installed by DBA's without System Administrator help, and require little or no extra software dependencies.
What should I look at next?
Look for install instructions in the INSTALL file in this directory.
Starting documentation is provided in docs/DBAShell.html file.
Refer to http://sourceforge.net/projects/dbashell/ for additional resources.
LICENSE
Copyright 2003-2006 Crispin Bivans <carkbster@gmail.com>,
Lancy Quadros,
Thom Carlin,
Pramod Sunkara.
This file is part of DBAShell.
DBAShell is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
DBAShell is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with DBAShell; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA