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.
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 126.96.36.199 Enterprise Edition, Oracle client tools, Oracle Weblogic, Oracle (more...)
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...)
I've downloaded the "Network Applications VM" from Oracle Technet. The appliance contains the following:
Attendees at COLLABORATE17 participate in an activity at the OAUX onsite lab.
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...)
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.
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.
By Mike Campbell
The OAM WebGate 188.8.131.52.170418 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 184.108.40.206.170418: Released via MOS Patch: 21118593
By Mike Campbell
The OAM 220.127.116.11.170418 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 18.104.22.168.170418: Released via Oracle Identity Management Suite Bundle Patch 22.214.171.124.170418 MOS Patch: 25654150
This release is identified as Patch 25348595 within the Identity Management Suite Bundle Patch.
VirtualBox 5.1.20 has been released!
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...)
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...)
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...)
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...)
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...)
Setup & 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
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...)
Bugs Resolved by This Patch: