DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.


http://dbashell.sourceforge.net





Separate each tag with a space.

Release Date:

2006-07-10

Topic:

Operating System:

License:

Translations:

Intended Audience:

User Interface:

Database Environment:

Programming Language:

Registered:

2006-06-15

Ratings and Reviews

  • Thumbs up:

    1
  • Thumbs down:

    0
100% of 1 user recommends this project
  • Thumbs up

    posted by anonymous 87 days ago

View all reviews

Project Feed

  • Forum comment added

    carkb commented on the RE: Project alive? forum thread

    posted by carkb 419 days ago

  • Forum thread added

    ziller created the Project alive? forum thread

    posted by ziller 422 days ago

  • Presentation for DBAShell given at MOUG

    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/

    posted by carkb 1079 days ago

  • Code committed

    carkb committed revision 26 to the DBAShell SVN repository, changing 1 files

    posted by carkb 1193 days ago

  • Code committed

    carkb committed revision 25 to the DBAShell SVN repository, changing 2 files

    posted by carkb 1205 days ago

  • Code committed

    carkb committed revision 24 to the DBAShell SVN repository, changing 11 files

    posted by carkb 1205 days ago

  • Code committed

    carkb committed revision 23 to the DBAShell SVN repository, changing 105 files

    posted by carkb 1237 days ago

  • Forum thread added

    carkb created the Please give your feedback here forum thread

    posted by carkb 1248 days ago

  • DBAShell Version 0.85 Released

    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 CHANGES in this update: * Re-architected dbashell.sh to use modular design for os, shell, database support functions and variables. New directory 'modules'. * Added ksh support. * Added autoloading support for functions. Cut down initial environment size from 52K to 11K. Each module as well as main scripts folder now has an 'autoload' folder. * Added dbashell_unload function to cleanly remove all functions and variables used by dbashell. Useful for testing and also to clean environment before calling programs that may complain about a cluttered environment. * Added dbashell_verbose and dbashell_debug functions to help with turning on testing and debugging output. New variables DBASHELL_VERBOSE and DBASHELL_DEBUG. Added command line options to dbashell.sh to support turning on those variables: -v and -d respectively. * Updated installer to understand subdirectories and softlinks. * Fixed is_db_up to not rely on oracle owner being named 'oracle' * Added AIX_THREADSCOPE variable for AIX Oracle setup * Fixed sqlplus_cmd to not rely on seeing 'Connected' in the logs. Oracle 10g Sqlplus omits this word. * Added TODO file. Project Site: http://sourceforge.net/projects/dbashell/ Download: http://prdownloads.sourceforge.net/dbashell/dbashell-0.85.tar.gz?download Release Notes: http://sourceforge.net/project/shownotes.php?group_id=170224&release_id=431098 Documentation: http://sourceforge.net/docman/display_doc.php?docid=33704&group_id=170224

    posted by carkb 1250 days ago

  • File released: /dbashell/dbashell-0.85/dbashell-0.85.tar.gz

    posted 1250 days ago

Rate and Review

Would you recommend this project?






<

Related Projects

DBAShell Actions

Thanks for your rating!

Would you also like to write a review?





Skip Review

Thanks for your review!

Get credit for your review by logging in via OpenID. Click your account provider:

No Thanks