Adobe Community: Message List - No matching authentication protocol Oracle 12c

Re: No matching authentication protocol Oracle 12c

forums_noreply@adobe.com — Wed, 02 Jul 2014 18:36:54 GMT

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?

Re: No matching authentication protocol Oracle 12c

forums_noreply@adobe.com — Tue, 25 Mar 2014 05:30:03 GMT

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

Re: No matching authentication protocol Oracle 12c

forums_noreply@adobe.com — Mon, 24 Mar 2014 16:46:07 GMT

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)

No matching authentication protocol Oracle 12c

forums_noreply@adobe.com — Sat, 01 Feb 2014 18:15:33 GMT

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.