When configuring a datasource for Oracle using the thin client, I get an Oracle error.

Report · Aug 16, 2013

We have had no problems using Oracle up to this point, and have been using ColdFusion and Oracle very happily for a long time.

Due to security requirements where the ColdFusion server is hosted, the following changes were made to the Oracle client on the Oracle RDMS machine which caused ColdFusion to be unable to connect.

In the sqlnet.ora file, we had to add the follwing line:

SQLNET.ALLOWED_LOGON_VERSION = 10

That parameter was required, it is not optional and we cannot lower it.

Info about our ColdFusion Server:

System Information

Server Details
Server Product	ColdFusion
Version	ColdFusion 10,285437
Edition	Enterprise
Operating System	Windows Server 2008 R2
OS Version	6.1
Update Level	/D:/ColdFusion10/cfusion/lib/updates/chf10000011.jar
Adobe Driver Version	4.1 (Build 0001)

We are using Oracle 11.2.0.3

Once that change is in place, connections from our ColdFusion server get refused with the following error:

ORA-28040: No matching authentication protocol

I have verified that I can connect to the database with our credentials, and verified that the connection is valid:

From the local server's ODBC Data Source Administrator console, I create a system DSN using the Oracle OCI client driver (ojdbc6.jar) by indicating that the TNS Service name is the same as defined in the TNSNames file, and it tests out fine.

Everything I have found on the net indicates that I would need to make a change to the Client, but the Client in this case is the ColdFusion server. It doesn't seem like other than the fact that it seems to be using the correct driver, that it is making any use of any of the additional settings, including those found in the sqlnet.ora file.

HELP! I don't know where else to go... i don't believe that this is an Oracle error, since everything seems to be functioning correctly. I believe this to be a ColdFusion issue.

Any help or pointers would be greatly appreciated.

Report · Aug 16, 2013

Hi,

Check this : https://forums.oracle.com/thread/863043

Thanks

VJ

Report · Aug 16, 2013

Thank you VJ, however that didn't provide any help. There are no pointers at all within that post.

Please keep in mind that I don't believe this to be an Oracle issue. The Oracle client is functioning fine when I use the ODBC tools in windows to verify the connection.

I can google, "SQLNET.ALLOWED_LOGON_VERSION = 10" and get a billion links that say basically nothing too.

I believe this is the way ColdFusion is configured to use the Oracle drivers... Which is why I can't ask Oracle, they'd just tell me to go to Adobe!

But, I have searched Oracle Support, and there wasn't much there either, so I am turning to the community in hopes that someone has seen this and solved it.

Report · Aug 23, 2013

Hi Robbart,

I noticed that you are using DataDirect Driver. Can you please try to switch to Oracle thin driver, it should work with that.

Thanks,

Anjaneai