SQLNET.AUTHENTICATION_SERVICES =(NONE, NTS)

[Former Member]

Hello Oracle experts,

is it possible to use "mixed authentication" method within Oracle 12 on Windows.

We tryied to set SQLNET.AUTHENTICATION_SERVICES =(NONE, NTS).

The problem is that the NTS authentication does not work after this change.

Any ideas?

Thank you!

[JamesZ]

Hi Alex,

Can you please let me know how do you think it is not working?

Because I do not think there is any change on behavior of

SQLNET.AUTHENTICATION_SERVICES in 12c

Best regards,
James

[Former Member]

Hello James,

I mean if I change SQLNET.AUTHENTICATION_SERVICES from (NTS) to (NONE, NTS) and restart the Listener,

the commando "sqlplus / as sysdba" does not work anymore. It seams that the combination (NONE, NTS) does not work in outr case.

Thank you!

[JamesZ]

Hi Alex,

Did you restart the listener? Or even did you try to reconnect listener again?

Best regards,
James

[Former Member]

Hello James,

we restarted Listener via service.msc.

The question is:

does Oracle 12c support this kind of  mixed authentication within SAP environment (NONE, NTS)?

Thank you!

[JamesZ]

Hi Alex,

It should support, please check oracle online help:

http://docs.oracle.com/database/121/DBSEG/asoauth.htm#DBSEG9766

at section "Configuring Multiple Authentication Methods".

Best regards,
James

[Former Member]

Hello James,

in our case it is unfortunately does not work.
The documentation link provided by you also does not describe the combination of (NONE, NTS).
There are only authentications methods like Kerberos, SSL and RADIUS will be mentioned.