oracle密码特殊符,设置oracle 含特殊字符密码 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 1342964878...

在shell中无法使用含$的密码使用sqlplus直接登录,而使用sqlplus /nolog connect p/w方式可以登录

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

[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"

[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>