Adding and Maintaining NLS Languages

Adding and Maintaining NLS Languages

* This is the new requirement from our client of Installing Arabic language in our EBS R12.1.3 as a part of HRMS implementation.

I will be giving high level steps here along with the issues faced during this installation of new language.

Step 1. Activate the language

* Check the languages that are already installed in system.

select LANGUAGE_CODE,NLS_LANGUAGE,INSTALLED_FLAG from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

Flag: 
B - Basic
I - Installed

* SO we have only US(American) language installed in our system as basic language, & now need to install Arabic language in addition with below steps.

Login to EBS with System Administrator Responsibility and follow below steps:

Navigation: System Administrator -> License Manager -> Languages-> 

* Check that new languages is in installed status in system.

SQL> select LANGUAGE_CODE,NLS_LANGUAGE,INSTALLED_FLAG from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

LANG     NLS_LANGUAGE                      I

----          ------------------------------           -

US           AMERICAN                              B

AR          ARABIC                                     I

SQL>

Step 2:Run Maintain Multi-lingual tables (MMT)

* Run adadmin and choose below options

     

 * Issues faced during MMT are mentioned at the end of the document.

Step 3.  Run Maintain snapshot information

* Run adadmin and choose below options

* end message will be like below:

1 Step 4.  Run Translation Synchronization Patch utility & Request Translation Synchronization Patches

* Run the Translation Synchronization Patch utility (adgennls.pl), upload the generated manifest to support and Requested Translation Synchronization Patches as per note 252422.1: 

* Upload this file at https://updates.oracle.com/TransSync and wait for patches from oracle.

Fusion Middleware Health `not ok` Alert

Fusion Middleware - WebLogic Admin or Managed servers health warning Alert

So, We had requirement where our SOA team requested to have alert in place if SOA Admin or any of managed servers health goes into warning. As usual, we tried to set the alert from Web-Logic itself using standard method given in oracle DOC ID: 2478424.1 . However we were having this error "SMTPSenderFailedException: 501 5.1.7 Invalid address" which we were not able to resolve even with help of oracle.

Well, we couldn't go to sleep yet and decided to have our own python customized script for the alert and Bingo !! it worked like charm. 

Coming straight to point, Please find below script that can be used for any version of FMW (11g, 12c ). Just copy paste the script and run it using wlst as below:

Step 1: 

$source setDomainEnv.sh 

Step2: 

$java weblogic.WLST  get_wls_serverstatus.py

you can just extract the result of above wlst in log file and grep "'Server OverAll Health" into your mail:

$cat get_wls_serverstatus.py

############################################################################

# This script is for checking the Health Status of the servers

#  Author: @achaltecharch.blogspot.com

############################################################################

#       Connect to the Admin Server

from java.io import FileInputStream

import java.lang

import os

import string

connect("weblogic","******","t3://<Admin Node host>:<port>")

domainRuntime()

 cd('ServerRuntimes')

 servers=domainRuntimeService.getServerRuntimes()

for server in servers:

     serverName=server.getName();

     print '##############' , serverName,'###############'

     print 'Server OverAll Health :', server.getOverallHealthState()

     print '----------------------------------------------'