Skip to main content
A
Anonymous
February 1, 2014
Question

No matching authentication protocol Oracle 12c

  • February 1, 2014
  • 3 replies
  • 11908 views

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.

This topic has been closed for replies.

3 replies

A
Anonymous
August 26, 2015

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"...

A
Anonymous
July 15, 2015

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
    kzimm888
    Participant
    August 18, 2015

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

    R
    Runrocket
    Participant
    March 24, 2014

    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)

    A
    Anonymous
    March 25, 2014

    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

    K
    kurttt
    Participating Frequently
    July 2, 2014

    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?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices