expdp, ora-1555, Query Duration = 0

By |2019-05-12T13:38:49+02:00March 2nd, 2019|Categories: Database|Tags: , , |

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.

ORA-600 [kdsgrp1] Opening a Cursor On a Table

By |2019-02-23T20:20:36+02:00February 28th, 2019|Categories: Database|Tags: , , |

Customer got the following internal error message : ORA-600 [kdsgrp1] SQL> analyze table OPS$DWHPOPR_TEST.DWH_EURTABLE validate structure online; ERROR at line 1: ORA-01498: block check failure - see trace file.

Questions when considering an ULA (Unlimited License Agreement)

By |2019-03-02T12:38:33+02:00February 26th, 2019|Categories: licensing|Tags: , , , , , |

Oracle is eager to offer companies a ULA, an Unlimited License Agreement, especially at the end of the financial year. If these companies are considering an ULA, this company obviously met the criteria : a large company with Oracle products in their roadmap, and anticipating a […]

Spatial: license-incompliancy while using Oracle Locator ?

By |2019-05-12T13:11:04+02:00February 23rd, 2019|Categories: licensing|Tags: , , , , |

As you may know, the use of Oracle Locator is free of charge, while Spatial is an option in Oracle Enterprise Edition which have to be paid for.

Spatial has more functionality though. But when using Locator functionality and Oracle LMS (License Management Services) comes around running their scripts, there may […]

Oracle Linux on virtualized ODA : paying support per VM ?

By |2019-05-12T13:14:53+02:00February 3rd, 2019|Categories: ODA|Tags: , , , |

A customer asked this question about Oracle Linux support. When Oracle Linux installed on OracleVM, on an ODA: is this support per VM, or per physical server (in this case the ODA-node). Could be quite a difference in paying and getting support.

[…]

What kind of Oracle Linux support on Oracle hardware is included

By |2019-05-30T11:31:46+02:00September 15th, 2018|Categories: Database, licensing, Uncategorized|Tags: , , |

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 […]

The bare minimum of licensing an ODA X7-2

By |2019-05-30T11:34:37+02:00August 31st, 2018|Categories: ODA, Uncategorized|Tags: , , , , , |

The other day we had a discussion about the question if you can buy an Oracle Database Appliance X7-2 HA when you only have 1 socket license Oracle SE. The licensing rules can be interpreted different by some. Disregarding the question why you would buy an ODA HA if you […]

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

By |2019-05-12T14:08:41+02:00June 27th, 2018|Categories: Cloud, Database|Tags: |

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….

[…]

Oracle’s extended support – when is it free of charge

By |2019-06-02T11:31:38+02:00June 19th, 2018|Categories: licensing|Tags: , , |

It’s such a simple, basic and old question I got from a colleague: “Do you have to pay for extended support?”.  And if so, how much I have to pay for it. So basic and yet… always have to check again  the waived support, what prices and where to find […]