New EMCLI Verbs in Enterprise Manager 12c R4 (

Today I see Ray Smith’s blog post about EM CLI Verb Changes. He provided a quick list of several new and deprecated EMCLI verbs in Enterprise Manager 12c R4. Pete Sharman commented on the blog post and said there are missing verbs. Ray said he made the list based on Oracle Documentation. So I decided to make another list based on EMCLI HELP output. Here’s the list of new EMCLI verbs:

Upgrading Enterprise Manager Cloud Control to

Enterprise Manager Cloud Control is released yesterday, and I have downloaded it immediately to upgrade our system. It was a very smooth process. The version of our Enterprise Manager was Enterprise Manager is compatible with agents, so total downtime was about 30 minutes (of course it depends on your hardware). I upgraded our system using “one system upgrade” option (more...)

Enterprise Manager 12c: Be Careful About Naming DB Systems

Yesterday, we added a development database to our EM12c system. About 15 minutes later, the incident management flooded us with alert mails about newly added database. Unfortunately its SID was same with our production DB, and when adding the database, my colleague didn’t change its name and accepted the defaults. I was out of office when I got those mails, after a short panic, I called my colleague to check the situation and she said (more...)

Oracle Enterprise Manager Cloud Control 12c Plugin for PostgreSQL

In my company, we use PostgreSQL, Postgres Plus (a commercial fork of PostgreSQL provided by EnterpriseDB) beside Oracle databases. Unfortunately different databases need different tools to monitor, and implementing a standard monitoring procedure for all databases becomes a real problem. Good thing is Oracle Enterprise Manager is an extendable software supporting 3rd party plugins, and there are companies like Blue Medora which focuses on the product enhancements for Enterprise Manager. Blue Medora released a plugin (more...)

EMDIAG Repvfy Kit for Oracle Enterprise Manager Cloud Control 12c

EMDIAG Repvfy is a tool which is designed to collect data from a Cloud Control Management Repository to assist in the diagnosis and optimization of EM12c. It’s mentioned on “Oracle Enterprise Manager 12c Configuration Best Practices (Doc ID 1553342.1)”, and you can find the required information on Doc ID 1426973.1, to download, install and run EMDIAG Repvfy. Yesterday, I installed it for our EM12c system, and I got some errors while running it. (more...)

A Short Script to List Mappings of ASM Disks to Physical Devices

I got a warning mail from our Enterprise Manager Cloud Control, it says “Disk Device emcpowere1 is 98.468% busy.”. I logged into the server to see the busy disk. There were no related mount point points so it should be used by ASM, but because we use ASMLIB, I needed to query each ASM disk to see which physical device it’s mapped to.

If you have a few disks, it won’t take time (more...)

TROUG DBA/Developer SIG 2014

This is a late post (sorry for all Turkish Oracle Users waiting for the presentations) about TROUG DBA/Developer SIG 2014. We successfully organized a hybrid SIG meeting on February 13th, but I could find time to write a blog post about it till today. My company (Innova) hosted the meeting, I would like to thank my manager for his support. There were 5 presentations, and all of them were in Turkish. I made a presentation (more...)

Finding And Deleting Old Files (on Unix and Windows)

I needed to write short scripts to delete old files on a Windows Server. It’s a very easy task on UNIX flavors but the limited capacity of Windows command line made me worried. You can use a simple “find” command to find old files on UNIX. For example, the following command will be enough to find and delete files older than 7 days:

find /folder/ -type f -mtime +7 -exec rm {} +

For the (more...)

Tips And Tricks For Installing Oracle Internet Directory

One of our customer needed to integrate OID with Siebel, and they asked me to install OID on a test server. I probably encountered all possibly errors during the installation but completed it successfully. Here are some tips for the ones who’re planning to install OID:

  • Use JRockit instead of regular Java. Install it before you install Weblogic. So Weblogic will detect and use it.
  • Make sure that you have enough RAM (and swap). Weblogic (more...)

Book Review: Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c

Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c I try to read and review all books about Enterprise Manager Cloud Control 12c (EM12c). The last one I read is, “Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c”. As you can understand from the name, the book focuses mainly on how you can build and manage IaaS and DBaaS using EM12c and it is about only 110 pages. The author, Ved Antani works as Technical Director with Electronic Arts. While (more...)