A day in the life of an Oracle Applications Consultant


Wednesday, October 18, 2006

Oracle Releases Eighth Critical Patch Update

Oracle DBA’s and Sysadmin’s: You’ve got a “friend” in Oracle’s October 2006 Critical Patch Update (CPUOct2006).

Winter Spring Summer or Fall,
All you have to do is call,
And I’ll be there yeah yeah yeah.
You’ve got a friend.
- James Taylor

Just like the lyrics in the famous James Taylor song, Oracle came calling again (yeah, Yeah, YEAH!) with its Fall Quarterly Update.  If, by chance, you don’t have any friends, at least you’ll have job security.  And if you’re an Oracle DBA or system administrator you probably don’t have time for socializing anyway, especially if you’re responsible for identifying, testing, and implementing the 101 patches identified in CPU #8.

But this time our jobs should be a little easier, as Oracle has included additional notes which include an executive summary that provides a summary of the vulnerabilities addressed with the latest patches. A rating system based on the Common Vulnerability Scoring System (CVSS) has also been incorporated into the risk matrix.  Although the risk matrix is nothing new to the CPU’s, MetaLink Note 394486.1 will help you understand the new format of the matrix.  I believe the new format will help facilitate an easier “yes/no” identification approach, and also help identify the resources and effort required to implement each of the patches.

For e-Business customers, there are 13 vulnerabilities identified in Appendix D.  According to the Oracle Global Product Security Blog, the patches are cumulative for all products except for the e-Business Suite.  If you’ve lagged behind in applying all the quarterly updates, you will need to do a gap analysis on previous CPU’s issued for the e-Business Suite to ensure you are compliant.  CPU’s for the technology stack components, however, should be cumulative, which means you can simply apply the latest CPU patches specified to ensure you are compliant.

I’ve got an out of the box 11.5.10CU2 environment I’ll be installing soon, so to identify all the patches required to ensure compliance, I’ll start by reviewing MetaLink Note 391564.1.  I’ll post my gap analysis in a future post.

I’d be interested in hearing how well others have been keeping up with the quarterly updates, and strategies for identifying patches to apply.  Do you apply all patches applicable to your environment?  Is there a change management process you follow?  What is your strategy for regression testing and production migration?  Post a comment to let us know your thoughts on dealing with these quarterly updates.


Monday, April 25, 2005

JD Edwards and Peoplesoft Product Packs now downloadable via Oracle’s e-delivery site

Last week I mentioned that you can now download the latest Oracle Software and Updates via Oracle’s e-delivery web site. I was rather chuffed to discover today that JD Edwards World, JD Edwards EnterpriseOne and Peoplesoft Enterprise have been added to the list of available downloads on this site.

This post from last week outlines how to access Oracle’s e-delivery site. The following additional software and products can now be downloaded from this site:

JD Edwards World

According to the JD Edwards World Product Lines Page: -

JD Edwards World is the leading enterprise software solution for the IBM iSeries platform. The applications offer small businesses a reliable, functionality-rich, web-enabled environment for world-class management of plants, inventories, equipment, finances, and people as a synchronized, integrated whole and are tightly integrated and pre-bundled on a single database, reducing implementation cost and complexity.

The following CD/Media Packs are available for this product on the IBM iSeries OS/400 platform: -

  • JD Edwards World Express V1.2
  • JD Edwards World A73 Multi Language Documentation
  • JD Edwards World A73SP15 MP2 Web Enablement
  • Letter: Crystal Reports Install
  • Crystal Reports for JD Edwards World
  • Crystal Enterprise for J. D. Edwards World
  • Crystal Reports ERP Direct 2032
  • Crystal Enterprise Direct 2032

JD Edwards EnterpriseOne

According to the JD Edwards EnterpriseOne Product Lines Page

JD Edwards EnterpriseOne is a complete suite of modular, pre-integrated industry-specific business applications designed for rapid deployment and ease of administration on a pure internet architecture. It is ideally suited for organizations that manufacture, construct, distribute, service, or manage products or physical assets.

The following CD/Media Packs are available for download via the Electronic Product Delivery (EPD) system: -

  • Crystal Reports and Enterprise Applications
  • JD Edwards EnterpriseOne 8.11 Applications
  • JD Edwards EnterpriseOne 8.11 Application with Translations
  • JD Edwards EnterpriseOne 8.10 Applications
  • JD Edwards EnterpriseOne 8.10 Application with Translations
  • JD Edwards EnterpriseOne 8.10 Application Localizations
  • JD Edwards EnterpriseOne User Productivity Kits Development Tool 2.5.4

These packs are available for the following platforms: -

  • AIX5L Based Systems (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM iSeries OS/400
  • Linux x86
  • Microsoft Windows (32-bit)
  • Solaris Operating System (SPARC 64-Bit)

Peoplesoft Enterprise

According to the Peoplesoft Enterprise Product Lines Page: -

PeopleSoft Enterprise is a suite of best-in-class applications built on our Pure Internet Architecture and designed for the most complex business requirements. Ideally suited for large, company-wide functions across all industries, it provides industry-leading web services integration with multivendor and homegrown applications. PeopleSoft Enterprise can be easily configured and adapted to meet the most unique customer requirements. In addition, it supports the broadest choice of technology infrastructure in the industry.

The following CD/Media Packs are available for download via the EPD system: -

  • Process Modeler Client 8.91
  • Enterprise Learning Solution 8.81
  • PeopleTools Enterprise Development 8.46
  • Supply Chain Planning 8.11
  • Customer Relationship Management 8.9
  • Human Resources Management System and Campus Solutions 8.9
  • Portal Solutions 8.9
  • Revenue Management Solution 8.9
  • Incentive Management 8.9
  • Enterprise Performance Management 8.8
  • Financial & Supply Chain Management 8.8
  • Human Resources Management System and Campus Solutions 8.8
  • Portal Solutions 8.8
  • Staffing 8.8
  • Enterprise Performance Management 8.8
  • User Productivity Kits Development Tool 2.5.4

These packs are available for the following platforms: -

  • AIX5L Based Systems (64-bit)
  • HP Tru64 UNIX
  • HP-UX Itanium
  • HP-UX PA-RISC (32-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM z/OS (OS/390)
  • Linux x86
  • Microsoft Windows (32-bit)
  • Solaris Operating System (SPARC 64-Bit)

Looks like I’ve got some serious downloading to start tonight!!

, , , , , , , , , , , ,