a collection of scripts to ease the day-to-day work of an Oracle DBA
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
izzy 380fb7a77e ohenv: determine ohpath based on script location (instead of using hardcoded path) 1 month ago
doc adding QuickCheck script (sql/db_simple_check.sql) 3 months ago
ohctl ohenv: determine ohpath based on script location (instead of using hardcoded path) 1 month ago
resman resman: add example SQL to readme 2 months ago
rman ! fixed syntax error in password file creation 11 years ago
sql adding simple alert log query 3 months ago
ts_mig adding 5th script to ts_reorg, working around an Oracle bug 4 years ago
ExportOracleDB ! ExportOracleDB: bzip2 compression was ignoring the --dryrun parameter 11 years ago
Generate_createdb.sh ! fixed duplicate execution of CREATE USER statements 12 years ago
Makefile * updated the uninstall target of the makefile and added a purge target (to also remove /etc/rmanrc) 11 years ago
README.md updating wiki link 4 months ago
analobj.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
configure move connection string building to "configure" and adjust all scripts using it 4 months ago
globalconf + adding output directory to config (where to put the spool files) 12 years ago
idxmove.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
idxrebuild_all.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
idxrebuild_inv.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
lazywaste.sh * some restructuring 14 years ago
sqltune + added script to tell undo records used by current processes 12 years ago
tabmove.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
tabreorg.sh move connection string building to "configure" and adjust all scripts using it 4 months ago
undo_used.sh + adding the undo_used.sh script 12 years ago

README.md

DBAHelper

DBAHelper is a collection of scripts to ease the day-to-day work of an Oracle DBA. Not everything can be done automatically (otherwise we’ld lose our jobs ;) – but certain tasks re-occur in the same order very often. In these cases we like to save some keystrokes and let the scripts do the job.

A more detailed introduction and documentation can be found in the doc/ and doc/html/ directories of the source code – and also in the wiki.