星期五, 7月 28, 2017

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

Oracle 9i/10g Client 透過odbc12c 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

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...