Home » SQL & PL/SQL » Client Tools » Oracle SQL Developer Connection (Oracel 11g R1, Windows SP3)
Oracle SQL Developer Connection [message #492621] Tue, 01 February 2011 08:23 Go to next message
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 251 times)
Re: Oracle SQL Developer Connection [message #492627 is a reply to message #492621] Tue, 01 February 2011 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
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
Re: Oracle SQL Developer Connection [message #492654 is a reply to message #492627] Tue, 01 February 2011 11:27 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi,

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

Solution please.

Thanks,
Ananth
Re: Oracle SQL Developer Connection [message #492658 is a reply to message #492654] Tue, 01 February 2011 11:34 Go to previous messageGo to next message
cookiemonster
Messages: 12989
Registered: September 2008
Location: Rainy Manchester
Senior Member
Tried what exactly?
Re: Oracle SQL Developer Connection [message #492659 is a reply to message #492658] Tue, 01 February 2011 11:36 Go to previous messageGo to next message
BlackSwan
Messages: 25793
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/
Re: Oracle SQL Developer Connection [message #492662 is a reply to message #492654] Tue, 01 February 2011 11:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
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

Re: Oracle SQL Developer Connection [message #492683 is a reply to message #492662] Tue, 01 February 2011 15:25 Go to previous message
Littlefoot
Messages: 21330
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?
Previous Topic: Connect to mssql\express 2008
Next Topic: Spool output in PDF Format
Goto Forum:
  


Current Time: Thu Jan 18 00:57:19 CST 2018

Total time taken to generate the page: 0.01246 seconds