I like the concept behind the Oracle Enterprise Manager Hybrid Cloud Architecture to connect my on-premise OMS with targets in the Oracle cloud. The Agent communicates via SSH tunnel to target servers, no other ports than SSH 22 are open against the world wide web. An I was interested to find out, if the installation of such an agent works for other cloud providers than Oracle too. Create a Oracle Linux Instance in Amazon AWS I have created a small Oracle Linux instance in Amazon AWS and inserted the public IP into the /etc/hosts file of the Oracle Management Server. Why I have used an Oracle Linux? According the documentation, at the moment only Oracle Linux x86-64 is supported to…
Read MoreCategory: EM12c Cloud Control
Oracle 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 Enterprise Manager 12cR5 – Clone a PDB to the Oracle Cloud
Cloning an on-premise PDB to the Oracle Cloud is basically done in three steps. 1. Select your PDB – 2. Start Clone Menu – 3. Verify new PDB. In the basic clone menu, Oracle uses some default settings in the background, for example the source datafiles will be packed in a compressed file which is located in /tmp directory of the source server. When your /tmp directory is too small, the clone process fails. Why this directory is used? I don’t know. But it could be a problem when you clone bigger databases. Maybe we can edit the clone procedure, but this is a task for me for a day when it’s raining outside… All cloning steps are well monitored,…
Read MoreOracle Enterprise Manager 12cR5 – Let’s connect to the Oracle Cloud
Since EM12c Release 5 Oracle has integrated the connection to the Oracle cloud, databases can be monitored and handled very easy, on-premise databases and cloud databases are now managed in one tool. Adding a cloud database to an on-premise EM12c from cloud.oracle.com is very easy and done in a few steps: Create a SSH key Create a DBaaS instance on cloud.oracle.com Configure a local Linux agent as Hybrid Cloud Gateway Agent Create an EM12c credential for SSH login Install EM12c Agent via push method on the DBaaS machine Discover and add the new targets Enjoy A few documents are available how this setup has to be done. But the best way to get some experience is just to do it.…
Read More