DevTech101

DevTech101

Monitoring

OEM 13c and Oracle Database Patch Errors

One of the requirements for upgrading to Enterprise Manager Cloud Control 13c Release 2, is to apply. Database patch set update 160419 While trying to apply the patch to Oracle GI + DB, it will error out with non existing files (more below…). opatchauto apply 22899531 System initialization log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2016-10-06_02-29-43PM.log. Session log file …

OEM 13c and Oracle Database Patch Errors Read More »

Integrating Oracle Ops Center Alert Notifications With Nagios

Contents 1 This document address how to disable nagios notification’s with Ops Center 1.1 Nagios notification overview 1.2 Nagios notifications 1.2.1 Methods to disable Nagios notifications remotely 1.2.2 Center and Nagios 1.2.2.1 Ops Center configuration 1.3 Scripts used to disable/enable Nagios 1.4 Example to enable/disable nagios with curl This document address how to disable nagios …

Integrating Oracle Ops Center Alert Notifications With Nagios Read More »

Oracle Enterprise Manager, ASM Tips and Tricks

Contents 1 To set system password 2 EM Cloud control help 3 EM cloud control process order 4 How to deploy a plugin 5 References To set system password ALTER USER system IDENTIFIED BY password; EM Cloud control help #To stop Oracle Management Service GUI only emctl stop oms # To stop all services emctl …

Oracle Enterprise Manager, ASM Tips and Tricks Read More »

Oracle Ops Center ZFS, Device fail-over Scripts

Contents 1 Ops Center scripts 1.1 Script to keep ZFS datatset while zone failover 1.1.1 Create the directory 1.1.2 Add the below script 1.2 Script to keep a device while zone failover 1.2.1 Create the directory Ops Center scripts Script to keep ZFS datatset while zone failover The below steps will keep a zone ZFS …

Oracle Ops Center ZFS, Device fail-over Scripts Read More »

Oracle Ops Center ASR Blacklist Bug Workaround

How to clear / blacklist an ASR entry in Ops Center Workaround for a bug if the serial number start with a “0” SQL> DELETE FROM asr_activation WHERE serial_number = ‘0929FM104E’; SQL> INSERT INTO asr_activation (serial_number,request_status,asr_status_cached,create_dtt) VALUES (‘0929FM104E’,’blacklisted’,’blacklisted’,sysdate); SQL> SELECT * FROM asr_activation WHERE SERIAL_NUMBER LIKE ‘0929FM104E’; You might also like this. Oracle Ops Center …

Oracle Ops Center ASR Blacklist Bug Workaround Read More »

Enterprise Manager Deleting Targets Manually With CLI

Enterprise Manager deleting a target manually First stop the agent. ./emctl stop agent Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Stopping agent … stopped. emcli login -username=sysman emcli sync emcli delete_target -name=”em-host.domain.com:3872″ -type=”oracle_emd” -delete_monitored_targets Now Uninstall the agent export ORACLE_HOME=export ORACLE_HOME=/u01/app/agent/core/12.1.0.2.0 $ORACLE_HOME/oui/bin/runInstaller -deinstall -removeallfiles # …

Enterprise Manager Deleting Targets Manually With CLI Read More »

Oracle Enterprise Manager 13c with Oracle DB Configuration Modifications

How to increase Oracle Database log size alter database add logfile size 600m; alter database drop logfile group 1; select l.group# , l.bytes , l.status , l.archived , lf.member from v$logfile lf , v$log l where lf.group# = l.group#; alter system switch logfile; alter system checkpoint; alter database drop logfile group [ active log]; Change …

Oracle Enterprise Manager 13c with Oracle DB Configuration Modifications Read More »

Enterprise Manager Cloud Control 12c startup issues

At startup first log directory /u01/app/oracle/gc_inst-r5/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.log After that log directory /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/ Note: By setting memory to low, like below OMS will hang and never complete startup emctl set property -name ‘JAVA_EM_MEM_ARGS’ -value ‘-Xms256m -Xmx1740m’ How to increase the memory on EM 12c https://community.oracle.com/community/support/support-blogs/enterprise-manager-support-blog/blog/2015/01/20/how-to-tune-the-jvm-heap-memory-arguments-for-12c-oms-and-agent