Friday, June 29, 2007

Program EBS R12 Bootcamp

I received the program for the upcoming two weeks in Montpellier. During the EBS R12 bootcamp we will try to investigate the following subjects :

1) Application-tier focus:
· Shared APPL_TOP
· Shared oAS (10.1.2 (forms) or 10.1.3 (oc4j) or both?)
· OAS Load Balancing (10.1.2, 10.1.3, both?)
· DMZ implementation, covering, possibly, Reverse Proxy and APPL_TOP or oAS Cloning
· Single Sign-On
· Integration with Oracle Business Intelligence (Discoverer / OBI EE)
· Upgrade to oAS 10.1.x if and when available

2) DB-Tier focus:
· RAC 10g (how to add an extra node)
· Database Vault with R12

3) General Architecture focus:
· Cloning (Full, Appl_top, oAS 10.1.2 oAS 10.1.3)
· Upgrading from R11 to R12 (no hands on - just review of steps)

4) Additional ideas
· Grid Control plugins
· MLS Impact. This is a time killer, but I would anticipate to document the translation steps, in dotted line, in a document deliverable, if any.
· Cross platform deployment. Looks like we don’t have the hardware ready for that, but maybe Paul may be able to get us some space in a zVM host to move the database here. The blazing speed of an IBM z9 platform is always refreshing.

. Java (JRE) Plug-In 1.5.0_12 for EBS 11i

Wednesday, June 27, 2007

Java (JRE) Plug-In 1.5.0_12 Certified with Apps 11i

For EBS R12 you could already use the Sun Java plugin instead of the Oracle Jinitiator.
Now the standard Sun java plugin is also certified for EBS 11i (11.5.9 and later..)
Version 1.5.0_12 is certified for 11i.
For more about this see the Steven Chan blog

Monday, June 25, 2007

EBS R12 bootcamp 2007

I will be blogging about R12 the next two weeks. From 2-7 till 13-7, I am participating in a Oracle/IBM EBS R12 bootcamp in Montpellier (France).
This bootcamp is organized by the Oracle/IBM Joint Solutions Center. At first a colleague of mine was invited, but he could not find the time and suggested I should go in his place....:)

So, for two weeks I will be working with R12 only...and will try to blog this adventure.

Thursday, June 21, 2007

Wednesday, June 13, 2007

Oracle Certified Expert

Because I passed the Oracle 11i System Administrator exam (1z0-232), I can now call myself an Oracle Certified Expert.
Yesterday I received a certificate....

Monday, June 11, 2007

Missing oraInventory

When running the http patch, I received some errors...It seemed the oraInventory was not valid, at least the http entry was missing.
The oraInventory that was incomplete was the global oraInventory. I noticed that the local oraInventory in the $IAS_HOME was complete, but running the patch with this oraInventory did not work. Something about the oraInventory...
In the file oraInst.loc (usually in the /var/opt/oracle directory), the location of the global oraInventory is shown. In the global oraInventory you find the installed ORACLE_HOMES and in the ORACLE_HOME you find the local oraInventory for that ORACLE_HOME.
I find out n Metalink that the global oraInventory can be restored if the local oraInventory is valid.
The perl script in the $ORACLE_HOME/appsoui/setup (IAS_HOME) directory can be used to recreate the global oraInventory.
After recreating the global oraInventory the http patch was successfully applied.

Tuesday, June 05, 2007

new templates after patch

The other day I patched a database and I had to run autoconfig at the end.
It seemed a template was modified by a patch, and this template had a customized version.
The following lines were produced by autoconfig...

Starting Utility to Report Version Conflicts at Fri Jun 01 00:19:04 MEST 2007Using version 115.4
[ AD_TOP ]

Template shipped by oracle is having a version different than the template lying in custom directory.Template shipped by Oracle : /opt/software/applmgr/SID/appl/ad/11.5.0/admin/template/APPLSYS_ux.env(version: 115.89)Custom template : /opt/software/applmgr/SID/appl/ad/11.5.0/admin/template/custom/APPLSYS_ux.env(version: 115.88)Please resolve the differences between the two templates or refer to metalink note 165195.1 for further details.

So, autoconfig shows me which templates have a different version. Now I have to find out which customizations are made to this template and update the customized template to the higher version of the template. You can use the unix 'diff ' command to compare the two templates.
Adjust the customized template and run autoconfig again..
You can also look into the patch logfile to find out which templates are modified....

Friday, June 01, 2007

Blog value

A half year ago (December 2006) I posted the value of my blog. At that moment It was worth
564.54 dollar...
A half year later...

My blog is worth $3,951.78.
How much is your blog worth?