This error may occur when you try to re-apply the patch 9239090 (EBS 12.1.3), because the mth_pre_upgrade.sql tries to create a table named “MTH.MTH_RESOURCES_D_TEMP” without checking if it exists. All you need is to drop that table and restart the worker. Connect your database as sys/system, and issue the command:

Then run adctrl, enter 2 (Tell worker to restart a failed job), and then enter the number of the failed worked. ADPatch will continue to apply the patch.

Managing unstructured data in a relational database system is one of the least know subjects. There is a large amount of unstructured data in the real world and a relational database designed to store data in a structured format but most database administrators and architectures do not have enough knowledge to handle unstructured Data. Marcelle Kratochvil’s book, “Managing Multimedia and Unstructured Data in the Oracle Database” aims to give a solid understanding of basic concepts involving unstructured data (specially multimedia).

The book is designed for technology architects and database administrators. Kratochvil plans to write another book which will will focus on developers and storage architects.

First chapter covers key concepts, later chapters cover technical details for database administrators.

Read More

I’m pleased to announce that we have teamed up with Packt Publishing and are organizing a give away especially for you. All you need to do is just comment below this post and win a free copy of Oracle Enterprise Manager 12c Administration Cookbook (which I have already reviewed). Three lucky winners stand a chance to win an e-copy of the book.

Overview of Oracle Enterprise Manager 12c Administration Cookbook eBook:

• Recipes for installing, configuring, and getting up and running with Oracle Enterprise Manager
• Set up automatic discovery, create and clone databases, and perform provisioning
• Monitor Oracle Fusion Middleware, and remotely use incident and problem management using iPad/iPhone

How to Enter?
Simply post your expectations from this book in comments section. You could be one of the 3 lucky participants to win the e-copy.

Read More

After I installed Ubuntu to my Laptop, I began to install my favorite applications. Everything went smooth. One of my favorite application is VirtualBox. I’m big fan of it, and I use it on both Windows and Linux systems. All of my virtual machines are created on VirtualBox. So I installed VirtualBox, copied a virtual machine from my backup storage and just before run the virtual machine, I remembered that I need to set up IP address of the host-only network. I opened the network tab in VirtualBox settings and I couldn’t see any Host-Only networks (there should be one in default). So I clicked to “Add Host-Only Network” button and got a strange error:

I haven’t seen this error before. I have checked if “/dev/vboxnetctl” exists, and unfortunately it doesn’t. It’s obvious that the “vboxnetctl” file should be a part of VirtualBox software but it wasn’t there. One of the good thing of VirtualBox is, you can do everything using command line. So I tried to add host-only network using command line, and this time I see “a warning message” before the error:

Read More

Oracle Enterprise Manager is getting highly popular so we see more and more books about it. Recently, Packt published a new book titled “Oracle Enterprise Manager 12c Administration Cookbook“. It is a well-written book which provides over 50 practical recipes to install, configure, upgrade Oracle Enterprise Manager Cloud Control and monitor your Oracle setup using Oracle Enterprise Manager.

The authors of the book (Dhananjay Papde, Tushar Nath and Vipul Patel) are experienced on Oracle Fusion Middleware, so you’ll also be able to find the integration of Oracle Fusion Middleware products such as Oracle Business Intelligence, Oracle GoldenGate, Oracle Business Intelligence Publisher and Oracle WebLogic. The book also covers recipes on Incident and Problem Management using iPhone or iPad, and there are recipes for creating and cloning databases and creating templates.

Read More