!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...)
Just a quick shout-out , in case you haven’t heard about the news before, Enterprise Manager is now available with its 4th release now. You can download it from OTN along with the documentation. Additionally, you can watch and learn about the latest features from the EM’s YouTube Channel and also from OLL’s YouTube Channel. Tim Hall’s installation articles for the same are just too good to be missed. Last but certainly not the least, (more...)
I have presented today on DOAG Development 2014 in Dusseldorf. For all non DOAG members – you can find the german presentation on slideshare too.
Filed under: Quality Assurances Tagged: 11g, 12c, acceptance test, ADF, Checkstyle, code coverage, commit test, Continous Integration, FindBugs, gui test, JaCoCo, JDeveloper, Jenkins, JUnit, Mockito, PMD, Powermock, Static Code Analysis, unit test
This is just a quick post while I’m waiting on a few other things to line up today. For many of us, the long awaited Release 4 of Oracle Enterprise Manager 12c is out! This release of OEM 12c has many exciting improvements and some really cool new stuff. I cannot remember all of them, but one I’m looking forward to is the AWR Warehouse and figure out how all of it (more...)
If you speak german and you are interested in quality assurance for your ADF projects you should come and attend my presentation at DOAG Development on 06/04/2014 in Dusseldorf.
I will show you, how you can implement in the JDeveloper IDE and in Continous Integration server Jenkins:
- static code analysis with PMD, FindBugs and Checkstyle
- Commit tests with JUnit, Mockito and Powermock for Mockito
- Code coverage for commit tests with JaCoCo
- Acceptance tests with JUnit (more...)
For a couple of weeks now, I’ve been trying to figure out a way to identify the size of data for transactions that are getting processed over a give period of time with Oracle GoldenGate. When I started to think through the process, I keyed in on the Relative Byte Address (RBA). What is the RBA? From reading Oracle’s GoldenGate documentation, the RBA is mostly a marker within the trail file to (more...)
There is a lot of change that release 12.1 or 12c has brought up. And it’s not in the more advanced new features that I am talking about but even in some areas about which, we have memorized a particular concept by heart from last many years. Once such change is what I am going to mention in this post-introduction of the LREG(Listener Registration) process.
Basics of Dynamic Registration
In the earlier releases,to register (more...)
firstname.lastname@example.org > create procedure p is begin null; end this_does_not_compile; 2 / Warning: Procedure created with compilation errors. email@example.com > show errors Errors for PROCEDURE P: LINE/COL ERROR -------- ----------------------------------------------------------------- 1/32 PLS-00113: END identifier 'THIS_DOES_NOT_COMPILE' must match 'P' at line 1, column 11 firstname.lastname@example.org > REM expexted email@example.com > create function f return number is begin return null; end this_does_not_compile; 2 / Warning: Function created with compilation errors. firstname.lastname@example.org > (more...)
Over the last few weeks I’ve been working and traveling a good bit. Amongst all the travel I’ve been trying to get time to test a few things. One test I wanted to get done was using Oracle GoldenGate 12c with Oracle Database 12c between Pluggable Databases (in the same instance). As of today, I’ve finally gotten my Oracle Virtual Box environment configured and ready, so now I can travel and still (more...)
Earlier I wrote a blog post about moving the Oracle Golden Gate Extract from “Classic” capture to “Integrated” capture. In this post, we will take a look at how to move a “Classic” replicat (apply) to an “Integrated” replicat (apply) process.
There has been some posts on the R/ORE on the Oracle discussion forums about installing ORE on Oracle 12c.
It turns out that the only way to install ORE on an Oracle 12c database is if you do a traditional install. What this means is that you do not have a CDB and PDBs configuration of Oracle 12c.
I'll assume that (more...)
Last week I was lucky enough to be presenting at the UKOUG AIM SIG. There was a decent enough crowd in attendance and there were some really interesting talks and some really good speakers. In particularly I found Chris Lawless speaking on replication a particularly engaging speaker, and Dave Webster really held the audiences attention late in day.
I was giving a presentation on the new features available to you with 12c ASM. The presentation (more...)
In 12c version of Oracle database, at the CDB level, (more...)
create table from_12c_onwards ( you_can_have_your_pk number generated always as identity, so_you_dont_have_to_type_it varchar2(10) ); insert into from_12c_onwards ( so_you_dont_have_to_type_it ) values ( 'yes' ); insert into from_12c_onwards ( so_you_dont_have_to_type_it ) values ( 'Yes' ); insert into from_12c_onwards ( so_you_dont_have_to_type_it ) values ( 'YES!' ); select * from from_12c_onwards; YOU_CAN_HAVE_YOUR_PK SO_YOU_DON -------------------- ---------- 1 yes 2 Yes 3 YES!
If you’d like more details, there’s a nice article on oracle-base discussing how (more...)