Guide to PeopleSoft Logging and Auditing – Revised Whitepaper

After discussions at Collaborate2017 with several PeopleSoft architects we have revised our Guide to PeopleSoft Auditing. The key change is the recommendation NOT to use PeopleSoft’s native database auditing and to instead use Oracle Fine Grained Auditing (FGA). FGA comes free with the Enterprise Edition of the Oracle RDBMS and, not only is it easier to implement, FGA does not have the performance impact of PeopleSoft’s native auditing.

If you have questions, please contact us at info@integrigy. (more...)

Oracle Database on the Docker Store

You probably know that there’s an official github repository storing Dockerfiles and samples to build Docker images for Oracle products and Open Source projects. Now Oracle takes one more step to support Docker. Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store (you can read the official announcement). Oracle Linux was already on the Docker Store. Oracle Database Enterprise Edition, Oracle client tools, Oracle Weblogic, Oracle (more...)

Is Oracle Database 12.2 really Oracle Database 13.1?

I wrote a post a few months ago where, amongst other things I mentioned my views on Oracle database versions, releases and patchsets. To summarise my points.

  • What we used to know as releases (12.1, 12.2) are now so big they are essentially new major versions, despite what the version numbers suggest. That’s reflected both in the content and the time between them.
  • What we used to know as patchsets are now more (more...)

Setting up a development environment

I'm setting up a new development environment so I can do some development with JavaScript, ApEx and REST.

Gitlab on Raspberry Pi
I've a Raspberry Pi 3 and followed the installation instruction on After the installation I have a working gitlab on the Raspberry and I created new projects inside gitlab. 

Pre-installed appliance
I've downloaded the "Network Applications VM" from Oracle Technet. The appliance contains the following: 
  • Oracle Linux 7 
  • Oracle Java JDK (more...)
  • April Roundup: OAUX team attends action-packed events

    It’s conference season, and that means members of the Oracle Applications User Experience (OAUX) team are traveling the globe: doing research with users, working with Oracle partners to make sure customers get the best user experience possible, and sharing our thought-leadership messages.

    Attendees at COLLABORATE17 participate in an activity at the OAUX onsite lab.

    COLLABORATE17: Earlier this month, the OAUX onsite lab headed to COLLABORATE17, a technology and applications forum for Oracle users in (more...)

    How to create dashboard with Netezza database

    IBM Netezza is the part of IBM PureSystems – expert integrated systems with built in expertise, integration by design and a simplified user experience.

    Are you using Netezza for your data marts or data-warehouse? If so, build your Free Netezza data dashboard software.

     Netezza dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Netezza SQL reporting reporting, it's a (more...)

    Submitted two abstracts for Oracle OpenWorld 2017

    I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together:

    • Python for the Oracle DBA
    • Toastmasters for the Oracle DBA

    I want to do these talks because they describe two things that I have spent time on and that have been valuable to me.

    I have given several recent talks about Delphix. Kyle Hailey let me use his slot at Oaktable World in 2015 which was at the same time (more...)

    New blog platform soon !

    We’re moving to a new platform in the next few days.

    Do not expect significant changes, however comments posted from now till migration will not be migrated.

    OAM WebGate is released

    By Mike Campbell 

    The OAM WebGate is released today. This patch is available for the following platforms/webservers:

    •  Linux 64-bit - iPlanet/OTD, OHS, Apache 2.2, & Apache 2.4
    •  Solaris Sparc 64-bit - iPlanet/OTD & OHS
    •  Windows 64-bit - OHS & IIS
    •  AIX - OHS
    •  HP-Itanium - OHS
    •  Linux 32-bit - OHS
    •  Solaris 64-bit - iPlanet/OTD & OHS

    OAM WebGate Released via MOS Patch: 21118593

    OAM is released

    By Mike Campbell

    The OAM is released today. This patch is a **Suite Bundle Patch** containing other products and its suite patch description may not match with the version of Oracle Access Manager it contains:  

    OAM Released via Oracle Identity Management Suite Bundle Patch MOS Patch: 25654150
    This release is identified as Patch 25348595 within the Identity Management Suite Bundle Patch.


    Bundle Patch Updates for Oracle WebCenter Content 12c have been released!

    The first Bundle Patch Updates for Oracle WebCenter Content, and have been released.

    These Bundle Patches are available from the My Oracle Support | Patches & Updates section.

    Supported Platforms: See Oracle Fusion Middleware Supported System Configurations

    Oracle WebCenter Content
    Patch 25694492

    Bugs Resolved by This Patch:

    • 23753742: Checkin Not Working With DCL
    • 25635957: csSystemCodeExecutionError (more...)

    VirtualBox 5.1.20

    VirtualBox 5.1.20 has been released!

    The downloads and changelog are in the usual places.

    The installation on macOS Sierra and Oracle Linux 6 hosts went well and all seems to be working OK there.

    I’m not 100% sure about the Windows 7 host though. The installation itself went fine, as did the installation of guest additions on a Linux VM running inside it. After a restart of the VM I attempted to do (more...)

    SQL-on-Hadoop: Impala vs Drill

    SQL-on-Hadoop: Impala vs Drill

    I recently wrote a blog post about Oracle's Analytic Views and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I'm expanding a little bit on my horizons by looking at how to effectively query data in Hadoop using SQL. The SQL-on-Hadoop interface is key for many organizations - it allows querying the Big Data world using existing (more...)

    Why Partners like Essbase

    Essbase ("Extended Spread Sheet dataBASE") helps you extend and differentiate your analytics solutions: especially for existing Oracle BI partners and using the new Oracle Analytics Cloud with Essbase.

    Most analytics tools are essentially “Read-Only” – that is why Excel is so popular, because it lets you input data, work on it with formulae, and then analyse it. But, spreadsheets are essentially 2-dimensional (row-column) and single user. People often try (more...)

    Oracle Critical Patch Update for April 2017 Released

    The Critical Patch Update for April 2017 was released on April 18th, 2017.
    Oracle strongly recommends applying the patches as soon as possible.

    The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important documents. Supported products that are not listed in the "Affected Products and Components" (more...)

    Live Twitter Chat on Headless CMS – Tomorrow!

    You are invited! Have you heard the term "headless CMS" going around? Decoupled/headless CMS architecture is rising in popularity in the development world and we want to hear from you! If you have something to say about headless CMS or WCM, if you have questions on this topics, if you have experience working with coupled or decoupled CMS or WCM, if you've been following the discussions on this topic or if you are just interested (more...)

    Training On Demand for EMEA partners: Oracle Service Cloud, May 2017

    The Oracle Service Cloud (RightNow) Implementation Camp was created to enable partners with the implementation tools and methodologies required to implement solutions to their clients with an advanced level of understanding of the technology, its features and its market preparedness. The course will cover a wide range of topics to give each student a basis of understanding of the product. Each student will learn the key points in each topic area, and will learn how (more...)

    Advisor Webcast: Setup & Troubleshooting Strategies in Oracle Advanced Collections

    Webcast_icon.jpgSetup & Troubleshooting Strategies in Oracle Advanced Collections

    Date: April 27, 2017 10 am ET, 7 am PT, 4 pm CET, 7:30 pm IST

    This one-hour Advisor Webcast is recommended for Advanced Collections users who would like to learn more about how to setup and troubleshoot Strategies in Oracle Advanced Collections.

    Topics will include:

    • How to setup Strategies
    • Troubleshooting tips on Strategies issues
    • Q&A

    Details & Registration via the My Oracle Support Community thread:  Advisor (more...)

    Come to the UKOUG PeopleSoft Roadshow

    The UK Oracle User Group PeopleSoft Roadshow is nearly upon us. It’s my favourite PeopleSoft event in the UK’s calendar as you know that everyone there has a focus on PeopleSoft and the agenda is always really strong.

    It’s 26th April (yes, a week today!) in the Crowne Plaza, London – the same as last time, which was a great venue.

    Oracle US Speakers

    In terms of Oracle speakers, we’re spoiled this year with (more...)

    Bundle Patch Update: Oracle WebCenter Content has been released!

    A Bundle Patch Update for Oracle WebCenter Content has been released.

    This Bundle Patch is available from the My Oracle Support | Patches & Updates section.

    Oracle WebCenter Content
    Patch 25751735

    Supported Platforms:

    See Oracle Fusion Middleware Supported System Configurations

    Bugs Resolved by This Patch:

    • 16681273 (more...)