OraNA :: Oracle News Aggregator

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, (more...)

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 (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). (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 (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 (more...)

Our customer asked if they can automatically upload latest RMAN backups via FTP to another server. Because they keep latest 3 backups in same directory, I wrote a small bash script which calls an SQL script to queries RMAN backups and then uploads only the backup pieces belong to the (more...)

One of my friend told me that they used to have Oracle Enterprise Manager Grid Control 10g and deployed its agents to some database servers but now they removed Grid Control and want to use Oracle Enterprise Manager Database Console. Usually people ask the opposite question

Anyway, in this blog (more...)

In case, your target systems have no support for SSH, you can use agentDeploy script to deploy Management Agents. To be able to use this method, you need to create a user for management agent and create required directories and give permission to the Management agent user.

Let’s say we’ll (more...)

If you prefer RPM package management system to keep tracks of installed software on your systems, you can deploy Oracle Management Agent using RPM File.

First, you need to create “/usr/lib/oracle” on OMS server (if there is no such a directory). Login as root user and run the following commands:

 (more...)

Some readers commented that, after they add JDBC driver for Microsoft SQL Server to their SQL Developer, the “New Connection” window (of SQL Developer) doesn’t open at all. I have downloaded the latest Java (1.6), SQL Developer and added jTDS driver then I have the same problem. I tried (more...)