Feed aggregator

MDM isn't about data quality its about collaboration

Steve Jones - Tue, 2014-05-27 10:00
I'm going to state a sacrilegious position for a moment: the quality of data isn't a primary goal in Master Data Management Now before the perfectly correct 'Garbage In, Garbage Out' statement let me explain.  Data Quality is certainly something that MDM can help with but its not actually the primary aim of MDM. MDM is about enabling collaboration, collaboration is about the cross-reference
Categories: Fusion Middleware

APEX boilerplate translation

Tony Andrews - Mon, 2014-05-26 10:25
APEX provides a mechanism for translating applications into other languages: Applications can be translated from a primary language into other languages. Each translation results in the creation of a new translated application. Each translation requires a mapping which identifies the target language as well as the translated application ID. Translated applications cannot be edited directly in Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com0http://tonyandrews.blogspot.com/2014/05/apex-boilerplate-translation.html

Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox

VitalSoftTech - Mon, 2014-05-26 09:45
If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.
Categories: DBA Blogs

Report from Collaborate 14, Las Vegas

David Haimes - Fri, 2014-05-23 23:54
David in a Suit

Talking Fusion Accounting Hub in a suit

Last month I attended and presented at Collaborate, the largest Oracle conference outside of Open World and one where the agenda is determined by the user community.

I was well organized this year; before I attended the conference I had downloaded the mobile App and started creating a conference agenda, I was a little bit disappointed that I had to manually add sessions I was presenting to my agenda, seems like a missing feature and it did not create the best first impression.  However, I then found the mobile app really good, a lot of discussions, the ability to comment on sessions and all the good social features you would expect.  When the conference got started the gamification they had added (a simple leader board of activity) helped to drive adoption and also caused some controversy, I’ll stay out of that but I would recommend reading Debra Lilley’s thoughts on it.

Throughout the week many people were talking about how several sessions they wanted to attend seemed to be scheduled at the same time. My first thought about this was that they were just making a polite excuse for not attending some of my sessions, but then I did observe the same thing myself.  It is hard having to choose between two or often three very interesting and useful sessions which are on at the same time, it is also tough when attendance at some sessions is lower than they deserve.  However, as I thought more about it, I feel it should be seen as a positive that the quality of the sessions and the presenters was very high.

My session on Fusion Accounting Hub and GLobal Charts of Accounts and Consolidation was on Monday and I had a decent crowd, got through a lot of material and had some really good questions (and I hope the answers were good).  I mentioned on my blog that FAH was the talk of the town based on the number of sessions that were covering it, I certainly spent  lots of time discussing it with people over the course of the conference.  We had a good GL SIG group meeting, I did a few minutes about the management segment and Data Access Sets in EBusiness Suite GL Release 12.  I was surprised that more people were not aware of this very useful feature, maybe I should blog about it (he says, adding it to a long to do list).  My third session was co-presented with Sangeeta Sameer from GE, I have asked Sangeeta to write a guest blog post introducing it, sharing the paper and announcing a webinar repeat of it – watch this space.

Exciting that all the things were, probably the part I enjoyed most was talking to so many people who had implemented or were implementing Cloud ERP Apps.  I had a chance to hear the positive comments and excitement that customers and partners had, but equally chat about where the y had suggestions for improvements.  We have a lot of very experienced, motivated and very smart partners out there and I enjoy every minute talking with them and learning from them, hopefully helping them out with a few tips too.

So next up for me is Open World, I did not make KScope this year, but one day I would like to go there, but for my particular field Collaborate is a must conference and if you have never been I would highly recommend you consider it next year, I will certainly be submitting a paper.




Categories: APPS Blogs


Catherine Devlin - Fri, 2014-05-23 16:09

I've had it on github for a while, but I finally released ddlgenerator to PyPI.

I've been frustrated for years that there was no good open-source way to set up RDBMS tables from flat data files. Sure, you could import the data - after setting up the DDL by hand. ddlgenerator handles that; in fact, you can go from zero, setting up and populating a table in a single line. Nothing up my sleeve:

$ psql -c "SELECT * FROM knights"
ERROR: relation "knights" does not exist
LINE 1: SELECT * FROM knights
$ ddlgenerator --inserts postgresql knights.yaml | psql
$ psql -c "SELECT * FROM knights"
name | dob | kg | brave
Lancelot | 0471-01-09 00:00:00 | 82.0000 | t
Gawain | | 69.2000 | t
Robin | 0471-01-09 00:00:00 | | f
Reepacheep | | 0.0691 | t

This is a fairly complex tool so I'm sure you'll be using the bug tracker. But I hope you'll enjoy it nonetheless!

Data Lakes will replace EDWs - a prediction

Steve Jones - Fri, 2014-05-23 15:14
Over the last few years there has been a trend of increased spending on BI, and that trend isn't going away.  The analyst predictions however have, understandably, been based on the mentality that the choice was between a traditional EDW/DW model or Hadoop.  With the new 'Business Data Lake' type of hybrid approach its pretty clear that the shift is underway for all vendors to have a hybrid
Categories: Fusion Middleware

Lipstick on the iceberg - why the local view matters for IT evolution

Steve Jones - Thu, 2014-05-22 13:00
There is a massive amount of IT hype that is focused on what people see, its about the agile delivery of interfaces, about reporting, visualisation and interactional models.  If you could weight hype then it is quite clear that 95% of all IT is about this area.  Its why we need development teams working hand-in-hand with the business, its why animations and visualisation are massively important.
Categories: Fusion Middleware

How to select a Hadoop distro - stop thinking about Hadoop

Steve Jones - Thu, 2014-05-22 10:00
Scoop, Flume, PIG, Zookeeper.  Do these mean anything to you?  If they do then the odds are you are looking at Hadoop.  The thing is that while that was cool a few years ago it really is time to face it that HDFS is a commodity, Map Reduce is interesting but not feasible for most users and the real question is how we turn all that raw data in HDFS into something we can actually use. That means
Categories: Fusion Middleware


Catherine Devlin - Wed, 2014-05-21 11:50

I went down a refactoring rabbit hole on ddl-generator and ended up pulling out the portion that pulls in data from various file formats. Perhaps it will be useful to others.

>>> from data_dispenser.sources import Source
>>> for row in Source('animals.csv'):
... print(row)
OrderedDict([('name', 'Alfred'), ('species', 'wart hog'), ('kg', '22'), ('notes', 'loves turnips')])
OrderedDict([('name', 'Gertrude'), ('species', 'polar bear'), ('kg', '312.7'), ('notes', 'deep thinker')])
OrderedDict([('name', 'Emily'), ('species', 'salamander'), ('kg', '0.3'), ('notes', '')])

Basically, I wanted a consistent way to consume rows of data - no matter where those rows come from. Right now, JSON, CSV, YAML, etc. all require separate libraries, each with its own API. This abstracts all that out, for reading purposes; now each data source is just a Source.

I'd love bug reports, and sample files to test against. And feel free to contribute patches! For example, it wouldn't be hard to add MS Excel as a data source.


Mounting VMWare-Volumes/Disks with Debian

Dietrich Schroff - Tue, 2014-05-20 15:30
Some time ago a vmware server did not recognize any more a data disk. This disk was formatted with vmfs v3 (enter the vmware server via ssh and type mount..). First thing i did, was creating an image of this disk, to play around without any danger of data loss.

There is a good article how to mount vmfs, but on debian i had to install the package otherosfs.

After i installed this package, i got the following error:

root@debian:/tmp# vmfs-fuse image /mnt/vm
VMFS VolInfo: invalid magic number 0x00000000
VMFS: Unable to read volume information
Trying to find partitions But: Do not worry about this error message. The image was mounted on /mnt/vm and accessible without any problem...

UKOUG Tech14 Call for Papers ... Better Hurry!!!

David Peake - Tue, 2014-05-20 14:42

Every year I like getting over to England for UKOUG's conference. This year Joel Kallman, Director APEX Development, will be joining Anthony Rayner and myself at the conference.

I have submitted a few sessions for Tech14 and also a session for Apps14, given they are co-located in Liverpool this year. My Apps14 session is on integrating EBS with APEX, a subject that is near and dear, and one that is gaining significant traction among EBS customers.

Tech14 Call for Papers has just been extended until Tuesday, 27th May @ 10:00 am!
For all you procrastinators out there, you have this weekend to crank out a title and abstract and enter it.

I generally extend my trip by a few days and head down to London to visit with customers and partners. Both Joel and myself will be available for meetings Thursday 11th and Friday 12th December. Let me know if you would like to meet with us.


Oracle APEX 5.0 UI techniques at NYOUG on June 3rd

Marc Sewtz - Mon, 2014-05-19 13:35
Are you ready to give your apps a fresh new look & feel? APEX 5.0 will bring you the Universal Theme and Template Options – a modern, responsive HTML5 theme that takes the guesswork out of choosing the right HTML templates and CSS classes. Thanks to easy-to-use declarative template options, you no longer have to be a HTML/CSS guru in order to create modern and beautiful web applications. 

Want to learn more? Then join us for an APEX 5.0 preview this Friday, May 23 at our first ORCLAPEX NYC Meetup:

And on Tuesday, June 3rd , head over to the NYOUG Summer Meeting at the BMCC on Chambers Street and get an in-depth look at the new UI techniques that will be introduced with APEX 5.0:

New OTN Tour

Hans Forbrich - Mon, 2014-05-19 12:51
For those of you who watch the OTN Tours, here is a list of the big ones this year

Feb 2014 - OTN Yathra by AIOUG (India) ... http://otnyathra.com/
May 2014 - OTN MENA by ARAB OUG ... http://www.otnmenatour.org/
August 2014 - OTN LAD North
August 2014 - OTN LAD South
November 2014 - OTN APAC

I was part of OTN Yathra (fantastic time again, thanks Murali), and have my name in the hat for LAD and APAC.  Unfortunately MENA conflicts with other scheduled events.
Categories: DBA Blogs

Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c

VitalSoftTech - Mon, 2014-05-19 09:50
In Oracle 12c, a new interesting much needed feature, has been introduced which controls the maximum amount of the PGA memory consumed by the user processes. The PGA_AGGREGATE_LIMIT parameter limits the amount of memory used by processes in the PGA.
Categories: DBA Blogs

Middle East & North Africa (MENA) 2014 OTN Tour - Tunis/Riyadh/Jeddah/Dubai

Syed Jaffar - Mon, 2014-05-19 05:44
First ever MENA OTN Tour is scheduled From 26-May to 1-June 2014 in Tunis/Saudi Arabia/Dubai major cities.

2 Continents, 3 Countries, 5 Cities:50+ Action-Packed Oracle Sessions.
Courtesy of the Oracle Technology Network (OTN) and the ARABOUG, the inaugural 2014 OTN MENA Tour brings a star-studded cast, consisting of some of the world's best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. The tour aims at sharing cutting edge knowledge and independent research in the MENA region, by accomplished Oracle experts from all over the world. This is a 100% FREE event for the benefit of the local Oracle communities.

bjoernrostedwardroskeSyedJaffarHussainOsama MustafaMohamedHouriJimCzupyrinskitariqfarooqmikeaultjoelpereshead044InamPic1basheerkhanmohamedcharguiSouhaibAmdouniZarroukHousseMeddingVishnu

ORCLAPEX NOVA Update - Columbus Brings It

Scott Spendolini - Mon, 2014-05-19 05:31

For the upcoming inaugural ORCLAPEX NOVA MeetUp on May 29th, not only will we have Mike Hichwa, Shakeeb Rahman and David Gale from the Reston-based Oracle APEX development team present, but we will also have the entire Columbus, OH based APEX team in attendance, as well: both Joel Kallman and Jason Straub will be in town and have RSVP’ed to the MeetUp!

Outside of major conferences such as KScope or OpenWorld, there is no other public forum that will have the same level of APEX expertise from the team that develops the product present!  So what are you waiting for?  Join the rest of us who have already RSVP’ed to this event, as it’s 100% free, and you’re sure to learn a bunch about APEX 5.0 and other exciting happenings in the Database Development world at Oracle.

Note: you have to be a member of MeetUp (which is free to join) and RSVP to the event to attend (which is also free), as a list of people needs to be provided to Oracle the day before the event occurs.

Interesting info-graphics on Data-center / DB-Manageability

Pankaj Chandiramani - Mon, 2014-05-19 05:21

 Interesting info-graphics on Data-center / DB-Manageability

Categories: DBA Blogs

Openstack with Oracle Linux and Oracle VM

Wim Coekaerts - Fri, 2014-05-16 13:48
The OpenStack Summit has been an exciting event. We announced the Oracle OpenStack Distribution with support for Oracle Linux and Oracle VM, and support included with Oracle Linux and Oracle VM Premier Support at no additional cost. The announcement was well received by our customers and partners. We’re pleased to continue the Oracle tradition of translating our enterprise experience into community contributions as we’ve done with Linux and Xen. Oracle is committed to ensuring choice for both our partners and customers.

A preview of OpenStack distribution (Havana) is now available on oracle.com for Oracle Linux (controller + compute) and Oracle VM (compute). We will follow this up with the production (GA) release in the next several months, including an update to IceHouse and later Juno. (whitepaper)

An OpenStack distribution contains several components that can be grouped into 2 major buckets (a) controller components, such as keystone, horizon, glance, cinder,.... (b) compute components such as nova and neutron. We provide support for the controller components on top of Oracle Linux and as part of Oracle Linux Premier Support. We provide support for the compute components on top of either Oracle Linux or Oracle VM (as part of Premier Support for both products).

By adding the Oracle OpenStack Distribution to Oracle Linux and Oracle VM, we can provide integrated support for all components in the stack including applications, database, middleware, guest OS, host OS, virtualization, and OpenStack – plus servers and storage. Our experience attacking the world’s toughest enterprise workloads means we focus on OpenStack stability, availability, performance, debugging and diagnostics. Oracle OpenStack customers and partners can immediately benefit from advanced features like Ksplice and DTrace from Oracle Linux and the hardening, testing, performance and stability of Oracle VM.

If you have chosen an OpenStack distribution other than Oracle’s, rest assured. Oracle will not attempt to force you to choose our OpenStack distribution by withholding support; we will provide the same high quality Oracle Linux and Oracle VM support no matter which OpenStack distribution you choose.

Furthermore, Oracle will continue to collaborate with Oracle’s OpenStack partners validating with Oracle Linux and Oracle VM. Our goal remains the same: jointly deliver great solutions and support experience for our mutual customers. We also look forward to working with other vendors to certify networking, storage, hypervisor and other plugins into the Oracle OpenStack Distribution.

Finally, we plan to follow a development model similar to the approach we use with Linux and the Unbreakable Enterprise Kernel. Our development work is focused on contributing upstream to the OpenStack community and we will pick up new releases of OpenStack after testing and validation.

It is an exciting time for OpenStack developers and users. We are thrilled that Oracle and our customers are part of it!

UnifiedPush Server 0.10.3 released

Matthias Wessendorf - Fri, 2014-05-16 05:26

The AeroGear UnifiedPush Server 0.10.3 was released to bintray and OpenShift online!

The release contains a few improvements:

  • Improved exception handling for Google Cloud Messaging
  • Generated Code Snippets match the simplified API of our Apache Cordova Push Plugin (0.5.0)
  • Generated Code Snippets for SimplePush match our JavaScript 1.5 release

For feedback, please join our mailing list! We are happy to help


Have fun!


A good use-case for Oracle Ksplice

Wim Coekaerts - Thu, 2014-05-15 12:34
One of the advantages of Oracle Ksplice is that you can stick to a given version of a kernel for a very long time. We provide you with the security updates through our Ksplice technology for all the various kernels released so that there's no need for a reboot and also no need to install a newer kernel version that typically also contains new drivers or even new features. Zero downtime yet you are current. Ksplice updates are always based on critical bugfixes or security fixes, things you really want to apply. We do not use Ksplice to provide new driver updates or new features, it's purely focused on those patches that you really want to apply on your environment without downtime and risk of change.

The typical model for providing kernel errata (security/critical fixes) is through providing a newer version of the latest kernel in a "dot dot" release. For instance, for Oracle Linux 6 if the current latest "Red Hat Compatible kernel" is 2.6.32-431.1.2 and a security issue gets fixed, there will be a 2.6.32-431.3.1 (or so). The sysadmin then has to install the new kernel and reboot the server(s) in order to get that fix to be active. Now these "dot dot" release versions typically only contain security fixes or critical bugfixes so while a reboot is annoying and can have a significant time impact, the actual updates are very specific.

When updated versions of the OS are released (such as OL6 update 1, OL6 update 2,...) however, the change in the kernel can be more significant. For instance when you look at the lifecycle of Oracle Linux 6 with the "RHCK" versions. OL6 GA was shipping with kernel 2.6.32-71, update 1 2.6.32-131, update 2 2.6.32-220, update 3 2.6.32-279, update 4 2.6.32-358, update 5 2.6.32-431. Each of these kernels will have pretty significant changes. Aside from carrying forward the security fixes and critical bugfixes, they typically also contain new device drivers, new features backported into older kernels. In fact, if you look at the changelog of the RHCKs you will see features from kernels as current as 3.x backported into 2.6.32.

In this case, going from one version to another is a bigger deal for some customers that have a very conservative upgrade policy. However to be current with security updates one typically has to go to a newer version in order to get the errata. Security fixes are not backported to all older versions by default, while some vendors have a support option where they will support one or 2 other kernel versions, it's relatively selective.

With Ksplice however, we make the security/critical fix errata available for all the various kernels. Not just one or 2 selective versions. So you can be on any of these kernels, and without the need for a reboot, have the fixes available. That's choice and flexibility. It reduces risk of upgrading to newer kernels to get a fix, it reduces down time to zero and increases the security of your servers.

By the way, 2.6.32-71 was released 03-Jan-2011. Since then there were 45 kernels released (RHCK), with vulnerability fixes and critical fixes, so if you wanted to remain current, that would have resulted in 44 reboots for each server since 2011 (so 3.5 years). With Oracle Ksplice, you could still be running that 2.6.32-71 kernel from January 2011, without any reboot and be current with your CVEs. Imagine having 100's, if not 1000's of servers... time saved, cost saved...

To give you a concrete example, here is a list of all the different kernel versions (RHCK) for Oracle Linux 6 :


With Oracle Linux and Ksplice you could be running -any- of the above kernel versions in your production environments when a security vulnerability gets fixed, we will make a fix available for all of the above.

Here is a list of the latest Ksplice update packages for Oracle Linux 6 with RHCK, as you can see, all the kernels are there :



Subscribe to Oracle FAQ aggregator