关于Environment variable的设置，无语了...

在做字符集测试的时候，想把系统环境变量NLS_LANG设为AMERICAN_AMERICA.US7ASCII，于是进行如下操作：

C:\Documents and Settings\p485224>set NLS_LANG=AMERICAN_AMERICA.US7ASCII;

可是用SQLPLUS死活连不进去了：

C:\Documents and Settings\p485224>SQLPLUS

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 24 16:49:01 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / AS SYSDBA
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

最后从文档上copy了一下粘贴上去，竟然成功了：

C:\Documents and Settings\p485224>set NLS_LANG=AMERICAN_AMERICA.US7ASCII

C:\Documents and Settings\p485224>SQLPLUS

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 24 16:49:17 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / AS SYSDBA

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>
SQL>

仔细一看，其中的区别让我真的很郁闷......一开始我总在最后加了一个“;”，所以一直不行！！！哎，如此的一个小问题，搞了半天才搞定。不过清楚了以后就不会犯类似的错误了~~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9765498/viewspace-217053/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9765498/viewspace-217053/