Your need You have a continuous stream of messages that arrive massively in your exchange flows, and you want some messages (answering certain criteria) can be pushed together so that to be sent grouped to a target application and/or in a specific order. Your basic architecture is as follows: Example Imagine you have a steady stream of thousands […]
Oracle Transparent Data Encryption 12c Concepts and Overview Based on Database Advanced Security Guide – Oracle 12c Documentation Oracle Transparent Data Encryption (TDE) enables the organizations to encrypt sensitive application data on storage media completely transparent to the application. TDE addresses encryption requirements associated with public and private privacy and security regulations such as PCI […]
The data source control operations are useful in situations such as when an Oracle RAC node is down or during a database maintenance window: The Shrink operation closes the idle connections of the pool, freeing the database connections and resources in use. It reduces the opened connections until the greater value is between the minimum capacity parameter and the in-use […]
If having a data guard solution makes us confident with a straightforward backup solution in case of failure of the primary, it is required in the counterpart to make sure primary and standby databases are well-synchronized. And it may happen that, in some events like network failure, the standby lags far behind the primary. Depending […]
Recently I had to face a high OLTP workload with RAC. This workload was a massive insert with high concurrency in one table. When used RAC, the performance drops down because of the concurrency management needed to maintain index : this creates a lot of roundtrips between the inserting nodes to agree which one should […]
This article presents one of many configurations available for deploying Oracle Real Application Clusters (RAC) on the Amazon Web Service Elastic Compute Cloud (AWS EC2). The following procedure relies on the AWS Command Line Interface (CLI). You can run the AWS CLI on your desktop, such as a PC, Mac or Linux machine. Although all […]
SQL Developer is still on his way, growing every day ! It’s last free release is now 4.1.2 dated October 24th 2015. You can read what is the new stuff here, but today we speak about licensing compatibility. What’s happen when you use it against your Standard Enterprise Database ? Does it trig or not […]
When hurriedly using a set of silent database creation scripts on 11gR2 I stumbled several times across an error where dbca was failing after about 15s, and had not even started copying files. The log files in $ORACLE_BASE/cfgtoollogs/dbca/<my_db> all contained: [crayon-5b7934bf1c290201206756/] Various posts on the web were suggesting a problem in the tnsnames.ora file which […]
There a quite a few new changes in OEL 7 (and its twins CentOS7, RHEL7, etc.), one of them is the default filesystem is now xfs instead of ext4. Well, I’d just got used to the latter, and in comes xfs, which you cannot shrink????
With Oracle’s « Preinstallation RPM » you can easily prepare Oracle Database 12c and 11g installations on Oracle Linux. But these RPMs will not work unless you’re working with a « UEK kernel ». The article below shows a tip to use this RPM on a « Redhat Kernel » anyway.