Using TOAD

Hi,

if you add your remote db to your tnsnames.ora file, you can connect it using T.O.A.D.

regards

how can i do that?
I hv no idea!

i hv installed Oracle Client installed .
so where i hv to provide all my ip address address and user name passwd to connect remote db from TOAD

Once you have the TNSNAMES.ORA set up - the ip address is specified in this file.

When you start TOAD it should ask you to connect to a database. In the drop down for Database, select the database name you specified in the TNSNAMES.ORA file (eg. REMOTESID.WORLD), enter your username and password in the appropriate boxes and click OK.

If you had TOAD open when you set up the TNSNAMES.ORA file, then to refresh the list...shutdown TOAD and restart it, or manually type in the name.

If TOAD isn't asking for the Server Login, select from the menu File -> New Connection.

so first i hv to edit my  TNSNAME.ORA file and one more thing what is SID how is it username.

if i use net8 assistant do i have to edit that file.?

Hi,

you can use Net8 assistant to edit tnsnames.ora. After adding the definition don't forget to test the connection.