Oracle and Open Source

Oracletool

Oracletool is a serious piece of weaponry in our Oracle and open source armory. This program is an excellent tool for maintaining Oracle databases. You can use it to help with performance tuning and to perform a variety of database administration functions. Oracletool provides a simple web-based interface to many of the day-to-day maintenance tasks a DBA needs to carry out in order to keep a typical database in good working order. And for those developers who can pluck a SELECT ANY TABLE privilege from the tight clutches of their DBA (good luck!), Oracletool is also a highly useful development utility.

Adam vonNieda first started work on Oracletool in 1997, and it had its first major release in March of 1999. Oracletool enjoys regular releases and maintains independence from any web server-specific modules. Written in Perl, it is completely CGI-driven and makes use of a number of great Perl modules, including Perl DBI and DBD::Oracle. Oracletool is a very straightforward program; its entire wealth of functionality is contained in a single CGI script. This implementation makes Oracletool easy to install and configure.

Oracletool provides a reasonable degree of security as a default, but it also gives you the ability to configure more rigorous security. You can choose your level of security based on your own site’s requirements. The faint of heart will be glad to hear that Oracletool does not modify your database. You can create a user with the SELECT ANY TABLE privilege ...