Wednesday, December 28, 2011

Oracle Priority Service Infogram for 28-DEC-2011


I have to admit that I only watched McGyver once, and only lasted about 10 minutes before my implausibility meter pegged and I switched it off, but the concept of MyGyvering technology is still valid, and here is an instance: APEX app running native on iPhone - the details. Over at Roels Blog. In an ironic twist, the link doesn't run right on iOS devices and you have to go to a different version to get it to display.


There's a session coming up on: Introduction to Troubleshooting EnterpriseOne Performance Issues. It's scheduled for January 11, 2011 at 8 am PT, 9 am MT, 11 am ET.


There's a new version of MOS in the works, not Flash and not HTML. I generated this set of hints the other day for a customer, and they apply to the current systems, and probably will come in handy for the next one as well. When you can't get through to MOS or, even more frustrating, have an SR creation process fail, here are some things to try:

  • Toggle between the Flash and HTML versions of MOS
  • Clear cache and cookies in the browser
  • Use another browser
  • Submit a quick 'shell' SR in a couple of minutes to make sure there aren't any timeout issues along the path. You can then edit it to add information to it.
  • Call hub (1-800-223-1711) to find out if there any problems showing up with your CSI, they have the ability to test, look at your account, etc.
  • If all else fails, hub can open a new SR for you.
Proactive Support

Over at Chris Warticki's Blog - Oracle Support is a link to a posting on Good example of Proactive Support from EPM/BI

.Chris has one of the best Oracle Support blogs out there and the daily Oracle News, Info and Support  now as well. Also check him out on Twitter.

Log Buffer

Always a source for good reading, The Pythian Blog hosts the Log Buffer: Log Buffer #248, A Carnival of the Vanities for DBAs.

Oracle Fusion Middleware

Feeling short on newsletters at this festive time of year? Go on over to the Oracle Fusion Middleware Newsletter.

...and if that didn't slake your thirst for newsletters, try this: Oracle EBS CRM Newsletter Current Edition.


MySQL Workbench 5.2.37 GA Released. Over at the MySQL blog.


Over at Geertjan's Blog there's a good rundown on NetBeans Property Editors for and String Arrays.


In a dangerously self-referential posting the Oracle Solaris team, on the Oracle Solaris blog, reflects on Oracle Solaris in the Year 2011 - A Review.


Scott Nelson's Portal Productivity Ponderings presents us with a warning on a WLS 10.3.x Silent Install Gotcha.

SQL Developer

That Jeff Smith (not the other one, mind you), posts on Top 10 Preferences to Tweak when using SQL Developer 


Gokhan Atil's Oracle Blog posts on Best Practices to Use Database Upgrade Assistan

Book Review: Oracle Core Essential Internals for DBAs and Developers

Charles Hooper does his usual thorough and helpful job reviewing this important resource for those who want to really want to know what is going on under the covers of an Oracle RDBMS.

Wednesday, December 21, 2011

Oracle Priority Service Infogram for 21-DEC-2011


A good intro at OTN: Introducing the Basics of Image Packaging System (IPS) on Oracle Solaris 11.


From Andrejus Baranovskis's BlogHow to set EAR Version for ADF Application on WebLogic.

Just like in the old Dragnet show: 'just the facts, ma'am.': WEBLOGIC 12C (=JAVA EE 6 FULL PROFILE EDITION) AND A SERVER SMOKE TEST at ADAM BIEN'S WEBLOG.


Installation is still a fairly complex activity, but this post can make life a little simpler: Smart View Command Line Install from Essbase Labs.

High Availability/Survivability

As everyone knows, the Mayans predicted the end of the world in 2012, so here's a solution for that (which leaves open the question why Mayan seers seemed to miss the end of their own civilization). Personally I think the Mayans simply let their calendar subscription run out when it came up for renewal a couple of centuries ago. At OTN Garage:  How to Survive the End of the World - Part I (also handy if you want to read about How to Install and Configure a Two Node Cluster, by the way).

Tempus Fugit

The end of the year approaches, and with it the 'best of 2011' articles. Here's one from OTNOur Most Popular Tech Articles of 2011.

SQL Developer

SQL Developer Data Modeler 3.1 Early Adopter 3 is now available.

Please see the links below to download the software and provide any feedback to the team. 

·         EA3 Downloads
·         Bugs Fixed
·         Release Notes
·         New Features


If you have five minutes and a computer with Internet you can get things rolling with NoSQL: Oracle NoSQL Database in 5 Minutes (Charles Lamb's Blog).

My Oracle Support is now LIVE on Twitter!

Twitter is now available on My Oracle Support! For those who are not familiar with how Twitter works; Twitter is simply a way to connect you to the latest information about what you find interesting. Connecting is easy! Just find the public streams you would like to follow and a world of conversations will be open to you. My Oracle Support Twitter will feature topics on Proactive Services, Webinars, My Oracle Support features, and especially the latest information on My Oracle Support Community events and important news.

If you don't have a twitter account, get started now at:

If you do have a twitter account, we invite you to follow the My Oracle Support team for the latest news and information at:

Oracle Linux


A step by step guide: Cookbook creating Business Rule Engine with a simple Decision Table in Oracle SOA Suite, over at the AMIS Technology blog.

Tuesday, December 20, 2011

Oracle Community

Would you like to interact with the extended Oracle community, but don't know where to start? Here's a handy cheat sheet with links to differenct communities along with a short description of each:

  • OTN Forums
    These are legacy forums that have been around for over a decade. Maintained by Development, every product along with features and functions are shared and discussed by our customers. It's in the Oracle domain. Call it free, but it is still part of a customers Premier Support investment. There are millions of threads and users.

  • MOS Communities
    Included as part of a customer's Premier Support investment. There are about 300 or so communities. They are moderated by Support personnel. There are tens of thousands of users. There is a customer knowledge repository where customers upload their own docs, ppts and other user-created FAQ's/Guides.

  • OracleMix
    The operative word here is blend. Where forums are product based, Mix blends products with products or products with industries, or products with whatever you want.
    You can create your own Mix groups, both public or private.
    Some Mix groups include most Products but for example there is a group created specifically for R12 Implementations. Another one specifically for Secure Gov't IdM product users. Anything can be created.

  • Blogs
    Blogs are authored. Blogs are created by Oracle employees externally to communicate messaging around our products, product lines and services.
    Blogs are articles that may include; links, video or other media and invite feedback from the readership and subscribers.

  • Wiki
    Think Wikipedia here.
    The purpose of a wiki is that anyone can create, edit, contribute. Anything.

  • Twitter
    A.K.A. - microblogging. Short < 120-140 character messages that can be broadcast to the world. People choose to follow you and your messages based on keywords, #hashtages, messages or message theme.

Wednesday, December 14, 2011

Oracle Priority Service Infogram for 14-DEC-2011

Blogger of Note

We frequently post items from Jonathan Lewis, so he is our 'Blogger of Note' this issue. He lets us know his wish for a more efficient way to gather stats (Dev, are you listening?): I wish. While you are there, don't miss his home page with its great list of quotes: Oracle Scratchpad.


From the Oracle E-Business Technology blog:


A very seasonal approach to SQL over at the So Many Oracle Manuals, So Little Time blog, based on the old Christmas song and starting from relational algebra: The 12 Days of SQL: 12 Things Every Oracle DBA and Developer Should Know About SQL (Day 1)

Also in the wonderful world of SQL is this posting on Factorial in Oracle SQL – using both new Recursive Subquery and classic Connect By approach from the AMIS Technology blog. Complex and useful.

Continuing the theme of complexities of SQL, here is a posting from Triggers Considered Harmful, Considered Harmful: "Workarounds" for ORA-04091


Some good solid material on the Challenges and Chances of the 11g Query Optimizer at the Striving for Optimal Performance blog.

SQL Developer

A couple of good postings on SQL Developer over at the That Jeff Smith blog:



Check in once in a while on the EPM / BI Information Center, as pointed out in this posting at the Proactive Support EPM and BI blog.


APEX Process Condition with Multiple Buttons over at Martin Giffy D'Souza on Oracle APEX.


Using ATG? Looking at Exalogic? Here's a whitepaper where the two come together.

Big Data

Some videos on Big Data from the experts at The Data Warehouse Insider.

New Releases

Really Cool Stuff Department

I never did anything more audibly amusing in the old days than putting an AM radio next to my 286 AT to listen to the RF coming out of it, but this is several levels of magnitude better than that: (Making a scanner sing) To all those old geeks out there at the Annals of Oracle's Improbable Errors blog.

Monday, December 12, 2011

Contributions by Angela Golla, Infogram Contributor

Customer User Administrators (CUA) control access to My Oracle Support and your CSI numbers for your company. This is important to control access to sensitive information for your SRs. If you are a CUA, be sure to check out Note:238871.1 for information and helpful tips for this responsibility.

Wednesday, December 7, 2011

Oracle Priority Service Infogram for 07-DEC-2011


From the Oracle E-Business Technology blog:

and a few good release 12 notes collected by one of our top SDMs:

New JDE Release Out

Oracle Announces Oracle’s JD Edwards EnterpriseOne Tools Release 9.1

JD Edwards EnterpriseOne delivers a major new release for the JD Edwards EnterpriseOne product line including a next generation user experience for all JD Edwards EnterpriseOne 9.0 Application releases. This is the most significant new release for the JD Edwards application suite in over 5 years!

Background Information

Thousands of organizations around the world rely on JD Edwards EnterpriseOne applications for their daily business operations. Supporting every JD Edwards EnterpriseOne installation is a JD Edwards EnterpriseOne Tools release which delivers a scalable, platform independent, secure and reliable platform for the application modules and the supporting infrastructure technologies from Oracle and other technology companies. Since all JD Edwards EnterpriseOne users interact with Tools through every inquiry, report, and transaction, every JD Edwards EnterpriseOne customer will benefit from improvements to the Tools releases.

These tools releases are designed to be “backward compatible” meaning a customer can apply a new tools release without a corresponding application upgrade. See below for specific backward compatibility details. This allows customers to rapidly add value to their enterprise applications without changes to their business processes.

Tools 9.1 dramatically improves the end user experience for all JD Edwards EnterpriseOne applications

· The traditional left-hand navigation is replaced with modern drop down menus, graphical navigation pages, and a carousel. As a result, users can much more quickly access frequently used applications and reports, report output, and open applications.

· Many improvements to the browser based user interface including a modern look and feel, advance interactive query capability, improvements to the line items grid, and seamless search and select dialogs.

· End user personalization capabilities to increase end user productivity and simplify upgrades by reducing the degree of customizations required. Users have the ability to create, save and auto-execute queries on any JD Edwards EnterpriseOne application form. They can also interactively create custom grid formats to meet their requirements including the ability to hide, show, freeze, and unfreeze columns in the grid.

Tools 9.1 continues to lower the customer Total Cost of Ownership

· Improvements which leverage the certification of the JD Edwards EnterpriseOne Application Management Suite for Oracle Enterprise Manager 12c. In addition to prior support for proactive system monitoring and administration, Tools 9.1 provides additional details on the processes running on the JD Edwards server including mission critical call object kernel and batch processing.

· To simplify the process of configuring High Availability solutions for a JD Edwards EnterpriseOne implementation, several new server clustering options are available including the clustering of the Business Services Server (BSSV) and the Real Time Events Transaction server (RTE). Also, Oracle Active Data Guard has been certified to provide a disaster recovery solution for the JD Edwards database.

· Improvements to system Performance and Scalability. The embedded Oracle BI Publisher reporting capability is improved to handle very large (>2GB) reports. A faster table conversions process was added to support the faster conversion of database tables during an application upgrade. Also, complex database join operations against large data sets execute much faster in many cases, such as the Customer Service Inquiry application.

Tools 9.1 further leverages the technology stack

· Certification of the latest Oracle technology stack components, including Oracle Solaris 11 and Oracle Fusion Middleware 11g PS4

· Uplifted certification of browser technologies including Internet Explorer and Firefox

· Certification of latest server infrastructure technologies from IBM and Microsoft, including AIX 7.1, Windows 7 and Visual Studio 2010.

Key Facts

· Available as part of standard maintenance, JD Edwards EnterpriseOne Tools 9.1 is available for Application releases 9.0 including Updates 1 & 2.

· JD Edwards EnterpriseOne Tools 9.1 is not compatible with Application releases prior to JD Edwards EnterpriseOne Applications 9.0.

· JD Edwards EnterpriseOne Tools 9.1 will also be compatible with JD Edwards EnterpriseOne Applications 9.1 when that product is released.

Resources and other information

· Press release

· Customer facing version of this announcement on My Oracle Support

· Video Demos of the Tools 9.1 User Interface (see Tools 9.1 playlist)

· Upgrade Value Proposition for Tools 9.1

· Release Notes for Tools 9.1 (included in Upgrade Value Proposition)

· (All) Releases Documentation Overview

· Tools 9.1 Online Learning Library (Product documentation)

· Tools 9.1 Data Sheet

· User Experience Data Sheet

· Tools 9.1 Release Overview Functional Transfer of Information

· Tools 9.1 User Experience Improvements Functional Transfer of Information

· Tools 9.1 Frequently Asked Questions

· Minimum Technical Requirements for JD Edwards EnterpriseOne

· Oracle Application Management Suite for JD Edwards data sheet

· JD Edwards EnterpriseOne Whitepaper library


Catch the latest WebLogic Weekly for December 5th, 2011, at The WebLogic Server Blog

And a set of slides to check out for a good overview of WLS 12c: Oracle WebLogic Server 12c - Developer Overview Slides.

Great Bloggers: Charles Hooper

Charles Hooper continues to impress me as the most thorough technologist online. Consider these two items from his recent blog postings. In one he ran into an intermittent problem on OTN and dove in at great depth. The process will give you a lot of insight into how to troubleshoot the Web: Internal Server Error – Contact Your System Administrator.

and his approach to a problem of whether some key performance options are part of standard RDBMS edition, or only enterprise: Stored Outlines (Plan Stability) are an Enterprise Edition Feature? A Self-Conflicting Story


Over at Pythian, a much cited posting on De-Confusing SSD (for Oracle Databases).


There was a movie called the 13 Steps. This posting has nothing to do with that: Integrate OBIEE 11g with OAM 11g for Single Sign-On in 13 steps. It's over at the Online Apps DBA blog.

Rittman Mead posts on Calling BI Publisher 11g Web Services from BPEL.

Contributions by Angela Golla, Infogram Contributor

PeopleSoft Newsletter
There is a new newsletter available for PeopleSoft Supply Chain Support Newsletter, Note: 1368043.1. The newsletter contains a list of SCM Bundles, Maintenance Packs & Bundle Release Notes as well as Supply Chain Patching and Maintenance Advisor tools.

Wednesday, November 30, 2011

Oracle Priority Service Infogram for 30-NOV-2011


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

And don't miss this great posting:


Over at the Striving for Optimal Performance blog there is a brief but very useful posting for those trying to use SQL Trace and Oracle Portal.

Oracle Forums

When is the last time you used the forums? (or is it forii?). There's a lot of useful info there to search through as well as some heavy-duty experts to help you with questions, and that can sometimes include the kind of questions that SRs don't typically deal with (can anyone say 'customizations'?)

Here are a few examples:

A discussion on Constraints and Indexes from Hemant's Oracle DBA Blog.

A discussion of Lost Sysadmin Access After Upgrade to Solaris 11 at the Oracle Forums at OTN.

A posting arising from a discussion at the Oracle Community forums at Eddie Awad's Blog: Why You Must Use an ORDER BY Sometimes

New Support Articles

Speaking of Eddie Awad. He shared some new Support documents of interest: Five Recently Created or Updated Oracle Support Articles.


The Upgrade your Database - NOW! blog gives us a heads up on an 11.2 RDBMS bug you should keep an eye out for if you are upgrading: Wrong statistics in AUX_STATS$ might puzzle the optimizer.


Amis Technology lets us in on the secret and arcane art of making clickable columns in APEX reports (okay, nothing is particularly arcane in APEX, that's why people love it, but it sounds cool to say it's arcane): APEX: Make a report row clickable.


Get involved with the process. Stephen Colebourne's blog fills us in on JDK Enhancement Proposals in this posting: The future is in the JEPs


I've owned a Kindle since the day they came out and definitely comparison shop on my iPhone and iPad when I'm in the store. Over at the The Complete CRM Blog we have an article about that comparison shopping and how widespread it is becoming. Indeed it makes me wonder about the future of bookstores. Perhaps they will morph into cafes that maintain sample copies of most books and a few big coffee table books that don't lend themselves to electronic form. I know my personal progression for purchasing books is: Kindle version, if there is none, used copy, if that doesn't work, new book from Amazon. That model doesn't leave a whole lot of room for the old fashioned brick and mortar book chain. I do still cruise used book stores, but it's more like going to an antique shop to see if something turns up now rather than looking for items of current interest.


SearchOracle has good things to say about a new book: Book explores Oracle, MySQL query methods


Rittman Mead goes over some of the features of Web Services in BI Publisher 11g.

Backup and Recovery

It's a good time to review backup and recovery. I guarantee it is. In the hubbub of maintaining, improving, upgrading and dealing with a chaotic mass of opposing wills (developers, I'm not talking about you...really), backup and recovery gets neglected. When it comes up as an issue it is often time to tune up your resume because it's too late to fix things. So this cautionary article is a good read: Why do companies backup infrequently? at Help Net Security.

Contributions by Angela Golla, Infogram Contributor

Oracle Technology Newsletters

Oracle Support has some great newsletters available filled with technical tips. Checkout four of them below:

Database Support Newsletter Note 230.1 (contains feature article 'SQL Tuning Health-Check Script - an alternative to SQLTXPLAIN (SQLT) ')

Enterprise Manager Support Newsletter Note 1363807.1 (contains feature article Enterprise Manager 12c has Arrived!)

Fusion Middleware Support Newsletter Note 1347075.

EPM and BI Support Newsletter Note 1347131.1

Wednesday, November 23, 2011

Oracle Priority Service Infogram for 23-NOV-2011

A short issue this week, what with the holiday and all most people are thinking more about their families than their server configurations. Can't say I blame them.


It's out there! A presentation: Introducing Oracle WebLogic Server 12c, the #1 Application Server Across Conventional and Cloud Environments

Data Guard

Connections between various pieces of a Data Guard environment, and the latencies thereof, can be a key issue for DBAs. At the Alejandro Vargas' Blog there is a posting on: How to Calculate TCP Socket Buffer Sizes for Data Guard Environments


Also from Alejandro is this handy item about Configuring FTP on Exadata.

Solaris 11

The blogosphere is generating a lot of info about Solaris 11. Here are several postings of interest:

From Dave Miner's Fore! blog: Virtually the fastest way to try Solaris 11 (and Solaris 10 zones).

How to Find Out Which Devices Are Supported By Solaris 11 (Oracle Technology Network Blog (aka TechBlog)).

Solaris 10 branded zone VM Templates for Solaris 11 on OTN (Virtually All The Time blog)

Fixing a shell problem: New Shell In Oracle Solaris 11 (OTN Garage).

And when it all goes 'Woof': How to Recover a Solaris 11 System (OTN).

Oracle Service Bus

Spider Logic brings us: Oracle Coherence & Oracle Service Bus: REST API Integration.


From the Oracle E-Business Suite Communities Blog: Oracle Demantra BAL Migration


From Syngress: A Brief Introduction on Migrating to an Oracle-based Cloud Environment.


CBR Online discusses: Oracle introduces BI publisher for enhanced visibility across project portfolio.

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.