mastweb.scrcu.com:/oracle/home/oracle/ogg12>export NLS_LANG=en_US.AL32UTF8
mastweb.scrcu.com:/oracle/home/oracle/ogg12>sqlplus lzl/lzl
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 27 11:15:11 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified
mastweb.scrcu.com:/oracle/home/oracle/ogg12>export NLS_LANG=
mastweb.scrcu.com:/oracle/home/oracle/ogg12>sqlplus lzl/lzl
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 27 11:18:14 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select userenv('LANGUAGE') from dual; --进库查看userenv('LANGUAGE')
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
mastweb.scrcu.com:/oracle/home/oracle/ogg12>export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
mastweb.scrcu.com:/oracle/home/oracle/ogg12>sqlplus mid/mid
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 27 11:18:38 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from "test1124";
ID
----------
NAME
--------------------------------------------------------------------------------
VAL
----------
3
胜多负少的 --可以查到中文
1. 是NLS_LANG不是LANG
2.export NLS_LANG的值是select userenv('LANGUAGE') from dual
3.是AMERICAN_AMERICA不是AMERICA_AMERICAN