EM13c: Performance Tuning Access to Read Only Administrators

About six months ago, when I was in the OUGN Spring Conference, someone asked me how they can let developers access to performance tuning pages on Enterprise Manager Cloud Control 13c. He said that they granted full administrator privileges to the developers so they could access the performance page but it’s not acceptable. He also mentioned that they didn’t need to grant full administration privilege to the developers’ EM users while they were using (more...)

How to Import Data (to Oracle RDBMS) from XML

I wrote a blog post about how to import data from a XML file to Oracle about 7 years ago. I demonstrated how we can use DBMS_XMLSTORE package to parse XML data. Yesterday, I replied a question from a blog reader about that post. He had problem with running my sample script, I did troubleshoot and find out the problem with his script, and while testing the sample script, I noticed that I can write (more...)

Book Review: Oracle Database Cloud Cookbook with Oracle Enterprise Manager Cloud Control 13c

13cCoverLatest Last week, I had a chance to read the latest book of my friend Porus Homi Havewala. If you’re interested in Oracle Enterprise Manager, you already knew him or at least read one of his articles/blog posts. He’s a Subject Matter Expert (SME) on Oracle Enterprise Manager Technology, Oracle Certified Master (OCM) and Oracle ACE Director. Porus created one of the world’s first blogs dedicated to Enterprise Manager (http://enterprise-manager.blogspot.com), and he (more...)

Oracle Enterprise Manager Plugin for PostgreSQL

Oracle Enterprise Manager supports 3rd party plugins which can help you to extend its monitoring and manageability capabilities. There are already developers and companies specialized in plugin development. Blue Medora is one of them (and probably the most famous one). In this blog post, I’ll show you how we can use Blue Medora’s EM PostgreSQL plugin, which is part of their True Visibility Suite for Oracle. I’ll download and deploy the plugin on the OMS (more...)

Installing EM13c Agents on Microsoft Windows Target Hosts

If your EM13c OMS installed on Unix-based OS, and want to deploy agents to Windows servers, you need to install Cygwin to target windows server to use regular deployment process. You can also use PsExec utility but in this case, you need a Microsoft Windows staging server. Installing Cygwin to enable SSH on Windows may sound like an unnecessarily complex solution at first, but Cygwin is easy to install and it comes with lots of (more...)

How to Modify the Retention Time for Metric Data in EM13c

Some Enterprise Manager customers, complain about the high volume of data stored in OMS repository. Enterprise Manager agents collect metric data of targets they monitor, and upload these “raw” metric data to OMS. Depending on your metric collection periods and number of targets, the volume required to keep these data can be very huge. Enterprise Manager has already a mechanism to minimize the size of the Management Repository. Once a day, the previous day’s metric (more...)

BGOUG Spring Conference 2016 & Twitter Statistics

As I already mentioned in my previous blog post, I attended the BGOUG (Bulgarian Oracle User Group) Spring Conference last week. It was my second time to attend BGOUG conferences, and as usual, it was a great organization. I’m really impressed how Milena Gerova and BGOUG Conference Team can organize such a successful event.

presenting

At the conference, I gave two speeches, one was “Linux Essential Commands for DBAs”, and the other one was “Oracle Enterprise (more...)

Reading Data From Oracle Data Files (without Connecting Database)

I attended the BGOUG Spring Conference last week as a speaker. While in BGOUG Conference, I had a chance to listen Kamil Stawiarski’s session about hacking Oracle. Kamil spoke about potential security issues of high level privileges such as create any index and create directory. At the end of the session, he also showed a tool written by himself. The tool (I do not remember its name right now), reads a datafile, searches for object (more...)

OUGF Harmony 2016 Spring Conference Twitter Statistics

If you didn’t come this page from my review about the OUGF Harmony16 Spring Conference, please don’t forget to read it. This post is generated almost automatically by scripts to share the twitter statistics of the conference. The statistics cover the period between May 17 and May 20. I included three hashtags (#OUGF, #OUGF16, #Harmony16), because at the beginning of the conference, people (including me) did not used the official hashtag (#Harmony16).

openning


#Harmony16 Tweets

(more...)

OUGF Harmony 16 Spring Conference

Last week I took part in the OUGF (Oracle User Group Finland) Harmony 16 Spring Conference. It was a two day event, and held in Helsinki, between May 18th and 19th. In the conference, I gave two speeches: “Essential Linux commands for DBAs” and “Enterprise Manager 13c for DBAs”. Most people expect to me to speak about Enterprise Manager but in my first session, I spoke about the tools which can be used for monitoring (more...)