TOra was written by Henrik Johnson and is now owned by Quest Software. It's an open source tool that is avalible on SourceForge. UNIX versions are avaliable at no cost, but the Windows version requires a license beyond 30 days (although not inforced). It's written in C++ and based on Qt.
TOra is a graphical interface that allows simple management of your database. The capital TO in TOra stands fo "Toolkit for Oracle". Over time, however, it has grown to also support PostgreSQL and MySQL. It has a SQL editor, table editors, a schema browser, PL/SQL editor and debugger, Security manager, a server tuning module, and much much more. I've never used the old Oracle Enterprise Manager back when it was a Win32 GUI app instead of web based, but from what I've seen TOra looks very similar to it. So if your DBAs are complaining that their old EM interface is gone and they don't like the web interface, here is your solution.
For the SA TOra makes the database extremely easy to plow around. If you connect to the database as SYSDBA you can scroll up and down the huge list of tables and views and see them in spreadsheet format. This provides an invaluable way to examine the guts of your database without typing out hundreds of SQL queries. And furthermore, because it's a nice controlled GUI you can look at massive tables with thousands of rows and just scroll down instead of trying to pipe output to a file for examination or something.
The SQL and PL/SQL editors are pretty sweet. Syntax highlighting, line stepping and breakpoint debugging, tree parsing, and more. Extremely handy and much better than trial and error using just VIM and SQL*Plus.
TOra can also manage multiple connections and have a pretty nice login interface, so you can just click your instance and go. Just make sure that when you first try to connect to the database that TNS resolution is working properly (tnsping the instance first) or uncheck "SQL*Net" on the login screen to use a local login.
Binary distributions are avalible for Win32 and Linux in both RPM and tarball. Some Solaris tarballs have been contributed and TOra is fully portable for any platform you want it on.
Get more information, look for updates, and check out features and screenshots at the TOra website: http://www.globecom.net/tora/