Mar 8 2006, 10:30 AM
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:
CODE
<local_service_name> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port>))
)
(CONNECT_DATA =
(SERVICE_NAME = <remote_oracle_service_name>)
)
)
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
Quote
0.0161sec
0.36
6 queries
GZIP Disabled