EM13c Cloud Control – Page 3

EM13c – Database Monitoring Template with DB Alert Log Metric

15. March 201615. March 2016

The new DB Alert Log metric Since the Oracle Enterprise Manager database plugin version 12.1.0.4, there is a new metric “DB Alert Log” available. This metric replaces the existing “Alert Log” metric. The benefit of the new plugin is if an ORA error is detected multiple times in the database alert log based on same error stack, it will be de-duplicated and only one metric alert is generated. Oracle’s recommendation is to replace this metric on the database targets – Changes to the Metric Alert Log Monitoring in Database Plug-in 12.1.0.4 and later (Doc ID 1587020.1). How to create such metrics and many more is very well described in Kellyn Pot’Vin blog post serie http://dbakevlar.com/2013/08/em12c-enterprise-monitoring-part-i/ The old metric Alert Log: The new metric DB…

Oracle Enterprise Manager 13c – Tail your Logfiles

8. February 20168. February 2016

This are my favorite aliases for Enterprise Manager 13c troubleshooting. Just replace $ORACLE_BASE with your own installation directory and add these aliases in your .profile/.bash_profile. Here is the URL to the Oracle documentation: http://docs.oracle.com/cd/E63000_01/EMADM/logging.htm#EMADM11796 – and feel free to create your own aliases e.g. for the *.OUT logfiles. Oracle Management Server alias taem=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log’ alias taeo=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log’ NodeManager alias tanm=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/nodemanager/nodemanager.log’ Weblogic AdminServer alias taad=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.log’ alias tagc=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/GCDomain.log’ Weblogic EMGC_OMS1 Managed Server alias taom=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.log’ Weblogic BIP Managed Server alias tabi=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/BIP.log’ OHS alias taha=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/ohs1/logs/access_log’ alias taho=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/ohs1/logs/ohs1.log’

Do you need a Mailserver for Testing Purposes? Communigate Pro!

4. February 2016

When I am testing Oracle and other software, I want to verify functions like sending alert mails. On Linux systems it’s easy. The most distributions have packages like sendmail already preconfigured and ready to use. But for example on Windows systems, there is no built-in solution. The goal was to have a small virtual machine running as mailserver which can be used for all my test cases. CommuniGate Pro CommuniGate Pro is a groupware which supports a lot of solutions like SMTP, POP3, Webmail and many more. In this post I describe how you can easy install the software and configure the SMTP component in Oracle Enterprise Linux 6. The goal is to use CommuniGate Pro for the Enterprise Manager…

Enterprise Manager 13c – Disable the BI Publisher

28. January 2016

The BI Publisher will be started automatically during the startup process of the Enterprise Manager 13c. You don’t like the BI Publisher or you don’t use it? Save the resources, speed up your startup process, disable it. The password of the database repository owner SYSMAN is required. Verify the Status – the BI Publisher is up and running [oracle@solothurn ~]$ export OMS_HOME=/u00/app/oracle/product/oms13cr1 [oracle@solothurn ~]$ $OMS_HOME/bin/emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server is Up Disable the BI Publisher [oracle@solothurn ~]$ $OMS_HOME/bin/emctl config oms -disable_bip Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright…

Enterprise Manager 13c – Change Memory Settings with emctl

18. January 201618. January 2016

In Enterprise Manager Grid Control 11g, changes in the Oracle Management Server JVM memory settings could be done in a file called startEMServer.sh located in a domain subdirectory like /u00/app/oracle/product/gc_inst/user_projects/domains/GCDomain/bin/. And after an OMS restart, the JVM has used this new settings for the OMS. Since 12c, it can be done by an emctl command. emctl – Get your actual Settings OMS_HEAP_MAX oracle@solothurn:~/ [oms13cr1] emctl get property -name OMS_HEAP_MAX Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. SYSMAN password: Value for property OMS_HEAP_MAX for oms local_oms is 1740M emctl – Change the Value For example, the Memory will be resized to 2304M. oracle@solothurn:~/ [oms13cr1] emctl set property -name OMS_HEAP_MAX -value 2304M Oracle Enterprise…