1

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition.

I have downloaded SQL developer which appears to be the Oracle world's equivalent to SSMS. I have gone to the new connection window, given my connection a name, used SYSTEM as the user and my password that I set up at installation. I have left hostname/port/sid as default (localhost/1521/xe respectively)

If I click test I get "status: success" However, if I click the connect button, nothing happens.

What am I missing here?

Improve this question
3
  • Check the listener.ora file of your local system ans make sure it has TNS entries of your database. Commented Sep 26, 2017 at 10:37
  • save the connection. on the tree, expand it - that will attempt a connect. Do you get an error message? Commented Sep 27, 2017 at 13:34
  • I believe that if you are connecting as SYS, you need to set the ROLE to SYSDBA. Commented Jul 20, 2018 at 12:45

1 Answer 1

Reset to default
1

When you connect from the connection properties dialog, two things will happen in the UI:

enter image description here

  1. the connection icon gets a 'connected' overlay
  2. you get a SQL Worksheet***

If your connection is not successful, you'll get an error message, with the text shown at the bottom of the connection properties window.

enter image description here

***For #2 above, this is conditional on the following preference being enabled, which the default is TRUE.

'Open a Worksheet on connect'

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.