Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can not connect to Oracle database using through sql developer

san_crazyFeb 22 2012 — edited Feb 27 2012
Hi ALl,

I have donwloaded and installed SQL developer 3.x.x 32 bit bundeled with JDK 1.6_11. But when I try to connect to oracle database HR84DMO using the credentials:
user name - sys
password - oracle12
role - sysdba
host name - localhost
port - 1521
sid = HR84DMO

Please note that everything is installed on my own laptop running with windows 7 64 bit. I am getting below error
Status : Failure -Test failed: The Network Adapter could not establish the connection
Please also note that, I have created two databases running at the same time and I am not sure if they are running with the same port 1521 because, when I started first database HR84DEV it certainly would have started with the port 1521 but I also started the database HR84DMO to which I am connecting to, at the same time.
Is there a port clash?

I can connect to database using the same credentials from command line and database is also running.

I am not really shure of this, just guessing that this might be the problem.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2012
Added on Feb 22 2012
21 comments
9,546 views