OraFAQ Forum: Client Tools » connect to oracle 11g

Home » Other » Client Tools » connect to oracle 11g (oracle 11g)

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

connect to oracle 11g [message #552968]

Mon, 30 April 2012 10:27

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 ?

Report message to a moderator

Re: connect to oracle 11g [message #552969 is a reply to message #552968]

Mon, 30 April 2012 10:32

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

Senior Member

Do we really need to tell you to post the error message?

Report message to a moderator

Re: connect to oracle 11g [message #552970 is a reply to message #552969]

Mon, 30 April 2012 10:43

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.

Attachment: sql-developer.jpg
(Size: 22.03KB, Downloaded 874 times)

Report message to a moderator

Re: connect to oracle 11g [message #552971 is a reply to message #552970]

Mon, 30 April 2012 10:48

cookiemonster
Messages: 13904
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.

Report message to a moderator

Re: connect to oracle 11g [message #552973 is a reply to message #552971]

Mon, 30 April 2012 10:53

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: connect to oracle 11g [message #552974 is a reply to message #552971]

Mon, 30 April 2012 11:00

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.

Attachment: sql-developer-tnsnames.jpg
(Size: 72.63KB, Downloaded 947 times)

Report message to a moderator

Re: connect to oracle 11g [message #552975 is a reply to message #552974]

Mon, 30 April 2012 11:09

cookiemonster
Messages: 13904
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.

Report message to a moderator

Re: connect to oracle 11g [message #552976 is a reply to message #552975]

Mon, 30 April 2012 11:23

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

Report message to a moderator

Re: connect to oracle 11g [message #552977 is a reply to message #552976]

Mon, 30 April 2012 11:27

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

Senior Member

Presumably toad automatically converts it to upper case before sending it to oracle.

Report message to a moderator

Previous Topic:	problem in toad
Next Topic:	export and import suing sql developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 03 16:23:57 CDT 2023