Resolved: OEM DB target is showing down status though connection test is successful.

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

9 replies

  1. 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!

  2. 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!

  3. 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.

  4. 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.

  5. 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.

  6. 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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s