Freeware

From Oracle FAQ
Jump to: navigation, search

List of Oracle Freeware products available in alphabetical order:

Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.

[edit] DBeauty

A relationship-oriented Database Browser. Provides insight into both the data and the interrelation of the rows. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Automatic detection of foreign keys. SQL/DML generator.
Latest version: 2.0.11 (2012-09-16)

[edit] DBAShell

DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.
Latest version: 0.85 (2006-07-11)

[edit] dbForge Data Compare for Oracle Express

dbForge Data Compare for Oracle Express is a free (only for Oracle Express Edition) edition of the handy free comparison tool, dbForge Data Compare for Oracle, from Devart. It helps to compare data in Oracle databases, find the differences at a glance, and get a SQL*Plus-compatible synchronization script to effortlessly synchronize data. All this is done in a clear graphical interface.
Latest version: 3.5.89 (2013-12-04)

[edit] dotConnect for Oracle Express

dotConnect Express for Oracle is a free (only for Oracle Express Edition) of charge enhanced ORM enabled data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications. dotConnect for Oracle features high performance, easy deployment, support for the latest versions of Oracle server and advanced Visual Studio 2008/2010/2012/2013 integration.
Latest version: 8.4.201 (10-07-2014)

[edit] Free PLSQL Editor/Compiler/Object Viewer

I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.
Latest version: 1.6 (2011-12-25)

[edit] HammerOra

Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.
Latest version: 2.13 (2012-DEC)

[edit] Instant SQL Formatter

Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

[edit] Jailer

Database Subsetting and Data Browsing tool. Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML. Since Release 3.6 it is also possible to browse a database based on relationships.
Latest version: 4.0.14 (2012-09-16)

[edit] MyGeneration Development Tool

MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free
Latest version: 1.3.1 (2011-01-02)

[edit] MyOra

MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.
Latest version: 3.5 (2011-07-11)

[edit] Odat, free Oracle Admin Tool

Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.
Latest version: 2005-09-29

[edit] OraExp - free, cross platform, native, asynchronous Oracle IDE

OraExp is a free Oracle IDE that targets to be lightweight and easy to use. Currently it is oriented mainly towards software developers. It works on Linux, Mac and Windows and supports Oracle 9i and later.
Latest version: 0.1.1 (2013-12-20)

[edit] OraPub System Monitor (OSM) Toolkit

The OSM is the tool kit referenced in Shallahamer's book, Oracle Performance Firefighting, used during OraPub consulting engagements, technical research, and during their training classes. The OSM is a complete set of performance diagnostic tools based upon response time analysis. It also contains a fantastic historical analysis pack (which will be eventually replaced with Statspack/AWR based reports). The OSM is sqlplus based, non-graphic, and comes with absolutely no warranty....and you'll love it! It's been around since 1998 and continues to be updated.

[edit] OraSentry

OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.
Latest version: 5.1 (2010-SEP)

[edit] OraSnap (Oracle Snapshot)

OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.
Latest version: 2008-01-14

[edit] Pretoria

Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.
Latest version: 3c (2008-04-28)

[edit] RRDORA

Trendanalysis on Oracle database with RRDTool.

[edit] Schema graphical editor

Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.
Latest version: 2003-05-19

[edit] SchemaSpy

Simple command line tool which generates HTML reports of oracle DB schema, including UML diagrams showing relationships. A little fiddly to set up. Free & Open Source
Latest version: 5.0.0 (2010-08-16) Graphical version: 0.99 (2009-02-21)

[edit] Silver Sash free

Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator. Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.
Latest version: 1.0.18 (2012-05-14)

[edit] SQL Developer

Oracle SQL Developer is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.
Latest version: 3.2.2 (2012-11-01)

[edit] SQLTools

SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.
Latest version: 1.6b15 (2011-12-26)

[edit] The DDL Extract Wizard

The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.
Latest version: v04.02.04 (2007)

[edit] TSHSQL - PL/SQL Editor and SQL Query Tool

TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).
Latest version: v112 (2005-03-10)