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

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