Wednesday, January 26, 2011

Contributions by Angela Golla, Infogram Contributor

"Working Effectively With Global Customer Support" is a document you will want to review periodically for updates. It is available on My Oracle Support in Note:166650.1.

Tuesday, January 25, 2011

Oracle Infogram This WeeK: CPU, Hyperion, PeopleSoft, RDBMS, Linux and VM, ECM, Sun, WLS, Oracle Support


The January Critical Patch Update is available. Read all about it here at the Oracle E-Business Suite Technology blog:

Critical Patch Update for January 2011 Now Available


Boy does this program linked from Cameron's Blog For Essbase Hackers look like a handy tool for Essbase users. As with all outside our firewall, please test carefully (yeah, well, alright, test our stuff too.): Introducing Data Detective


From the PeopleSoft Technology comes this announcement: New version of the PSFT HCM 9.1 OVM Template


An interesting blog I somehow didn't notice before is Oracle database internals by Riyaj. Here's a sample: Books and presentations

From our Oracle Luxembourg XPS on Database team comes this really techie article on Clusterware 11gR2 – Setting up an Active/Passive failover configuration.

Perhaps it's McGyver syndrome, but I somehow picture them doing this in their garage using a set of modified Palm Pilots networked to use the magnetron from an old microwave to calibrate the cluster. The technical challenge is: How to keep production up while using the cluster to nuke a burritto?

Someone else to join the crowd around the microwave is Porus Homi Havewala, author of this article on how to Provision Your Oracle RAC Systems Using Oracle Enterprise Manager over at Technet.

Linux and VM

We're doing some very exciting things with the combined force of hardware, OS, and software. This TechCast Live on Linux and Virtualization with Wim Coekaerts, SVP Linux Engineering is well worth your time.


The Oracle ECM Alerts - Product News & Information blog lets us know that Oracle Enterprise Content Management 11gR1 Patch Set 3 has been Released.


Follow the path from Oracle Technology Network Blog (aka TechBlog) to the OTN Garage blog to find out more about the status and location of Sun Microsystems documentation.


At the WebLogic Server blog you might expect to hear about something like WebLogic Server 10.3.4 Released - Key APIs of Java EE 6 and More. Well, you're right. Please give it a read.

Oracle Support

I know that creating an SR can be a bit frustrating at times, especially when the situation is very critical and you don't really want to spend a bunch of time dotting i's and crossing t's under the angry glare of an executive with a down server, but please take the extra moment to fill out the subcomponent field. Not only will it help get the SR triaged to the right team more reliably, but it will generate better statistics for response time within our system.

Tuesday, January 18, 2011

Contributions by Angela Golla, Infogram Contributor

The January / February issue of Oracle Magazine has been released. It contains a wealth of information on MySQL, IT Security and the Oracle Excellence Awards. Check it out at:

Thursday, January 13, 2011

Oracle Infogram This Week: Patching, Exadata, Programming, SOAP, APEX, Hyperion , GoldenGate



There was a recent (Nov. 2010) change in the way nomenclature operates for patching on EPM. Please see this note in MOS for details: Release Nomenclature and Numbering for Oracle EPM Products (Doc ID 1219387.1).


Looking for a Sun patch? (I'm tempted to make some outrageous pun about shady patches, etc., but will show restraint). You can find some info at the Patch Corner blog (yes, they have a blog for that): Searching for Oracle Sun patches in My Oracle Support (MOS).


There are a million stories in the city....thousands on Exadata...dozens on Exadata performance....only one from Tanel Poder on Performance Stories from Exadata Migrations.

Structured Data gives us some insight on Making the Most of Oracle Exadata – A Technical Review.

Programming lets us know that Oracle enhanced adapter 1.3.2 is released.


The ORA-00001: Unique constraint violated blog lets us know about



Triangle Circle Square tells us of something small but elegant to do in APEX: Adding tooltips to your Apex report.

Over at Technet you can find the rundown on Oracle Application Express Web Services Integration, including how to hook things up with Amazon S3, Amazon Store and alien spaceships. Well, two of those, anyway.


This is something that is handy for a lot more than Hyperion. Need a way to wipe out the data in a spreadsheet and leave the shell intact? in2Hyperion shows us how: Removing Data From Excel Templates.


I've said before how much neater GoldenGate is than sliced bread and other innovations and achievements of western civilization. But it still doesn't play nice with absolutely everything in the Oracle universe, particularly compression, at least for now, so please read this cautionary note if you are planning to use GoldenGate (and then use it, because it's still neater than sliced bread): Oracle GoldenGate and Compressed Tables over at Oracle Notes.

Wednesday, January 12, 2011

Infogram This Week: Hyperion, EBS, WLS, Identity Management, ECM, VM, SQL, Performance, SQL Profiler, PeopleSoft


Looking for a way to link Oracle EBS with Oracle EPM (Hyperion) role based security? One of our SDMs found this valuable presentation recently:

To configure EPM System so that all of its functional security can be managed in the EBS UI, follow the steps highlighted in this document “Using EBS to Manage EPM Functional Security".


At the
Oracle E-Business Suite Technology blog this week:

Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

BPEL Certified for Prebuilt E-Business Suite 12.1.3 SOA Integrations

Customized Database Listener Names Now Supported for EBS


Brad Tumy lets us know how to recover from a pretty common and annoying error: forgetting the danged password on WLS: Recover Weblogic server admin password (on Linux).

Over at the
AMIS blog is concept I like: Oracle WebLogic: Configuring DyeInjection Monitor. And please don't tell people I recommended you inject dye into your servers. I know you are tempted some days to just pour coffee down the back of the unit and go home, but please resist the urge.

Identity Management

Talking Identity blog joins the burgeoning discussion of everyone's favorite buzz word of the year: cloud computing, with this article about Oracle's SSO: Future in the Clouds? How About Some ESSO-To-Go?


Oracle ECM Alerts - Product News & Information let's us know that the latest Quarterly Customer Update Webcast is coming up.


Wim Coekaerts Blog brings us some handy info on Using Solaris zfs + iscsi targets with Oracle VM.


We usually post links to valuable internals material from
Tanel Poder, this time around it's just some fun. Take a look at these oddments: Is this valid SQL syntax? :-).


Oracle performance legend
Jonathan Lewis takes on the heavy topic of cost once again: Cost – again .

SQL Profiler

I never thought of this, but
Kerry Osbourne did, and it's something worth checking into with your Oracle Sales folks. SQL Profiler is part of an add-on pack, not the RDBMS itself: Licensing Requirements for SQL Profiles.


There's a New PeopleTools Developer Book Available. See the link on Oracle's own
PeopleSoft Technology Blog.

Tuesday, January 11, 2011

Contributions by Angela Golla, Infogram Contributor

RDA 4.22 has been released. It contains many enhancements across the Oracle product line. Check out Note:414970.1 for more information.

Wednesday, January 5, 2011

Oracle Infogram This Week: Performance, OOW, EBS, APEX, Security, Coding, Fusion Middleware


Getting back to the basics of performance from James Koopmann over at Using the Oracle Performance Method.

Part II in a series by Craig Shallahamer over at his A W i d e r V i e w blog on IO Read Wait Occurrence Mismatch.


This week at Oracle E-Business Suite Technology:

ATG Live Webcast Event - EBS 12 OAF Rich UI Enhancements

The Eight Most-Important EBS Techstack Stories of 2010


Missed OpenWorld? At least you can find some of the materials from OOW on on Technet: Enterprise Manager Oracle OpenWorld 2010 Content.


David Peake brings us the latest kick-the-tires, neater than sliced bread demo page for APEX new features: 4.0 New Features Application.


Well, another week, another hulking vulnerability out of the blue: Telephony. Other than the obvious threat of human engineering which has been the classic platform for use of the telephone for nefarious purposes there is now a more direct, technical risk. Read about it from ComputerWorld: Recalculating the telephony security equation

Data Warehousing

The RNM blog came up with a whitepaper I had not seen before: Oracle Whitepaper – “Best Practices for a Data Warehouse on Oracle Database 11g”


Over at the Code of Our Lives blog there's a useful technique for Adding CLOB values to XML as CDATA.

Fusion Middleware

A good thorough rundown on basics and methods involved in: A Role-Based Approach to Automated Provisioning and Personalized Portals over at Technet.

Tuesday, January 4, 2011

Contributions by Angela Golla, Infogram Contributor

The end of Database release 10.2 Premier Support poses many questions for customers. Note:11303271 attempts to pull together all the most important information customers need to know regarding the transition of 10.2 from Premier Support to Extended Support.

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.