OraFAQ Forum: Client Tools » Oracle SQL Developer Connection

Home » Other » Client Tools » Oracle SQL Developer Connection (Oracel 11g R1, Windows SP3)

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

Oracle SQL Developer Connection [message #492621]

Tue, 01 February 2011 08:23

GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur

Member

Please clarify me.

I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.

I have given user name: ora; pswd: ora.

In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora

But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.

So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.

1] What is SID. Is it session ID. If so how to find it.

2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.

I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])

See the attachment & help me on this.

3] Is there any editor for practising sql & pl sql queries. where I can download it.

Thanks,
Ananth

Attachment: Ora_Conn.JPG
(Size: 93.15KB, Downloaded 1176 times)

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492627 is a reply to message #492621]

Tue, 01 February 2011 08:35

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) It is instance name. Something like the standard ORCL or XE.
2) Just try to connect
3) SQL*Plus, you already have it.

I recommend you to watch the following videos:
http://www.youtube.com/results?search_query=%22Oracle+DBA+Lite%22&aq=f

Regards
Michel

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492654 is a reply to message #492627]

Tue, 01 February 2011 11:27

GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur

Member

Hi,

I tried several times. But it won't work.

Solution please.

Thanks,
Ananth

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492658 is a reply to message #492654]

Tue, 01 February 2011 11:34

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Tried what exactly?

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492659 is a reply to message #492658]

Tue, 01 February 2011 11:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But it won't work.
While likely true, is completely lacking in any useful detail.

My car won't work.
Tell me how to make my car go.

Posting COMPLETE error code & message might provide us a clue as to the problem.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492662 is a reply to message #492654]

Tue, 01 February 2011 11:42

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

GaneshAnanth wrote on Tue, 01 February 2011 18:27

Hi,

I tried several times. But it won't work.

Solution please.

Thanks,
Ananth

Once again, I advise you to follow the videos, at least the first couple ones.
It is easy, it requires NO effort and gives you the solution to make your environment work.

Regards
Michel

Report message to a moderator

Re: Oracle SQL Developer Connection [message #492683 is a reply to message #492662]

Tue, 01 February 2011 15:25

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

Senior Member
Account Moderator

From a screenshot you posted: connection type is "Basic". What happens if you choose the "TNS" radio button? I guess that it might offer database aliases contained in TNSNAMES.ORA file. How does TNSNAMES.ORA look like? Is "XE" SID or Service Name?

Report message to a moderator

Previous Topic:	Connect to mssql\express 2008
Next Topic:	Spool output in PDF Format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 07:24:19 CDT 2024