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…
Read MoreCategory: Oracle Tools
Enterprise Manager 13c – Change Memory Settings with emctl
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…
Read MoreOracle Enterprise Manager 13c – KILL SESSION for Application Administrators – Part 1
Basically to execute a ALTER SYSTEM KILL SESSION command you have to be a) a DBA or b) you need the ALTER SYSTEM privilege. Granting the ALTER SYSTEM privilege to a Non-DBA has big risks. This user is now able to change a lot of parameters like memory parameters, NLS settings etc. In one of my projects, a small team of well known application administrators is having a read-only account in Enterprise Manager 12c to verify the performance, see the user sessions and many more of their subset of databases. And sometimes, they have to kill a hanging Oracle session. Until now they called the DBA: “Please do it for me”. Sure, we can build a small PL/SQL procedure on every database…
Read MoreEM12c Agent – java.lang.OutOfMemoryError: Java heap space
After an AIX 7.1 server reboot, there was one agent which did not started. The command emctl start agent resulted in a java.lang.OutOfMemoryError: Java heap space message. In the agent subdirectory some dumpfiles were created: -rw-r—– 1 oracle dba 291373 Oct 19 11:00 javacore.20151019.110002.14876844.0002.txt -rw-r—– 1 oracle dba 22182281 Oct 19 11:00 heapdump.20151019.110002.14876844.0001.phd -rw-r–r– 1 oracle dba 167408 Oct 19 11:00 Snap.20151019.110002.14876844.0003.trc First I took a look in the agent logfiles to gather more information. /u00/app/oracle/product/agent12c/agent_inst/sysman/log/emdctlj.log 2015-10-19 10:59:11,711 [1:F7DA781F:main-16449708] INFO – EmdCtl Timezone = Europe/Zurich 2015-10-19 10:59:11,884 [1:F288756D:main-11600120] INFO – EmdCtl Timezone = Europe/Zurich 2015-10-19 10:59:13,584 [1:2CF29A0A] INFO – Disconnecting: client terminus 2015-10-19 10:59:13,585 [1:2CF29A0A] INFO – stdout: Status agent Failure:unable to connect to http server at https://srvaix111.mvn.ch:3874/emd/lifecycle/main/. [peer not aut henticated]…
Read MoreOracle 12c – Zwei Minuten bis “Connected to an idle instance.”
Ausgangslage Eine neue 12c Installation auf einer AIX 6.1 LPAR Auftrag Upgrade einer bestehenden 11.2.0.4 Datenbank mit der “Out-of-Place” Variante auf 12.1.0.2 Die Installation der 12.1.0.2 RDBMS-Software lief sauber durch SQL*Plus bleibt hängen Nach der Installation der 12c Software habe ich auf dem Server versuchsweise die Variable ORACLE_HOME auf das neu erstellte Verzeichnis gesetzt, um rudimentär SQL*Plus zu testen. ORACLE_SID wurde auf einen Dummy-Wert gesetzt damit die Meldung “Connected to an idle instance” angezeigt werden sollte. Doch wie heisst es immer so schön: Erstens kommt es anders, zweitens als man denkt! oracle@solothurn:~/ [rdbms12102] sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 14 12:45:57 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Nach ungefähr 2 Minuten kam…
Read More