Hope you are doing well & enjoying my recent articles!!!
Recently I faced strange issue with one of my Database instance target on OEM. It was showing down status, though connection test was successful with no errors:
Target DB version: 19.8
OMS version: 220.127.116.11
OEM Agent version: 18.104.22.168
PFA screenshots explaining exact issue:
Even I tried removing & re-adding target without any success.
I thought of running few commands on agent side to get more information about the issue I was facing:
emctl config agent listtargets
Okay I can see my target.
emctl status agent target testdb.test.com,oracle_database
This confirms there is issue with my target.
emctl getmetric agent testdb.test.com,oracle_database,Response
Okay now I can see what is the issue. This is compatibility issue. My OEM agent is 22.214.171.124 & has difficulty in communicating with 19C DB target.
I added below 2 parameters in sqlnet.ora of my 19C DB Oracle home as a workaround, so it will allow OEM agent connection.
After adding this parameters, I was able to resolve the issue:
Now I can see my target is up on OEM OMS GUI too.
Hope u will find this post very useful.