Dear Readers,
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: 12.1.0.5
OEM Agent version: 12.1.0.5
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 12.1.0.5 & 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.
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
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.
Cheers
Regards,
Adityanath
Categories: 12c, 19c, Administration, automation, DB parameters, Feature, Installation, Monitoring, OEM, ORA errors, Oracle 18c, Scripts, Uncategorized, Upgrade
Adityanath's Oracle Blog 
Hi! This is my first visit to your blog! We are a group of volunteers and starting a new project in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!
Greetings from Carolina! I’m bored to death at work so I decided to browse your blog on my iphone during lunch break. I really like the info you present here and can’t wait to take a look when I get home. I’m shocked at how fast your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, superb blog!
Hello there, I found your website via Google while looking for a related topic, your web site came up, it looks great. I’ve bookmarked it in my google bookmarks.
Thank you for the auspicious writeup. It in reality was a leisure account it. Look advanced to more introduced agreeable from you! By the way, how can we keep in touch?
Hello there, I discovered your site by way of Google at the same time as looking for a similar subject, your site came up, it appears to be like good. I have bookmarked it in my google bookmarks.
You could certainly see your enthusiasm in the work you write. The world hopes for even more passionate writers like you who aren’t afraid to say how they believe. Always follow your heart.
This website online can be a walk-via for the entire information you wished about this and didn抰 know who to ask. Glimpse right here, and also you抣l definitely discover it.
Hello! I’m at work surfing around your blog from my new apple iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the excellent work!
I have read several good stuff here. Certainly worth bookmarking for revisiting. I wonder how much effort you put to create such a great informative site.