Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ARABIC setup for oracle DB on linux red hat 4

580303Jun 5 2008 — edited Jun 8 2008
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2008
Added on Jun 5 2008
4 comments
956 views