SQL Developer – Fedora

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...)

Database landscape 2014 visualization

I saw this database landscape 2014 overview from “451 Research” with an very nice visualization…

MySQL OCP Exams

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...)

Error deploying Oracle Composite with wrong encoding wsdl

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...)

#C15LV Collaborate’15 updates!!

Hi All, Last week, I registered my presence at Collaborate’15 in Las Vegas as a speaker, attendee and at Oracle demo booth duty. It was an awesome experience meeting some polished brains and smart minds. After the first day of registration, I attended the #DBIM12c session by Maria Colgan, #DB12c Multitenant by John McHugh and #Exadata session … Continue reading

Oracle and Docker

So, as many of you know, I've been working out different ways to host my Oracle labs and demos instances without chewing up phenomenal amounts of disk space and processing power.  Lately, I've been diving into Docker.

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...)

Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2

Today I worked on silent upgrade of Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.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...)

Oracle Enterprise Manager EMCLI on Mac OS X

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...)

Real Push Button Refresh with Raspberry Pi

Push Button

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...)

ASM Rebalance Too Slow? 3 Tips To Improve Rebalance Times

see-saw

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...)

Goldengate Data Manipulation – When Inserts & Updates differ

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:

APEX 5.0 available for download

Since yesterday (15th April 2015) the latest Oracle Application Express (APEX) release 5.0 is available for download.

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 11.1.0.7 or higher, even Oracle Express Edition 11g (XE) can be used for the new APEX 5.0

Oracle Application Express 5.0 available for download

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.

Smart firewalls

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 11.2.0.3 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...)

Collaborate’15 A New View of Database Views

Thanks to everybody who visited my presentation! Here is a link to view and/or download the slide set: http://www.slideshare.net/MishaRosenblum/2015-458-rosenblumpptfinal

Feel free to ask questions!

Good News On The EBS Front

Most people who know me professionally know about my enthusiasm for enterprise applications delivered via the SaaS model.  In terms of adoption and agility, SaaS is a winner.  But, at the same time, I also recognized that SaaS is not for everybody.  Those who customize heavily and those who want to retain a higher level of control are probably better off with on-premise enterprise applications.

So I was happy to hear about Cliff Godwin, Oracle's (more...)

Awesome Oracle ERP Cloud on Apple Watch design concepts. For…





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.

Licensing Oracle in a public cloud: the CPU calculation impact

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...)

SQLDeveloper VAR NUMBER

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*Plus:

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...)