Oracle Priority Service Infogram for 02-OCT-2012

EBS

From the Oracle E-Business Suite Technology blog: New Whitepaper: Primer on Integrating with EBS 12 with Other Applications.

RDBMS

I sure never heard of an overlaps predicate, but Eddie Awad chanced upon it and covers it in his blog: Cool Undocumented OVERLAPS Predicate

A couple of good items this week from dbaStreet. First an article on 12c new features.

Then an item on a new Exalogic utility for gathering deployment info.

Speaking of 12c, OOW is still going on as I write this, but the good ideas, new features and new articles are already starting to flow. Here from Jonathan Lewis is a heads up on 12c partitioning new features: 12c Partitioning.

Network

Eddie Awad has good things to say about the PocketSoap tracing tool.

PeopleSoft

The PeopleSoft DBA Blog offers some thoughts and experiments on Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g. As the author says, please bear in mind that this is experimental.

This item at the PeopleSoft Wiki is certainly interesting. The author is offering a roll your own associative array: Associative Array.

When I read this article about virtualization and the box within a box within a box concept at the On the PeopleSoft Road blog, for some reason it reminded me of an old joke about Russian spies working undercover in the German army's HQ during the war. One of them is revealed, then it's revealed the one who revealed him is also a Russian, etc., etc. until finally someone says: Wait a minute, aren't there any Germans in the headquarters at all?

http://gasparotto.blogspot.com/2012/10/did-you-say-vm-in-oracle-vm-server-in.html

Hyperion

At in 2 Hyperion another great technical article for hands on types: Change Application Maintenance Mode via Command Line.

And at Rittman Mead: Alternatives to the Summary Advisor for Refreshing Exalytics Aggregates.

SOAP

Posting this: soapUI is back, with lot more for you, partly because it looks interesting for techies, but also because the blog title Web Services on Drugs intrigues me. Personally I don't use web services, but combining them with drugs is likely to dilute the whole psychedelic experience. Not a good idea.

New Book

Over at RedStack, an announcement about a new book that’s out: Oracle BPM Suite 11g: Advanced BPMN Topics.

Contributions by Angela Golla, Infogram Contributor

	PEOPLESOFT ENTERPRISE APPLICATIONS COMMUNITY
	Use the links below to collaborate and share information about PeopleSoft Enterprise applications. PeopleSoft on Facebook Interact with PeopleSoft executive on the official Facebook page PeopleSoft on Twitter Keep up to date with the latest PeopleSoft news by following us on Twitter PeopleSoft Video Feature Overviews View video demonstrations of the latest PeopleSoft features and functionality PeopleSoft Forums PeopleSoft Discussion Forums let you share your comments with the rest of the community. PeopleSoft Apps Strategy Blog This blog is dedicated to topics focused on PeopleSoft Applications, including Human Capital Management, Financials, Enterprise Service Automation, Asset Lifecycle Management, Procurement, Supply Chain and Customer Relationship Management.

Oracle Priority Service Infogram for 26-SEP-2012

OOW

It’s almost upon us…Oracle OpenWorld. Here are just a few of the interest area extracts, but first this excellent rundown of tips on OOW for first time attendees to help you get the most out of the experience from Pythian: OOW tips for the first-time attendee …

MySQL Connect 9 Days Away – Optimizer Sessions

Focus On Oracle Exadata

E-Business Suite Technology Sessions at OpenWorld 2012

Focus on Cloud Application Foundation with WebLogic Server, Coherence and Tuxedo

And now for something completely different...Oak Table World. No, not a convention of artisanal coffee table makers held within the conference, but a group of uber-geeks led by Oak Table maven, part-time Viking and full-time beer consultant Mogens Norgaard: As mentioned at Structured Data OakTable World and here complete with video: OakTable World at the Kerry Osborne’s Oracle Blog.

SOA

At Data Integration: Data-Driven SOA with Oracle Data Integrator.

My Oracle Support

There have been a lot of improvements to MOS of late. You can start reading about them here at the My Oracle Support blog: Mobile My Oracle Support is all New for July 2012 Release.

Some notes on the new Oracle search in MOS: MOS 6.2 (KM) Release.

And a nice thick stack of documentation.

But whatever version of the docs you are looking at there is one recent change of particular interest to customers who may be working in time zones outside their standard office time zone and the like: Auto Detect Timezone.

To change it manually, you can set Auto Detect Timezone to Off and then select the correct time zone. 

In MOS, click on your name in the upper right to get to the  Settings(Personal) page, click on the Personalization link, then click the radio button for Auto Detect Timezone.

To Select a time zone manually, click on Auto-Detect Off then use the dropdown to select the time zone. Be sure to click on Apply Changes to save).

Primavera

At the Oracle Primavera Analytics Blog: How to automate a monitoring system for ETL runs.

Exalytics

Robin King contributed this great 'getting acquainted' entry at the Oracle Exalytics blog: An Exalytics Conversation.

Relational Theory

Come to think of that, good name for a rock group: Relational Theory. But in this case it's the real deal, with relational algebra and all that: NOT EXISTS in Relational Algebra and QBQL at the Relational Database Theory blog.

RDBMS

A little more clarity cast by example at the Oracle DBA – Tips and Techniques blog: CURSOR_SHARING=SIMILAR and FORCE - some examples.

From the External Table blog a tale with links of that proud breed, the command line DBA: On Command-Line DBA.

WebCenter

At the Oracle WebCenter Alerts blog: Product Support Webcast for Existing Customers: Security Scenarios with Oracle WebCenter Content.

ADF

Muck about with ADF for free, at AppsLab: Oracle ADF Essentials, a Free Version of ADF.

…and Andrejus Baranovski takes us back to the basics on his blog: ADF Essentials - Quick Technical Review.

Solaris Studio

How to Extend Oracle Solaris Studio with NetBeans Plug-Ins.

And Finally...

Future trends coming to your office soon, from Wired: The New MakerBot Replicator Might Just Change Your World

And right after coming up with a warp drive someone finally invented a perpetual motion machine, though they call it a clock: Eternal clock could keep time after universe dies.

Contributions by Angela Golla, Infogram Contributor

Oracle Magazine
Oracle Magazine offers a wealth of technical articles and podcasts.  Check out the Oracle Magazine home page for the current issue and more. 

Oracle Priority Service Infogram for 19-SEP-2012

RDBMS

At our Support site: How I Simplified Oracle Database 11g Installation on Oracle Linux 6.

Performance

Stats, and their sometimes seemingly slinky character, is discussed by Jonathan Lewis at Oracle Scratchpad: Minimum Stats.

Security

The Third Party Vulnerability Resolution Blog at Oracle is a good resource for the 'big gaping security hole de jour'. For example: Multiple vulnerabilities in Oracle Java Web Console.

Support

At Chris Warticki's Blog - Oracle Support, an EBS--Technology Stack NAVIGATION Page.

Solaris

There's a new Solaris 11 book available (Oracle Solaris 11 System Administration The Complete Reference), and info on it is available at Jim Laurent's Weblog: New Solaris 11 book available.

VM and Linux

Oracle has a lot of very technically savvy VPs, and Wim Coekaerts definitely is in that category. Here’s a link to his interview with ServerWatch.

Hardware

At the Oracle Hardware blog: Introducing Oracle System Assistant.

BI

Apparently IT is starting to run out of names and starting on pejoratives. At last I'd always thought of 'git' as being rather negative when applied to a person. But now, apparently, if you say you are an expert at working with the Git they don't think you mean someone in management.

Configuring Oracle Business Intelligence 11g MDS XML Source Control Management with Git Version Control

APEX

At the APEX-AT-WORK blog, a bug that is not quite a bug: Check-box bug in tabular form.

PeopleSoft

At the PeopleSoft Technology Blog a link to the New Paper on the PeopleSoft Interaction Hub-PeopleTools Relationship.

OOW

The date quickly approaches, and many of the technologies and product lines are putting out roadmaps to navigate the labyrinth of OOW scheduling:

SOA/BPM

Focus On SOA & BPM for Oracle OpenWorld Now Available

 (at SOA Governance@work).

Big Data

Big Data Sessions at Openworld 2012

 (at the Data Warehouse Insider).

ADF

Oracle ADF Coverage at OOW

(at ADF Code Corner Oracle JDeveloper OTN Harvest).

Linking Up

An update with link back to a larger article on Troubleshooting Oracle Link Server Issue at Pythian.

WebCenter

At the Oracle WebCenter Alerts blog, a reminder about the upcoming Product Support Webcast for Existing Customers: Security Scenarios with Oracle WebCenter Content.

And Finally...

Good news for Trekkies, especially young ones who may live to see this. It seems scientists are closing in on a warp drive.

Okay, we go to warp drive, let's say we travel ten times the speed of light as in this article 'Warp drive' may be more feasible than thought, scientists say. That's the good news. The bad news is that light takes years and years and years to go from one star to another, so we're still very limited on where we can go. And then there's that whole 'uh-oh, this planet we found is occupied and they have big signs all over saying 'Welcome Earth Appetizers!"

And in another realm of innovation altogether, maybe it's just me, but isn't this underground park going to go from neat idea to the police department's least favorite place to patrol in about three weeks after it opens?

Contributions by Angela Golla, Infogram Contributor

High Availability Support for Engineered Systems

Available at no additional cost to Oracle Premier Support customers who maintain certified configurations on Oracle engineered systems. Features include: 24/7 fault monitoring, faster response and restore times, and patch deployment services.  Learn more HERE. 

Oracle Priority Service Infogram for 12-SEP-2012

SOA

From the 'Linux' blog: SOA and the Cloud: Why Your Cloud Applications Need SOA.

RDBMS

Redgate passed along a couple of really intriguing sounding webinars coming up (one published before the Infogram's publication date, so you'll need to dig in the archives for it):

The Undiscovered Country: Useful Built-in Database Packages You've Never Heard About

Presented by Morten Egan (OakTable).

And another from perennial Infogram favorite Jonathan Lewis:

Temporary Tables in Oracle and SQL Server

Presented by Jonathan Lewis (Oracle ACE Director, OakTable) and Grant Fritchey (SQL Server MVP).

FBI Delete

Don't get all excited, it's not a civil liberties article and it's not THAT FBI, it's about function based indexes and it's from Jonathan Lewis: FBI Delete.

Performance

The Oracle Diagnostician (I think he's kind of like House, but without the cane and the attitude, or maybe vice versa) brings us: A map to AWR report.

Over at Oracle related stuff: Exchange Partition, Virtual Columns And Column Statistics.

ASM

From ORAganism: Orphaned Files in ASM. The author stresses this, and I want to reiterate, be very careful about deleting things. Most times in IT there is enough storage to move/rename etc., then delete when you are sure the coast is clear.

MySQL

At the Oracle's MySQL Blog: MySQL Connect: What to Expect From the Wondrous Land of MySQL Cluster. (I'd say if it's billed as wondrous it had better have mythical kingdoms shrouded in mystery and limned with joy. Or at least free beer and pizza): MySQL Connect: What to Expect From the Wondrous Land of MySQL Cluster.

MOS at OOW

That's My Oracle Support at Oracle OpenWorld for those communicating in full words. Love MOS? Hate it? Knowledge and feedback sessions at OOW will let you express yourself: MyOracle Support at Oracle OpenWorld 2012. The tricky part is that you have to log in to MOS to view it, so that's an implicit like right there.

XML

Adventures in XML from the AMIS Technology Blog: Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML.

OBIEE

From Rittman Mead Consulting's Blog Archive: Automated Monitoring of OBIEE in the Enterprise – an overview.

Reports Integration

From Darwin-IT, a step by step account of one developer's experience on how to: Call Oracle Reports from the Middle Tier And Parse/XPath query the response.

Solaris

How to Automate the Installation and Setup of Oracle Solaris Cluster 4.0

On Oracle Solaris 11.

First...hire an ACS engineer to help. Ha, ha, only serious.

JDeveloper

From the Born To DeBug blog, a little detective work: Where are the DB connections stored in JDeveloper?

ADF

The article is titled: What To Do When ADF Editable Table Misbehaves. My solution is to slap it silly. But Andrejus Baranovski apparently prefers a more nuanced, technical approach.