DBAShell 0.85 review

Download
by rbytes.net on

DBAShell framework scripts are a set of functions to assist in *nix/Linux operations related to Oracle databases. Many helper func

License: GPL (GNU General Public License)
File size: 0K
Developer: belkar and carkb
0 stars award from rbytes.net

DBAShell framework scripts are a set of functions to assist in *nix/Linux operations related to Oracle databases.

Many helper functions exist for things such as adjusting Oracle environment variables for different Oracle versions, storing and retrieving passwords for scripts, cleaning up sqlplus logs, creating exportation/importation compressed pipes, etc.

The scripts have been used with Oracle RDBMS 8i, 9i, and 10g. There is no reason they shouldn't also work with Oracle RDBMS 7 and 8.0.

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 OpenSource world than being trapped on our company servers forever.

DBAShell currently runs for the following environments:

Database: Oracle 8i, 9.2, 10gR2
Shell: bash
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's New in This Release:
dbashell.sh has been re-architected to use a modular design for OS, shell, database support functions, and variables.
ksh support has been added.
Autoloading support for functions has been added.
The initial environment size has been cut down from 52K to 11K.
A dbashell_unload function has been added to cleanly remove all functions and variables used by dbashell.
An AIX_THREADSCOPE variable for AIX Oracle setups has been added.

DBAShell 0.85 keywords