Oracle licenses needed while monitoring your (non-)Oracle environment with OEM

Oracle licenses needed while monitoring your (non-)Oracle environment with OEM

With Oracle Enterprise Manager (OEM) you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server.

You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM. How to monitor this heterogeneous environment. What licenses do you for monitoring? And.. do you need Oracle licenses when sending notifications by mail? Hold on to this thought.

(more…)

expdp, ora-1555, Query Duration = 0

expdp, ora-1555, Query Duration = 0

During a migration of a database, a remote export/import procedure (through database-link) fails intermittently. Some tables are skipped during export, with the familiair ‘ORA-0155’ error. Snapshot too old. Procedure hasn’t changed. What’s going on, besides the obvious reasons for an ORA-0155. Database version changed from 10.2.0.4 to 11.2.0.4.

(more…)

What kind of Oracle Linux support on Oracle hardware is included

What kind of Oracle Linux support on Oracle hardware is included

When you buy an Oracle Database Appliance – any type – or just a X-server (e.g. X7-2), you get free support for OracleVM, Oracle Solaris and Oracle Linux. But Oracle Linux has different flavours , like basic, premier and premier limited. What kind of support do you get when buying hardware from Oracle? Can Ksplice be used? Found out it’s documented, but not in the way I lwould ike it to see.

(more…)

ORA-31626, (Database-pump)-job does not exist

ORA-31626, (Database-pump)-job does not exist

Found out a scheduled export- and import job was broken. Error:  ORA-31626: job does not exist. After checking the scheduled jobs I realized that it’s not the scheduled job, but the datapump-job. And it’s all related to being cost-effective in the cloud….

(more…)

X