Kscope ’12 and the Rodeo Special Event

Just arrived back home in New York after a great week at the ODTUG Kscope ’12 conference in San Antonio, TX. It was great meeting many members of our ever growing APEX community again, seeing several outstanding presentations on APEX and other topics and being able to present to our (more...)

Do You Know What Day It Is?

Have you ever sat in on a meeting like this?

Person 1:  The customer wants a green background on this page.

Person 2: Do we know they're going to stick with green?  Maybe we need a configuration option for background color.

Nobody wants to disagree and the manager (more...)

Speaking at E4!

I’ll be co-speaking with Randy Johnson (one of the authors of Expert Oracle Exadata) at E4 to share about the war stories and detail on a bunch of technical stuff on a Peoplesoft and BIEE consolidation project we had on one of our clients. See the abstract below:

Randy Johnson & Karl Arao
A PeopleSoft & OBIEE Consolidation Success Story
In today’s competitive business climate companies are under constant pressure to reduce costs without sacrificing quality. Many companies see database and server consolidation as the key to meeting this goal. Since its introduction, Exadata has become the obvious choice for (more...)

The effect of ASM redundancy/parity on read/write IOPS – SLOB test case! for Exadata and non-Exa environments

Last week I had a lengthy post at oracle-l that tackles Calibrate IO, Short Stroking, Stripe size, UEK kernel, and ASM redundancy effect on IOPS Exadata which you can read here
followed by interesting exchange of tweets with Kevin Closson here (see 06/21-22 tweets) which I was replying in between games at UnderwaterHockey US Nationals 2012 which we won the championship for the B division ;) I have my awesome photo with the medal here

This post will detail on the ASM redundancy/parity effect on IOPS… if… by changing the ASM redundancy (external, normal, and high) will it decrease the workload (more...)

Important R12 FV PO Commitment Accounting Attribute Assignment Updates identified in patch 13610367

Patch 13610367, released earlier this year, provided an update to the seeded Federal Purchasing AAD that is important for all R12.1 Federal PO Customers to understand, even if not using the seeded Federal SLA definitions.  The AAD change included updates to a couple of the key Accounting Attribute Assignments for the FV PO Commitment JLT. 

The changes were:

Accounting Attribute Assignment: Allocated to Distribution Type, changed to source: Allocated to Main Document Distribution Type
Accounting Attribute Assignment: Allocated to First Distribution Identifier, changed to source: Allocated to Main Document Distribution Identifier

The SLA configuration we’re using at my current gig is non-seeded and agency-unique but modeled (more...)

My Oracle Support Interface Change

If you are a use of My Oracle Support you should have received notification regarding a change to the user interface. As of July 13, 2012 Oracle will be retiring their Flash-based interface and replacing it with an improved HTML interface that has added functionality.

There is a CALL TO ACTION regarding this change. If you follow the link you will be directed to a page that will describe the changes in detail and advise what you have to do in order to take advantage of the new user interface.

EclipseLink Team Blog 2012-06-27 08:54:00

EclipseLink 2.4.0 Released

I am very excited to announce that EclipseLink 2.4.0 is now available for download.

Highlights of this release include:....

RESTFul Persistence

Java Persistence units can now be exposed over REST using either JSON or XML media.

Tenant Isolation - Table per tenant

Developers can design and deploy applications where their persistent entities are stored in separate tables per tenant.


This release introduces EclipseLink's NoSQL support for MongoDB and Oracle NoSQL.


EclipseLink MOXy can now be used for the marshaling and unmarshaling of JSON object. This is core infrastructure to the JPA-RS (more...)

EclipseLink 2.4:

EclipseLink 2.4.0 Juno - RELEASED

As part of the Juno Eclipse release train the EclipseLink project has released EclipseLink 2.4.0. The release landing page describes some of the new and noteworthy features as well as providing links to documentation and examples so you can get started. (more...)

Java 7-Auto-Update, more Links

Here are some more links and notes to the Java 7 Auto-Update-Problem. You must log into "My Oracle Support" to see the metalink-notes.

Oracle Java SE Support Roadmap

Updated Java 6 EOL date

Note 1412103.2
Installation and Configuration for Oracle Java SE

Note 1467442.1
URGENT BULLETIN: All E-Business Suite End-Users Must Manually Apply JRE 6 Updates

Note 1469230.1
FAQ - Java SE Auto Update

Note 1470123.1
What Impact does the Desupport of Java 6 have on Fusion Middleware 11

Note 1470671.1
JRE7 Is Not Certified For Oracle Health Insurance

Actual version of JRE 1.6
Oracle JDK 6 update 33 (1.6.0_33)

have fun

Poll Results and upcoming Oracle Event in Pune

Last month I have posted a poll on my blog and LinkedIn group Oracle Database Performance Tuning about suggestions for a topic for webcast. I am enraptured by the response I got and as you can see below majority of the people have voted in favor of presentation title “Database Capacity Planning how to start?”.

This is inline to my expectations. Last year I have delivered a presentation at AIOUG’s annual meet Sangam11 on the topic “Day Someone Say the word Capacity?”. It was about the basics and concepts related to Capacity planning in general with some specific (more...)

Java 7-Auto-Update Warning

It looks like, that all forms-applications run into a huge problem, starting next week, July 3rd 2012.

Oracle's Java 1.6-Updater will automatically update the JRE to 1.7 on all PC's, where auto-update is activated. And Java 1.7 is not certified with Forms 10g, Forms 11g or the E-Business-Suite (EBS-forms-components)

I try to find all relevant informations to that topic and blog them afterwards. So feel free to share this blog to all customers who may have this problem next week.

Here are the first links:

The latest news directly from E-Business Suite Development

JRE Troubleshouting Guide

OTN (more...)

A Universal JMX Client for Weblogic –Part 1: Monitoring BPEL Thread Pools in SOA 11g

Monitoring and optimizing BPEL Thread Pool utilization (and other metrics) is one of the key activities in performance tuning of BPEL/SOA based integrations. Although EM console provides some basic monitoring of the BPEL engine statistics, it is limited regarding the update interval, detail and the recording interval and cannot display (more...)

How to simulate DML Operations on XML data using XU (XQuery Update)

The following SQL pattern can be used to simulate DML operations on XML data by utilizing XU (XQuery Update) functionalities.

This query will do the following XML data transformation by using XU insert/delete/rename/replace statements.

1) Convert all the XML Attributes to Elements.                ( XU Delete & Insert)

2) Change the  (more...)

Oracle ApEx Class Online

I've been building out an Oracle Application Express class on InteliVideo.  Check out the class...I'd love to get your feedback, ideas, etc.  I'll give the first 10 people to send me an email (brad@intelivideo.com) a free class registration.

ORA-16792 configuration property value is inconsistent with database setting

As per the reference this error literally means:

Cause: The values of one or more configuration properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by altering initialization parameters directly instead of altering property values using Data Guard broker.

Actions: Query property the InconsistentProperties on the database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configuration property settings to be propagated to to the (more...)

Exadata motherboard replacement

This photo story is about a motherboard replacement in an Exadata X2-2 database server (Sun Fire X4170 M2).

While setting up a half rack Exadata system, we discovered a problem with the motherboard in database server 4, so we got ourselves a new one. Even for an internal system, I had to log an SR, get our hardware team to review the diagnostics and have them confirm that a new motherboard is required. I had a full customer experience with me being both the customer and Support Engineer! Anyway, a replacement motherboard arrived the next day.

We stopped the clusterware (more...)

A small change in parallel insert with serial data access between 11.1 and 11.2

There is an interesting small change in parallel insert between 11.1 and 11.2 in queries with parallelized insert, but serialized data access. On a practice the simplest case where we can see this it is CTAS or parallel insert as select from remote table.
As an example I will use CTAS from remote table.

create table tbllocal parallel 2
    as select *
  from tblremote@dblink;

Note: even if remote part of this query (select from tblremote@dblink) will be parallelized, it will be run in parallel on remote side. Communication between remote and local servers will be performed in one (more...)

Application Express 4.2 Early Adopter and Kscope 12

Today we released the first Early Adopter version of Oracle Application Express 4.2 – right in time for ODTUG KScope12. You can sign up and give it a try:

One of our focus areas in this release of course has been Mobile. And while we’re still (more...)

Application Express 4.2 Early Adopter 1

Following on from Joel's post this morning (http://t.co/HW9dflZC) the first Early Adopter for APEX 4.2 is now available @ https://apexea.oracle.com.

A list of Feature Descriptions and Known Issues is also available @ http://apex.oracle.com/pls/apex/f?p=38997:1:0

One of the main features we are introducing (more...)

Clear Cache for all Pages within a Page Group

Most client sites I have been on tend to love wizards that hold the users hand through often complex business process / workflows.

As a general rule, if I have a 10 step wizard (I generally use 1 page per step) I like to ensure that all 10 pages have (more...)