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.”
A few days ago, I was asked to find a way to automate the addition of newly created Linux virtual machines and databases in our EM13c console. Of course, no action should be performed via the EM web interface!
For the first part (installing the EM13c agent on newly created virtual machines), it’s quite simple, because Oracle gives you many methods (for example, “agent pull” method), in order to carry out this task. But the second part seemed more delicate according to the documentation and my constraints: everything must be done on the virtual machine. I am not allowed to connect to the EM server using SSH.
Fortunately, there is a simple solution that only requires a few extra lines in your shell script!
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.