No matching authentication protocol Oracle 12c

[Guest]

Hi, we are working with ColdFusion 10 and Oracle 12c Database, but when we are trying to connect with the database across CF, we have the following message:

java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocol

Does anybody know how can we work with Oracle 12c? Is necessary an update to fix that?

Thank you.

[Runrocket]

Here's the message I got back from Adobe. It can be referenced in the bugbase (https://bugbase.adobe.com/index.cfm?event=bug&id=3721707).

Rupesh Kumar

1:24:29 AM GMT+00:00 Mar 18, 2014

The support for Oracle 12c is there in ColdFusion 11. As of now, we don't have any plans to add this support in ColdFusion 9/10

Stephen Johnson

Adobe Advanced ColdFusion Certified Developer (ADB184437)

[Guest]

Hi Stephen Johnson

I appreciate too much your help, for this moment we will continue working

in CF 10, and we will wait the new version of CF 11 to work with 12c.

Thank you very much for your support, greetings from Mexico.

Sincerely

Javier Morales Rangel

2014-03-24 10:46 GMT-06:00 Runrocket <forums_noreply@adobe.com>:

Re: No matching authentication protocol Oracle 12c created by

Runrocket <http://forums.adobe.com/people/Runrocket> in Database Access- View

the full discussion <http://forums.adobe.com/message/6237571#6237571

[kurttt]

I have oracle 12c working with coldfusion 11 enterprise edition on 64bit oracle linux 6.5.

However, 12c uses a container/pluggable architecture.

If I create a user in the container database (CDB), the datasource GUI in CF11 can log into that user account.

If I create a user in the pluggable database (PDB), I CANNOT get CF11 to log into that account.

If I create an oracle service name in listener.ora, I CAN log into the pluggable account from the shell i.e. sqlplus user@pdb.

So, the service naming is not the issue.

Is it even possible to hit the account within the PDB with the default ORACLE driver in CF11 datasource GUI?

Or, ...must one set up the database as a container-only to allow CF11 access?

[Guest]

If you need to get CF9 or 10 to work with Oracle 12c until you can upgrade to CF11, add this to your sqlnet.ora file on your database server:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

In Oracle 12c, the default was effectively changed to 11, meaning that older authentication protocols will not work.

[kzimm888]

Your fix worked for us, and I want to add we were having this problem with ColdFusion 8.

[erics25041409]

Re. this setting:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Any idea what this might break? Oracle 12c is back-end for a mission-critical database; how likely is this change to cause a problem for other applications (e.g. Banner)?

[Guest]

I found this "amazing" solution here and it worked like a charm for me. It solves the problem on the Oracle side.

12c: USE_SID_AS_SERVICE_listener_name - ORACLE IN ACTION

It is sad that Adobe couldn't come up with an answer/(alternative) solution to this problem for such a long time - all those devoted CF users out there are feeling "abandoned"...