Category: Engineered Systems
Earlier this month, Oracle announced the availability of the latest Exadata machine, the X8-2. As well as the option to swap in big 14 TB disks in older versions …
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 …
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 …
So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes down from management: “Are we using any …
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 …
Harry Dragstra
January 24, 2017
AMIS, Cyber Security, Database, Databases, DBA Oracle, DevOps, Engineered Systems, ExaData, ODA, Oracle, Oracle 12, PL/SQL, SQL
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 …
In addition to offering infrastructure services from the cloud, Oracle continues to extend its line of engineered systems. The high end consists of SuperCluster and Exadata, ExaLogic and Exalytics …
A brief headsup for everyone responsible for maintaining kernel options in the oracle executable. The environment where I discovered this is a 3 node racattack cluster with Oracle GI …
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 …
On 21 January 2015, Oracle announced Exadata X5, the sixth revision of Oracle’s database management system (DBMS) engineered system. The entire Exadata configuration no longer needs to be licensed …
When Oracle Exalogic is delivered in you data center and you implemented Exalogic as a virtual platform, the Exalogic Guest Base Template (EGBT) is based on Oracle Linux 5.8. …
The first major keynote of this year’s Oracle Open World conference was last night – Larry Ellison announcing the Oracle Exalogic machine, the “cloud in a box”. A high …
So, if I would wonder what is the purpose of this almost “hidden” feature called flash cache and were this came from (also see my post “Permanent Link to …
![DIY Parallelization with Oracle DBMS_DATAPUMP]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "DIY Parallelization with Oracle DBMS_DATAPUMP")
