On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Sunday, August 14, 2011

Connecting to SQL Developer

A while ago, the disk on my laptop crashed, and so now I'm trying to download and set up some of the tools I used before. I got SQL Developer installed, but naturally couldn't remember what I did to get the connection.  This time I decided to put it in writing.  I honestly haven't done any studying of Oracle's material on installation so it probably is all there, but one of the main reasons I blog is so I can find things again. 

Here I'm connecting to Oracle's HR schema, using the password I selected when I installed the database.
Click on 'Service name' at the bottom, and supply the three values found in your tnsnames.ora file.

Voila! Click on 'Test' or 'Connect.'

No comments:

Post a Comment