Working on Enterprise Manager 22.214.171.124 version at a client’s site, we would like to know if oracle database target in 18c version could be discovered and monitored, even if Enterprise Manager 126.96.36.199 does not support Oracle 18c database targets.
Installing the agent 12c on the target host did not cause any problem, the oracle database 18c discovery ran successfully, but the database was seen as down in the Enterprise Manager 188.8.131.52 console.
We tried several tricks without any positive results, but running the following command shows us that this was a connection problem:
[email protected]:/home/oracle/:> emctl getmetric agent DB18,oracle_database,Response Oracle Enterprise Manager Cloud Control 12c Release 4 Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved. Status,State,oraerr,Archiver,DatabaseStatus,ActiveState0,UNKNOWN, Failed to connect: java.sql.SQLException: ORA-28040: No matching authentication protocol,UNKNOWN,UNKNOWN,UNKNOWN With Oracle 18c, the default value for SQLNET.ALLOWED_LOGON_VERSION parameter is 12, it means that database clients using pre-12c jdbc thin drivers cannot authenticate to 18c database servers.
The workaround is to add in the database server sqlnet.ora the following lines:
We restart the database and the agent, and the Oracle database 18c is displayed up and running in Enterprise Manager 184.108.40.206:
Some more tests showed us that everything is working fine: incident management, performance, top activity ..aso
Nevertheless do not forget that oracle database target version 18c are not supported with Enterprise Manager 220.127.116.11. I will recommand to use the last Enterprise Manager 13.3 last version in order to administer and monitor Oracle database 18c.