Skip to Main Content

ODP.NET

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!

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

2665960May 2 2014 — edited May 3 2014

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.

Comments

justsomeone

Hello

the compiler can not find the User class
for example in this line in your code
public void insertUsers(List < User > list)
insertUsers take list of User but it can not find the class User so to solve it

  1. import the class User
  2. if the class User are in the same package then you do not need to do anything
  3. if the class User are nested member (static inner class or inner class) then you do not need to anything also

but i guess this class are in other package maybe from the tutorial you mentioned it's mentioned in previous page or something

hope that help and have a nice day :)

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 30 2014
Added on May 2 2014
5 comments
8,208 views