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.

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

[…]

Implementing ORAchk in Oracle Enterprise Manager 13c

By |2019-10-01T22:37:58+02:00February 3rd, 2016|Categories: Database, Meta-DBA|Tags: , , , |

Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate ORAchk, the healthcheck tool for databases, RAC and Engineered Systems.

This post is about downloading (and importing), deploying and provisioning the ORAchk-plugin. Spoiler-alert: there’s downtime involved of the OMS.

There are two […]

Oracle OpenWorld 2015 – a customer’s perspective

By |2016-02-03T08:49:54+01:00February 2nd, 2016|Categories: Architecture, Database|Tags: , , |

At the start of the each year, I always take the time to look back on the year we left behind. Last year, one of my most memorable experiences was Oracle OpenWorld in San Francisco. The event has always been an overwhelming experience, but this year it seemed even more so. […]

Oracle licenses and the cloud

By |2019-10-19T15:49:25+02:00March 15th, 2015|Categories: Database, licensing|Tags: , , , , , , , |

Suppose the number of Oracle licenses you acquired in the past, is in line with the use. That is, you’re compliant with all the licensing rules Oracle come up with. The  license form you use is the so called ‘Full use’ license, this is the most common license form. Everybody […]

My project with Dbvisit Standby – basics

By |2019-10-08T22:19:26+02:00March 31st, 2013|Categories: Database, Standby|Tags: , , , , |

A while ago I made a promise to take a look at the product Dbvisit, found out this is not the product, but just the firm Dbvisit. The product I’m about to install is called officially ‘Dbvisit Standby‘. There’s […]

ODA – a brief view on a virtualized platform

By |2019-10-12T17:51:37+02:00February 8th, 2013|Categories: Database|Tags: , , , , , |

Received a pdf from Oracle with the new features of the Oracle Database Appliance (when you are using the OracleVM-option).

Among other things, the two last sheets about the licensing had my attention too. I’m just showing the slides, haven’t worked with it, so I can’t tell you in detail the […]

How many NUP’s you really need when using Oracle Database SE?

By |2019-09-29T17:24:13+02:00December 14th, 2012|Categories: licensing|Tags: , |

Something about licensing. Boring for the most of us, but this may save you a lot of money…. The next is not completely new, but I never had it on writing, so found it worthy to blog.  The following has by the way no legal status and I’m not held responsible […]

Processes and startup-sequences in 11.2

By |2019-09-29T19:19:30+02:00September 29th, 2011|Categories: Database, RAC|Tags: , , , , |

Remember the old days. You had just a few processes to watch. Something has changed along the way. A lot of processes should be running on your database system (with infrastructure), but how are they connected to eachother and what is the startup sequence ? Or.. what processes I can kill without any other proces starting it up... :-)