oracle 12c 禁用tfa,orabbix连接Oracle 12c错误ORA-28040: No matching authentication protocol

使用orabbix监控oracle12c出错，查看log[root@testdb1 logs]# tail orabbix.log

2020-01-17 16:16:52,216 [main] INFO Orabbix - maxIdleSize=1

2020-01-17 16:16:52,216 [main] INFO Orabbix - maxIdleTime=1800000ms

2020-01-17 16:16:52,216 [main] INFO Orabbix - poolTimeout=100

2020-01-17 16:16:52,217 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1

2020-01-17 16:16:52,217 [main] INFO Orabbix - numTestsPerEvictionRun=3

2020-01-17 16:16:52,481 [main] ERROR Orabbix - Error on Configurator for database TESTDB1 -->ORA-28040: No matching authentication protocol

2020-01-17 16:16:52,482 [main] INFO Orabbix - This Database TESTDB1 removed

2020-01-17 16:16:52,482 [main] ERROR Orabbix - ERROR on main - Connections is empty

主要原因是 jdk版本 和 oracle 12C不兼容[root@testdb1 inventory]# find / -name ojdbc*

/root/orabbix4zabbix4-master/orabbix/lib/ojdbc6.jar

/var/lib/docker/overlay2/549c3ff4588a6e47c4b18cb1832eb7d21dde1fb9a39c5ee2a1f6ccf079753f2f/diff/opt/orabbix/lib/ojdbc6.jar

/tmp/database/stage/ext/jlib/ojdbc8.jar

/tmp/OraInstall2020-01-15_09-06-02AM/ext/jlib/ojdbc8.jar

/opt/orabbix/lib/ojdbc6.jar

/u01/app/oracle/product/12.2.0/dbhome_1/inventory/Scripts/ext/jlib/ojdbc8.jar

/u01/app/oracle/product/12.2.0/dbhome_1/inventory/backup/2020-01-15_09-06-29AM/Scripts/ext/jlib/ojdbc8.jar

/u01/app/oracle/product/12.2.0/dbhome_1/dmu/jlib/ojdbc6.jar

/u01/app/oracle/product/12.2.0/dbhome_1/jdbc/lib/ojdbc8dms_g.jar

/u01/app/oracle/product/12.2.0/dbhome_1/jdbc/lib/ojdbc8dms.jar

/u01/app/oracle/product/12.2.0/dbhome_1/jdbc/lib/ojdbc8_g.jar

/u01/app/oracle/product/12.2.0/dbhome_1/jdbc/lib/ojdbc8.jar

/u01/app/oracle/product/12.2.0/dbhome_1/md/property_graph/lib/ojdbc7.jar

/u01/app/oracle/product/12.2.0/dbhome_1/sqldeveloper/jdbc/lib/ojdbc7.jar

/u01/app/oracle/product/12.2.0/dbhome_1/sqldeveloper/sqlcl/lib/ojdbc7.jar

/u01/app/oracle/product/12.2.0/dbhome_1/suptools/tfa/release/tfa_home/jlib/ojdbc5.jar

查看ojdbc6.jar[root@testdb1 inventory]# ll /u01/app/oracle/product/12.2.0/dbhome_1/dmu/jlib/ojdbc6.jar -h

-rw-r--r-- 1 oracle oinstall 3.6M Jun 2 2016 /u01/app/oracle/product/12.2.0/dbhome_1/dmu/jlib/ojdbc6.jar

原来orabbix的ojdbc.jar才2.3m[root@testdb1 inventory]# cp /u01/app/oracle/product/12.2.0/dbhome_1/dmu/jlib/ojdbc6.jar /opt/orabbix4zabbix4-master/orabbix/lib/ojdbc6.jar

cp: overwrite ‘/opt/orabbix4zabbix4-master/orabbix/lib/ojdbc6.jar’? y

重新buid下orabbix[root@testdb1 orabbix4zabbix4-master]# sh build.sh

ok，重新运行orabbix问题解决[root@testdb1 orabbix]# tail -f logs/orabbix.log

2020-01-17 16:37:08,978 [main] INFO Orabbix - Connected as SYSTEM

2020-01-17 16:37:08,985 [main] INFO Orabbix - --------- on Database -> ORCLPDB

2020-01-17 16:37:09,611 [pool-1-thread-1] WARN Orabbix - Error while executing ->dbversion- on database