Wednesday, August 31, 2011

Oracle Priority Service Infogram for 31-AUG-2011


A quick rundown on security at PSoftPros: An Introduction to PeopleSoft Security

Bored with your PeopleSoft GUI? Here's a posting at the PeopleSoft Technology Blog on getting some excitement in there (well, other than having it offer a 'give me a raise' button, that is): Creating a Great User Experience in PeopleSoft.

And an official, suitable for framing press release on some of the new features: Oracle Updates Oracle’s PeopleSoft HCM 9.1 with the Release of New Features.


Speaking of releases, from NEWSBYTES: Oracle rolls out latest version of on-demand CRM .


Invisible indexes are a really splendid 11g feature, something you had to spend a whole lot of money to do using a third party app in past versions, and I wanted to make sure our customers explored it. It's a form of conditional index you can use in delicate situations (like performance problems on prod). From Yet another DBA blog: Invisible Indexes in Oracle 11g.

Richard Foote wrote up a nice demo of Jonathan Lewis' article on BLEVEL 1 => BLEVEL 2. Just the kind of hands on, techie approach that wins the day.


Into each life, a little rain must fall, sometimes in the form of a service failing. Middleware Magig discusses: Managing Failure Conditions in a WebLogic Environment.


Data Masking

Data masking can be invaluable. There's no better model of production than production. But often you can't use it because of the sensitive data. Good data masking can preserve the 'shape' of the data while sanitizing content. Read about it at the Oracle Enterprise Manager blog: Overview demo of Oracle Data Masking solution - Safely use production data for development, testing and sharing with partners.


This week at the Oracle E-Business Technology blog:

Tuesday, August 30, 2011

E-Business Suite ATG Advisor Webcast

E-Business Suite - RAC & Parallel Concurrent Processing (PCP)
· Overview of RAC
· Overview of Parallel Concurrent processing
· PCP with RAC: How it works
· Configuration
· Failover/failback scenarios and examples
· Common Issues and troubleshooting

Session Details:
EMEA / APAC session:
Tuesday, 13-September-2011 at 10:00 am CET, 01:30 pm India, 05:00 pm Japan, 07:00 pm Australia (Sydney)

US session:
Wednesday, 14-September-2011 at at 17:00 UK / 18:00 CET / 09:00 am Pacific / 10:00 am Mountain / 12:00 Eastern
For Registration- and Dial-In Details, please log in to My Oracle Support to see Note 1342343.1

For any other Advisor Webcast scheduled for the Applications Technology Group of the E-Business Suite, please check Note 1186338.1.

Friday, August 26, 2011

Contributions by Angela Golla, Infogram Contributor

High Availability Best Practices
Oracle has released a new whitepaper on HA Best Practices for RDBMS 11g R2. It is a comprehensive document with in depth technical information on how to get the most out of your HA environment. Check it out at:

Wednesday, August 24, 2011

Oracle Priority Service Infogram for 24-AUG-2011


Online Apps DBA gives other Oracle users a heads up on something they encountered: WebLogic Startup fails with Unable to obtain lock on Server may already be running.

RDBMS Performance

Craig Shallahamer, an author of many articles and books on Oracle performance over the years, posts this article at his A W i d e r V i e w blog: Why tuning oracle works and modeling it. Give it a read and tell Craig your thoughts.

Always one of the joys of performance (well, for engineers, anyway), trace files come in many flavors. the Structured Data blog gives us a new angle: Creating Optimizer Trace Files.

Computing and the Future

Ok, so it wasn't in our labs, but this is seriously cool: IBM unveils chips that mimic the human brain


Shay Shmeltzer's Weblog has a few semi-sneaky tricks in the realm of Java Class and UML Modeling with JDeveloper. Did you know that many people never do a full, proper design process the way we did in the 'good old days'? I am shocked.


The Oracle DBA – Tips and Techniques blog posted a useful method for GoldenGate users: Using the GoldenGate column conversion functions - CASE and EVAL.


Martin's Blog is subtitled 'Another Oracle DBA blog'. I like that, though I probably would have used YAODB (Yet another...). It seems a very useful part of the crowded field, though. Here's a link to Martin's article on Essential tools for Exadata performance experiments.


Oracle WebCenter Content Alerts blog lets us know that the next quarterly customer update is rolling around soon.


This week at the Oracle E-Business Suite Technology blog:

Reminder: ATG Live Webcast Aug 24: Tuning All Layers of E-Business Suite (Part 1)

Managing EBS 12 Physical Standby Databases with Oracle Data Guard Broker

ATG Live Webcast: Tuning All Layers of E-Business Suite


The Cubegeek discusses Attribute Drilling and In 2 Hyperion fills us in on: How to Maximize Excel by Using Customer Functions.

Book Reviews

Charles Hooper brings us a very detailed review on the new edition of Beginning Oracle SQL at his Charles Hooper's Oracle Notes blog.

Also of interest is this review of Oracle on Amazon Web Services and Rackspace Cloud over at the One Size Doesn't Fit All blog.

Oracle Supply Chain News

Supply Chain Best Practices at Oracle OpenWorld 2011
Oracle senior vice president Rick Jewell outlines the overall direction for Oracle supply chain management strategies in a keynote session at Oracle OpenWorld 2011 on Monday, October 3. Additional sessions focus on key business issues and solutions for manufacturing companies in today's uncertain business environment, along with supply chain best practices in complex global business environments.
Read More

Oracle Slated to Introduce New Electronic Kanban Capabilities
Oracle is expected to announce that new electronic Kanban, or eKanban, features will be included in an upcoming version of Oracle E-Business Suite designed to improve the flow of resources in manufacturing operations.
Read More

New Safeguards Protect Workers in Hazardous Areas
An upcoming release of Oracle Enterprise Asset Management is slated to include additional controls for protecting maintenance and technical workers against accidents in hazardous environments.
Read More

Monday, August 22, 2011

Contributions by Angela Golla, Infogram Contributor

Advisory Webcast: Making EBS Upgrade From 11.5.10 Easier
A successful upgrade requires careful planning, correct upgrade processing, detailed testing, and user (re)training prior to upgrade. There are a number of tools available via My Oracle Support and as part of the E-Business Suite product offerings to assist customers in a successful upgrade. To learn more about these tools and how to use them, join us for a two part webcast series, Making The EBS Upgrade from 11.5.10 Easier available at Note:1342291.1. The first webcast will be on September 8, 2011 at 8:00 a.m. Pacific.

Overview of Tools Available for Upgrading
Upgrade Community
Upgrade Product Information Center Page
Detailed Look at Upgrade Advisors
Detailed Look at Patching and Maintenance Advisor

Wednesday, August 17, 2011

Oracle Priority Service Infogram for 17-AUG-2011


Over at the PeopleSoft Technology Blog this week there's a peek into the future: Related Content Framework--Great Things Happening.

Enterprise Computing

A couple of interesting posts from Kevin Closson of late, both of them looking back at the past while keeping up with the cutting edge of high powered systems of today:



At In Depth Apps - Oracle eBusiness Suite - Gareth Roberts we have some useful material on how to Track and Trace E-Business Suite Concurrent Request - EBS Logs, O/S Process IDs, Locks.

Over at the Oracle E-Business Suite Technology blog this week:


An overview of Oracle Audit Vault over at OracleApps Epicenter.

Performance (and how to maintain it, and your sanity)

Over at Coskan's Approach to Oracle there a really nice technical rundown on what can happen to your I/O when you move from 10.2 to 11.2 without enough of the right kind of testing: What happens, when you did not do a load test before release upgrades ?. The I/O display is a colorful picture, but pretty only in a very abstract sense. If it's your system, it's not pretty at all. And it's loud, with all those application managers and directors yelling at your over the phone and around your desk. Take home lesson: You can get some great improvements from upgrading the RDBMS, but you can also produce some really bad short term situations. Please test thoroughly! And yes, this may require a battle with some of the other divisions in your company, but if you can get across to them that it is precisely their interests at risk, they may wise up and give you the time and resources you need.


Okay, I don't know a whole lot about SOA, but the folks at A-Team - SOA sure do, and they want to tell us about Coherence in SOA Suite 11g.

Oracle Support

An outstanding listing of self-help (and help us help you) resources at Chris Warticki's Blog - Oracle Support: 8 Habits of Highly Effective Oracle Support Users.


Structured Data has a run down on: Sessions By OakTable Members.


Some interesting material over at a blog I haven't posted from before: iMERGE Group : Bhavik Fuletra : (OCE)


Education is expensive, but Stanford seems to be giving away a valuable course for techies for free: Introduction to Databases. I particularly recommend this kind of course for non-DBAs. Application developers often don't understand what the DB is capable of and try to stuff all the functions into the code, to the determinent of both. If they understand the logic of the relational model, etc., they can design and write better code.

Links to Links

Finally this week a link to Log Buffer #233, A Carnival of the Vanities for DBAs, a blog with a similar links to the links format as the Infogram.

Friday, August 12, 2011

Contributions from Angela Golla, Infogram Contributor

Java Magazine
Oracle has just launched Java Magazine. This publication, which is designed from the ground up to fulfill the full reader-engagement promises of digital publishing, is an essential source of knowledge about Java technology, the Java programming language, and Java-based applications for people who rely on them in their professional careers, or who aspire to. Subscribe to this important publication here.

Wednesday, August 10, 2011

Contributions by Angela Golla, Infogram Contributor

New PeopleSoft Time and Labor Resource
Check out the new PeopleSoft Time and Labor Support Newsletter, Note:1338875.1. It contains information on the Approval Workflow Engine, HCM 9.1 Bundle 16 highlights and Health Checks. You can also subscribe to have upcoming newsletters sent to you.

Oracle Priority Service Infogram for 10-AUG-2011


Kevin Closson, one of our long-time favorite bloggers, cuts through some of the forming fog around Exadata with this posting: Exadata: It’s The World’s Fastest Database Machine And The Best For Oracle Database – Part I. Do As I Say, Not As I Do!

...and speaking of favorite bloggers on Oracle, there is the start of much anticipated series from Tanel Poder on Exadata here: Are you getting the most out of your Exadata performance? Part 1.


Oracle's Linux Blog announced that: Oracle Linux 5 update 7 is on edelivery.


Now if only they could tell me how to get iTunes to not produce scads of music duplicates everytime I change out an Apple device.

The Upgrade your Database - NOW! blog has some words of wisdom on: DBMS_SCHEDULER jobs stuck after upgrade to 11.2? Check this parameter!

Sokrates on Oracle discusses ORA-8103s, with pointers to Tanel Poder's invaluable blog.

I don't think we linked to this series on index organized tables at Martin Widlake's Yet Another Oracle Blog previously, so better late than never: IOT Part 4 – Greatly Boosting Buffer Cache Efficiency.


Hotsos has historically held the best Oracle performance symposiums, and they are open for early purchasing rates for the Symposium in March 2012.


Interested in Oracle Solaris 11 Express? Here's a good place to start: First Steps with Oracle Solaris 11 Express.


Online Apps DBA has an article on: How to reset Lost Oracle WebLogic Password for Fusion Middleware Applications. I want to stress, as I often do, that you always want to test on other systems before moving to prod and, in an operation that may involve multitiered security changes as one often encounters in Fusion and WLS, it doesn't hurt to get Oracle Support involved if you have any questions or doubts whatsoever.

Did you know there's a weekly WLS update over at the The WebLogic Server Blog? Here's the latest: WebLogic Weekly for August 1st, 2011 - New exam, Exalogic go-live and more.


As we announced previously, Java 7 is out, and people are beginning to identify some of the features they like best in it, like this posting over at 7 new cool features in Java 7.


Can't sleep nights wondering what's in all those PeopleSoft tables? Yeah, thought so. Still, this posting at Peoplesoft /Oracle tips points out a handy reference: PeopleTools Table Reference.


A good reminder on OBIEE and Websphere in this posting from Rittman Mead Consulting: OBIEE 11g Statement of Direction for IBM Websphere.


Cameron, over at Cameron's Blog For Essbase Hackers, is pretty happy about our upgrade advisor from to If Cameron is happy, I'm happy. Read about it here: More cool free stuff from Oracle, upgrade edition

Data Mining

Over at the SmartData Collective there is an article taking a First Look at the latest Oracle Data Mining Update.


The latest from the Oracle E-Business Suite Technology blog:

Summary of Oracle E-Business Suite Technology Webcasts

Latest DSTv16 Timezone Patches Available for E-Business Suite R12

Internet Explorer 9 Certified with Oracle E-Business Suite

Why Does EBS Integration with Oracle Access Manager Require Oracle Internet Directory?

Thursday, August 4, 2011

From Profit Online

Five Ideas: Supply Chain

Oracle customers extend their idea of what “supply chain management” means in order to gain more control over volatility. Find out how that's helping them do new and exciting things in their businesses.

Seven Myths about HCM and the Cloud

A number of potential “gotchas” still exist when moving HR applications to the cloud. They range from unanticipated integration costs to lingering concerns about cloud security and privacy. So where do cloud myths end and realities begin?

Wednesday, August 3, 2011

Oracle Priority Service Infogram for 03-AUG-2011


The Java Source lets us know that Java SE 7 is officially here: Java SE 7 Is Here! Please remember that for our software, as for any software, test, test, test before turning it loose in production.


Another new arrival at the Oracle household is OES. The Identity Management blog lets us know about a webcast on that: Oracle Entitlements Server (OES) 11g Webcast Q&A.


Bring in the clones...just like in the song. Actually the song was bring in the clowns. But clones are more useful for a DBA, and a DBA sees enough clowns at meetings. Good posting on the utility of cloning at the blog: In Praise of Clones.

Of course another thing to think about when proliferating databases is how big they are, and there are some complexities to that not handled by some of the standard scripts. The Global Oracle Contractors Network blog talks about some of the items you'd expect to count, and a few that can bite you if you don't factor them in: How big is my Oracle database.


The lengthily named Preferisco - thoughts about Oracle, EAI/ETL and more blog discusses a spot to look out for when coding MySQL (especially if you're new to it and have been working with Oracle for some time): MySQL Group By is a little too indulgent

A renewed discussion on how to Show PDF in a popup: ADF 11g at the Amis Technology blog.


The July Edition of Oracle E-Business CRM Support Newsletter is now available


The PeopleSoft Technology blog fills us in on Using Feeds in PeopleSoft.

...and this posting is of interest to those using PeopleSoft and Hyperion together:

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.