[oracle@localhost trace]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
Oracle is too dumb to lie.
BELIEVE this error message.
If it worked before & does not work now; then something changed!
Default behavior for V11 Oracle is for passwords are CaSeDePeNDeNT
with ORA-01017 error message an code, Oracle does is correct to report invalid username/password
You should be talking with the folks who run the database & not us. We can not change your reality.
BTW - Oracle treats ORA-01017 as an application; therefore does NOT log it into alert_SID.log file.
The listener log file will show a status of 0 (success) because the connection request was successfully handed off to the database.
I had an Native OLE DB\Microsoft OLE DB Provider for Oracle connection set up in SSIS to pull data from an Oracle 11g database and everything was working fine and then it stopped. Now when I test the connection I get "Test Connection failed because on an error initializing provider. ORA-01017: invalid username/password; login denied". I have also tried it with a .Net Provider\OracleClient Data Provider with the same result.
The people at the site of the Oracle server tried logging in with my username/password and were able to login
Which means that it is YOUR end that is causing the problem.
Which means something on YOUR end changed. An environment variable, a second Oracle client installed.
Investigate what changed on your end.
For the microsoft end of things you need to post in a microsoft or SSIS forum.
For Oracle/ODP related things you need to post in the ODP forum.
In either case you have posted in the WRONG forum. Please mark the thread answered and repost it elsewhere.
Thank you for your responses and I am not trying to be rude or break any rules, I just did not see the other ODP forum. I cannot mark the thread as answered because the two replies I got said two opposite things, but I will move it to the correct forum. I am a newbie at Oracle and apologize for the inconvenience.
I did not see a way to move this post nor could I see a way to get in touch with the site Moderator. Could the site moderator please move this post to: https://community.oracle.com/community/developer/english/oracle_database/windows_and_.net/odp.net
try tnsping and ping. Ask them to show you output of lnsrctl status.
It could be that some routing information changed in between you to point to a different server. It could be someone on your end restored an old tnsnames .ora to point to the wrong place. Are you using some kind of dynamic dns? That might have changed (I've seen situations where these things are defined in multiple places, with a failover a previous version is used pointing to a repurposed box with a db running on it. All sorts of confusing things can happen when all the db's are named ORCL.).
Oracle may be too dumb to lie, but it may also be too dumb to give a clear answer.