c# - Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied -

c# - Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied -

i have challenging situation on 1 of our servers. have asp.net mvc 3 application needs connect oracle 12c database. using next connection string:

user id=myuserid;password=mypass;data source=(description=(address_list=(address=(protocol=tcp)(host=<ip address>)(port = 1521)))(connect_data=(service_name=pdb1)));

i'm using oracle's oracle.manageddataaccess, version 4.121.1.0. each effort connect results in next error:

ora-01017: invalid username/password; logon denied

i can connect on desktop above credentials. have same code on server, using older, un-managed version of library, , can connect aforementioned credentials. however, server on code run fails every single time using same credentials enable successful connections on different servers.

on server fails, can:

connect via sqlplus hit database tnsping create scheme dsn found odbc connection

i have checked tnsnames.ora in locations , appear correct.

after hitting database many times, business relationship locked indicating was, indeed, hitting database , database did not credentials presented. checked applications connected , failed error indicating business relationship locked. unlocking business relationship caused applications connect exception of server having problems.

i @ wit's end.

does have other suggestions might cause problem?

edit:

i installed wireshark on local computer , on offending server. captured communication between desktop , database offending server , database. found desktop communicated password:

0080 35 42 31 41 43 34 30 00 01 01 01 0d 0d 41 55 54 5b1ac40......aut 0090 48 5f 50 41 53 53 57 4f 52 44 01 40 40 43 30 36 h_password.@@c06 00a0 37 39 42 31 31 42 46 36 42 41 43 44 39 30 38 44 79b11bf6bacd908d 00b0 37 39 34 34 31 31 46 34 32 33 30 42 34 36 44 36 794411f4230b46d6 00c0 35 36 36 33 31 42 45 39 39 41 36 43 36 37 42 44 56631be99a6c67bd 00d0 43 33 35 42 42 44 36 44 42 45 37 34 36 00 01 0d c35bbd6dbe746...

whereas server having problems, did not (or @ to the lowest degree that's assumption):

0080 39 33 39 37 32 33 46 00 01 01 01 0d 0d 41 55 54 939723f......aut 0090 48 5f 50 41 53 53 57 4f 52 44 01 40 40 00 00 00 h_password.@@... 00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 00b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 00d0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 0d ................

does know of security/configuration setting prevent passwords beingness transmitted though nowadays in connection string?

i have been struggling same issue couple of weeks , have resolution. had disable fips security policy, seek setting key:

[hkey_local_machine\system\currentcontrolset\control\lsa\fipsalgorithmpolicy] "enabled"=dword:00000000

to zero, worked me

i next thread blank password issue pointed me here:

https://community.oracle.com/thread/2557592?start=30&tstart=0

c# oracle12c odp.net-managed ora-01017