Today, I read the blog of Uwe Hesse about multiple dbverify sessions accessing one large datafile in parallel. I had some doubts if running multiple dbverify in parallel can significantly speed up the verification process but it looked like a good idea to me, so I decided to write a perl script to fetch size of the datafile, then spawn dbverify processes according to the desired parallelism.

Here’s the test result:

Read More

Oracle ACE, Asif Momen’s first book is released from Packt Publishing: Oracle Database XE 11gR2 Jump Start Guide. As you know, Oracle Database XE is a free version of the Oracle RDBMS. Oracle XE is limited to only use one CPU on a system; use up to 1GB of RAM; store up to 11G of user data. These limitations shouldn’t make you think that Oracle Database XE is not good for production. It’s a great product for small applications and can be upgraded to other Oracle versions if needed.

In his book, Asif Momen guides you how to install and use Oracle XE and explains fundamentals of Oracle Databases and Oracle Application Express.

Read More

As you may know, EM12c BP1 was released for Solaris about 3 weeks ago. Our EM12c runs on Solaris, so I decided to apply it to our production system. To apply BP1 to EM12c environment, first we need to apply BP1 (and additional 1-2 patches) to OMS (Oracle Management Service), then apply some patches to deployed agents, and lastly, upgrade EM12c plug-ins (some of them may require additional patches to be applied to OMS). As you may guess, it’s not a piece of cake. Oracle recommends you to analyze how much effort you need to re-configure and re-deploy agents, and if it’s feasible, uninstall the existing Cloud Control and do a fresh installation.

These instructions are only valid (and tested) for EM12c running gon Solaris 10 (SPARC). You may need additional patches for Linux or AIX. My OMS is located in “/u03/oracle/Middleware/oms/”. My repository DB is “emrep” and located in a server named “erciyes”. Before I start to apply the patch, I stop all services by issuing the following command:

Important: Before you apply Bundle Patch 1, Oracle recommends to back up all EM components:

• Management Repository Database (Highly Recommended!)
• Middleware Home and EM domain
• Instance Home where OMS is installed
• Default Management Agent with OMS
• Software Library
• Oracle Inventory

Read More

At last, OEM 12c Bundle Patch 1 is available for Solaris and AIX! We installed our OEM Cloud Control 12c on a Sparc server, and I was waiting this bundle patch about 4 months. I’ll apply it as soon as possible because all actual plug-ins require this must-have bundle patch. Of course, I’ll blog about the patching process. After applying patch, I’m planning to test Management Connector for CA Service Desk and I’ll also blog about it.

OEM Base Platform Patch Number is 13242773.

As you may know, if you do a fresh install, you don’t need to apply this patch, because installation packages include BP1.

Here is the link for OEM 12c with BP1 for Solaris SPARC:

http://www.oracle.com/technetwork/oem/grid-control/downloads/solsoft-094433.html

Yesterday, I was at TROUG DBA SIG event. I organized the event and I’m very satisfied with the result. Bilginc IT Academy were our hosts. The conference place and the audience were all good. We established a good contact with the audience, and all the sessions were very interactive. People did not hesitate to ask questions during the presentations, it’s not usual in Turkey

We planned that Zekeriya Besiroglu (President of TROUG) would speak at the event, unfortunately he was sick and couldn’t speak. So I made the keynote speech, and I think It was too long! I spoke for 2 hours non-stop

After my “double” session, Kamil Turkyilmaz spoke about partitioning best practices. Specially test results impressed people, and they surely get the benefits of composite partitioning and partition-wise joining.

Read More