السلام عليكم ورحمه الله 

 

 

توجد مشكله فى اللغه 

 you need to change nls_lang parameter

 open regedit and navigate to 
HKEY_LOCAL_MACHINE > software> oracle 
and find nls_lang key and change it's value to
AMERICAN_AMERICA.AR8MSWIN1256

or try to run this command from normal cmd console

C:\Documents and Settings\Administrateur>set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256

or you can alter your current session 

SQL> ALTER SESSION SET NLS_LANGUAGE='ENGLISH'

sqlplus / as sysdba

لندخل برنامج SQLPLUS الذى سنجرى فيه كل الأوامر التالية

نبدأ بتنفيذ جملة الSQL التالية لمعرفة التكويد الحالى لقاعدة البيانات

SELECT parameter , value FROM NLS_DATABASE_PARAMETERS WHERE parameter like ‘%CHARACTERSET%’

/

SQL>   2

PARAMETER                      VALUE

—————————— —————————————-

NLS_CHARACTERSET               WE8MSWIN1252

NLS_NCHAR_CHARACTERSET         AL16UTF16

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 6415736832 bytes

Fixed Size                  2217192 bytes

Variable Size            1077938968 bytes

Database Buffers         5330960384 bytes

Redo Buffers                4620288 bytes

Database mounted.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

Database altered.

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> STARTUP;

ORACLE instance started.

Total System Global Area 6415736832 bytes

Fixed Size                  2217192 bytes

Variable Size            1077938968 bytes

Database Buffers         5330960384 bytes

Redo Buffers                4620288 bytes

Database mounted.

Database opened.

SQL> SELECT parameter , value FROM NLS_DATABASE_PARAMETERS WHERE parameter like ‘%CHARACTERSET%’

/  2

PARAMETER

——————————

VALUE

——————————————————————————–

NLS_CHARACTERSET

AL32UTF8

NLS_NCHAR_CHARACTERSET

AL16UTF16

SQL> col VALUE format a10

SQL> /

PARAMETER                      VALUE

—————————— ———-

NLS_CHARACTERSET               AL32UTF8

NLS_NCHAR_CHARACTERSET         AL16UTF16