Issue OCI client doesn't fall back to user name/pass when sqlnet.authentication_services is set to all.
We need both kerberos5 and name/pass to work for different connection.
I see Bug 21962287, i tried setting SQLNET.KERBEROS5_CC_NAME, still same issue. I would like try the patch in windows, is it possible to get it?
Instant Client Version: 12.2.0.1.0
Client: jdk1.8.0_131 OCI driver
sqlnet config:
sqlnet.authentication_services=(ALL)
sqlnet.authentication_kerberos5_service=host
sqlnet.kerberos5_conf=c:\WINDOWS\krb5.ini
sqlnet.kerberos5_clockskew=6000
sqlnet.kerberos5_conf_mit=TRUE
DIAG_ADR_ENABLED=OFF
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
SQLNET.FALLBACK_AUTHENTICATION=true
TRACE_LEVEL_CLIENT=admin
TRACE_DIRECTORY_CLIENT=C:\oracle\product\trace
Error:
Exception in thread "main" java.sql.SQLException: ORA-12641: Authentication service failed to initialize
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1136)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1045)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:693)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:60)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.pimco.popcorn.oracle.TestConnection.main(TestConnection.java:20)
Attached is the trace file.