hello guys,

anyone here uses TOAD or TORA to connect to a remote Oracle??

mind to share how you configure?

Ha, this will be interesting. I tried, but eventually gave up and ran it locally on the Oracle box instead.

I thought it'd be something like creating a tnsnames.ora for SQLplus. Maybe it is. It didn't work for me though.

at first i tried TORA...kinda stupid..i manage to connect to remote using SQLplus..but guess what..TORA is can't find my remote server...

Never tried TORA, but I'm guessing it's not very different from TOAD.

Assuming you've already installed the Oracle client on your PC, you just need to add a new local service name that'll connect to the remote Oracle DB. You can use either Net Manager for this or you can edit <ora_home>\network\ADMIN\tnsnames.ora by hand like so:



This is for Oracle 8i and above. Oracle 8 and below will have a different looking tnsnames entry. Google it or post here if your version of Oracle is 8 or below.

Once you've done it, just start TOAD and connect to the local service name that you've created. If it doesn't work, use the usual tools like sqlplus or tnsping to troubleshoot your connection. Good luck.

This post has been edited by fly: Mar 8 2006, 10:31 AM

ahh...Thanks..it works for TOAD but not TORA...anyway..Thanks

anyway..do remember to place the "msvcr71.dll" is the PATH as well