Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEM queries against remote targets 13c - how to ?

User_F9TF2Apr 13 2018 — edited Apr 17 2018

I wish to run queries against data dictionary on remote database targets. Mainly for healthcheck of parameters/configuration that are not covered in OEM repository.

In old versions we used to use target_user_table_from_sql approach

However this note says no longer will work in 13c.

So ...... how can we do this in 13c - basically run 3-4 custom queries against remote taregt databases and have the results sent in a report/email.

EM 12c, EM 13c: Enterprise Manager Cloud Control - How to Create a SQL-Based Metric Extension (Doc ID 1455942.1)

"Previous workarounds which created the "target_user_table_from _sql" as a report, were not supported and no longer work in EM.'

This post has been answered by Ian Baugaard on Apr 17 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2018

Added on Apr 13 2018

4 comments

2,581 views