Install Oracle 10 Gb in red-flag Linux DC 5.0

If, when you install Oracle 10 Gb in red-flag Linux DC 5.0, all Chinese characters inserted are question marks, do you feel a headache? You don't need to worry about the specific solution to the problem. I hope you will be helpful after browsing.

The following is a list of parameters from select * from nls_database_parameters. The value of NLS_CHARACTERSET is WE8ISO8859P1, and the Chinese characters of INSERT are garbled. Then, use sys to change it to AMERICAN_AMERICA.US7ASCII as sysdba)

 
 

  
  
PARAMETER VALUE  
  
  
NLS_LANGUAGE AMERICAN  
  
  
NLS_TERRITORY AMERICA  
  
  
NLS_CURRENCY $  
  
  
NLS_ISO_CURRENCY AMERICA  
  
  
NLS_NUMERIC_CHARACTERS .,  
  
  
NLS_CHARACTERSET AMERICAN_AMERICA.US7ASCII  
  
  
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 UTF8  
  
  
NLS_RDBMS_VERSION 10.2.0.1.0  
 
 

When installing Oracle 10 Gb in red-flag Linux DC 5.0, You need to perform the following system parameters:

 
 

  
  
CPU Type | Intel(R) Xeon(TM) MP CPU 2.83GHz 
| | Intel(R) Xeon(TM) MP CPU 3.16GHz | | 
Intel(R) Xeon(TM) MP CPU 2.83GHz | | 
Intel(R) Xeon(TM) MP CPU 3.16GHz |  
  
  
| |-- CPU Speed | 2333.751 MHz | 
2333.751 MHz | 2333.751 MHz | 2333.751 MHz  
  
  
| |-- App Architecture x86_64  
  
  
| |-- Kernel Architecture x86_64  
  
  
| |-- Kernel Bit Size  
  
  
| |-- OS Name Linux  
  
  
| |-- OS Version 2.6.9-11.19AXsmp  
  
  
| |-- OS Distribution Asianux release 2.0 (Trinity)  
  
  
| |-- Libc Name glibc  
  
  
| |-- Libc Version 2.3.4  
  
  
| |-- Kernel Version Linux version 2.6.9-11.19AXsmp 
(packager@asianux.com) (gcc version 3.4.3 20050227 
(Asianux 2.0 3.4.3-22.1.1)) #1 SMP Fri Aug 5 05:05:01 EDT 2005  
 
 

The above content is a detailed introduction to the solution where the inserted Chinese characters are all question marks when Oracle is installed for 10 Gb in red-flag Linux DC 5.0.