GOAT Oracle Administration Tool

I coded a "very" simple Java application to monitor our 100+ Oracle Databases about 2 years ago. It doesn't need any installation on database-side and works on Linux, Solaris and Windows (thanks to Java!). I stopped using (and developing) it when we started Oracle Enterprise Grid Control. Now I've decided to continue developing it.

Here are screenshots:







TODO:

1) Query RMAN catalog (Oracle 9i doesn't have v$rman_backup_job_details)
2) Add more tabs (to gather more information about databases)
3) Add Berkeley DB to store the login informations for databases.
4) Create an Installer.

FAQ:

1) Will it be open-source? Not sure, why not? :)
2) When will it be ready for download? Soon.

Update Log:

07/08/2011: Started to use thin client.
07/01/2011: Add S-ASH Support (http://ashmasters.com/): I have modified SASH to store repository tables in target database.
06/29/2011: SQL Syntax highlighter: I was not planning to add it but found a cool highlighter for Java and added it to the project (http://code.google.com/p/jsyntaxpane/)

6 comments:

  1. Hi Gokhan,

    Any update on when GOAT will be ready for download? Am itching to give it a try :-)

    ReplyDelete
  2. I was so busy therefore I couldn't find time to work on it, but it's still in my todo list :)

    I'll try to make it ready for download in a couple of months.

    ReplyDelete
  3. Can't wait to try it out :)
    Hope you'll find some time to make it downloadable .

    Thanks

    ReplyDelete
  4. I am waiting for dowloadable version.

    ReplyDelete
  5. Why continue? In what way is GOAT not redundant?
    I can imagine that it is trimmed down to just what you want how you want to see it, but is it more than that over-and-above 12c?

    ReplyDelete
  6. Jim, GOAT has some important advantages: It can use SASH if you do not have tuning pack license, it doesn't need any agent deployment (you just create SASH schema/packs if you do not use ASH), doesn't need a high configuration, it's simply and fast... Don't get me wrong, I do not claim that GOAT is an alternative to Enterprise Manager. It's just a hobby for me and to be honest, I could not find time to develop it last months and it's almost died (again).

    ReplyDelete