Point-in-time recovery of an Oracle DB entails the use of transaction log files. The set of such logs grows over the lifetime of a DB, and their management often requires that they be copied to remote locations and/or backed up to offline storage. Alv can verify a set of archive logs prior to its use in a DB recovery scenario: checks are made on file size and type, and the checksum of each redo record is verified. The output is a sequence of log file numbers and character codes to indicate status and highlight any gaps in the sequence (which would stall a recovery). Environment variables can be set to allow for custom log file name formats and to check the DBNAME associated with each log.
ERDesignerNG is a Java-based entity relationship design and database modeling tool. It has a powerful WYSIWYG interface for physical database design, supports 2D and 3D database modeling, browsing, and design, handles tables, relations, indexes, and comments, supports a central repository for all models (Model Repository), supports subject areas, supports domains, supports MySQL, Oracle, Microsoft SQLServer, PostgreSQL, and H2, creates the SQL DDL statements for schema creation, has an integrated schema version control system, can generate schema migration scripts for every change, stores the database definition as XML files for further processing, can export the database schema as GIF, BMP, JPEG, or SVG files, has an integrated reverse engineering module for existing schemas, has a build in schema compare feature, can generate schema documentation as PDF, HTML, RTF, and other formats, and supports schema conversion between different dialects.
XIST is an extensible HTML and XML generator. It is also an XML parser with a very simple and Python-esque tree API. Every XML element type corresponds to a Python class, and these Python classes provide a conversion method to transform the XML tree (e.g. into HTML). XIST can be considered 'object-oriented XSLT'. XIST also includes a cross-platform templating language, Oracle utilities, and various other tools.
check_oracle_health is a plugin for the Shinken (Nagios) monitoring software that allows you to monitor various metrics of an Oracle database. It includes connection time, SGA data buffer hit ratio, SGA library cache hit ratio, SGA dictionary cache hit ratio, SGA shared pool free, PGA in memory sort ratio, tablespace usage, tablespace fragmentation, tablespace I/O balance, invalid objects, and many more.
HTSQL a high-level query language and Web service gateway for relational databases. It comes with source code and is royalty free for any use with open source database systems such as MySQL, PostgreSQL, SQLite, etc. Licenses for using HTSQL in conjunction with proprietary databases such as Microsoft SQL and Oracle can be purchased.
sqlmap is a penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a detection engine, many niche features, and a broad range of switches including database fingerprinting, data fetching from the database, and accessing the underlying file system and executing commands on the operating system via out-of-band connections.
websqlclient (WSQLC or wiskl) is a lightweight HTTP server which allows an end user to access JDBC data sources via automatically-generated data entry screens. It is designed to be used with standard Web browsers and wireless tablet PCs, and is highly configurable. It can connect to any JDBC data source. Its main purpose is to provide rapid data-model-driven development. The websqlclient data entry forms are generated by querying the database system table information, but can be configured manually. websqlclient includes a database-agnostic data loading utility (SQLLoader), a data unloading tool (SQLExport), and SQL scripting capabilities.
The goal of dzo is to treat application database objects the same way the application's source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or Java EE application server, dzo has a servlet that controls the deployment process, inspects and executes the necessary database changes, and finally deploys the application. Dzo currently works with HSQLDB, MySQL, Oracle, PostgreSQL, and SQL Server (more to come).
Oracletool is an interactive, Web-based application for Oracle Database administration. The advantage of Oracletool over non-Web-based tools is that nothing needs to be installed on the client-side machine or in your databases. All you need to use Oracletool, once installed, is a Web browser.