当Oracle数据库用户的密码含特殊字符如 @ 时,直接使用正常的密码输入,由于oracle将@后的字符解析为网络服务名而导致登陆失败
创建一个密码中含有特殊符号的用户: test
SQL> create user test identified by "aba123!@#"; --用户名:test 密码:aba123!@# 注意创建的时候用双引号 User created. SQL> grant create session to test; Grant succeeded.
Linux平台登录方式:'test/"aba123!@#"'@scp --1个双引号扩密码,1个单引号扩 用户名+密码,即: '用户名/"密码"'@服务名
[oracle@dg1 ~]$ sqlplus 'test/"aba123!@#"'@scp SQL*Plus: Release 12.1.0.2.0 Production on Thu May 26 00:34:37 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL>
Windows 平台:test/"""aba123!@#"""@10.0.96.96/etdb --3个双引号扩密码,即: 用户名/"""密码"""@服务名
C:UsersChangchun>sqlplus test/"""aba123!@#"""@10.0.96.96/etdb SQL*Plus: Release 11.2.0.1.0 Production on 星期三 5月 25 16:36:53 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. 连接到: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL>
文章参考:http://www.68idc.cn/help/mysqldata/oracle/2013031423677.html