I had the privilege to present with John Klinke of Oracle WebCenter Product Management during a recent webinar. John and I discussed the integrations that Fishbowl and Oracle provide for SharePoint, and instead of focusing on the feature/function of the integrations (connectors), we chose to detail the use cases that (more...)
As usual the latest version can be downloaded here.
The new version comes with numerous improvements and (more...)
If you tuned into last week’s blog post talking I talked about the new release of WebCenter Capture. Well, low and behold Oracle released a new version of OFR.
If you look closely, this a step in the right direction as the verifer component is now available as a web (more...)
“Everything should be made as simple as possible, but not simpler.” – Albert Einstein
I am curious as to why anyone would use ASM for a standalone database as it introduce more complexity of having to install, maintain, and upgrade Grid Infrastructure.
I asked the DBAs and here are (more...)
I just uploaded my DOAG 2013 presentation “Best of Oracle Security 2013“.
This presentation shows how to bypass Oracle Data Redaction, become DBA using CREATE ANY INDEX, Hide information from Oracle Auding using VPD and more…
SQL> select * from scott.credit_card where 1=ordsys.ord_dicom.getmappingxpath((card_id),user,user);
Within the last few months Oracle has released a new version of the WebCenter products (188.8.131.52). With this update there were quite a few significant updates to WebCenter that includes a new UI — built in Oracle ADF, Mobile availability, but one significant update I was excited (more...)
This is a milestone release with some bug fixes but mainly it boasts fantastic enhancements that we are really excited to show the Oracle Business Intelligence (BI) community at large. If you had seen a previous release of BITeamwork you owe it to yourself, your organization, or your clients to (more...)
So there I was, looking for a script to calculate the backup size. After several thoughts, it was not exactly what I was looking for.
Here’s the one I created.
SELECT TO_CHAR(completion_time, 'YYYY-MON-DD') completion_time, type, round(sum(bytes)/1048576) MB, round(sum(elapsed_seconds)/60) min FROM ( SELECT CASE WHEN s.backup_type='L' THEN 'ARCHIVELOG' WHEN s. (more...)
In configuring Golden Gate environments, I always use a separate operating system user. This user tends to be named something along the lines of “ggate” or “gg”. This makes it simple to identify the purpose of the user. However, when installing Golden Gate under a different OS (more...)
First and foremost, thank you to all the bloggers sharing their knowledge.
Free Block Corruption is from a data file block which is now Free but used (more...)
Oracle BI 184.108.40.206 now has the ability to integrate with the well-known entry point for Oracle EPM, Workspace. However, from a browser perspective this integration requires additional plug-in configuration on each user's browser in order to render the interface correctly. Some users already attempting this OBIEE to (more...)
While working with a customer this week, they were testing some audit functionality on the database. The database version being tested was Oracle 11g (220.127.116.11.5). When the user created a table, the entry in the SYS.AUD$ is registered as a CREATE TABLE. (more...)
With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore. One new feature is the new way of installing Oracle Golden Gate. In the past, the installation was simple. Just copy the zip/tar file to the directory (more...)
Ever since I have been working with Golden Gate, I have always installed and configured Oracle Golden Gate under a separate OS users. In most installations, I use a user named “ggate” (makes it easier to identify). As I’ve been setting up a new environment to do some (more...)
At Derbycon 3.0, László Tóth and Ferenc Spala gave a a new presentation “What’s common in Oracle and Samsung? They tried to think differently… ” (Video). The main focus of the presentation was the Samsung encryption and a new framework called sandy but there was also a small (more...)
With the latest Oracle SOA Suite (PS6) the Enterprise Manager has been updated. The first thing that will be noticed is that the look and feel has been changed. However that is not the only difference. While looking for log messages (I was not allowed to log into the server (more...)
First; I’d like to say thanks to all those that attended my presentation and both IOUG and ODTUG for giving me the opportunity to present this year - It was fantastic seeing so many interested in ADF transformation and how we can now use techniques like adaptive and responsive design (more...)