Unable to create a DSN to an Oracle 12.1c database

Description

Trying to create a DSN to an Oracle 12c database (version 12.1.0.2.0) using the Oracle 12.1c thin client, but getting an Oracle authentication error (ORA-28040: No matching authentication protocol). That seems to be associated with it using a lower allowed login version than the database is using (although it should work if they are both 12c). What version authentication is Lucee attempting and is there any place where it could be modified (or will the 12.2c driver resolve the issue)?

Activity

Show:
Allen Weng
December 7, 2017, 9:08 PM
Edited

Hi, I saw https://github.com/lucee/extension-jdbc-oracle.. is that possible you can consider to put that one line change in Oracle.cfc we describe in
https://luceeserver.atlassian.net/browse/LDEV-1498
https://luceeserver.atlassian.net/browse/LDEV-868

Update that file in this folder lucee-server\context\context\admin\dbdriver\ to be

originally it is

(change the last colon to be a slash, I have to manually modify this to run my Oracle db after installing Lucee 5)
which will make Oracle 12c pluggable database happy, and it will also work with Oracle 11g

Assignee

Unassigned

Reporter

Brien Louque

Labels

None

Affects versions

Priority

New