Oracle Audit Scripts

Pete Finnigan - Oracle and Oracle security scripts

• check_parameter.sql This is the last of the five core auditing scripts available from this tools page. There will be others in the future but the first five here are useful core tools. This script allows you to neatly print out the values of initialization parameters from the database and to also check the results against a known correct value. The script also allows you to check hidden or undocumented parameters. A sample usage of this script is given here.
• Oracle Default Password checking tool  This is a set of SQL and PL/SQL scripts that can be used to check a database for the existance of any default user accounts with their well known default passwords still set. The list of accounts used is based on the largest list of Oracle default users on the net. Use this tool to ensure that your database is not vulnerable to the most fundamental issue is Orale security 101.
• Oracle Password Brute Forcer (Perl)  I was made aware of this perl script that can be used to brute force Oracle database passwords. The script is reasonably simple. It first builds TNS packets to get the SIDs/services available from the listener that is being queried. It then uses the SID's found and attempts to connect to the database.
• CIS Oracle database security benchmark tool  The center for Internet Security provides benchmark documents that are intended to be a best practice minimum standard on securing each piece of equipment that is the subject of the document. There is an Oracle security benchmark document that was developed by CIS in part from the SANS Oracle Security step-by-step written by Pete Finnigan. This scoring tool is based on the benchmark paper and checks most of the items in this paper. The tool provides a score as to how compliant you are with the benchmark.

  Some items in the benchmark are not covered by the tool but you can check this from the document itself as each item in the benchmark document indicates if its included in the tool. The tool covers quite a lot of items in the score by asking a questionnaire at the beginning of its operation. The rest of the checks are done programmatically. The tool is written in Java and is available for Windows, Solaris and Linux for Oracle 8i and 9i.

  The tools are free for download.

• dbcool_audit.pl This is a short security audit script written in perl that can be used to do a simple Oracle security audit.
• fileprobe.sh This is a superb script written by Tim Gorman. This korn shell script checks the files in the $ORACLE_HOME and $ORACLE_BASE for any security loopholes

EvDBT.Com - Scripts and Tools

• fileprobe.sh (ASCII text file – 16Kb)  UNIX Korn-shell script which performs checks on the permissions of files in the Oracle software distribution (i.e. ORACLE_HOME), administration files (i.e. ORACLE_BASE/admin), and database files (i.e. control files, online redo log files, archived redo log files, data files, and temp files).   Updated on 29-April 2005!!!
• oraprobe.sh (ASCII text file – 10Kb)  UNIX Korn-shell script which calls SQL*Plus to probe an Oracle database for possible use of default or guess-able passwords for the standard accounts created during the installation of Oracle products.  The script works in two passes:  the first pass uses the fixed list of standard accounts with guess-able passwords;  the second pass is used whenever the first pass works.  The second pass acquires a list of the accounts existing in the ALL_USERS data dictionary view and then tries the account name as the password.  In a future version of the script, I’ll include guess-able passwords here also, as well as guess-able variants (such as common number substitution for letters, etc).  The intent of this script is not to cause harm or to encourage mayhem, but rather to convince DBAs and database application designers of the importance of strong password protection, which have been built into the RDBMS since v8.0.  Newly added on 01-October 2002!!!
• tnsprobe.sh (ASCII text file – 6Kb)  UNIX Korn-shell script which calls tnsping and lsnrctl to probe a database server host machine for any ports (in the range from 1025 to 65536) with Oracle TNS Listeners on them.  If one is found, then the Oracle lsnrctl services command is issued to find if the topology of databases served by the TNS Listener can be displayed, and also to determine if the TNS Listener is passworded.  If the lsnrctl services command succeeds, then its output is parsed and the “oraprobe.sh” shell script (see above) is called to probe the Oracle database for accounts with guess-able passwords.  The intent of this script is not to cause harm or to encourage mayhem, but rather to convince DBAs and database application designers of the importance of strong password protection, which have been built into the RDBMS since v8.0.  Newly added on 01-October 2002!!!

Etc

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotes :  Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce :  Bernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOS :  Programming Languages History : PL/1 : Simula 67 : C : History of GCC development :  Scripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-Month :  How to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Last modified: March 12, 2019