Category: ODA

The other day we had a discussion with Oracle sales about the question if you can buy an Oracle Database Appliance (ODA) X7-2 HA when you only have 1 …

In this post I will explain how to create your own ACFS file system (on the command line) that you can use to (temporarily) store data. So you have …

ODA X5-2 simplifies and speeds up the creation of a 12c database quite considerably with oakcli. You can take advantage of this command by also using it in the …

One of the great advantages of the Oracle database Appliance HA is the possibility of Virtualization through OracleVM. This virtualization wasn’t possible for the other members of the Oracle …

While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the …

At a recent customer install, I was faced with configuring Oracle Traffic Director (OTD) 12.2.1.2.0 Webgate with Oracle Access Manager. Deploying Webgate on OD 12c is very well described …

Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target …

Since the birth of the ODA X6-2 HA, the net usable storage has become more of a challenge when advising a customer as the X5-2 HA had substantial more …

This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to the query and the generated filename the Dump_Delimited function …

Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 …

THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most …

Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to …

A while ago I published an article about the ODA X6-2S and X6-2M, the new entry level machines for small business. And since then Oracle introduced the ODA X6-2L …

I admit, I’m a bit of a fan of the Oracle Database Appliance. And I also admit there are some characteristics of the X5-2 ODA’s which made it sometimes …

In my previous post Network considerations on an ODA X5-2 I described a solution where I created a private network to optimize network performance between the components running on …

When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times 10Gb copper Ethernet (bonded into two interfaces) for public …

Oracle introduced the ODA X6-2S and ODA X6-2M. And no, they are not the successor of the quite popular ODA X5-2, which we installed and configured quite a number …

Since Oracle launched the Oracle Database Appliance a few years ago it has become clear that only the Enterprise Edition is allowed on the machine. But when NOT using …