Thursday, December 29, 2005

Raptor has arrived...

Project Raptor is available for download.  I first talked about Raptor at the UKOUG this year and said it might be available as a “late Christmas present” and here it is.  It is pretty small, installs easily and gives you a SQLPlus like GUI to the database.  

Check it out – I think you’ll like it.


Anonymous Anonymous said....

Just downloaded it. Couple of annoyances. (What will the world be without us complainers :-)

*) 60MB download - Expanded to 112MB So much for small size

*) Why cant it read my tnsnames.ora for all my databases!!! Why do I have to create new connections??

Thu Dec 29, 10:43:00 AM EST  

Blogger Thomas Kyte said....

Best place to post questions about this would be the forum - the guys who wrote it are watching over there!

Thu Dec 29, 10:56:00 AM EST  

Blogger Scott said....

a great present, as I was just trying out different PL/SQL editors, for work and at home.

Thu Dec 29, 11:03:00 AM EST  

Blogger David Aldridge said....

Looks like a pretty good start -- a very hassle-free install anyway, providing you have the right JDK, and performance is much better than OEM

Thu Dec 29, 11:34:00 AM EST  

Blogger Rahul said....

This comment has been removed by a blog administrator.

Thu Dec 29, 01:11:00 PM EST  

Blogger Rahul said....

Thanks for the headsup. Guess the guys that have similar products must be pretty worried :)

Thu Dec 29, 01:12:00 PM EST  

Blogger Tom said....



I've been waiting for this. I'm going to download this and start playing with it and hopefully give a presentation on this at the end of January!

Thu Dec 29, 01:26:00 PM EST  

Anonymous Cristian said....

Great. I wasn't expecting it until next year. Well I guess we got lucky.

Thu Dec 29, 01:40:00 PM EST  

Anonymous Anonymous said....

It was one of the tools that was missing (from Oracle). So far I am liking it. It's nice we don't have to look for third party tools, anymore.

Thu Dec 29, 01:45:00 PM EST  

Blogger Tom said....

You can't use the TNSNAMES.ORA

I'm going to check the forums to see what they recommend.

I see you can import connections from an XML file. Maybe I will export to XML to find the format and write a utility to convert a TNSNAMES.ORA file into an XML file that Raptor can ready.

If anyone else already did this then let me know!

Thu Dec 29, 01:50:00 PM EST  

Blogger Tom said....

Actually, you can click the TNS tab when creating a connection and put in the TNSNAME.

Raptor appears to be setup to work even if you lack a TNSNAMES FILE or Oracle Client Install (Even the thin client)

Pretty cool stuff! You can install Raptor with nothing else and just use it. In fact you don't even need to run an installer.

Thu Dec 29, 01:54:00 PM EST  

Blogger Pete_S said....

You can't use the TNSNAMES.ORA
It's in the help files... But basically you set an environment variable to tell it where the TNSNAMES file is.

I like Raptor a lot so far - and the guys on the forum are responding so quickly to requests and comments. I can't wait to the one that supports all of the materialized view metadata and partitioning comes out!

Thu Dec 29, 01:58:00 PM EST  

Anonymous Anonymous said....

pretty good, but PL/SQL Developer still rocks my boat.

Thu Dec 29, 02:26:00 PM EST  

Blogger Tom said....

Look in Section 1-11 of the Help File.

I set a System Variable in Windows of TNS_ADMIN and pointed it to E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

You could also do %ORACLE_HOME%\NETWORK\ADMIN if you have ORACLE_HOME set.

There is also a registry variable that you can set as well.

In UNIX it is the global configuration directory.

Thu Dec 29, 02:27:00 PM EST  

Blogger Tom said....


Raptor and PL/SQL Developer are intended for 2 different audiences.

If you look, there are other things in this that are not in Developer.

It's more intended for management of the DB while PL/SQL Developer is intended for a developer audience. Apples and Oranges.

Thu Dec 29, 02:28:00 PM EST  

Blogger Gleisson Henrique said....

I like it so far. Takes much more memory than I would like, but hey I am comparing to SQL*Plus. What about that Snippet windows ? Pretty cool stuff!

Thu Dec 29, 02:54:00 PM EST  

Blogger Thet said....

This is a great debut. Performance so far is quite good.

Thanks also for keeping the us informed. I watch your blog more closely than the OTN pages. :->

Thanks for everything you have done for us in the community.

Happy Holidays!

Thu Dec 29, 04:45:00 PM EST  

Blogger Gary Myers said....

Tom, you said:
"It's more intended for management of the DB while PL/SQL Developer is intended for a developer audience. Apples and Oranges."
but on the forum (Raptor vs Toad, pg 2) from mhichwa (who appears to be one of the developers of raptor)
"Yes we need to focus on the database developer; not the hard core dba. "

I was seeing Raptor as a development tool, probably because I'm in development. I wonder why you saw it more as a management tool ?

Thu Dec 29, 05:22:00 PM EST  

Blogger Danny R said....

768 Meg of RAM seems an awful lot for minimum memory spec, any idea why this is?

Final Year Computing Student

Thu Dec 29, 05:50:00 PM EST  

Blogger Tom said....

I'm not Tom Kyte, just so no one gets confused.

Actually, after poking around it it does seem more like a Developer tool. I think it works for both.

I like the explain plan, I like how you can go in and edit a table as you can in TOAD or SQL Server's Enterprise Manager.

I can script things out, but so can developers.

From a DBA perspective, I like the reports Tab.

Under Reports you have:

Data Dictionary Reports which includes:

About Your Database

Database Adminsitration, which includes DB Parameters, Storage, Sessions, All Tables, Top SQL, Users (Really nice)

Security (Nice),
All Objects,
and Data Dictionary.

You can also see the Grants on Objects.

I personally think Raptor is going to be a tool that provides Development functionality and Database Management, all neatly packaged in one program.

Thu Dec 29, 05:59:00 PM EST  

Blogger Tom said....

Danny, I have no idea, But I installed it on my machine with 2GB of Ram and it runs fine.

I also installed it on another machine, Win2k, 1GZ Proc, and 256 MB Ram and it also ran fine, (just a bit slow)

I think Oracle, as most do, recommend things higher than they need to be so they don't run into any issues. Best be safe than sorry.

Also that 256 MB Machine doesn't have anything else running on it.

Thu Dec 29, 06:00:00 PM EST  

Blogger Stephen Booth said....


I had a play with Raptor this afternoon. I agree it's probably not for the hardcore DBA, not as a primary tool anyway.

Where I can see me probably using it is as something I can give to the non-DBAs who happen to do some DB management. I'll have to investigate it further to make sure that it's reasonably safe to let them use it though. I haven't had a chance to read much of the docs yet and haven't been able to hit the forums.

For my own use I can see me possibly putting it on a USB thumb drive so if I'm away from my desk and have to use a PC which doesn't have the Oracle client installed I can just plug it in and connect to a database if needed.

Actually, I'm going to be launching an internal Oracle Users Group in the organisation I work for, a demonstration of Raptor would probably be a good opening gambit.

Thu Dec 29, 06:00:00 PM EST  

Anonymous Anonymous said....

I don't detest Sql*Plus, I like Raptor but I love TOAD

Thu Dec 29, 07:10:00 PM EST  

Blogger Tom said....

Yes, I agree. Raptor has a long way to go to catch TOAD, but if anyone can do it, it's the folks at Oracle.

Thu Dec 29, 10:38:00 PM EST  

Anonymous Øyvind said....

Downloaded it and tested it briefly. Looks very nice and it scales better against large databases. I can't use Tora with a midsized Oracle Applications database because it does not handle the number of objects. Raptor responds faster and generates SQL for an object almost instantly. With Tora it often did not complete. Smart move.

Fri Dec 30, 05:18:00 AM EST  

Anonymous Martin said....

It looks nice, but it's quit buggy. Not that I am surprised...

Fri Dec 30, 05:27:00 AM EST  

Blogger Kim Nørby Andersen said....

Well, of course there are bugs - it's an early adopter version anyway.

One of the minor annoyances is, that the ctrl+enter in the current sql-statement removes focus from the code editing window, and sets it to the void - so the instant-editing gets breaked up all the time :(

Anyway, really nice for a "first public beta", and looking forward for some good competition between TOAD and Raptor :)

Fri Dec 30, 06:40:00 AM EST  

Blogger Tom said....

This comment has been removed by a blog administrator.

Fri Dec 30, 10:41:00 AM EST  

Blogger Tom said....

The Raptor development team is very responsive on the forums and open to suggestions as well as bugs. If you wan't a feature or think there should be an enhancement, then let them know about it.

I think as they interact with the end users and take our suggestions, then they can make something that is very powerful! (It sort of already is, and it's very lightweight)

Also, as they fix bugs, I like the fact that Raptor can update itself rather than having to delete and install a newer version.

Fri Dec 30, 10:42:00 AM EST  

Blogger Rjamya said....

Yes, it is great ... i have been using it for two days and been busy logging on the forum.

So far I like the product.

Fri Dec 30, 11:44:00 AM EST  

Blogger Sreekanth said....

looks good, but i like toad better.

Fri Dec 30, 01:36:00 PM EST  

Blogger Danny R said....

Hi Tom

Turns out the 768 Meg RAM requirement was a mis print, it should have been 256.

Sharon on the forum has updated the docs now! Your right they do watch the forum ;-)

Final Year Computing Student

Sat Dec 31, 01:25:00 PM EST  

Blogger Thai Rices said....

"Turns out the 768 Meg RAM requirement was a mis print, it should have been 256."

Wow, so it isn't just me who always accidentally types 768 when I meant 256...

Wed Jan 04, 10:01:00 AM EST  

Anonymous Ron said....

'not for hardcore DBAs' -
I think there are two DBA skill sets - Operations DBA and Project DBA. Operations DBA does backup/recovery, tunes memory/space, etc. Project DBA works with apps developers to tune app code, design DB schemas, optimize index design, etc. I see Raptor as a great Project DBA tool that's also good for apps developers to use during design.

Mon Jan 09, 06:30:00 PM EST  

Anonymous Anonymous said....

TNS_ADMIN needs to be in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment not in local_software\oracle..


Mon Jan 16, 12:03:00 PM EST  

Anonymous Anonymous said....

"TNS_ADMIN needs to be in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment not in local_software\oracle.."

Its the same as setting in Control -> EnviPanel -> System -> Advanced -> Enviornment variable

But im my case it was important to force filename lowercase! It didn't work with TNSNAMES.ora

Hope it was helpfull...

Thu Jan 18, 05:22:00 AM EST  

Blogger aOlsen said....

I have read the posts regarding the type of DBA work to be done. I have been using (now called) SQL-developer for developement tasks and I like it a lot, but I have to admit, I often start Toad in order to monitor the jobs and sessions that I have started, remove locks and so forth. These features in Toad are missing in the SQL developer. Whatever we develop has to be deployed in a running environment and that can hardly be acheived without monitoring the running system. So for as far as I can see, Raptor is still behind Toad, though a great tool that keeps evolving.

Sun Jan 28, 07:45:00 AM EST  

Anonymous Anonymous said....

Very Good article , this article make some interesting points.
Tactical Flashlights
r c helicopter
video game
Tactical Flashlight

Mon Jun 23, 02:37:00 AM EDT  

Anonymous Anonymous said....

hi guy

i downloaded the file named "License Maker make any license of any trial software 100 working.raptor" but it can not work. because it's extension is .raptor. i have no idea to extract the raptor file after download it.

how to make the file workable? plz help me.

my email is:


Tue Sep 02, 04:17:00 AM EDT  


<< Home