当用户密码中含有字符时，需要做特殊的处理才能登陆
1、通过取得sqlplus合法性后登陆
C:\Documents and Settings\olm>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 4月 6 21:47:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter user test identified by "";
用户已更改。
SQL> conn test/""
已连接。
SQL> show user
USER 为 "TEST"
SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
2、通过转义字符转换
C:\Documents and Settings\olm>sqlplus test/""
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 4月 6 21:50:21 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS: 无法解析指定的连接标识符
请输入用户名:
C:\Documents and Settings\olm>sqlplus test/\"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 4月 6 21:51:03 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
阅读(1635) | 评论(0) | 转发(0) |
