Tag: oem

Query Management Pack Acess from OMR in Enterprise Manager 13c

~ Antoine ~ Leave a comment

Like most of Oracle’s products, Enterprise Manager comes with options that are enabled by default, but licensed when used. In order to prevent these options from being used and to avoid having to pay the corresponding license fee, your company may ask you to list the status of these options on a regular basis.

On Oracle Enterprise Manager, these options are called “Management Packs” :

  • Oracle Cloud Management Pack for Oracle Database
  • Oracle Cloud Management Pack for Oracle Fusion Middleware
  • Application Replay Pack
  • Management Pack for Oracle Coherence
  • Database Diagnostics Pack
  • Oracle Database Lifecycle Management Pack
  • Oracle Data Masking and Subsetting Pack
  • Database Tuning Pack
  • Configuration Management Pack for Applications
  • WLS Management Pack EE

Recently, my client asked me to automate the collection of the status of these management packs. The information is easily retrievable from the Enterprise Manager console (Setup=>Management Packs=>Management Pack Access), but there is no possibility to export the list to Microsoft Excel for example, which is not practical to include in a reporting.

After some research, I developed a query that extracts this information from the OMR database in CSV format.

Continue reading “Query Management Pack Acess from OMR in Enterprise Manager 13c” →

Force metric collection in Oracle Enterprise Manager

~ Antoine ~ Leave a comment

When working on the implementation of monitoring via Oracle Enterprise Manager, it is sometimes necessary to perform several tests with different thresholds in order to refine alerting, or simply to verify that the monitoring is working properly.

The main problem is that you have to wait until the collection is done to see the result. Since most metrics have a “Collection Schedule” of more than 5 minutes, this can quickly become a waste of time.

To avoid this wait, it is possible to force the collection of a particular metric for a target directly from the EM agent.

Continue reading “Force metric collection in Oracle Enterprise Manager” →

Error “platform=${platform/\)/%29}: bad substitution” when installing an Enterprise Manager Agent with AgentPull method on AIX

~ Antoine ~ Leave a comment

Today, I have been asked to deploy several Oracle Enterprise Manager agents on AIX 7.1 servers.
For this type of request, I have a preference for the “AgentPull” method when I don’t have a suitable Gold Image available.
Unfortunately, it seems that the “AgentPull” script does not work properly on AIX machines because when executing it, I got the following error: “platform=${platform/)/%29}: bad substitution“.

Continue reading “Error “platform=${platform/\)/%29}: bad substitution” when installing an Enterprise Manager Agent with AgentPull method on AIX” →

Install EM13c agent and add targets using the Linux command line only

~ Antoine ~ 2 Comments

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!

Continue reading “Install EM13c agent and add targets using the Linux command line only” →

Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository

~ Antoine ~ 12 Comments

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.

Continue reading “Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository” →