进入sqlplus之前先设置SET NLS_LANG=AMERICAN,再输入SQLPLUS SYS AS SYSDBA,即可正常显示英文
C:\Users\legion>SET NLS_LANG=AMERICAN
C:\Users\legion>SQLPLUS SYS AS SYSDBA
SQL*Plus: Release 12.2.0.1.0 Production on Tue Jun 16 01:36:14 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
查看服务端的字符集,执行下面的SQL找出这3个参数值
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
NLS_TERRITORY
AMERICA
NLS_LANGUAGE
AMERICAN
依照NLS_LANG的内容格式:NLS_LANG=NLS_LANGUAGE_NLS_TERRI