5 Replies Latest reply on May 2, 2014 11:59 PM by jgarry

password

d6739753-447c-40ba-a181-df7dbd3679f7 May 2, 2014 10:20 PM

First let me explain that the system I am talking about is on a seperate network with no access to the public internet so posting log files and the such will be out of the question, but I can type whatever needed information.

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. They say it is a problem on my end, even though I did not change anything. I say it is a problem on their end since I am obviously hitting the Oracle server with a 1017 error, but they say they did not change anything.

I am not an Oracle person, but this is very strange to me how they are able to login and I am not with the same account information. Not to mention that it was working and now it is not. I imagine that a firewall or port issue would give me a different error. Could a policy have been implimented that put some sort of wrapper on my login information when it is transmitted? The network and policy people are always implimenting thing without our awareness. Given the error and situation, where would be a logicall place to start looking for the problem on my end (A) or theirs (B)? And if it is on B then what do I tell them to look at, the listener.ora file? Does anyone have any direction or suggestions?

I have spent a week of Googling on this and have read many articles but I still am no closer to solving this issue, so any help would be GREATLY appreicated.

1. Re: Remotely: Error 1017 username/password; login denied. Locally: Login works with username/password

sb92075 May 2, 2014 10:31 PM (in response to d6739753-447c-40ba-a181-df7dbd3679f7)

[oracle@localhost trace]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

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.
Like Show 0 Likes(0)

Actions
2. Re: Remotely: Error 1017 username/password; login denied. Locally: Login works with username/password

rp0428 May 2, 2014 10:36 PM (in response to d6739753-447c-40ba-a181-df7dbd3679f7)

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.
https://community.oracle.com/community/developer/english/oracle_database/windows_and_.net/odp.net

In either case you have posted in the WRONG forum. Please mark the thread answered and repost it elsewhere.
Like Show 0 Likes(0)

Actions
3. Re: Remotely: Error 1017 username/password; login denied. Locally: Login works with username/password

d6739753-447c-40ba-a181-df7dbd3679f7 May 2, 2014 11:30 PM (in response to d6739753-447c-40ba-a181-df7dbd3679f7)

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
Thank you.
Like Show 0 Likes(0)

Actions
4. Re: Remotely: Error 1017 username/password; login denied. Locally: Login works with username/password

jgarry May 2, 2014 11:58 PM (in response to d6739753-447c-40ba-a181-df7dbd3679f7)

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.
Like Show 0 Likes(0)

Actions
5. Re: Remotely: Error 1017 username/password; login denied. Locally: Login works with username/password

jgarry May 2, 2014 11:59 PM (in response to d6739753-447c-40ba-a181-df7dbd3679f7)

By the way, I think simply mentioning the correct space branches the thread there, so look and see.
Like Show 0 Likes(0)

Actions

Go to original post