Video: Introducing the eDB360 Tool

Some of you have asked if the “Introducing the eDB360 Tool” session at the Oaktable World 2014 was recorder. Actually it was, and thanks to Kyle Hailey it is now available as well as the slides. Just go to the agenda of this event and click on corresponding link. There you will also find video and/or slides for all other sessions.

Thanks Kyle for making this possible!

Business Value of Engineered Systems

Engineered Systems are optimized to run PeopleSoft, E-Business Suite, JD Edwards and Siebel which provides customers with extreme performance improvements over any other platform.  While performance is a key driver for customers to consider Engineered Systems there are many additional business benefits that are just as important.  These additional benefits include:

  • Reduced risk
  • Simplified monitoring and management
  • Consolidation
  • Business agility
  • IT spending less on day to day activities and more time adding value (more...)

Purging Data From the BPEL Store by Matt Brasier

In this recipe, taken from the book Oracle SOA Suite 11g Performance Tuning Cookbook (ISBN: 9781849688840, Packt Publishing) we will remove old BPEL dehydration data and state from the SOA infrastructure database.
Getting ready
You will need to have access to the database on which the SOA_INFRA schema is hosted. In this recipe we’ll be using a command line local to the host on which we installed the database.
You’ll also need access to the (more...)

EM12c Release 4, Health Overview

As part of the projects I work on at Oracle, it’s often ensuring that those customers that wish to deploy Enterprise Manager, (EM12c) to large environments, have the correct settings and are tuned to offer the best performance from the Oracle Management repository database, weblogic and up to the console URL’s accessed by users.  This means that these large environments often receive recommendations from our experts  that differ from what EM12c comes “out of (more...)

Collected advice on Unix CLI Design & Implementation

| Oct 31, 2014

Last week, a blog post by made the rounds. It presented nine suggestions on what makes a command a good citizen of the Unix command-line ecosystem, especially for fitting into pipelines and filters.

This reminded me of a longer list of guidelines I recently gathered as part of our efforts to train new hires in Solaris engineering. I polled long time engineers, trawled the Best Practices documents of (more...)

T H March Seeks to Redefine the Jewelry Insurance Customer Experience

A young couple stands in front of a jewelry store window, holding hands and gazing in wonder at the life changing purchase they are about to make—a stunning engagement ring. It’s a timeless scene until the bride-to-be snaps a selfie with her smartphone to share on social media and the future groom checks the establishment’s reviews on Yelp. Welcome to buying jewelry in the digital age. (more...)

Internet of Things— Superfood for your Business

By Ward Quarles - JD Edwards Director

Popeye is depicted as capable of creating solutions to problems that everyone else thought were insurmountable. After consuming his superfood, spinach, solutions were possible because of his superhuman strength.  Will the Internet of Things become superfood to our businesses?

The Internet of Things (IoT) is the next frontier in technology and business development. JD Edwards customers are exploring IoT technologies that allow them to capture, transmit and (more...)


I found some notes from a course I took in 1990. They said that it was only possible to GRANT ALTER or GRANT SELECT on a sequence. This seemed reasonable to me but I wanted to check if it was still the case. I did this test on Oracle 12.1. First I created a user who would own a sequence:

SQL> create user u1 identified by pw1
  2  /
User created.

Friday Spotlight: Oracle Linux will be Featured at Dell World 2014

| Oct 31, 2014

Happy Halloween everyone!  

This year, like in the past, Oracle Linux is featured in DellWorld at Austin, Texas, November 4-6. There are two Breakout Sessions and Oracle Stand you can visit to get more information about the Dell Integrated Systems with Oracle Databases (DISOD) based on Oracle Linux.

Session MT11: Lowering the cost via appliances and Dell engineered solutions 

How can you lower your total solution costs, improve performance and availability and reduce (more...)

Multiple vulnerabilities in Bash

CVE DescriptionCVSSv2 Base ScoreComponentProduct and Resolution
CVE-2014-6271 OS Command Injections vulnerability 10.0 Bash
Solaris 11.2
Solaris 10 SPARC: 126546-07 X86: 126547-07
Solaris 9 SPARC: 149079-03 X86: 149080-02
Solaris 8 SPARC: 150512-01 X86: 150513-01
CVE-2014-6277 OS Command Injections vulnerability 10.0
CVE-2014-6278 OS Command Injections vulnerability 10.0
CVE-2014-7169 OS Command Injections vulnerability 10.0
CVE-2014-7186 Buffer Errors vulnerability 10.0
CVE-2014-7187 Buffer Errors vulnerability 10. (more...)

Friday Spotlight: Managing Oracle VM 3.3 from Oracle Enterprise Manager 12c

| Oct 31, 2014

In the previous blog, we announced that the new virtualization plug-in ( for Oracle Enterprise Manager 12c Cloud Control was available. With the latest virtualization plug-in update, Oracle Enterprise Manager 12c works seamlessly with Oracle VM Manager 3.3. In today's blog, Daniel Ritzman, Principal Best Practices Consultant from Oracle VM product management team, covers how to use the new plug-in to (more...)

Best of OTN – Week of October 26th

Java Community -

Your spooky pirate, Tori Wieldt, OTN SR. Java Community Manager

JavaOne sessions available - This year at JavaOne we captured video of some of the biggest sessions. For the rest of the sessions we captured the audio and synched it with the presentation deck. We'll be rolling out sessions every couple of weeks, so check back often for the latest content and follow the JavaOneConf twitter handle for announcements.

Java SE 8 (more...)

OSB 12c; tips for use DomainValueMap in Xquery

Today I was building a Xquery with a reference to a DomainValueMap (DVM) in JDeveloper 12c for an OSB 12c project.

When testing my Xquery I ran into the following error:

Caused by: oracle.tip.dvm.exception.DVMValidationException: Unable to get Metadata Manager for DVM “”
Please ensure the Metadata Manager is available.
at oracle.tip.dvm.DVMManagerImpl.getDVMRTObject(
at oracle.tip.dvm.DVMManagerImpl.lookupValue(

When you create a dvm lookup function in Xquery you get this :
dvmtr:lookup(<dvm-location>,<dvm source-domain>, <dvm sourcevalue>, (more...)

Reverse engineer and discover foreign keys with SQL Developer Data Modeler

Originally posted on HeliFromFinland:
You can easily document your database with Data Modeler: just reverse engineer the database with File-> Import -> Data Dictionary. But what if the database has no foreign keys? What’s the point of documenting then? Just tables that has nothing to do with each other…. Well, Data Modeler can help with…


No, not the 10th posting about first_rows() this week – whatever it may seem like – just an example that happens to use the “calculate costs for fetching the first 10 rows” optimizer strategy and does it badly. I think it’s a bug, but it’s certainly a defect that is a poster case for the inherent risk of using anything other than all_rows optimisation.  Here’s some code to build a couple of sample tables:

	dbms_stats. (more...)

Best Practices: Implementing SSL in Oracle Identity Manager

Implementing SSL in OIM 11g R2 PS1

Infosys Limited (NYSE:INFY) is a global leader in technology, consulting and services and an Oracle (Diamond) Partner that has graciously agreed to present on best practices garnered from experience working on Large Enterprise IDM deployments in a four part series hosted here in the Identity Management Blog.

In this blog post, part three of the four part series, Infosys shares its experience with enabling SSL between Oracle Identity (more...)

Oracle ZFS Storage Appliance Plug-in for Enterprise Manager (v2.0) Now Available

Version 2.0 of the Oracle ZFS Storage Appliance Plug-in for Enterprise Manager is now available.  The plug-in supports the capture and display of metrics from any number of ZFS Storage Appliances in the Enterprise Manager interface.  Also available through the interface are all tunable settings (including support for provisioning of projects and shares).

As noted in the 2014 IOUG Database Storage Survey, for a vast majority of customers, the current vendor-supplied storage management tools (more...)

Data Warehouse Appliance Offerings


Information Technology units will continue to be challenged by the unbridled growth of their organization’s data stores. An ever-increasing amount of data needs to be extracted, cleansed, analyzed and presented to the end user community. Data volumes that were unheard of a year ago are now commonplace. Day-to-day operational systems are now storing such large amounts of data that they rival data warehouses in disk storage and administrative complexity. New trends, products, and strategies, (more...)

Solaris 9 exiting Extended Support period

Solaris 9 is exiting Extended Support and entering Sustaining Support.

In accordance with the Oracle Lifetime Support Policy for Software and Operating Systems, (Page 37), and (Pages 6 and 9), all patches created during the Extended Support period will revert to "Operating System" access entitlement on MOS so they are available to all customers will a valid support contract, not just those that purchased Extended Support.

There (more...)

Portic Barcelona uses WebLogic for Private PaaS, Achieves 32x Performance Improvement

| Oct 31, 2014

Portic Barcelona S.A. (Portic) is a service provider used by the logistics community of the Port of Barcelona. Portic’s mission is to improve the competitiveness of the Port of Barcelona Logistics Community through a technological platform that facilitates interaction between its members through its information services to logistics agents and other customers.

Portic's goal was to establish a hardware-independent, cost-effective, centralized platform support and maintenance with a single, strategic supplier to reduce complexity and (more...)