We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Using TOAD

joyjohn
joyjohn asked
on
Medium Priority
2,346 Views
Last Modified: 2008-03-10
Can we connect to my remote database via using toad?
regards
Comment
Watch Question

Commented:
Hi,

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

regards

Author

Commented:
how can i do that?
I hv no idea!
Project Architect
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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
Lee WadwellProject Architect
CERTIFIED EXPERT

Commented:
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.

Author

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

Author

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

Commented:
Hi,

you can use Net8 assistant to edit tnsnames.ora. After adding the definition don't forget to test the connection.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.