Thursday, August 28, 2008

Connect to Remote Oracle DB using various SQL Editors

You want to connect to a remote Oracle DB using various SQL Editors but do not have or want to install Oracle DB. How do you do that?
Below is the syntax to connect to remote Oracle DB with various SQL Editors

Some Editors may require Oracle Instant Client. Oracle Instant Client can be found at http://www.oracle.com/technology/software/index.html
Download the Instant Client and unzip it to a directory. Set the library loading path in your environment to that. On Windows, PATH should be used.
To set Environment Variable Right Click on My Computer, goto Advanced Tab -> Environment Variables -> User variables for <user> -> New.
Enter PATH in Variable Name: and <path to Instant Client directory> in Variable value:
Click OK, OK, Apply, OK.

Editors that require Oracle Instant Client
1) TOAD Freeware: Enter <IP address>:<port>/<SID> in Database box.

2) TOAD Licensed:
Option #1. Enter <IP address>:<port>/<SID> in Database box.
Option #2. In Direct tab, enter <IP address> in Host box, <port> in Port box, <SID> in SID box.

3) SQLPlus: Enter connect <username>/<password>@<IP address>:<port>/<SID> at SQL prompt.

Editors that do not require Oracle Instant Client
4) OraCmd: Enter connect <username>/<password>@<IP address>:<port>:<SID>; at OraCmd prompt.

Note: You could also enter Host Name in place of IP Address

No comments:

Post a Comment