Home » SQL & PL/SQL » Client Tools » connect to oracle 11g (oracle 11g)
connect to oracle 11g [message #552968] Mon, 30 April 2012 10:27 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I am trying to connect to oracle 11g , I am having problems connection to databse , I able to connect from toad , but when I try from command line using sqlplus it fails also from sqldeveloper it fails ? pleae advice me how to troubleshoot the issue ?

Re: connect to oracle 11g [message #552969 is a reply to message #552968] Mon, 30 April 2012 10:32 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do we really need to tell you to post the error message?
Re: connect to oracle 11g [message #552970 is a reply to message #552969] Mon, 30 April 2012 10:43 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
sorry here is the error message , attached the screen shot with the error message.
the error is ora-01017:invalid username/password: logon denied.

the password I enter is the same it work only from toad , I also tried from sql plus from command prompt there also I get
ERROR:
ORA-01017: invalid username/password; logon denied,
pelase advice me.




Re: connect to oracle 11g [message #552971 is a reply to message #552970] Mon, 30 April 2012 10:48 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
You've almost certainly got multiple tnsnames.ora files on your pc. The one toad is using is pointing to a different DB to the one sqlplus and sqldeveloper are using.

Add a TNS_ADMIN setting to your registry to specify which tnsnames.ora file you want to use.
Re: connect to oracle 11g [message #552973 is a reply to message #552971] Mon, 30 April 2012 10:53 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
BTW, starting with V11 passwords are CaseSensitive.

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

http://www.orafaq.com/forum/t/88153/0/
Re: connect to oracle 11g [message #552974 is a reply to message #552971] Mon, 30 April 2012 11:00 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
In sql developer I specified tnsnames.ora directory attached is the screenshot.
In command prompt I am able to use tnsping to see my database tns entry.

Its the database in amazon cloud.


Re: connect to oracle 11g [message #552975 is a reply to message #552974] Mon, 30 April 2012 11:09 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
If it's not tnsnames that's the issue then I can only assuming it's due to the password being case sensitive.
Re: connect to oracle 11g [message #552976 is a reply to message #552975] Mon, 30 April 2012 11:23 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
thanks a lot it worked.upper case password worked. dont how toad logs in with lower case password
Re: connect to oracle 11g [message #552977 is a reply to message #552976] Mon, 30 April 2012 11:27 Go to previous message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
Presumably toad automatically converts it to upper case before sending it to oracle.
Previous Topic: problem in toad
Next Topic: export and import suing sql developer
Goto Forum:
  


Current Time: Sun Oct 21 18:24:31 CDT 2018