0 ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot…
Browsing: Oracle
Everything that is Oracle related.
0 Configuring Oracle Traffic Director 12c with WebGate
At a recent customer install, I was faced with configuring Oracle Traffic Director (OTD) 12.2.1.2.0 Webgate with Oracle Access Manager.…
0 Golden Gate 12c and DIY Sequence Replication with PL/SQL
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by…
1 Better track the Usage of Database Options and Management Packs, or it will cost you
So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious…
0 Change UUIDs in VirtualBox
If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to…
1 Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to…
3 DIY Parallelization with Oracle DBMS_DATAPUMP
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In…
0 How About Oracle Database 12c Threaded_Execution
THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting…
0 Oracle 12c STIG Password Generator in PL/SQL
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find…
0 Oracle Compute Cloud – Uploading My Image – Part one
Recently (October 2016) I had the opportunity to attend an Oracle Compute Cloud workshop that was very interesting. As a…
0 The Oracle Public Cloud – work in progress
Building up a public cloud is quite a challenge. Oracle has faced and overcome many challenges – and it has…
0 Spark with a K – how Apache Spark is omnipresent at Oracle OpenWorld 2016
Apache Spark made numerous appearances in many different sessions during Oracle OpenWorld 2016. It is clear that Oracle is very…
1 One of the many nice new features in 12c database: code based access control
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it.…
0 Virtual columns
Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT…
1 Virtual Private Database…
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem.…
0 How to create a private 10 Gb network on an ODA X5-2
In my previous post Network considerations on an ODA X5-2 I described a solution where I created a private network…
0 Network considerations on an ODA X5-2
When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times…
0 Application deployment to Oracle Java Cloud instance using XL Deploy on AWS EC2
This article is about experimenting configuration, connection and deployment from one cloud instance to the other using the basic installation, connections…
0 Continuous Delivery and the Oracle database (III)
In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In…
2 Continuous Delivery and the Oracle database (II)
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In…