Home » Other » Client Tools » connect to sql developer (oracle 11g, windows xp)
connect to sql developer [message #575674] Fri, 25 January 2013 09:52 Go to next message
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 1989 times)
Re: connect to sql developer [message #575676 is a reply to message #575674] Fri, 25 January 2013 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: connect to sql developer [message #575680 is a reply to message #575676] Fri, 25 January 2013 10:48 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: connect to sql developer [message #575681 is a reply to message #575680] Fri, 25 January 2013 11:18 Go to previous messageGo to next message
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/
Re: connect to sql developer [message #575683 is a reply to message #575681] Fri, 25 January 2013 11:47 Go to previous messageGo to next message
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
Re: connect to sql developer [message #575685 is a reply to message #575683] Fri, 25 January 2013 11:51 Go to previous messageGo to next message
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/

Re: connect to sql developer [message #575688 is a reply to message #575685] Fri, 25 January 2013 12:12 Go to previous messageGo to next message
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.
Re: connect to sql developer [message #575689 is a reply to message #575688] Fri, 25 January 2013 12:15 Go to previous messageGo to next message
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?
Re: connect to sql developer [message #575692 is a reply to message #575689] Fri, 25 January 2013 12:24 Go to previous messageGo to next message
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.
Re: connect to sql developer [message #575695 is a reply to message #575689] Fri, 25 January 2013 12:28 Go to previous messageGo to next message
wvu1999
Messages: 40
Registered: April 2007
Member

SDid you set the as sysdba option?
Re: connect to sql developer [message #575696 is a reply to message #575695] Fri, 25 January 2013 12:29 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I just gave the username as SYSDBA.
Re: connect to sql developer [message #575697 is a reply to message #575696] Fri, 25 January 2013 12:32 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: connect to sql developer [message #575699 is a reply to message #575697] Fri, 25 January 2013 12:42 Go to previous messageGo to next message
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
Re: connect to sql developer [message #575700 is a reply to message #575697] Fri, 25 January 2013 12:43 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Please find the snapshot.
  • Attachment: 1.png
    (Size: 31.03KB, Downloaded 1867 times)
Re: connect to sql developer [message #575701 is a reply to message #575699] Fri, 25 January 2013 12:44 Go to previous messageGo to next message
wvu1999
Messages: 40
Registered: April 2007
Member

SQL Developer doesn't require OCI/Oracle Client to connect...but I think you knew that Smile
Re: connect to sql developer [message #575702 is a reply to message #575700] Fri, 25 January 2013 12:46 Go to previous messageGo to next message
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.
Re: connect to sql developer [message #575703 is a reply to message #575699] Fri, 25 January 2013 12:53 Go to previous messageGo to next message
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.
Re: connect to sql developer [message #575705 is a reply to message #575703] Fri, 25 January 2013 12:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: connect to sql developer [message #575707 is a reply to message #575705] Fri, 25 January 2013 13:01 Go to previous messageGo to next message
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
Re: connect to sql developer [message #575709 is a reply to message #575707] Fri, 25 January 2013 13:13 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Ok. Can I know how to proceed further?
Re: connect to sql developer [message #575710 is a reply to message #575709] Fri, 25 January 2013 13:22 Go to previous message
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
Previous Topic: Column heading setting
Next Topic: very simple instruction to have in a pl/sql procedure
Goto Forum:
  


Current Time: Thu Mar 28 16:18:42 CDT 2024