handling disks for ASM – when DB, Linux and Storage admins work together

A proper management of ASM Disks can be a complicated task.

On DOAG2015 I discussed with Martin Bach about the concept in my current company, where we implemented a setting which is consistent, robust and enables Storage, Linux and DB admins to work together easily.

As we started to think about ASM when 10.1 was out we tried to evaluate our possibility. asmlib was discarded quite early as it only increased complexity without additional (more...)

OIM11gR2: Side-effects of using EntityManager API on update Event Handlers

The main purpose of using EntityManager API to update a user-profile on a post-update event handler is that the event handler shouldn't get into an infinite loop. This is very clear.

Consider a scenario where there is a UDF 'Company Name' which is populated based on user's Organization. Assume, it is just a simple 1-1 mapping between user's Company Name and Organization.  The 'Company Name' attribute is read-only on the user profile and its value (more...)

Europe leads in Oracle PaaS adaption driven by Oracle Partners!

clip_image001It’s a pleasure to work with the Oracle EMEA SOA & BPM and WebLogic & Developer Partner Community and see the success in our cloud adoption. The latest press release proves that our EMEA partners lead adoption. Oracle provides the same technology in the cloud as on-premises. This enables partners to secure their investment in knowledge and skills and rapidly build cloud applications for our joint customers.

Partners who can support your cloud adoption

Looking (more...)

Oracle APEX Programming Competition 2016 für Studenten aus NRW

Macht mit - bildet ein Team und bewerbt euch online bis zum 22. Januar 2016 :-) 

Auch 2016 sucht die PITSS GmbH in Zusammenarbeit mit Oracle Deutschland wieder die APEX Talente von morgen: diesmal unter den Studierenden der Hochschulen & Unis in Nordrhein-Westfalen. In dem Wettbewerb programmieren studentische Teams eine Anwendung in Oracle Application Express (APEX).

Alle Infos und Termine findet ihr hier.

SHA-2 PKI Certificates Certified with EBS 12.1.3 on Windows

As a follow-up to a prior announcement, SHA-2 signed PKI certificates are now certified for inbound connections to the Oracle HTTP Server (OHS) delivered with Oracle E-Business Suite 12.1.3 on Windows.  

As published in a prior blog article, SHA-2 signed PKI certificates are already certified for outbound connections from Oracle E-Business Suite 12.1.3.

Required Steps

If you are enabling SSL/TLS for the first time for Oracle E-Business Suite (more...)

PL/SQL Formatting : More pearls of wisdom from Bryn

glasses-272399_1280-smallAnother topic of conversation that came out of Bryn‘s session at Oracle Midlands related to PL/SQL code formatting. I’m not sure I agree 100% with his opinion, but it’s certainly making me think about my current stance.

When I said I was going to blog about a couple of the points he raised, Bryn emailed me some stuff, which I’m going to use here. So this is Bryn’s content, with some of my opinions thrown in. I (more...)

Custom Transports in Oracle Service Bus 12.2.1


Chart Tips: Coloring by Group and Displaying Attribute Groups in the Legend

We often get questions from customers on how to configure chart colors. The JET blog article How to Create Colorful Bar Charts explains very well how to configure chart colors in JET. In this blog article we will explain how to configure chart colors in ADF.

In a previous blog post we talked about displaying overview window on the charts and coloring by groups. In this post you will learn more about attribute groups and (more...)

PeopleSoft Design Jam in India

We just got back from our whirlwind trip running design jams in our offices in Hyderabad and Bangalore.  While we wait for jet lag to diminish and we are able to get our internal summaries of the entries together, I thought I'd share the fact that design jams are taking off as a way to foster innovation and solve design challenges in many places at Oracle.  I've always said that my goal is (more...)

Crowd Pleasers

| Nov 25, 2015

At this year’s Web Summit in Dublin, Ireland, I had the opportunity to observe thousands of attendees. They came from 135 different countries and represented different generations.

Despite these enormous differences, they came together and communicated.

But how? With all of the hype about how different communication styles are among the Baby Boomers, Gen Xers, Millennials, and Generation Zers, I expected to see lots of small groupings of attendees based on (more...)

Lancement du blog Oracle Systems France

Bienvenue sur le nouveau Blog (more...)

Changing Appearances: Give The Apps Your Corporate Look

Oracle spends a lot of effort creating good-looking user interfaces.  And yet we understand that our customers often have their own corporate look and feel standards and would like their employees (or customers/partners in case of externally facing apps) see that same look and feel across all websites and applications.  So Fusion Applications offers tools and mechanisms to customize their out-of-the box look.  In this post we are going to give you a quick tour (more...)


My apologies for being so slow to see and respond to comments. This is my first ever blog and I was not aware there was a page I had to go to to see and approve comments so I was unaware that there were any. I've now published all the comments I've received and responded to them here appropriate.



Is Your Holiday Campaign Focusing on the Right Audience Data?

In today’s digital world, there’s one thing we can all agree on: marketers can’t afford to waste ad dollars on the wrong audience, especially at the height of a holiday campaign. The task of turning prospects into buyers at this time of year can certainly turn up the pressure to deliver results. The good news is that our experts at The Data Hotline are always available to help. Deliver results this season with some of (more...)

Preventing PL/SQL name clashes. You learn something new every day!

glasses-272399_1280-smallI mentioned in yesterday’s Oracle Midlands post, Bryn had an example of some syntax I had not seen in 20+ years of PL/SQL development.

You tend to name PL/SQL parameters and variables in such a way as to prevent name clashes with table columns. Let’s cause an obvious name clash…

The table DUAL has a column called DUMMY with a single row with the value ‘X’.

SQL> select * from dual;


1 row  (more...)

#OOW15 Wrap by Frank Munz


Oracle Open World is finished and IMHO it was great! What I particularly enjoyed was that Oracle this year delivered a lot of what was announced last year. The cloud offerings seem to be heading the right way (Oracle uses industry accepted terms now when talking about cloud, concludes to my definitions and delivers across IaaS, PaaS and SaaS). In addition Oracle Fusion Middleware 12.2.1, in particular WebLogic 12.2.1 is (more...)

How to rename ASM disk groups in Exadata

Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default  ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t make sense to me and the only place where I find the default ones is on Exadata.

I had an incident last year where the Exadata deployed half way through and names were left by default (more...)

WebCenter Portal Certified with E-Business Suite 12.2

Oracle WebCenter Suite is an integrated suite of Fusion Middleware 11gR1 tools used to create web sites and portals using service-oriented architecture (SOA).  Applications adapters are also available.

WebCenter Development Framework

WebCenter Portal is now certified with Oracle E-Business Suite Release 12.2.  WebCenter Portal is part of Oracle Fusion Middleware 11g Release 1 Version, also known as FMW 11gR1 Patchset 8. 


Oracle Midlands : Event #12 – Summary

Tonight was Oracle Midlands Event #12 with Bryn Llewellyn  and Neil Chandler.

Bryn very kindly stepped in for Tom Freyer who unfortunately couldn’t make it. Bryn’s presentation was called Why use PL/SQL?, which was based on his whitepaper of the same name. I’ve written about a number of the topics he raised, including a piece on My Utopian Development Environment, but his talk and his whitepaper put forward a much more consistent and compelling argument. Definitely worth checking (more...)

Why ALL Tools in at Your Disposal ARE IMPORTANT

After my AWR Warehouse session at DOAG in Nuremberg, Germany last week, an attendee asked me if he really needed to use trace files anymore with the value provided by AWR, (Automatic Workload Repository) and ASH, (Active Session History.)  I responded that trace files were incredibly valuable and should never be discounted.

To use an analogy, when I was 22 years old, and entered a doctor’s office missing a small percentage of my visual (more...)