This is the continuation of my efforts to stage an awesome Fedora developer’s instance. It shows you how to install Java 1.8 software development kit, which is nice to have. Though you can’t use Java 1.8 officially with Oracle SQL Developer 4.0.3 it is required for Oracle SQL Developer 4.1. Fortunately, the Oracle Product Manager, Jeff Smith has advised us that you can use Java 1.8 JDK with Oracle (more...)
Advanced Oracle Troubleshooting Guide – Part 12: control file parallel reads causing enq: SQ – contention waits?
Vishal Desai systematically troubleshooted an interesting case where the initial symptoms of the problem showed a spike of enq: SQ – contention waits, but he dug deeper – and found the root cause to be quite different. He followed the blockers of waiting sessions manually to reach the root cause – and also used my @ash/ash_wait_chains.sql and @ash/event_hist.sql scripts to extract the same information more conveniently (note that he had modified the scripts to (more...)
Planning out my year, I decided to take the Oracle OCP and MySQL OCP exams. I checked for review books and was pleasantly surprised to find the soon to be released OCP MySQL Database Administrator Exam Guide (Exam 1Z0-883). However, I noticed that the book was actually prepared for the obsolete and discountinued Exams 1Z0-870, 1Z0-873, and 1Z0-874.
There isn’t an alternative review book for the OCP MySQL 5.6 Developer or Database Administrator (more...)
We had some issues with deploying a composite which retrieves his wsdl for the partnerlinks from Nexus.
The supplier of the services adds the archive with the wsdl artifacts in Nexus, we download the dependency and after that we compile/validate the composite against the downloaded set of artifacts.
For one particular partnerlink the composite just wouldn’t compile.
Error message :
Validating composite "c:ReposcompositesmydomainobjectMyServicecomposite.xml" c:ReposcompositesmydomainobjectMyServicecomposite.xml:21: error: Load of wsdl "oramds:/apps/xsd/nextgen/gm/services/mydomainobject/2/myservice.wsdl" failed c:ReposcompositesmydomainobjectMyServicecomposite.xml:44: (more...)
Docker has turned out to be pretty cool and very easy to learn. And it's lightweight. The idea is that you run containers - your app, your operating system, and your virtual machine - bundled together in a (more...)
Today I worked on silent upgrade of Oracle GoldenGate from 18.104.22.168.0 to 22.214.171.124.2, so thought to blog it which might help some of you. These are the steps I performed
Current GoldenGate Home –> /oracle/app/product/ogg12.1.2
1. Gather the details of GoldenGate Processes before stopping them
GGSCI> INFO EXTRACT EXTL, SHOWCH INFO EXTRACT DPUMP, SHOWCH GGSCI> SEND EXTRACT EXTL, SHOWTRANS GGSCI> STOP EXTRACT DPUMP GGSCI> STOP (more...)
EMCLI is not certified or supported on Mac OS X, but I wondered if it is possible to run on my new macbook. I searched metalink, googled and couldn’t found any useful information. I thought it should be easy because EMCLI is a java application certified to run almost all enterprise operating systems including HP-UX, AIX, Linux, Windows, Solaris, and we all remember “write once, run everywhere” slogan of Java. Unfortunately it wasn’t as easy (more...)
In this post, we’re going to perform a push button refresh of an Oracle Database, Application Express (APEX) installation, and Tomcat webserver.
“But Oracle Alchemist,” you’re probably thinking, “we know about that. You’ve told us about how Delphix can provision and refresh data.” And yes, you’d be right. But I wasn’t done yet.
We’re going to perform a refresh of an Oracle Database, APEX installation, and Tomcat running in Amazon Web Services, replicated from (more...)
I’ve run into a few customers recently who have had problems with their ASM rebalance operations running too slowly. Surprisingly, there were some simple concepts being overlooked – and once these were understood, the rebalance times were dramatically improved. For that reason, I’m documenting the solutions here… I hope that somebody, somewhere benefits…
1. Don’t Overbalance
Every time you run an ALTER DISKGROUP <NAME> REBALANCE operation you initiate a large amount of I/O workload as (more...)
One very useful aspect of Golden Gate is to allow the manipulation of data between the source and the destinations.
One recent problem that I encountered was to alter the data differently for inserts than for updates. This was caused by the receiving system needing to have some default data in columns which may or may not be supplied by the insert or update statements. This is slightly more complex than first imagined:
- If we (more...)
APEX 5.0 can be found under http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
The new APEX 5.0 is supported for all Editions of Oracle Database 126.96.36.199 or higher, even Oracle Express Edition 11g (XE) can be used for the new APEX 5.0
In the past few weeks Oracle has been working towards a climax regarding the new version of Application Express. After updating the Early Adapters environment and later the hosted applications at apex.oracle.com to version 5.0 it is now finally time for the full release!
APEX 5.0 can be downloaded at apex.oracle.com.
For more information on the most important new features visit the Oracle blog.
It’s been a while since my last post but I was really busy working on a number of projects.
The purpose of this post is to highlight an issue I had while building a standby database. The environment we had – three 188.8.131.52 databases at host A (primary) and same were restored from backup on another host B (standby), both hosts were running Linux. It’s important to mention that both hosts were (more...)
Feel free to ask questions!
So I was happy to hear about Cliff Godwin, Oracle's (more...)
Awesome Oracle ERP Cloud on Apple Watch design concepts. For more information see: A Glance at Smartwatches in the Enterprise: A Moment in Time Experience.
First of all a disclaimer: I don’t work for Oracle nor do I speak for them. I believe this information to be correct, but for licensing questions, Oracle themselves have the final word.
With that out of the way, followers of this blog may have seen some of the results from my testing of actual CPU capacity with public clouds like Amazon Web Services, Microsoft Azure, and Google Compute Engine. In each of these (more...)
Just been tearing my hair out on some unexpected SQL behaviour in SQL Developer.
Eventually I managed to get to the root cause of the problem as illustrated below.
SQL> var ps number SQL> exec :ps := 4001644945; PL/SQL procedure successfully completed. SQL> select :ps from dual; :PS ---------- 4001644945 SQL>
SQL Developer v3.2 and v4.0 via “Run As Script(F5)”:
var ps number exec :ps := 4001644945; select :ps from dual; anonymous (more...)