Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ORA-01017: invalid username/password error only with specific tools

765364Apr 16 2010 — edited Apr 16 2010
Hi,
I am a Junior DBA still getting familiar with Oracle. I am having trouble accessing one of my databases through both TOAD and SQLDetective tools. When I try to log in to my database using these tools, I get the error:

ORA - 01017: invalid username/password; login denied

Even though the password and username is correct.

I can successfully login through other tools like SQLTools and through SQL Plus. I have searched this issue and I have seen people with the same problems but I couldnt find a solution. The weird thing is, I can use TOAD and SQLDetective to login to other databases without any issues. It seems to be this one specific database.

My database is an 11g database on a linux box. I have 9i and 10g clients installed on my machine. The all my apps use the tnsnames from the 9i home on my machine.

Any help on this would be greatly appreciated. Thanks.

Rgs,
Rob

Edited by: rgilligan on 16-Apr-2010 02:11
This post has been answered by he420834ke on Apr 16 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2010
Added on Apr 16 2010
6 comments
1,398 views