Does anyone out there in ToadWorld have a clue as to where I should be looking in the OEM 12c repository database to find out the following:
- a list of targets of type Database or Host;
- a list of the named credentials for the above;
- a list of the preferred credentials for the above.
I am not interested in decrypting the passwords, I’m not interested in the passwords, I already have access to the vault we store them in, I am trying to come up with a simple way of determining which, if any, of our target databases and hosts do not have named and/or preferred credentials defined in OEM.
I’m not an OEM expert by any means, so be gentle with me. Thanks.
I have had a look on Google etc. I have looked at the various tables in the SYSMAN schema and the MGMT$ views and the Oracle Docs, but while I get some way towards what I need, I can’t get all the way.