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

A short guide to networking in Virtual Box with Oracle Linux inside.

A short guide to networking in Virtual Box with Oracle Linux inside.

This post is intended to be a dummy guide, best practices, or whatever you call it…   about setting up a network while working with virtual boxes on a desk- or laptop. I was setting up a virtual box environment with several Virtual Boxes on my laptop, and as I’m not a network – specialist, I came across a few annoying things, challenges if you like.  And when I was googling around, it appeared to be I’m not the only one, so I felt the urge to share some experiences.

Already published this post on the amis-blog by the way, a long time ago. Decided to publish it also on my own blog.

What I want is the following environment and some elements smells like a subset of the real life:

1. Connect from my laptop to my virtual box through ssh and sqlplus, with fixed ip-address.

2. Simulate a private network, a network between the virtual boxes, also with fixed ip-addresses.

3. Occasionally connect to the internet from within the virtual boxes. To performs a ‘yum update’ and that kind of stuff.

 

(more…)

Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes

Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes

image.png 

This post has already been published in the past on the AMIS-blog.

To build an Oracle 12C RAC database – on Virtual Boxes – there’s at least shared storage needed for ASM, and a DNS-server for the SCAN-addresses. Several methods can be used for this, but  for the storage in my private project I chose Openfiler, an open source management storage tool, on a separate Virtual Box. It’s like a SAN in real life (the complete system will be three Virtual Boxes: two RAC-nodes and 1 storage Virtual Box). Version Openfiler: 2.99.

O.k. storage is clear, but what about DNS? The quickest and dirtiest way to accomplish this is to use Dnsmasq on every RAC-node. A nice blogpost about this subject is here to be found.

But what I want is a separate DNS-server, just as in real life. The perfect candidate is to use the separate Openfiler Virtual Box

(more…)

Licensing development and test environments

Licensing development and test environments

This post has already been published in the past on the AMIS technology blog.

Once in a while a company wants to know if her Oracle development- and test- environments needs to be licensed. And in a lot of cases this question simply can be answered as: yes, these environments must be licensed. The cases in which these licenses are not needed, are quite rare and a company should verify this with her Oracle representative or an intermediary.

(more…)

X