ST_Wong
Feb 11, 2020Cirrus
Oracle monitor SQL encryption
Hi,
We're running BIG-IP 14.1.0.5. We tried to monitor a Oracle 18c database but keeps getting following error:
2020-02-11 05:27:33,972 [DBPinger-50] - Attempting DB connection, attempt # 3
2020-02-11 05:27:34,017 [DBPinger-50] - DB DriverManager.getConnection failed
2020-02-11 05:27:34,017 [DBPinger-50] - SQL Exception:
java.sql.SQLException: ORA-28040: No matching authentication protocol
Since the DB has SQLnet encryption enabled in sqlnet.ora:
sqlnet.encryption_client=required
sqlnet.encryption_types_client=(AES256)
sqlnet.crypto_checksum_client=requested
sqlnet.crypto_checksum_types_client=(SHA512)
Will this be the cause of problem, and how to resolve it?
Thanks a lot.