content top

How to Upgrade Sybase IQ 16 to 16.0.10 (SP10)

Sybase-IQ-Box-300x314Yesterday, I did my first Sybase IQ upgrade. I upgraded our main datawarehouse from Sybase IQ 16 to 16 SP10. The process was easy: Stop the database instance, install the new software, start the instance (from new software home), run an SQL to upgrade the metadata. Although the process was easy, I had some unexpected problems so I wanted to my notes in case you may need to upgrade your Sybase IQ.

You have probably heard it a thousand times but here I’ll say it again: Read the manual! Then open a ticket (or call) to Sybase support and ask questions about upgrading process. The process is very easy but it’s not documented well. Maybe I feel like this because I’m used to read Oracle’s word-class manuals. I’m serious. Oracle provides best manuals compared to the other Database vendors.

Second mandatory warning: Before you start to upgrade operation, make sure you have a valid backup of database.

Make sure that your license file is compatible with the software version you’ll install. You may need to generate an uptodate SySAM License! You can also contact Sybase suport and ask them to send you a compatible license file.

Read More

How to Download EM12c R5 Installation Files Using Wget

Although EM12c R5 ( was released about 2.5 months ago, I couldn’t find time to upgrade our EM12c system until now. I have decided to dedicate my day for upgrading our EM12c. I’m not planning to write a step by step document because it’s already documented well by other bloggers. I’ll just share my notes if I encounter any problem.

I have probably told several times that EM12c should have some internet access, at least, it should be able to reach My Oracle Support website. Luckily, our server has direct-access to the internet (not accepting any incoming connection requests), so I’ll download the installation files directly to the server. Because I like tricky things, I’ll use “wget” instead of an internet browser. I got a sample wget script from Oracle Support Website to download patches, and then modified it to download EM12c files. The script may be helpful if you’re planning to install EM12c to a remote server which you do not have X windows access.

Read More

Monitoring MongoDB using Oracle Enterprise Manager Cloud Control

Scott Wardrop from AIDEV told me that they produced a plugin for Oracle Enterprise Manager Cloud Control 12c to monitor MongoDB. We use MongoDB in our production systems, so I decided to examine the plugin and write a blog post about it. Unfortunately version of our MongoDB databases are too old (2.4.x series) so the plugin didn’t work. Of course, it didn’t stop me. We created a simple MongoDB Cluster environment to test the MongoDB plugin for EM12c.

Becasue the installation is well documented by the vendor, I will not give a step by step installation guide. You can find the installation document on the download page. By the way, you need to manually download and deploy the plugin using EMCLI. Before you start deployment, send an email to for the unlock password (of the zip file). After you receive the password, download the latest plugin zip file, unzip it and run EMCLI:

After the installation is done, you need to deploy it to the OMS, and to the agents running on MongoDB servers.


Before you add the MongoDB targets using “Add Targets Declaratively by Specifying Target Monitoring Properties”, you also need to make some preparation on target MongoDB database and server. First you need to create a “monitoring” user. Login to target MongoDB database and run the following scripts:

Read More

If EMD_MAINTENANCE.DISABLE_EM_DBMS_JOBS Hangs When Deconfiguring Plug-In from Management Repository

Today, I tried to remove a plugin from Management Server but I see that undeployment process was hung at step 5:

I connected to Management Repository and see if there’s any waiting process. Unfortunately there was nothing. So I started to examine “active” processes of SYS user. You may know that EM12c uses SYS user when deploying or undeploying agent software. I found a process working for minutes, trying to complete the following commmand:

Read More

Oracle Enterprise Manager Cloud Control 12c Release 5 ( is Ready to Download

Enterprise Manager Cloud Control 12c Release 5 is avaliable to download. The new release is designed to monitor and manage both your on-premise and Oracle Cloud deployments which is called “Hybrid Cloud” by Oracle. You can deploy Management Agents onto the Oracle Cloud virtual hosts to manage Oracle Cloud targets just as you would any other targets. EM12c R5 also supports data cloning between on-premise and Oracle Cloud. Integration with Oracle Enterprise Manager Ops Center will help dynamic on-demand resource provisioning.

I’m planning to upgrade our EM12c Release 4 to Release 5 in a couple of days, and discover the new features. Maybe I may write a couple of blog posts about upgrading or installing the new release.


As you may know, EM12c R5 was announced a couple of days ago, so I was regularly checking the download page, and noticed that EM12c never gets old, it is always NEW :)

Page 1 of 3412345...Last »
content top