oracle使用者口令中帶@符號問題

oracle使用者口令中帶@符號問題

==================

oracle@localhost ~$sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 28 17:46:46 2010
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

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

建立特殊符號口令使用者
SQL>  create user abs_test identified by "abc@dd";
User created.

SQL> grant dba to abs_test;
Grant succeeded.

本地連線使用雙引號擴住本地就可以登陸
SQL>  conn abs_test/"abc@dd"
Connected.
SQL>

SQL> create user an identified by an ; 
User created.

SQL> grant dba to an;
Grant succeeded.

遠端連線
普通口令使用者
C:\Documents and Settings\Administrator>sqlplus an/an@197
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 12月 28 18:01:31 2010
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

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

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

帶特殊字元口令使用者
C:\Documents and Settings\Administrator>sqlplus abs_test/"abc@dd"@197
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 12月 28 18:01:35 2010
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

結論：雖然本地連線可以，但遠端連線還是連不上，有限制的。
   不能這麼使用

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13177610/viewspace-682741/，如需轉載，請註明出處，否則將追究法律責任。