Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, 22.214.171.124 is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have 126.96.36.199 included in it. But I am sure that it’s coming soon!
So grab your copy now and happy downloads :=).
Replicating data can be a time consuming process to setup. Fortunately, Oracle GoldenGate provide a few tools to help ease the complexity of setup. One of these tools is the “macro”. Macros are used to simplify and automate the work associated with setting up and replicating data. So what exactly is a macro? Oracle defines a macro as:
A macro is a built-in automation tool that enables you to call a stored set of processing (more...)
Yesterday, Oracle released a new critical patch update (CPU Jul 2014) for July 2014. This CPU contains fixes for 5 database vulnerabilities. The most critical one, CVE-2013-3751, has a base score of 9.0 and affects Oracle 12.1 only. The same issue was already fixed for Oracle 11.2 in July 2013 (CPU Jul 2013).
After a short research on the web (google and twitter, less than 5 minutes) I found an (more...)
However when I went to start things up, ASM wasn't starting up, giving me these errors:
ORA-04031: unable to allocate 32 bytes of shared (more...)
I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back.
- Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1)
I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and views respectively.
A week ago, Oracle released Oracle SOA Suite 12c. In this blog I will show how easy it is to create a Standalone-server environment for Oracle Event Processing (OEP) 12c.
The major new features of Oracle Event Processing 12 are the new integrated development environment based on Jdeveloper and the Event Delivery Network (EDN) event adapter nodes which provide that tight integration at runtime to SOA Suite composites and all other SOA components supporting the (more...)
A week ago, Oracle released Oracle SOA Suite 12c. In this blog I will show how easy it is to create a SOA Suite development environment.
The Oracle SOA Suite 12c Quick Start distributions allow you to quickly install a development or evaluation environment on a single host computer. It only takes a couple of minutes to set it up.
Before starting the installation, make sure that you have a working Java Development (more...)
Well, this blog posting is not about explaining the (more...)
So at the time of writing there is only the “Quickstart” 12C SOA and BPM. That’s all fun and games, it installs straight out of the box.
However, I want a real development environment, and run it on my dev server.
So, first thing first.
After installing SOA Suite 12c I created, as everyone else, my first composite. Jdeveloper will generate your project for you. The first thing you will notice is the new directory structure. Not every file is loaded in same directory like it used to be in SOA Suite 11g.
When giving the directory structure a second look I noticed the “resources” directory with the pom file in it. 12c has maven support!
However, when running my (more...)
This was promising, so I give it a short try for Oracle ADF applications. For this blog I use the Summit ADF application, delivered by Oracle, but I have tried with our own application too. Test is done in JDeveloper 12.1.2.
After the download there are some easy steps (more...)
Oracle has finally announced 12c, so now everybody can get their hands on it. One of the new features is that Oracle Service Bus development is integrated into Oracle jDeveloper Studio.
One way to get started quickly is by simply importing your 11g service bus sources into 12c.
First export your 11g sources, either from the Servicebus Console or Eclipse (OEPE):
Then, this sbconfig.jar is easily imported into the new Oracle jDeveloper Studio (more...)
A quick fly through the options for conditional uniqueness.
Requirement #1: I want uniqueness on a column but only under certain conditions.
For example, I have an active flag and I want to make sure there is only one active record for a particular attribute but there can be many inactive rows.
create table t1 (col1 number not null ,col2 varchar2(24) not null ,is_active number(1) not null ,constraint pk_t1 primary key (col1) ,constraint (more...)
!The code contained in this post is meant to be used at your own risk!
With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on. One aspect that many people want to know is how can I validate that every record is being transferred to the target system. Once such way is to use Oracle Veridata; however, some times there is not enough time to setup and (more...)
When working with Oracle GoldenGate, understanding the System Change Number (SCN) is important. The SCN is an internal number maintained by the database that keeps track of the changes made to the database for recovery purposes. The SCN is also important when working with Oracle GoldenGate. In many environments, instantiation of Oracle GoldenGate environments require knowing where to start the replicat from.
To find the current SCN for the database, Oracle has made this pretty (more...)