OraFAQ Forum: Client Tools » connect to sql developer

Home » Other » Client Tools » connect to sql developer (oracle 11g, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect to sql developer [message #575674]

Fri, 25 January 2013 09:52

lg123
Messages: 225
Registered: August 2008

Senior Member

I haven't used SQL Developer for a very long time. But now I would have to use it to work with the oracle database. I have downloaded and installed the oracle sql developer. But I am not sure how to connect the SQL Developer to the oracle database that I had created. Can someone help me in this. I am attaching the screenshot of where I am. Can I know how to proceed further?

Attachment: pic1.jpg
(Size: 42.37KB, Downloaded 2577 times)

Report message to a moderator

Re: connect to sql developer [message #575676 is a reply to message #575674]

Fri, 25 January 2013 10:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you see "Help" top right the screen, it is there to... help you.
Maybe you should use it and read the documentation instead of relying on us for everything.

Regards
Michel

Report message to a moderator

Re: connect to sql developer [message #575680 is a reply to message #575676]

Fri, 25 January 2013 10:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You are on the wrong place, obviously. What are you doing on the "Reports" tab? You should return to "Connections" one and create a new connection.

Report message to a moderator

Re: connect to sql developer [message #575681 is a reply to message #575680]

Fri, 25 January 2013 11:18

wvu1999
Messages: 40
Registered: April 2007

Member

I have some information here on how to get connected to Oracle using SQL Developer
http://www.thatjeffsmith.com/archive/2012/12/i-have-oracle-sql-developer-installed-now-what/

Report message to a moderator

Re: connect to sql developer [message #575683 is a reply to message #575681]

Fri, 25 January 2013 11:47

lg123
Messages: 225
Registered: August 2008

Senior Member

Thanks. I am able to successfully connect the sql developer to oracle database using system user, but not using sysdba user. I get the below error :

Status : Failure - Test failed: ORA-01017: invalid username/password; logon denied

Report message to a moderator

Re: connect to sql developer [message #575685 is a reply to message #575683]

Fri, 25 January 2013 11:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01017: invalid username/password; logon denied

no error is thrown when you use valid username/password combination
with V11 passwords are now Case SenSitive

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: connect to sql developer [message #575688 is a reply to message #575685]

Fri, 25 January 2013 12:12

lg123
Messages: 225
Registered: August 2008

Senior Member

Even the passwords are the same for both system and sysdba users. I tried almost 3 times. I am sure I gave the correct password.

Report message to a moderator

Re: connect to sql developer [message #575689 is a reply to message #575688]

Fri, 25 January 2013 12:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Even the passwords are the same for both system and sysdba users. I tried almost 3 times. I am sure I gave the correct password.
Either you are correct & Oracle has a bug,
or Oracle is correct & you are mistaken.

Do you want to bet on which better reports reality; you or Oracle?
Does SQL Developer require & use SQL*Net to connect to the DB?

Report message to a moderator

Re: connect to sql developer [message #575692 is a reply to message #575689]

Fri, 25 January 2013 12:24

lg123
Messages: 225
Registered: August 2008

Senior Member

I use the same password in sql plus to login to the oracle database. I don't think SQL Developer requires SQL*Net to connect to the db.

Report message to a moderator

Re: connect to sql developer [message #575695 is a reply to message #575689]

Fri, 25 January 2013 12:28

wvu1999
Messages: 40
Registered: April 2007

Member

SDid you set the as sysdba option?

Report message to a moderator

Re: connect to sql developer [message #575696 is a reply to message #575695]

Fri, 25 January 2013 12:29

lg123
Messages: 225
Registered: August 2008

Senior Member

I just gave the username as SYSDBA.

Report message to a moderator

Re: connect to sql developer [message #575697 is a reply to message #575696]

Fri, 25 January 2013 12:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you saying that username = SYSDBA? Are you sure? Please, post a screenshot of what you do.

Report message to a moderator

Re: connect to sql developer [message #575699 is a reply to message #575697]

Fri, 25 January 2013 12:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I don't think SQL Developer requires SQL*Net to connect to the db.
then do as below

lsnrctl stop

& now connect to the DB using SQL Develeoper then post results back here

Report message to a moderator

Re: connect to sql developer [message #575700 is a reply to message #575697]

Fri, 25 January 2013 12:43

lg123
Messages: 225
Registered: August 2008

Senior Member

Please find the snapshot.

Attachment: 1.png
(Size: 31.03KB, Downloaded 2429 times)

Report message to a moderator

Re: connect to sql developer [message #575701 is a reply to message #575699]

Fri, 25 January 2013 12:44

wvu1999
Messages: 40
Registered: April 2007

Member

SQL Developer doesn't require OCI/Oracle Client to connect...but I think you knew that Smile

Smile

Report message to a moderator

Re: connect to sql developer [message #575702 is a reply to message #575700]

Fri, 25 January 2013 12:46

wvu1999
Messages: 40
Registered: April 2007

Member

use 'SYS' as your username, not SYSDBA

Then on the drop-down where it says 'default', click there and switch to AS SYSDBA

Next, create a new user with limited privs so you don't screw up your environment - which is very easy to do if you're using SYS.

Report message to a moderator

Re: connect to sql developer [message #575703 is a reply to message #575699]

Fri, 25 January 2013 12:53

lg123
Messages: 225
Registered: August 2008

Senior Member

Actually i am not very sure whether it uses sql*net or not. It is a production database, I do not want to stop the listener now.

I used SYS as the username and changed the default to AS SYSDBA. Still no luck.

Report message to a moderator

Re: connect to sql developer [message #575705 is a reply to message #575703]

Fri, 25 January 2013 12:56

wvu1999
Messages: 40
Registered: April 2007

Member

so your password is wrong then...you said you connected in SQL*Plus, right?

Confirm the service/sid you have set in SQL Developer is the same you're using in SQL*Plus

[Updated on: Fri, 25 January 2013 12:57]

Report message to a moderator

Re: connect to sql developer [message #575706 is a reply to message #575705]

Fri, 25 January 2013 12:59

lg123
Messages: 225
Registered: August 2008

Senior Member

The password is correct, because I could connect through sql plus tool. I did not use SID, instead I used the service name. I erased the confidential details while sending the picture. So, you cant be able to see it. But those values are correct, because i used the same values when I was using system user to connect.

Report message to a moderator

Re: connect to sql developer [message #575707 is a reply to message #575705]

Fri, 25 January 2013 13:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Actually i am not very sure whether it uses sql*net or not.
The connection request will be logged into listener.log file
connecting AS SYSDBA across SQL*Net uses external password file located in the DATABASE folder

Report message to a moderator

Re: connect to sql developer [message #575709 is a reply to message #575707]

Fri, 25 January 2013 13:13

lg123
Messages: 225
Registered: August 2008

Senior Member

Ok. Can I know how to proceed further?

Report message to a moderator

Re: connect to sql developer [message #575710 is a reply to message #575709]

Fri, 25 January 2013 13:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm#ADMIN10241

Report message to a moderator

Previous Topic:	Column heading setting
Next Topic:	very simple instruction to have in a pl/sql procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 02:35:10 CST 2025