expdp, ora-1555, Query Duration = 0

By |2019-02-24T12:17:51+01: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+01: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.

What kind of Oracle Linux support on Oracle hardware is included

By |2018-09-15T11:44:32+01: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 […]

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

By |2018-08-24T09:39:13+01: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, Azure Cloud and licensing with hyperthreading enabled.

By |2018-01-25T13:42:31+01:00January 25th, 2018|Categories: Cloud, Database, licensing|Tags: , , |

Until recently, there was one rule when deploying Oracle software in the Azure cloud:

  • count one Azure CPU Core as equivalent to one Oracle Processor license.

But there was somehow what confusion about hyperthreading VM’s. This has been nuanced by Oracle in their cloud-licensing document very recently

Oracle Open World; day 4 – almost done

By |2017-10-05T20:43:38+01:00October 5th, 2017|Categories: Cloud, Database|Tags: , , |

Almost done. It’s not expected that tomorrow, thursday, will be a day full of new stuff, exciting news. Today, wednesday was a mix for me between ‘normal’ content like sessions about migrating to Oracle Enterprise 13.2 (another packed room) and a very interesting session about the Autonomous Database.  Just a […]

Oracle Open World; day 2 – highlights

By |2017-10-03T18:00:54+01:00October 3rd, 2017|Categories: Database|Tags: , |

 

At Monday Oracle Open World really starts. A whole lot of general sessions with announcements and strategic directions on product / service level. In this post I’ll try to summarize the highlights of this day. Quite hard, there are a whole lot of interesting sessions which overlap. Always the feeling […]

Oracle Open World 2017; day 1 observations

By |2017-10-02T16:46:58+01:00October 2nd, 2017|Categories: Cloud, Database, Uncategorized|Tags: , |

Just a quick note about day 1 at Oracle Open World. This Sunday traditionally is filled with presentations of usergroups, customers and product management, and at the end of the day the welcome-keynote. In the presentations there’s not really exciting news, they will have to wait until the keynotes. But […]

The day before OOW17; infra expectations

By |2017-10-01T12:22:28+01:00October 1st, 2017|Categories: Cloud, Database, Uncategorized|Tags: , |

Oracle Open World 2017 is starting tomorrow, and as a platinum partner of Oracle, we – AMIS Services – are obliged to keep us and our customers informed with the roadmap of Oracle products.

And of course translate this to added business-value for our customers.  In short: what to pick of […]

X