Scripts

Here you find some Scripts I wrote or co-authored. The scripts are available free to anyone to use. I do not accept any responsibility for any damage, errors or anything whatsoever caused by running or using these scripts. The scripts have been tested thoroughly but as there are many platforms, oracle versions and possible configurations, it does not mean that they will work for you when they work for me. Please review the file header for further information on the scripts, references etc before running them especially on production system.



Date Title Language
12. October 2016 oudbase_install.tgz
(Size 12.3 KiB / Hits 118)
OUD Environment scripts for manual installation
12. October 2016 oudbase_install.sh
(Size 20.7 KiB / Hits 411)
OUD Environment Installation Script (including TAR)
4. September 2015 connect_scott.sql
(Size 283.4 KiB / Hits 791)
Test script to test the SHA512 Memory Leak issue.
4. September 2015 connect_scott_template.sql
(Size 290 bytes / Hits 772)
Template to create the test SQL Script with a bunch of connects
14. October 2013 dbl.sql
(Size 1.7 KiB / Hits 1,271)
Script to query database links
14. October 2013 dbl_drop.sql
(Size 2.5 KiB / Hits 1,125)
Script to drop all or some private database links as sysdba
6. August 2013 cpui.sql
(Size 1.3 KiB / Hits 4,507)
List of applied PSU / CPU patches
24. July 2013 taln.sql
(Size 1.8 KiB / Hits 4,252)
List/query the latest n lines of the alert log
24. July 2013 tal.sql
(Size 1.7 KiB / Hits 4,863)
list/query alert log
24. July 2013 utlpwdmg.sql
(Size 17.9 KiB / Hits 9,206)
This is a script for enabling the password management features by setting the default password resource limits.
23. January 2012 hip.sql
(Size 2.1 KiB / Hits 1,811)
List init.ora parameter including hidden parameters.
23. January 2012 oradba.tgz
(Size 3.1 KiB / Hits 1,636)
Collection of shell and SQL scripts
1. May 2011 mos_download_url.sh
(Size 3.5 KiB / Hits 2,407)
Burn shell script to download patch's from MOS
1. May 2011 tsq.sql
(Size 2.7 KiB / Hits 2,417)
SQL query to find user with unlimited quota on a tablespace
3. April 2013 rj.sql
(Size 1.9 KiB / Hits 1,599)
rman