To omem
J. Laurindo Chiappa, February 09, 2018 - 3:20 pm UTC
Nope : confirming the note, even a 10gR2 client (with the lats patchset) don´t work :
C:\Users\Chiappa>sqlplus system/oracle@desenv12cr2
SQL*Plus: Release 10.2.0.5.0 - Production on Sex Fev 9 13:12:06 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-28040: Nenhum protocolo de autenticaçăo correspondente
Informe o nome do usuário:
C:\Users\Chiappa>
==> But a modern client works ok :
E:\>sqlplus system/oracle@desenv12c
SQL*Plus: Release 12.2.0.1.0 Production on Sex Fev 9 13:11:45 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-28002: a senha expirará dentro de 7 dias
Horário do último log-in bem-sucedido: Seg Out 16 2017 17:24:39 -02:00
Conectado a:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SYSTEM:@desenv12cr2:SQL>
Regards,
Chiappa
Obs : please don´t care about the non-English error and login messages...
February 10, 2018 - 12:05 am UTC
Thanks for the doing the test. I don't have any 10g clients any more :-)
Previous answer for 12.2
David Penington, February 13, 2018 - 12:43 am UTC
February 13, 2018 - 1:13 am UTC
Nice input - I'd forgotten about that.
To David : reasons appear to exist
Jos� Laurindo Chiappa, February 16, 2018 - 2:25 pm UTC
Hi, David : yes, in some cases we can workaround connection issues caused by old clients with this setting, but (for example) in my case (OS=Windows 2012, client 10.2.0.5 without any additional CPU/PSU) it don´t work :
=> in the server :
C:\app\oracle\product\12.2.0\dbhome_12cR2\network\admin>type sqlnet.ora
# sqlnet.ora Network Configuration File: C:\app\oracle\product\12.2.0\dbhome_12cR2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
C:\app\oracle\product\12.2.0\dbhome_12cR2\network\admin>
=> in the client machine :
C:\Users\Chiappa>tnsping desenv12cR2
TNS Ping Utility for 64-bit Windows: Version 10.2.0.5.0 - Production on 16-FEV-2018 12:08:11
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Arquivos de parâmetros usados:
C:\app\Chiappa\product\10g\client\network\admin\sqlnet.ora
Usado o adaptador TNSNAMES para resolver o apelido
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.yyyy.zz.nnn)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = desenv12cr2)))
OK (30 ms)
C:\Users\Chiappa>sqlplus system/oracle@desenv12cr2
SQL*Plus: Release 10.2.0.5.0 - Production on Sex Fev 16 12:08:15 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-28040: Nenhum protocolo de autenticaçăo correspondente
Informe o nome do usuário:
C:\Users\Chiappa>sqlplus system/oracle@desenv12cr2
SQL*Plus: Release 10.2.0.5.0 - Production on Sex Fev 16 12:09:19 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-28040: Nenhum protocolo de autenticaçăo correspondente
Informe o nome do usuário:
ERROR:
ORA-12560: TNS:erro de adaptador de protocolo
Informe o nome do usuário:
==> So, this time Support appears to be right : the combination 10gR2 client x 12cR2 database is something a little 'not so stable', the guys were right forbidding the thing in that Note ....
With this, the answer to Omem is the only possible - if he wants to be sure, do not try this at Prod...
Regards,
J. Laurindo Chiappa