Tuesday, July 29, 2008

Installing new NLS...

I was asked to install an new NLS language on our excisting EBS environment. I had never done this before, usally the NLS is installed during a fresh install of EBS. This time I had to install the German language next to our US end NL languages.


Installing a new language is one thing, I downloaded the German langugae cd from e-delivery. This is a patch that can be installed, so no problem so far. I also downloaded the online help patch from Metalink and started patching.

But how to get the new language one the same pacthlevel as our other languages ? Should you look into every patch ever applied ?? I searched Metalink for a answer and found the following note 252422.1. According to this note Oracle provides you a synchronization patch for your NLS languages. All you have to do is run a perl script $AD_TOP/bin/adgennls.pl
This script genrates an manifest $APPL_TOP/admin/$TWO_TASK/out/adgennls.txt you should upload to Oracle (see the note for prereqs etc..)
I created the manifest for our test enviroment and it looks like this :

# Release: 11i# Active languages: D, NL, US# Manifest generated by adgennls.pl 115.7
abm admin/import/US abmactwk.dis 115.1 D:115.1:0 NL:115.1:0

abm admin/import/US abmcowk.dis 115.1 D:115.1:0 NL:115.1:0
abm admin/import/US abmdepwk.dis 115.1 D:115.1:0 NL:115.1:0
abm admin/import/US abmexpwk.dis 115.1 D:115.1:0 NL:115.1:0
abm admin/import/US abmmatwk.dis 115.1 D:115.1:0 NL:115.1:0
abm patch/115/discover/US abmactaccdaseflo.eex 115.7 D:115.7:0 NL:115.7:0
abm patch/115/discover/US abmactaccdavaflo.eex 115.6 D:115.6:0 NL:115.6:0
abm patch/115/discover/US abmactaccflo.eex 115.5 D:115.5:0 NL:115.5:0
abm patch/115/discover/US abmactbao.eex 115.5 D:115.5:0 NL:115.5:0
abm patch/115/discover/US abmactdrvflo.eex 115.5 D:115.5:0 NL:115.5:0
abm patch/115/discover/US abmactdrvsrcflo.eex 115.5 D:115.5:0 NL:115.5:0

The NL and D files are compared to the US files. If different your NLS is patched by the patch deliverd by Oracle.
So far, I have recieved a Dutch synchronization patch.

No comments: