Thursday, January 24, 2008

RAC, Performance, EBS, Recovery, PeopleSoft, JD Edwards

RAC

Last week we pointed out an article on backing up control files. This week Alejandro Vargas calls our attention to an article on How to Recreate the Controlfile on a RAC Environment.

Performance

The Oracle optimizer team has another great 'inside the gearbox' article, this time on the 11g feature that allows you to automate sample size on statistics.

EBS

Stephen Chan (I sure seem to be typing that name a lot) has another great find: Hidden Features Revealed: Technology Inventory Utility for Apps 12.

Recovery

Not backup and recovery, just recovery, which is the key step you do all that backing up for. When you need to recover, you, the DBA, are either the hero of the hour or the Monster.com new profile and resume poster. Tom Kyte has a good article on the subject today at his blog.

I would add that when you are doing a recovery you should not let yourself be rushed, no matter how much pressure is applied (usually lots). Read everything to the end and don't rush any steps. Recoveries often can be like the episode of M.A.S.H. when a U.S. bomb landed in the compound and the doctors had to disarm it using an Army manual. They read out something along the lines of: Ok, pull the green wire out...Done...Now the red wire...Ok. (Turns the page) But first....Oh *&#%@$!...and they dive into a foxhole.

So read all the way to the end of the note you are using before following the steps, and avoid that: 'but first'. My experience is that the red wire is usually
RESETLOGS. Please only use that command when you are sure it is safe and needed.


PeopleSoft and JD Edwards

(Contributed to the Infogram by Anu Sachdeva)

HCM -Two-step upgrade from 8.3 to 9.0 - Upgrade Wrapper

Instead of just providing that Red Paper on how to do a two-step upgrade from 8.3 to 9.0, there is a new tool called the "Wrapper".

Here is the link on Customer Connection with the information:

http://www4.peoplesoft.com/upgrades.nsf/0fff1a8d55aa883888256ed1007df764/423a5659a9c505f788257222007223da?OpenDocument

Generic Solutions to be omitted from Customer Connection Solution Search
Global Customer Care, JD Edwards Enterprise One, JD Edwards World, Peoplesoft Enterprise: Beginning Friday, January 25 generic solutions will no longer appear in Solution Advisor searches on Customer Connection. This upcoming change will alter the way solution data is indexed within the application so that when a search is performed, no solution with Type = "Generic" will appear in the results. Removing generic solutions from the search index will reduce the amount of useless items that appear each time an engineer or a customer performs a search for technical solution data.

MOST RECENT APPCASTS

The latest in the JD Edwards EnterpriseOne Tools and Technology Area Play!(10 min.)
January 22, 2008 — Live with Cliff
Eric Oss, Manager of Customer Operations from the Oracle JD Edwards implementation and hosting partner WTS and Gary Grieshaber, Sr. Director, Strategy discuss the latest JD Edwards EnterpriseOne Tools 8.97 release, the feedback they have been receiving from the marketplace and why customers should take advantage of this new release.

What are Social CRM Applications? Play!(12 min.)
January 17, 2008 — Live with Cliff
Listen to Anthony Lye, Senior Vice President of CRM, discuss how Oracle's Social CRM Applications combine powerful enterprise applications and the latest in social networking with Web 2.0 technology to dramatically improve end user productivity.

The Benefits of Oracle's Price Management Solution Play!(12 min.)
January 17, 2008 — Live with Cliff
David Trice, Oracle Vice President of Product Strategy presents an overview of Oracle's Price Management Solution, why Oracle has invested in that area, and why customers should care about Price Management.

PeopleSoft: For Your Upgrade and Expansion Consideration Play!(11 min.)
January 15, 2008 — Live with Cliff
Considering an upgrade of Oracle's PeopleSoft? Listen to John Webb, Vice President Strategy for PeopleSoft Enterprise, discuss how upgrading and expanding your PeopleSoft Applications can add tremendous value and how far the Applications have come in the latest release.

UPK version 3.1 goes GA! Play!(5 min.)
January 10, 2008 — Live with Cliff
Hear Russell Handley, Director, UPK Product Marketing, discuss the much anticipated release of UPK 3.1, and how it can benefit enterprises of all sizes, across all geographies.

Calendar of upcoming Webcasts for February:

More details available on Customer Connection > Advisor Webcasts

PeopleSoft Enterprise:

PeopleSoft Web Services

February 26 -12:00 noon (MST)

JD Edwards EnterpriseOne

Transportation Freight Update

January 31 - 10:00 a.m. (MST)

Using Change Assistant for Search and Deployment of JD Edwards EnterpriseOne ESUs

February 12 -10:00 a.m. (MST)

Basket and order Repricing

February 12 - 8:30 p.m. (MST) 9 a.m. (IST) on February 13

Government reporting for Equal Employment Opportunity (EEO)

February 14 - 10:00 a.m. (MST)

Quote Management

February 19 - 10:00 a.m. (MST)

Features of 8.11SP1 India Localization in Comparision with Legacy Products

February 19 - 8:30 p.m. (MST) 9 a.m. (IST) on February 20

Automated Receipts Processing

February 26 - 8:30 p.m. (MST) 9 a.m. (IST) on February 27

JD Edwards World

A9.1 HRM/Payroll Enhancements

February 21 - 10:00 a.m. (MST)

How to Generate Timecard Journals

February 27 - 10:00 a.m. (MST)

No comments:

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.