Oracle 9i/10g Client 透過odbc連12c DB 無法連線 ORA-28040 no matching authentication protocol

Oracle 9i/10g Client 透過odbc連12c DB 無法連線 ORA-28040 no matching authentication protocol

 

 

解決方法

 

@DB Server(Windows)

echo SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 >> %oracle_home%\network\admin\sqlnet.ora

echo SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 >> %oracle_home%\network\admin\sqlnet.ora

echo SQLNET.ALLOWED_LOGON_VERSION=8 >> %oracle_home%\network\admin\sqlnet.ora

 

@DB Server(Linux)

echo "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" >> $ORACLE_HOME/network/admin/sqlnet.ora

echo "SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8" >> $ORACLE_HOME/network/admin/sqlnet.ora

echo "SQLNET.ALLOWED_LOGON_VERSION=8" >> $ORACLE_HOME/network/admin/sqlnet.ora

 

 

ref:

https://community.oracle.com/thread/4010944