Metric Extensions allows extending monitoring for a target type by adding new metrics. These Metric Extensions (ME) can also be any OS commands to enhance OS monitoring.Depending on security requirements this feature can be a risk. Especially if the Enterprise Manager is managed by other department or i.e. outside your organization. Note: Oracle does not … EM13c – Block the usage of Metric Extensions for specific target type only weiterlesen
Oracle Database Appliance – Change DNS-Server
Change the DNS-Server on a ODA as Day2-Action after the deployment of the Appliance is easy. Change the /etc/resolv.conf and the job is done. Really? No, not really, but almost. The ILOM and the repository database of the ODA contains the settings of DNS-Server(s) too , so you have to adapt them too. Change DNS-Server … Oracle Database Appliance – Change DNS-Server weiterlesen
EM13c – MOS Connection with Proxy
Setup Proxy-Configuration with 3rd-Party Certificates on OEM to connect to MyOracleSupport (MOS)
EM13c – Backup OEM by Script
Based on the cool blog-post about Advanced Backup strategies for Oracle Enterprise Manager written by Robert Crames, I wrote a small script to export some target independent configurations which may be needed or helpful in the case of a recovery or migration to a new Enterprise Manager setup. The setup is quite simple. Create the … EM13c – Backup OEM by Script weiterlesen
Monitoring ASR-Gateway with Oracle Enterprise Manager CloudControl 13c
Introduction Oracle have a nice small tool called ASR-Gateway (Oracle Auto Service Request) which (as the name already says) opens automatically a Service Request at Oracle (support.oracle.com) if a hardware component fails on a Engineered System like ExaData or PCA (and the others too 🙂 ). In a customer project, this ASR-Gateway failed sometimes or … Monitoring ASR-Gateway with Oracle Enterprise Manager CloudControl 13c weiterlesen
EM13c – Install (13.3) EM-Agent manually
Introduction To deploy the EM-Agent to the targets (push) you need ssh-access from the OMS-Host to the Monitoring-Host. For security reasons, some security admins disallow ssh-connections to the server. In this case you need to install the EM-Agent manually on the target-system. The installation process for the EM-Agent is done within a few steps. Downloading … EM13c – Install (13.3) EM-Agent manually weiterlesen
Gather historic information about table size and row count
Often the support need to know which tables are growing fast and which are stable. Out of the Box, Oracle don't provide such a statistic on object level. Classic monitoring tools collect this information only on the database-, tablespace- and datafile-level, but not on object level. A small script helps you to answer this question … Gather historic information about table size and row count weiterlesen
X11-Forwarding with Magic-Cookie
Problem X11-Redirection to users desktop is quite simple. But if you switch the user in the ssh-session for security-reasons you have to deal with the Magic-Cookie. Solution with Magic-Cookie This command creates two files in the temp-Directory that are run with the other user
EM13c – Setup LDAP-Authentication
Allgemein Durch das Setup der LDAP-Authentifizierung ist es möglich, AD-User im Active Directory zu integrieren. Dies hat den Vorteil, dass sich der Enterprise Manager resp. der DBA nicht um die Passwörter kümmern muss. Die klassischen Repository-Accounts können natürlich weiterhin verwendet und auch neue hinzugefügt werden. Weiterführende Informationen sind unter folgendem Link zu finden: https://docs.oracle.com/cd/E73210_01/EMSEC/GUID-5DD3B11A-1159-40BD-8AEB-41EDE664AB12.htm#EMSEC13008 Konfiguration … EM13c – Setup LDAP-Authentication weiterlesen
EM13c – Bulk create Named Credentials
Sollen diverse NCs erstellt werden (z.b bei einer Migration auf ein neues OMS) ist das einzelne Erstellen von NCs ein mühsamer Prozess.Dazu gibt es die Möglichkeit via emcli NCs zu erstellen. In Kombination mit einem SQL-Statement können so sehr viele NCs auf einmal erstellt werden. Das Script kann beliebig oft ausgeführt werden, es werden nur … EM13c – Bulk create Named Credentials weiterlesen
