Oracle Priority Service Infogram, 28-FEB-2013

Java

From the Alexey Ragozin blog: Remote code execution in Java made trivial.

SOA

From SOA Proactive Support: How to Configure Multiple Authentication Providers for Oracle SOA Suite Human Workflow.

Performance

From the ORACLE DIAGNOSTICIAN: Efficiency-based SQL tuning.

At Kevin Closson's Blog: Platforms, Databases and Storage Platform, Database and Storage Topics Blog: Using Linux Perf(1) To Analyze Database Processes – Part I.

Several bloggers and residents of the tweetosphere noted this posting by Carlos Sierra at Oracle SQL Tuning Tools and Tips: About TKPROF, Trace Analyzer and Method-R Profiler.

Linux

At Technet: How to Configure the Linux Out-of-Memory Killer.

WebCenter

Kyle's Blog on WebCenter Content fills us in on: Conversions in WebCenter Content.

OIM

Oracle's Identity Management blog is letting everyone know about an interesting conference coming later this year for those in the healthcare industry: See you at HIMSS 2013?

Also from Identity Management comes this posting on User Management for Databases (UM4DB).

Security

From the OTN Garage: Do YOU Know Where Your Data Has Been?

Data Mining

Stepping right in to the middle of a series over at Brendan Tierney - Oracle & Data Mining Blog, here is a link to Clustering in Oracle Data Miner–Part 3. We leave it as an exercise to the reader to track back to part 1.

BPM

Over at RedStack: Collecting diagnostic information for BPM.

And over at CONFESSIONS OF A SOFTWARE DEVELOPER, BPM: how to time out synchronous calls to external services?

Troubleshooting

At Ora-600, a detective tale of recovering from an error. I would add one caveat: When in doubt, take it to Support. If you open an SR and follow the process you know you are going to stay in the warm and fuzzy realm of being supported. But it's an impressive read: Recover from unusable dictionary indexes in 10g using 11g.

Upgrades

Good note links to keep in a little box on the wall that says 'in case of debacle, break glass'. Database downgrade - MOS useful notes, from Jaffar's Oracle blog.

Book Review

A review of View Updating and Relational Theory Solving the View Update Problem By C.J. Date over at Surachart Opun's Blog.

Contributions by Angela Golla, Infogram Deputy Editor

Check out the new Support videos that focus on Oracle E-Business Suite, JD Edwards, and PeopleSoft. These videos not only walk through the latest enhancements, but also highlight Oracle's ongoing commitment.
• (JD Edwards and Oracle Premier Support) - http://medianetwork.oracle.com/video/player/2127725329001

• (EBS and Oracle Premier Support) - http://medianetwork.oracle.com/video/player/2127755698001

• (PeopleSoft and Oracle Premier Support) - http://medianetwork.oracle.com/video/player/2127766864001

Visit My Oracle Support Note:432.1 to learn more about upgrading to the latest versions of JD Edwards, EBS and PeopleSoft products.

Oracle Priority Service Infogram for 22-FEB-2013

SOA

At OTN: Fanning Out Events on the Oracle SOA Suite 11g Event Delivery Network.

RDBMS Performance

The Oracle at Delphix talks about Oracle I/O latency monitoring.

Also at Delphix, an answer to the plaintive cry we've all heard: Why does my full table scan take 10x longer today ?!

From the master of taking Oracle binaries apart and seeing where all the gears mesh, TANEL PODER'S BLOG: IT & MOBILE FOR GEEKS AND PROS: Peeking into Linux kernel-land using /proc filesystem for quick’n'dirty troubleshooting.

PeopleSoft

Have you checked out some of the PeopleSoft Advisor Webcasts lately?

And from Linda Harmon-Corniola:

Check out the PeopleTools 8.53 documentation on our newly redesigned Hosted PeopleSoft Online Help (PeopleBooks) Site.

And also:

PeopleSoft Online Library

Tech Updates are posted on a regular basis. Announcements may contain news about new certifications, end of support or third party retirement notices as well as any other platform related information.

Hyperion

A couple of goodies lately from Essbase Labs:

Data Input Template with Smart View and Planning

and

What’s New with Smart View.

MySQL

Performing Full-text Searches in MySQL 5.6 from Database Journal.

Enhance Your MySQL Skills with Virtual Developer Day: MySQL - March 12th - Posted by OTN.

Exalogic

From the WebLogic Partner Community EMEA blog: ExaLogic new material.

Oracle Support

Chris Warticki's Blog - Oracle Support reminds us to take an occasional look at upcoming Customer Resource: Events.

OVM

At OTN, a nice technical article: Sysadmins Rejoice! OVM 3.2.1 Includes a Full-Featured CLI. Of course I included it mainly for the references to Monty Python.

WebCenter

Oracle WebCenter Alerts lets us know about an upcoming event: Product Support Webcast for Existing Customers: Framework Folders for WebCenter Content 11g.

Blog of Note

Ms Yin-Jen Su recommends keeping a link established to the Oracle Security Inside Out newsletter. Sagely advice, in this age of hack and counter-hack.

Java

Better life through robots, Java and a Myriad of Toys! at The Java Source.

...And Finally

Have a Kindle and Amazon Prime? You can borrow books, lots of them, but only one at a time and one a month. Here's how to find the goods, at lifehacker: How to View the Entire Free Kindle Lending Library from Your Browser.

Contributions by Angela Golla, Infogram Deputy Editor

Oracle Newsletters
Oracle has a wealth of online magazines and newsletters to keep you informed.  You can subscribe to them here. 

Support specific newsletters are a vailable at Note:222.1.

Oracle Priority Service Infogram for 13-FEB-2013

Big Data

RDX discusses how Big Data Mining Can Strengthen the Security Model.

From OTN: How to Set Up a Hadoop Cluster Using Oracle Solaris Zones

PeopleSoft

A good article on the 8.5.3 PeopleTools release from the Oracle PeopleSoft Technology blog recommended by Linda Corniola: Oracle and PeopleSoft Development Announce the General Availability of PeopleTools 8.53.

Performance

At the Oracle Scratchpad, Jonathan Lewis discusses a string of useful and entertaining acronyms: STS, OFE and SPM.

Security

At Beyond Oracle: Protect your servers against brute force SSH attacks.

BPM

At RedStack: Collecting diagnostic information for BPM.

GoldenGate

At Oracle DBA – Tips and Techniques, GoldenGate Integrated Capture Mode.

Bugs

The Momen Blog discusses: Bug: ORA-00979: not a GROUP BY expression.

OBIEE

An announcement from the Oracle Business Intelligence Blog: OBIEE Bundle Patch 11.1.1.5.5 Available.

ADF

From the always excellent Andrejus Baranovskis's Blog: ADF BC - Scrolling To The Last Row.

Fragment Template to Fragment Communication with ADF Contextual Events.

At the Oracle Forms Community: Oracle Forms to Mobile is Now a Reality! ADF Mobile Support for Oracle Forms.

Waveset, OIM

A roadmap of the changes from Sun Identity Manager to OIM: migration Oracle Waveset OW, earlier Sun Identity Manager) to Oracle Identity Manager at Online Apps DBA.

SQL

At Oracle SQL: Deterministic function vs scalar subquery caching.

Book Reviews and Announcements

The WebLogic 12c Book is Finally Here at the Oracle Fusion Middleware blog.

At the The PeopleSoft Tipster Blog: Jim Marion's new book.

Contributions by Angela Golla, Deputy Infogram Editor

E-Business Suite Resources
Steven Chan has a great E-Business Suite Blog.  Check it out at: 

http://blogs.oracle.com/stevenChan.  For those of you preparing to upgrade to E-Business Suite Release 12, the following notes have a wealth of information:  Note:1406960.1, Note:1322667.1 and Note:380482.1.    

Oracle Priority Service Infogram for 06-FEB-2013

Data Warehouse

Lots and lots of data, one letter 'R'. From The Data Warehouse Insider: Parallel R: Quick Ways Model More.

WebLogic

Over at Technet, how to Track Down a Memory Leak.

Solaris

Also at Technet is this article on Evaluating Oracle Solaris 11 from Inside Oracle VM VirtualBox.

APEX

Over at Martin Giffy D'Souza on Oracle APEX, Embedding Files within APEX: WORKSPACE_IMAGES vs APP_IMAGES.

RDBMS Performance

We all know the benefits of replacing SQL literals with bind variables, but how do you speed things up if you've already got a bunch of them in the code? Pythian makes a suggestion: regexp_replace: Auto-translate SQL literals to bind vars.

ITIL and the DBA

ITIL is one of the key elements of understanding how Oracle Support does its job, and a major element of any modern IT shop. Here's an article on it from the DBA's perspective at Jobacle (sounds like a labor-related icicle, eh?): What does a DBA really do – in ITIL terms ?

PeopleSoft

It's heeere! Oracle Releases Oracle’s PeopleSoft PeopleTools 8.53.

GoldenGate

At Integrate, Harmonize, Orchestrate with Oracle Solutions, Capture Application Events using Oracle Goldengate.

Security

Oracle Java SE Critical Patch Update for February 2013

The Oracle Java SE Critical Patch Update for February 2013 was released on February 1st, 2013. The original Critical Patch Update for Java SE was scheduled on February 19th , but Oracle decided to accelerate the release of this Critical Patch Update because active exploitation “in the wild” of one of the vulnerabilities affecting the Java Runtime Environment (JRE) in desktop browsers, was addressed with this Critical Patch Update. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents.

Also, it is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches, as this is where you can find important pertinent information.

The Critical Patch Update Advisories are available at the following location:

Oracle Technology Network:
http://www.oracle.com/technetwork/topics/security/alerts-086861.html

Oracle Java SE Critical Patch Update for February 2013:

Oracle Technology Network:
http://www.oracle.com/technetwork/topics/security/javacpufeb2013-1841061.html

The next three scheduled dates for Oracle Java SE Critical Patch Updates are:

• 18 June 2013
• 15 October 2013
• 14 January 2014

Sincerely,
Oracle Security Alerts

Contributions by Angela Golla, Infogram Deputy Editor

Improve Issue-to-Resolution-Time with Demo It To Oracle (DITO)


If you are having problems arranging an OWC with Support to see your problem or issue, DITO (Demo It To Oracle) can help you.  DITO uses CamStudio, a third party desktop recording software that is able to record all screen and audio activity on your computer into standard AVI video files and uses its built-in SWF (Streaming Flash Video) Producer to turn those AVIs into smaller, bandwidth-friendly streaming flash videos.

The idea of DITO is that you can demonstrate your issue for Oracle Support just like you do on an Oracle Web Conference; however, you can do this offline at your convenience without having to arrange for the presence of a support engineer.  You can make the recordings available to Oracle Support by uploading them to your SR in My Oracle Support.

This tool will record the reproducing steps from the customer that will allow Support or Development see what happens without setting up an OWC.
For complete instructions on how to use DITO, please refer to "Ditto It To Oracle" (DITO) CamStudio Help (Doc ID 11.1)