ARABIC setup for oracle DB on linux red hat 4
580303Jun 5 2008 — edited Jun 8 2008Hi,
i have installed oracle DB on red hat 4 linux OS. I want to input and read/view arabic data on the oracle db. my oralce db NLS parameter setting are given below.
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0
also please let me know what changes do i have to make to my .bash_profile file in linux OS. the content of the file is given below.
#bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/u02/oracle
ORACLE_HOME=/u02/oracle/product/10.2.0/db_1
ORACLE_SID=fgbuatdb
LD_LIBRARY_PATH=/u02/oracle/product/10.2.0/db_1/lib
TNS_ADMIN=/u02/oracle/product/10.2.0/db_1/network/admin
PATH=/u02/oracle/product/10.2.0/db_1/bin:/u02/oracle/product/10.2.0/db_1/OPatch:$PATH
ORA_NLS33=/u02/oracle/product/10.2.0/db_1/ocommon/nls/admin/data; export ORA_NLS33
NLS_LANG=ARABIC_.AR8ISO8859P6; export NLS_LANG
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN