In my current work environment, I often have to switch from one OEM console to another. In order to quickly identify which console I’m going to connect to, and to make sure I don’t make a mistake by confusing production and non-production, I discovered a trick that allows me to add a banner on the login page.Continue reading “Add a banner on Oracle Enterprise Manager login page.”
Today, I’m going to share with you a simple SQL query that will allow you to quickly extract useful information from your OEM repository about your databases:
- Database name
- Database version
- Server name
- Server OS
- OS version
The query can be very useful if you need to fill in a new CMDB for example.