Forum Stats

  • 3,752,188 Users
  • 2,250,468 Discussions
  • 7,867,747 Comments

Discussions

SQLNET.FALLBACK_AUTHENTICATION doesn't work in 12.2.0.1.0

3612363
3612363 Member Posts: 2
edited Jan 18, 2018 1:48PM in Oracle Call Interface (OCI)

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.

Tagged:

Answers

This discussion has been closed.