Tuesday, February 27, 2007

First patch on Oracle E-Business Suite R12

This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of them (patch p5856453_R12[1].AD.A_R12_LINUX.zip).
I could not help feeling a little bit excited, because patching is changed in EBS R12.
The manual steps to be taken before patching are removed from the readme and placed into an xml file. Before patching you are supposed to run a new perl script called $AD_TOP/bin/admsi.pl

This script creates an install_{patch_number}.html.
After performing the steps in the html file, you have to run $AD_TOP/bin/admsi.pl –done (to let the system know you have performed the manual steps….).
The admsi.pl also creates a custom readme which you have to read before patching.

I was a little bit disappointed, because the patch I downloaded is maybe to small. Nothing about admsi.pl in the readme…Tried to run admsi.pl anyway

cd /ebs/patches/5856453/ad/patch/115/manualsteps
[oracle@vamisux34 manualsteps]$ $AD_TOP/bin/admsi.pl

Invoking Oracle Patch Application Assistant….
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.jgoodies.looks.plastic.PlasticLookAndFeel.(PlasticLookAndFeel.java:122)
at oracle.apps.ad.msi.LaunchUI._useOracleLookAndFeel(LaunchUI.java:69)
at oracle.apps.ad.msi.LaunchUI.(LaunchUI.java:29)
Caused by: java.awt.HeadlessException:
No X11 DISPLAY variable was set, but this program performed an operation which requires it.
at sun.awt.HeadlessToolkit.getScreenResolution(HeadlessToolkit.java:189)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:436)
at com.jgoodies.looks.LookUtils.(LookUtils.java:180)
… 3 more

Maybe with X-manager and $DISPLAY set ? No, admsi.pl returns a java exception…

Invoking Oracle Patch Application Assistant….
Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1762)
at oracle.apps.ad.msi.LaunchUI.main(LaunchUI.java:107)

Running admsi.pl like this.....

[oracle@vamisux34 manualsteps]$ perl $AD_TOP/bin/admsi.pl -cli

Gathering Information..
Enter the patch_top : /ebs/patches/5856453
Enter the APPS user password:
Logfile for this session is located at admsi.log
Generating installation instructions for patch 5856453..
Updating database....
install_5856453.html generated successfully
install_5856453.txt generated successfully
[oracle@vamisux34 manualsteps]$

The install_5856443.html is the new readme. Because there are no manual actions to perform, the new generated readme is the same as the old one and I can apply the patch using adpatch..


oracle@vamisux34 appl]$ cd /ebs/patches
[oracle@vamisux34 patches]$ ls
5856453 p5856453_R12[1].AD.A_R12_LINUX.zip
[oracle@vamisux34 patches]$ cd 5856453/
[oracle@vamisux34 5856453]$ adpatch options=hotpatch
************* Start of AutoPatch session *************
AutoPatch version: 12.0.0
AutoPatch started at: Tue Feb 27 2007 11:05:47

…..

AutoPatch is complete.
AutoPatch may have written informational messages to the file/appl/apps/apps_st/appl/admin/PROD/log/u5856453.lgi
Errors and warnings are listed in the log file/appl/apps/apps_st/appl/admin/PROD/log/u5856453.log
and in other log files in the same directory.

The patch finished without problems….


7 comments:

Liz said...

Thanks Bas. I've just finished installing R12 and need to patch it up to 12.0.2, I couldn't get admsi.pl to work until I saw your post.

Question for you -- have you tried to install R12 in multi-tier configuration on VMWare? I've been fighting for two weeks to get it to work but no luck. I can install as a single tier without any problems. But with multi-tier the Web services tier can't start JSP. Any ideas? Oracle seem to be stumped. My Sev 1 SR is going nowhere. Yes I know VMWare isn't supported, but the client wants to use it.

Bas Klaassen said...

Liz,

during the bootcamp we also experienced some problems with a multi node install of EBS R12.
Which OS are you using for EBS ? (on vmware ?)

Liz said...

Bas, I've been trying to update this for ages. I kept getting a security notice that wouldn't go away. Finally it seems to have gone for lunch!

Okay here we go, the os is RHEL 4 update 5, which happens to be the host's os too.

Bas Klaassen said...

Liz,

it could be a problem we also faced. It seems rapidwiz is creating a lot of broken links in the ORACLE_HOME.
Try relinking and write down the broken links, recreate them and maybe it will solve your problem.

Unknown said...

Can you please provide the link to the r12 step by step instruction for enterprise linux

Anonymous said...

Hi! Does anyone know e-franchise ideas? If there are any, back me up on franchise forum!

Anonymous said...

asHello,
Thank your for your suite. But I don't know how create msi of java application in code, Do you have any idea? Any help will be appreciated.