Tuesday Apr 29, 2008

Implications of OracleAS Support Policies for Apps R12 Environments

Oracle E-Business Suite Release 12 was built with the latest Oracle Application Server components available at the time of its release.


Whilst this is a good thing, it does mean that Apps DBAs need to be more aware of what is going on in the Oracle Application Server 10g (AS10g) world with regards to the latter's support policies.

Evaluating Impacts on the Release 12 10.1.3 ORACLE_HOME

One example of the importance of this concept is a notice in the January 2008 Critical Patch Update (CPU):

Some customers may have missed or not realized the significance for E-Business Suite environments.  It states:-

CPUJan2008 is the terminal CPU for: Oracle Application Server

This means that in order to be able to apply all April 2008 CPU patches to E-Business Suite R12 environments, you MUST upgrade to AS as described in :

Just to clarify: Oracle Application Server 10g will continue to be supported for E-Business Suite Release 12 customers. However, the latest April 2008 Critical Patch Updates are not available for Oracle Application Server 10g  Given my recommendation to always apply the latest CPU patches, I suggest that you upgrade your E-Business Suite Release 12 environment to Oracle Application Server 10g if you have not done so already.

Evaluating Impacts on the Release 12 10.1.2 ORACLE_HOME

The same situation applies to the 10.1.2 ORACLE_HOMEs as well.  "Critical Patch Update April 2008 Availability Information for Oracle Database and Fusion Middleware Products" (Metalink Note 552248.1) states:

... the terminal CPU for is scheduled for CPUJan2009

The direct implication is that eBiz customers will likely need to upgrade their 10.1.2 ORACLE_HOMEs by April 2009 to keep up-to-date with Critical Patch Updates.

Taking Time Out to Study the Documentation

Keeping your environments up to date with the latest Critical Patch Updates is an essential part of an Apps DBAs role, so it is important to take some "quiet time" in your busy schedule to carefully read through the CPU patch documentation when planning your patch rollout.  (I sometimes find myself sitting in the restaurant with a coffee if I need to read through a load of documents; the boss sometimes pays for the coffee as well!)   Whilst we do try to make the documentation as easy and concise as possible, I am sure you will let us know how it can be improved if you find it lacking.


Related Articles

Friday Jul 13, 2007

Four Essential Oracle OCP Certifications for Apps DBAs

In my view, Apps DBAs and their employers benefit from Oracle Certified Professional (OCP) certification, as it not only proves a certain level of understanding, but more importantly, the OCP process itself provides a vehicle to renew and expand your knowledge.

I have always found certifications very good learning tools.  When in a class, if I know I need to pass an exam on the topic, it gives me great incentive to pay attention and ensure I understand everything that is being discussed... and after will ensure that I re-read the course notes and play around with the product, until confident I really know the topic


Why become OCP Certified?

  • The requisite training, self study and background reading will give you a good understanding of the whole topic area being covered.  In your normal daily role, you may not get exposure to the full product, so the training will introduce you to new skills and enhance your existing understanding.
  • Gives you access to your peers and instructor.  You will meet new people who are likely doing a similar job to your own, so can exchange tips, views and experiences.
  • Sense of achievement, with recognition of your skills by your peers

Why should your manager approve your request for training and exam fees ?

  • Enhances employee skills, making them more efficient, confident and capable
  • Giving employees sense of worth and job satisfaction
  • Helps induce employee loyalty

The webcast What Your Manager Should Know about Certification covers benefits in more detail.

Oracle Certification Program

Oracle have a variety of OCP exams covering Database, Middleware, Applications and Linux all of which you can view from the Oracle Certification web site.

Which OCP are essential for Apps DBAs?

In my opinion, these are all essential for any Apps DBA:

  1. Oracle Database 10g Administrator

    All Apps DBAs need a good understanding of Database and related technologies, so this should be a no-brainer

  2. Oracle 11i Applications Database Administrator Certified Professional

    Installation, patching and maintenance:  all essential skills

  3. Oracle 11i System Administrator Certified Expert

    Covers OAM, Concurrent Manager and other important Apps DBA tasks
  4. Oracle Application Server 10g Administrator

    For those using OracleAS10g components such as Single Sign-On (SSO), Portal, or Discoverer integration. 

    This is also essential for Release 12 administrators, since the technology stack for this release is based on Oracle Application Server 10g.

Are there any other Oracle OCPs that would be useful?

  1. Oracle 11i Workflow Certified Expert

    So much of the eBiz functionality relies on Workflow that this knowledge is generally useful

  2. Oracle Database 10g: Real Application Clusters Administrator Certified Expert   

    For those of you using or evaluating RAC deployments
  3. Operating system vendor certifications

    Most operating system vendors offer operating system certifications program.  In addition, Oracle offers the "Oracle Database 10g: Managing Oracle on Linux for DBAs."  


I believe certifications in general have real world value, with OCP exams being particularly relevant and important for Apps DBAs.  For me, there is no doubt it is a good investment of time and money and I am certain most Apps DBAs would find similar benefits.


Thursday Jun 14, 2007

UK OUG: Apps DBA for OEBS SIG Meeting

Apps DBA for OEBS SIG is a bit of a mouthful, but is better than having to write "Applications Database Administrator for Oracle E-Business Suite Special Interest Group"!    Basically these are technically-oriented meetings for E-Biz Apps DBAs and are held mainly in the UK and Ireland.

UKOUG Website screenshot:

Whilst not as glamorous as the going to Vegas for Collaborate'07 like Steven gets to go to, I do at least get out of the office to present at these meetings.

Yesterday's conference was at the Heritage Motor Centre, so I was very much looking forward to going.  Unfortunately, time flew by far too quickly and I didn't get to see the cars in the museum this time, but I did get to talk to a fair few of the attendees, especially during the Speed Networking Session.   It is great to be able to meet the front line DBAs and talk about issues and ideas informally.   Some are working on very exciting projects and some have challenging environments, so getting to hear of your configurations, issues and concerns is one of the real highlights for me.  I hope to continue supporting the UKOUG.

The presentations themselves were very interesting, with:

  • Richard Dewes talking about setting up the TNS entries with RAC (covering the subtle differences between 9i and 10g)  
  • John Able discussed new Security features in Rel 12
  • Mike Buckland had a session on Business Intelligence (including Oracle Fusion Intelligence for the E-Business Suite)  
Unfortunately, the only non-Oracle speaker was unable to attend so we missed out on hearing about common Concurrent Manager problems, but I hope that will be rescheduled for a future event.

UK OUG members can download the presentations from this and all previous meetings via the UKOUG web site.

The next meeting is 9th October 2007 in Slough, so if you are based in the UK it would be well worth checking to see if you are able to attend.



« July 2016