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!

List of all database instances, Oracle version and server from OEM repository

2706390Nov 3 2014 — edited Nov 3 2014

Hello!

We are using Oracle Cloud Control 12.1.0.2 for database management.

I am looking for a select that creates a list of all database instances, their Oracle version and the server they a located on.

Has anybody done this with SQL an is willing to share the statement with me?

If there is a solution with emcli i would be happy, too.

Regards

Andreas

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2014

Added on Nov 3 2014

3 comments

2,479 views