Getting ORA-01017: invalid username/password error only with specific tools
765364Apr 16 2010 — edited Apr 16 2010Hi,
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