Shell-Scripts-for-Oracle-DBAs

Shell scripts written by an Oracle DBA

These are shell scripts I've written and used at the various companies I have worked at. They encapsulate common actions into an easy to run format.

Name		Name	Last commit message	Last commit date
Latest commit History 54 Commits
online_partitioning		online_partitioning
.gitattributes		.gitattributes
.gitignore		.gitignore
CleanupOracleFiles.sh		CleanupOracleFiles.sh
ClonePDB.sh		ClonePDB.sh
Constraints.sh		Constraints.sh
DBHC_general.sh		DBHC_general.sh
DatafileShrink.sh		DatafileShrink.sh
FRAmonitor.sh		FRAmonitor.sh
GatherStats.sh		GatherStats.sh
JobMaintenance.sh		JobMaintenance.sh
LOBcheck.sh		LOBcheck.sh
PGA-stats.sql		PGA-stats.sql
README.md		README.md
RMAN_backup.sh		RMAN_backup.sh
RenameConstraints.sql		RenameConstraints.sql
RunForAllDatabases.sh		RunForAllDatabases.sh
TableShrinks.sh		TableShrinks.sh
change_password.sh		change_password.sh
chk_invalid.sql		chk_invalid.sql
cycle_db_logs.sh		cycle_db_logs.sh
db_option_usage.sql		db_option_usage.sql
dbca_commands.txt		dbca_commands.txt
fix_oracle_dirs.sh		fix_oracle_dirs.sh
flashback_db.sh		flashback_db.sh
glogin.sql		glogin.sql
index_monitor.sh		index_monitor.sh
manage_partitions.sh		manage_partitions.sh
manage_tablespaces.sh		manage_tablespaces.sh
ora_funcs.sh		ora_funcs.sh
pdb_commands.txt		pdb_commands.txt
save_db_configs.sh		save_db_configs.sh
test_ora_funcs.sh		test_ora_funcs.sh
validate_indexes.sql		validate_indexes.sql

Provide feedback