A short time ago, I was working on an upgrade and ran into a situation where this was needed. According to the patch readme, I needed to submit a concurrent request after applying a specific patch. So, to do this graphically, I needed to disable the maintenance mode and start up the application. Then I [...]
Submitting Concurrent Requests from the Command Line
December 30th, 2008 · 6 Comments
Tags: E-Business Suite · Patch · Patching · Release 11i · Release 12
Patchset TXK.S Bug
December 30th, 2008 · No Comments
By now you all know that the proper way to add a custom top directory to your E-Business Suite instance is through the ${APPL_TOP}/admin/topfile.txt (MetaLink Note: 216589.1). By adding an entry to that file, AutoConfig will:
1) Create the environment variable for you
2) Put it into the context file
3) Update various commonly missed files (formservlet.ini, for [...]
Tags: E-Business Suite · Patch · Patching · Release 12
My Oracle Support
December 3rd, 2008 · 1 Comment
By now I’m sure that all of you have at least seen the new MetaLink V3 (now dubbed “My Oracle Support”). The Adobe Flash driven site has several nifty features, including the ability to easily switch between accounts through a pull-down near the top right corner.
Many of you may not see the [...]
Tags: E-Business Suite
Release 12 Critical Patch Collection for November Available
December 1st, 2008 · No Comments
In a previous post we discussed the new patching bundle, the Critical Patch Collection (CPC) that Oracle began issuing in October. As a recap, this is what Oracle says about CPC’s.
R12 Financials Critical Patch Collections (CPC) are consolidated critical patches that all R12 Financials customers must apply to ensure proper operation of their systems. Advantages [...]
Tags: Critical Patch Collection · DBA · E-Business Suite · Oracle · Patch · Release 12
Applying RUP6 for Release 12.0.6
December 1st, 2008 · No Comments
I recently applied the latest RUP for Release 12 at a client that is in the midst of a new R12 installation. I thought I’d recap my experience.
The 12.0.6 patch was released on Friday, November 7th. We were alerted to it because we ran a fresh version of patchsets.sh during the week and it indicated [...]
Tags: DBA · E-Business Suite · Oracle · Patch · RUP · Release 12
DataInstall for Oracle Payroll and HR Command Line Options
November 5th, 2008 · 1 Comment
When applying HR Patches, we frequently have to load legislative data. This is accomplished by running a java-based tool called “DataInstall” which basically just sets a few flags. You then use the adpatch tool to apply the latest “hrglobal.drv”. The hrglobal.drv driver uses the flags set by DataInstall to determine which [...]
Tags: Oracle · Oracle Payroll
Do You Need a Password on the TNS Listener?
November 5th, 2008 · No Comments
One of our clients asked if they really need to use a password entry in the listener.ora file in their production environment. They pointed out that in MetaLink Note: 260986.1, Oracle states: “In Oracle 10, the TNS Listener is secure out of the box and there should not be a need [...]
Tags: DBA · Database · Release 11i · Release 12 · Security
So That’s What Those Hidden Oracle Parameters Are For!
November 5th, 2008 · No Comments
We hit this issue when we were cloning a production RAC environment that had been backed up using RMAN and then restored to a non-RAC test environment. To get past it, we had to add a hidden parameter to the target init.ora file to allow us to open the duplicated database, and [...]
Tags: DBA · Database · E-Business Suite · RAC · Release 12
The Acronymists at Oracle Have Come Out With a New One: CPC – Critical Patch Collections
October 17th, 2008 · 1 Comment
I have to admit, I was taken completely by surprise while at a client site this week working on a Release 12 Implementation Assessment when John Stouffer pointed to a News & Notes article on MetaLink called EBS: Oracle Releases R12 Financials Critical Patch Collections September 2008. “Critical Patch Collections?!! Is that a CPU?” Nope. [...]
Tags: Critical Patch Update · E-Business Suite · Oracle · Patch · RUP · Release 12
Oracle Critical Patch Updates for this Quarter
October 15th, 2008 · No Comments
A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of inter-dependencies) by those security patches. Critical Patch Updates are cumulative (with some exceptions) but each advisory describes only the security fixes added since the previous Critical Patch Update.
The Critical Patch [...]
Tags: Critical Patch Update · Database · E-Business Suite · Oracle · Patch