hi all,

I'm facing problem while searching with a string which contains some spanish character.

In our pre production server, when we are searching in a schema with field1 ='LII TestingRecord - manándar', resulting rcord is having field1= 'LII TestingRecord - manandar'.

Internally its converting the string 'LII TestingRecord - manándar' to ''LII TestingRecord - manandar' and retrieving the result.

But in our production server its not able to convert the string from 'LII TestingRecord - manándar' to ''LII TestingRecord - manandar'

I tried setting the same locale in both the server. Both the server have same version, patch number , DBVERSION in control table , Database Version.

Can anyone please point out why it is behaving differently?

Is there configuration change i need to do?

Thakns and Regards,
KSP

Hi,

Did you check the NLS paramaters of both databases?
Did you check the characterset of both databases?

hi,

NLS parameters and Characterset of both the databases are same.

Any idea what might be the reason?

Regards,
KSP

What about client locale and version? It's the same when you try to perform serach on both server?

locale and version of client tool are also same.We tried logging in both server in the same window. locale En_GB and client version 5.01.02 Patch 1350.

Regards,
KSP

Quite amazing...

Are the locale of both server OS the same?

Can you please let me know how to check that?

Regards,
KSP

On Windows it is: Control Panel --> Regional and Language Options
On Unix (I think) it is: locale -a

i did locale -a and found the same result in both the server, we compared two result sets and those are identical.

Then i check env for both the server. here a small discrepency we found was --
in one server (where the problem does not exists) NLS_LANG parameter is set, which is not the case in other server (where the problem exists).

Do you think this can be the problem?

Regards,
KSP

What is the NLS_LANG Value?
$ echo $NLS_LANG

What's the locale value set in the arsystem startup script?

thanks boss, Finally we resolved the problem. There was no entry for NLS_LANG in the startup script. we put an entry and it worked fine.

thanks a lot for your help.

Regards,
KSP

We are also facing the same problem can you please help me where to see the Startup Script

Thanks in Advance
San

This is the script you are using to start and stop the AR System server...

The Start Up Script for the Testing environment and the Development environment are same.
Please see the Startup Script

ARSYSTEM_START()
{
RPC=`rpcinfo -p > /dev/null 2>&1`
if [ $? != 0 ]; then
echo "RPC is not initialized."
exit 0
fi
$PS | egrep "\-s ${AR_SERVER_ID} " | egrep 'arserverd' | egrep -v egrep > /dev/null
if [ $? = 0 ]; then
echo "Action Request System is already initialized."
exit 0
fi
$PS | egrep "\-s ${AR_SERVER_ID} " | egrep 'armonitor' | egrep -v egrep > /dev/null
if [ $? = 0 ]; then
echo "Action Request System is already initialized."
exit 0
fi
echo "Action Request System initializing."

#=========================================================
echo "Starting AR System Server"
if [ -x ${INSTALL_DIR}/bin/armonitor ]; then
${INSTALL_DIR}/bin/armonitor -s ${AR_SERVER_ID} -c ${ARMON_CONF} 2>&1 &
sleep 40
else
if [ -x ${INSTALL_DIR}/bin/arserverd ]; then
${INSTALL_DIR}/bin/arserverd -s ${AR_SERVER_ID} -i ${INSTALL_DIR} -l ${AR_SYSTEM_LIC_DIR} 2>&1 &
sleep 40
fi
fi
echo 'Action Request System initialization is complete.'
#=========================================================
}

#================================================
# ARSYSTEM_STOP - Stop the armonitor and associated servers
#================================================
ARSYSTEM_STOP()
{
echo "Action Request System shutdown in progress."
rpcb=`rpcinfo -p 1>/dev/null 2>&1;echo $?`
[ $rpcb -eq 0 ] && rpcinfo -d 390600 1 1>/dev/null 2>&1
#stop all the daemons (armonitor, arserverd, armaild, arservdsd, arservftd)
STOP_SERVER "armonitor"
[ $? -eq 1 ] && echo "Action Request System Monitor shutdown failed."
STOP_SERVER "arserverd"
[ $? -eq 1 ] && echo "Action Request System Server shutdown failed."
STOP_SERVER "armaild"
[ $? -eq 1 ] && echo "Action Request System Email Server shutdown failed."
STOP_SERVER "arservdsd"
[ $? -eq 1 ] && echo "Action Request System Distributed Server shutdown failed."
STOP_SERVER "arservftd"
[ $? -eq 1 ] && echo "Action Request System Full Text Index Server shutdown failed."

# Get any other processes accociated with this server ID (.i.e Approval Server)
PIDS=`$PS | egrep "${PROD_PROGS}" | egrep "\-s $AR_SERVER_ID |\-s $AR_SERVER_ID$" | egrep -v egrep | awk '{print $2}'`

if [ "${PIDS}" != "" ]; then
# Stop the remaining processes all at once
kill -15 ${PIDS} >> /dev/null 2>&1
#give the processes a few seconds to come down
RETRY=0
# Quick escape if the process stopped or else wait some more
while [ "${PIDS}" != "" ] && [ "${RETRY}" -lt "${MAX_RETRY}" ]
do
sleep 5
RETRY=`expr $RETRY + 1`
PIDS=`$PS | egrep "${PROD_PROGS}" | egrep "\-s $AR_SERVER_ID |\-s $AR_SERVER_ID$" | egrep -v egrep | awk '{print $2}'`
done

#make sure the server went away
if [ "${PIDS}" != "" ]; then
# Hard kill any remaining process
kill -9 ${PIDS} >> /dev/null 2>&1
RETRY=0
# Quick escape if the process stopped or else wait some more
while [ "${PIDS}" != "" ] && [ "${RETRY}" -lt "${MAX_RETRY}" ]
do
sleep 5
RETRY=`expr $RETRY + 1`
PIDS=`$PS | egrep "${PROD_PROGS}" | egrep "\-s $AR_SERVER_ID |\-s $AR_SERVER_ID$" | egrep -v egrep | awk '{print $2}'`
done
fi
if [ "${PIDS}" != "" ]; then
echo "The following processes could not be stopped and may need to be stopped manually:"
$PS | egrep "\-s $AR_SERVER_ID |\-s $AR_SERVER_ID$" | egrep -v egrep
fi
fi
echo 'Action Request System shutdown process complete.'
}

#================================================
# MAIN
#================================================

case $PLATFORM in
"aix" ) if [ "$LIBPATH" = "" ]; then
LIBPATH=/usr/lib:/lib:${SHR_LIB_PATH}${JAVADIR}
else
LIBPATH=$LIBPATH:${SHR_LIB_PATH}${JAVADIR}
fi
export LIBPATH
;;
"hpux" ) if [ "$SHLIB_PATH" = "" ]; then
SHLIB_PATH=${SHR_LIB_PATH}${JAVADIR}:/usr/lib:/lib
else
SHLIB_PATH=${SHR_LIB_PATH}${JAVADIR}:$SHLIB_PATH
fi
export SHLIB_PATH
;;
"linux"|"solaris" ) FTSLIBPATH=${INSTALL_DIR}/common/_solaris/bin
if [ "$LD_LIBRARY_PATH" = "" ]; then
LD_LIBRARY_PATH=/usr/lib:/lib:${FTSLIBPATH}:${SHR_LIB_PATH}${JAVADIR}
else
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:${FTSLIBPATH}:${SHR_LIB_PATH}${JAVADIR}
fi
export LD_LIBRARY_PATH
;;
esac

language=`echo $LANG|cut -c1-2`
if [ -d $DB_HOME/ocommon/nls/admin/data ]; then
#=========================================
# Set the appropriate variables for Oracle
#=========================================
ORA_NLS=$DB_HOME/ocommon/nls/admin/data
export ORA_NLS

ORA_NLS32=$ORA_NLS
export ORA_NLS32

ORA_NLS33=$ORA_NLS
export ORA_NLS33

if [ -z "$NLS_LANG" ]; then
case $language in
"ja" ) NLS_LANG=japanese_japan.JA16EUC;;
"de"|"ge" ) NLS_LANG=german_germany.WE8ISO8859P1;;
"fr" ) NLS_LANG=french_france.WE8ISO8859P1;;
"es"|"sp" ) NLS_LANG=spanish_spain.WE8ISO8859P1;;
"da" ) NLS_LANG=danish_denmark.WE8ISO8859P1;;
"du"|"nl" ) NLS_LANG=dutch_netherland.WE8ISO8859P1;;
"fi" ) NLS_LANG=finnish_finland.WE8ISO8859P1;;
"it" ) NLS_LANG=italian_italy.WE8ISO8859P1;;
"no" ) NLS_LANG=norwegian_norway.WE8ISO8859P1;;
"po"|"pt" ) NLS_LANG=portuguese_portugal.WE8ISO8859P1;;
"sv"|"sw" ) NLS_LANG=swedish_sweden.WE8ISO8859P1;;
esac

language=`echo $LANG|cut -c1-5`
case $language in
[Zz][Hh]_CN ) NLS_LANG="simplified chinese"_china.ZHS16GBK;;
[Zz][Hh]_TW ) NLS_LANG="traditional chinese"_taiwan.ZHT16BIG5;;
esac

fi
else
if [ -z "$NLS_LANG" ]; then
case $language in
"ja" ) NLS_LANG=japanese;;
"de"|"ge" ) NLS_LANG=german;;
"fr" ) NLS_LANG=french;;
"es"|"sp" ) NLS_LANG=spanish;;
"da" ) NLS_LANG=danish;;
"du"|"nl" ) NLS_LANG=dutch;;
"fi" ) NLS_LANG=finnish;;
"it" ) NLS_LANG=italian;;
"no" ) NLS_LANG=norwegian;;
"po"|"pt" ) NLS_LANG=portuguese;;
"sv"|"sw" ) NLS_LANG=swedish;;
esac

language=`echo $LANG|cut -c1-5`
case $language in
[Zz][Hh]_CN ) NLS_LANG="simplified chinese";;
[Zz][Hh]_TW ) NLS_LANG="traditional chinese";;
esac
fi
fi

[ "$NLS_LANG" != "" ] && export NLS_LANG

ARLANG=$language
if [ "$NLSPATH" = "" ]; then
NLSPATH=/usr/lib/locale/$ARLANG/LC_MESSAGES/%N:${INSTALL_DIR}/locale/$ARLANG/%N
else
NLSPATH=$NLSPATH:${INSTALL_DIR}/locale/$ARLANG/%N
fi
export NLSPATH

#===========================================
# Set the appropriate variables for Informix
#===========================================

if [ -z "$CLIENT_LOCALE" ]; then
language=`echo $LANG|cut -c1-2`
case $language in
ja ) CLIENT_LOCALE=ja_jp.sjis;;
"de"|"ge" ) CLIENT_LOCALE=de_de.8859-1;;
fr ) CLIENT_LOCALE=fr_fr.8859-1;;
"es"|"sp" ) CLIENT_LOCALE=es_es.8859-1;;
da ) CLIENT_LOCALE=da_dk.8859-1;;
du|nl ) CLIENT_LOCALE=nl_nl.8859-1;;
"fi" ) CLIENT_LOCALE=fi_fi.8859-1;;
it ) CLIENT_LOCALE=it_it.8859-1;;
no ) CLIENT_LOCALE=no_no.8859-1;;
"po"|"pt" ) CLIENT_LOCALE=pt_pt.8859-1;;
"sv"|"sw" ) CLIENT_LOCALE=sv_se.8859-1;;
zh ) CLIENT_LOCALE=zh_tw.big5;;
* ) CLIENT_LOCALE=en_us.8859-1;;
esac
export CLIENT_LOCALE
fi

case "$1" in
'start_msg') echo "Starting Action Request System Servers"
;;
'stop_msg') echo "Stopping Action Request System Servers"
;;
'start') ARSYSTEM_START
;;
'stop') ARSYSTEM_STOP
;;
'restart') echo "Action Request System beginning the restart process."
ARSYSTEM_STOP
sleep 10
ARSYSTEM_START
;;
* ) echo "Usage: ${INSTALL_DIR}/bin/arsystem { start | stop | restart }"
;;
esac

Please help me to fix this issue
Thanks and Regards
Santosh

Hi,

This is not the entire file.

At the begin of this file, you should have this :

#! /bin/sh
#
# %name: arsystem %
# %version: 76 %
# %date_modified: Tues Feb 18 19:23:00 2003 %
#
#=====================================
# The following variables are modified
# during the server installation
#=====================================
INSTALL_DIR=/opt/arsystem/linuxoracle
LANG=fr_FR.UTF-8
OLANG=fr_FR.UTF-8
AR_SERVER_ID=linuxoracle
PLATFORM=linux
JAVADIR=:/usr/java/j2sdk1.4.2_12:/usr/java/j2sdk1.4.2_12/jre/lib/i386/server:/usr/java/j2sdk1.4.2_12/jre/lib/i386:/usr/java/j2sdk1.4.2_12/jre/lib/i386/native_threads
DB2PROFILE=
FULHOME=
FTSPROFILE=
CONFDIR=/opt/arsystem/linuxoracle/conf
TNS_ADMIN=/opt/oracle/OraHome1/network/admin/; export TNS_ADMIN

This is here