ORACLE技术论坛–请到ask.orasos.com提问

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
sqlplus 直接登录含有$的密码的oracle用户
2015 年 11 月 06 日
08:44
惜分飞
Admin
Forum Posts: 344
Member Since:
2010 年 07 月 31 日
Offline

[oracle@web103 ~]$ ss

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:34:01 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user test1 identified by "a$b";

User created.

SQL> grant dba to test1;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

[oracle@web103 ~]$ sqlplus test1/a$b

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:41:27 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

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

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
[oracle@web103 ~]$ sqlplus test1/"a$b"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:41:32 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

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

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
[oracle@web103 ~]$

 

[oracle@web103 ~]$ sqlplus test1/"a\$b"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:36:21 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user;
USER is "TEST1"

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

2015 年 11 月 06 日
08:46
惜分飞
Admin
Forum Posts: 344
Member Since:
2010 年 07 月 31 日
Offline

原因是由于$在shell中是定义变量的,因为在sqlplus中直接登录含$的,就无法正常使用,需要转义,或者使用间接登录方式

[oracle@web103 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:45:50 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn test1/a$b
Connected.
SQL> show user;
USER is "TEST1"
SQL>

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。