Enterprise Manager 13c – How to apply p23095307: enterprise manager for oms plugins 13.1.1.0.160429

Patch 23095307 is the newest system patch for the Enterprise Manager 13c family. This patch will be applied with the new patch tool OMSPatcher (see blog post http://dbakevlar.com/2016/05/em13c-applying-system-patches-with-the-oms-patcher from @dbakevlar for details). To apply this patch, the OMS has to be stopped. Prerequisites OMS 13.1.0.0.0 OMSPatcher 13.6.0.0.1 – I have installed it in directory /u00/app/oracle/product/em13cr1/OMSPatcher URL / Username / Password from your EM13c Weblogic AdminServer (emctl status oms -details) Patch 23095307 is unzipped and available in a local directory, in…

Read More

EM13c – Database Monitoring Template with DB Alert Log Metric

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…

Read More

Houston – we have deleted all SYS DBMS_SCHEDULER Jobs !

Bad, bad PL/SQL…. A customer of me has executed a simple script to cleanup DBMS_SCHEDULER jobs and programs for an application. Unfortunately he did as user SYS. The content of the SQL script: BEGIN FOR JOB IN (SELECT * FROM USER_SCHEDULER_JOBS) LOOP DBMS_SCHEDULER.DROP_JOB(JOB_NAME => JOB.JOB_NAME, FORCE => TRUE); END LOOP; FOR PROG in (select * from USER_SCHEDULER_PROGRAMS) LOOP DBMS_SCHEDULER.DROP_PROGRAM(PROGRAM_NAME => PROG.PROGRAM_NAME, FORCE => TRUE); END LOOP; END; / All the Oracle internal maintenance jobs and programs like the AUTO_SPACE_ADVISOR_PROG, GATHER_STATS_PROG,…

Read More

Oracle Enterprise Manager 13c – Tail your Logfiles

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…

Read More

Enterprise Manager 13c – Disable the BI Publisher

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…

Read More