Oracle12c错误01017,Oracle 12c: ORA-01017: invalid username/password; logon denied — oracle-tech

Attempting to connect using Oracle.ManagedDataAccess to a vendor database running 12c gets a ORA-01017.

Details:

Vendor database: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Source systems are both windows 7 64bit.

I've tried with Visual Studio 2017 and Visual Studio 2013 (different pc) with same results.

I've updated Oracle Developer Tools for Visual Studio 2017 to 18.3.0 with no change.

MDAC versions tried:

V18.6.0 (NuGet)

V18.3.0 (NuGet)

12.1.21  (NuGet)

4.121.2.0 ODAC release 4  (installed manually, didn't use NuGet)

What does work:

SQL Developer

TOAD

sqlplus

ODBC

including OdbcConnection called in .net console app

Unmanaged Data Access (same exact code just change using at the top to Oracle.DataAccess.Client).

Also using MDAC, I can connect to the systems at my company which are oracle 10.2 and 11g without issue.

Details:

Tried the various connection methods including with or without TNS and even with user/password passed in via OracleCredential parameter.

The password is mixed case, contains a numeric and an special character.    I've varied my password to include only underscores or exclaimation point or plus sign without a change of behavior.

I've tried the various ways quote the user id and password.

My FipsAlgorithmPolicy is 0 (off)

Here's one sample:

User Id=MY_ID;Password="Aa12345+6";Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = VENDERHOST)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = MMMM)))