content top

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 EM12c.

Unfortunately I forgot to examine the situation until I saw a similar question on OTN (Oracle Community) forum on Friday. The forum reader has exactly the same problem. The database user was already granted required privileges but the EM administrator see the menu items related with “performance tools” are grayed out.

Read 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 much better script.

This is my sample XML (employees.xml):

I created a table to load the data and a directory link so we can access the file:

Read 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 is the author of the books, “Oracle Enterprise Manager Grid Control (published by Rampart)” and “Oracle Enterprise Manager Cloud Control 12c: Managing Data Centre Chaos (published by PACKT)”.

His latest book also focus about Oracle Enterprise Manager and titled as “Oracle Database Cloud Cookbook with Oracle Enterprise Manager Cloud Control 13c“. It’s a cookbook so the readers will get fast recipes to build your Hybrid Database Cloud using EM13c.

The book has 382 pages and there are 8 chapters:

1) Consolidation Planning for the Cloud: This chapter focuses on two tools offered by the Enterprise Manager: The Host Consolidation Planner and the Database Consolidation Workbench. In this chapter, you’ll see sample usage of both tools.

Read 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 (management servers), then deploy the plugin on the agent(s) and at the end, I’ll add a PostgreSQL target to our Enterprise Manager system.

The PosgteSQL plugin is not available on Self-Update, so we need to download and register it manually to our Enterprise Manager. To download the trial version of the plugin, I go to their website, click “download trial”, and fill a form to request trial version. Blue Medora will see our form and send us an email with download link of the plugin. After I download the zip file to my OMS server (ie into the temp folder), I issue the following commands:

postgres1

Read 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 useful utilities. So It’s worth installing. In this blog, I’ll show how to deploy EM agent on Microsoft Windows target. I’ll download and install Cygwin to the target server, enable SSH service and create user for SSH. After these steps, I’ll use Enterprise Manager Add Host page to deploy Enterprise Manager agent to the target Windows server like it’s just another Linux host.

First login to the target Windows server with administrator user and download Cygwin from https://www.cygwin.com/install.html. Depending on your CPU architecture (is there any one still using 32bit?) you need to download setup-x86.exe or setup-x86_64.exe from the installation page. These are very small executables, and they will download the required packages from the internet.

cygwin2

When you run the setup-x86_64.exe, you see the welcome screen. You click NEXT to choose a download source. If your target server has no internet access, you can install packages from a local directory. That means, you can use the packages downloaded by another Cygwin installation on another server. All you need is to use a shared location or copy files from other server which is already Cygwin installed. Click NEXT to continue.

cygwin3

Read More
Page 1 of 3912345...Last »
content top