We have a set of Applications in Coldfusion MX7 with Oracle 11g Database.
Connected Datasources in Coldfusion using JDBC thin Driver. The coldfusion server has ojdbc14.jar in c:\coldfusionmx7\lib
The Oracle version has now been upgrade to 12c.
The Application throws "ORA-28040: No matching authentication protocol"
We googled and found that the jdbc driver used is not compatible and they suggested
1. change the ojbc14.jar to ojdbc6.jar in c:\coldfusionmx7\lib, restart Coldfusion server and start mapping the Datasources.
2. Set SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 in the oracle/network/admin/sqlnet.ora file.
Please give us a clear suggestion
1. Whether downloading ojdbc6.jar from Oracle website and placing it in c:\coldfusionmx7\lib instead of ojdbc14.jar
will work properly- Is it compatible with MX7?
2. Adding the server version "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" in sqlnet.ora file will do or
do we have to specify SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 also. If so, do we have to restart the Database
server to make it effective?
I doubt you will get this working as you fully intend. 12c support is only available on CF11. Some older version have had luck getting this working but we are talking CF9/10. MX7 may have further complications.
Generally I think the only way for the older version is to add the SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 to the sqlnet.ora. I think the people using this trick are using a version of CF that supports 11g though. MX7 only supports up to 10g.
You will have to try ojdbc6.jar or ojdbc7.jar to see if it makes any difference when trying it with CF. ojdbc7.jar is the 12c JDBC driver.
Any changes you make will require service restarts.