{"id":123,"date":"2010-10-31T18:33:29","date_gmt":"2010-10-31T17:33:29","guid":{"rendered":"http:\/\/www.oradba.ch"},"modified":"2013-01-03T22:02:22","modified_gmt":"2013-01-03T21:02:22","slug":"scripts","status":"publish","type":"page","link":"https:\/\/www.oradba.ch\/wordpress\/publications\/scripts\/","title":{"rendered":"Scripts"},"content":{"rendered":"

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\u00a0for 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.\u00a0Please review the file header for further information on the scripts, references etc before running them especially on\u00a0production system.<\/p>\n\n\n\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Date<\/th>\nTitle<\/th>\nLanguage<\/th>\n<\/tr>\n
24. January 2018<\/small><\/td>\r\n\"\"oudbase_install.tgz<\/a>
(Size unknown \/ Hits 921)<\/small><\/td>\r\n		OUD Environment scripts for manual installation. As of now latest release is available via GitHub.<\/small><\/td>\r\n <\/tr>
24. January 2018<\/small><\/td>\r\n\"\"oudbase_install.sh<\/a>
(Size unknown \/ Hits 775)<\/small><\/td>\r\n		OUD Environment Installation Script (including TAR). Now also on GitHub https:\/\/github.com\/oehrlis\/oudbase<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_password_hash.sql<\/a>
(Size 11.2 KiB \/ Hits 1,911)<\/small><\/td>\r\n		Check if user has a weak password.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_passwords.sql<\/a>
(Size 14.1 KiB \/ Hits 2,239)<\/small><\/td>\r\n		Check if user in sys.user$ has a weak DES based password. Base Script for verify_alluser_passwords.sql, verify_alluser_passwords_no.sql, verify_user_password.sql and verify_user_password_no.sql.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_alluser_passwords_no.sql<\/a>
(Size 1.4 KiB \/ Hits 1,819)<\/small><\/td>\r\n		Wrapper script to check if any user in sys.user$ has a weak DES based password. Passwords will not be displayed.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_alluser_passwords.sql<\/a>
(Size 1.4 KiB \/ Hits 2,094)<\/small><\/td>\r\n		Wrapper script to check if a user has a weak DES based password. Passwords will not be displayed<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_user_password_no.sql<\/a>
(Size 1.4 KiB \/ Hits 1,617)<\/small><\/td>\r\n		Wrapper script to check if a user has a weak password. Passwords will not be displayed.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"verify_user_password.sql<\/a>
(Size 1.4 KiB \/ Hits 1,636)<\/small><\/td>\r\n		Wrapper script to check if a user has a weak password. Passwords will be displayed<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"create_password_hash.sql<\/a>
(Size 4.5 KiB \/ Hits 2,093)<\/small><\/td>\r\n		Calculate Oracle DES based password hash from username and password<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"aui.sql<\/a>
(Size 1.7 KiB \/ Hits 1,525)<\/small><\/td>\r\n		Script to show authentication information of the connected user and from its USERENV context.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"07_tsdp_audit.sql<\/a>
(Size 8.5 KiB \/ Hits 1,513)<\/small><\/td>\r\n		Transparent Sensitive Data Protection and Data Redaction demo<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"06_tsdp_redact.sql<\/a>
(Size 5.7 KiB \/ Hits 1,565)<\/small><\/td>\r\n		Transparent Sensitive Data Protection and Data Redaction demo<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"05_redaction.sql<\/a>
(Size 3.4 KiB \/ Hits 1,303)<\/small><\/td>\r\n		Oracle Data Redaction demo script<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"04_audit.sql<\/a>
(Size 3.6 KiB \/ Hits 1,544)<\/small><\/td>\r\n		Unified audit demo script<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"03_vpd.sql<\/a>
(Size 4.0 KiB \/ Hits 1,363)<\/small><\/td>\r\n		Virtual Private Database demo with default and column masking.<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"02_privileges.sql<\/a>
(Size 3.8 KiB \/ Hits 1,486)<\/small><\/td>\r\n		Database privileges analysis demo<\/small><\/td>\r\n <\/tr>
24. November 2017<\/small><\/td>\r\n\"\"01_authentication.sql<\/a>
(Size 11.0 KiB \/ Hits 1,573)<\/small><\/td>\r\n		Short example to demonstrate the different authentication and user types.<\/small><\/td>\r\n <\/tr>
4. September 2015<\/small><\/td>\r\n\"\"connect_scott.sql<\/a>
(Size 283.4 KiB \/ Hits 2,152)<\/small><\/td>\r\n		Test script to test the SHA512 Memory Leak issue.<\/small><\/td>\r\n <\/tr>
4. September 2015<\/small><\/td>\r\n\"\"connect_scott_template.sql<\/a>
(Size 290 bytes \/ Hits 1,990)<\/small><\/td>\r\n		Template to create the test SQL Script with a bunch of connects<\/small><\/td>\r\n <\/tr>
14. October 2013<\/small><\/td>\r\n\"\"dbl.sql<\/a>
(Size 1.7 KiB \/ Hits 2,502)<\/small><\/td>\r\n		Script to query database links<\/small><\/td>\r\n <\/tr>
\n Page 1 of 2 <\/span> 1 <\/span> 2 <\/a> » <\/a><\/div>
\n
3. April 2013<\/small><\/td>\r\n\"\"rj.sql<\/a>
(Size 1.9 KiB \/ Hits 3,066)<\/small><\/td>\r\n		rman<\/small><\/td>\r\n <\/tr>
\n <\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

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\u00a0for 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":129,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"page-templates\/full-width.php","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-123","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1aErb-1Z","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":127,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/tools\/","url_meta":{"origin":123,"position":0},"title":"Tools","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Here you find links to some Tools I regularly use. The tools are written by others, therefore I can not accept any responsibility for them.\u00a0Please review the tools before running them especially on\u00a0production system. Date Title Language","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":125,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/papers\/","url_meta":{"origin":123,"position":1},"title":"Papers and Presentations","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Here you find some technical publications and presentations I wrote or co-authored. Date Title Description","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1477,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/others\/","url_meta":{"origin":123,"position":2},"title":"Others","author":"Stefan","date":"26. September 2013","format":false,"excerpt":"Here you find some white papers, notes, articles and third party documents. These documents are just kept for reference. Date Title Language","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":129,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/","url_meta":{"origin":123,"position":3},"title":"Publications","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Her you find scripts, papers and publications I wrote or co-authored. Papers and Presentations What else... Scripts Stuff that I mentioned in my posts... Tools Ok, not really my stuff but tools I regularly used...","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14162,"url":"https:\/\/www.oradba.ch\/wordpress\/howtos\/","url_meta":{"origin":123,"position":4},"title":"Howto’s","author":"Stefan","date":"13. October 2023","format":false,"excerpt":"As my grandmother used to say, \" kid, you need to write this down\". With that in mind, I've started creating a series of special how-to blogposts. These contain clear step-by-step instructions on a particular topic without much fuss. The commands or scripts provided should be executable in any environment\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69,"url":"https:\/\/www.oradba.ch\/wordpress\/","url_meta":{"origin":123,"position":5},"title":"Welcome to my site","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"My name is Stefan Oehrli. I'm a Swiss electrical engineer working since several years as an Oracle DBA and consultant. My main interests are backup & recovery, database internals, database security, infrastructure management and other stuff coming across my daily work as a DBA and Tech Architecture Manager at Trivadis\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":30,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/123\/revisions"}],"predecessor-version":[{"id":13887,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/123\/revisions\/13887"}],"up":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/129"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}