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

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

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