Home » SQL & PL/SQL » Client Tools » Unable to see database list in dropdown of pl/sql developer (pl/sql developer)
Unable to see database list in dropdown of pl/sql developer [message #580729] Wed, 27 March 2013 09:40 Go to next message
pavan9999
Messages: 2
Registered: March 2013
Location: Bangalore
Junior Member
Hi Everyone,

I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.
I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.
Could any one suggest me the necessary steps to follow. Please let me know if you need any further details from me.
Thanks in advance.

With Regards,
Pavan
Re: Unable to see database list in dropdown of pl/sql developer [message #580730 is a reply to message #580729] Wed, 27 March 2013 09:52 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you manually type in a DB name does it connect ok?
Re: Unable to see database list in dropdown of pl/sql developer [message #580731 is a reply to message #580730] Wed, 27 March 2013 10:01 Go to previous messageGo to next message
pavan9999
Messages: 2
Registered: March 2013
Location: Bangalore
Junior Member
No, i am unable to connect if i tried manually
Re: Unable to see database list in dropdown of pl/sql developer [message #580733 is a reply to message #580731] Wed, 27 March 2013 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 21955
Registered: January 2009
Senior Member
>No, i am unable to connect if i tried manually

while above is likely 100% true, it is also 100% devoid of any actionable detail.
what is actual & complete error code & message?

my car won't go.
tell me how to make my car go.

Is DB Server on different system than where PL/SQL Developer was installed?

on DB Server system issue following OS commands

lsnrctl status
lsnrctl service

COPY the results from above then PASTE all back here
Re: Unable to see database list in dropdown of pl/sql developer [message #583360 is a reply to message #580729] Tue, 30 April 2013 02:25 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Can you connect with SQL*Plus or anything else?

Can you tnsping the instance?

Can you ping the server?

What connection method are you using?
Previous Topic: How do I see the information before commit?
Next Topic: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
Goto Forum:
  


Current Time: Mon Apr 21 04:13:33 CDT 2014

Total time taken to generate the page: 0.08767 seconds