oracle用户密码设置的特殊字符问题

当oracle用户的密码里带有如@、$、!等特殊字符时，会出现一些问题。

以hr用户为例：

当oracle用户的密码里带有@时：

SYS@ORCL> alter user hr identified by qwet@2017;

alter user hr identified by qwet@2017

*

ERROR at line 1:

ORA-00922: missing or invalid option

SYS@ORCL> alter user hr identified by 'qwet@2017';

alter user hr identified by 'qwet@2017'

*

ERROR at line 1:

ORA-00988: missing or invalid password(s)

SYS@ORCL> alter user hr identified by "qwet@2017";

User altered.

修改密码需用双引号包含密码；

[oracle@hhu Desktop]$ sqlplus hr/qwet@2017

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:09:09 2017

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

ERROR:

ORA-12543: TNS:destination host unreachable

Enter user-name:

[oracle@hhu Desktop]$ sqlplus 'hr/"qwet@2017"'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:08:28 2017

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

HR@ORCL>

在linux脚本或shell中需要填写用户名和密码时候按以下格式稍加修改；

            '用户名/"密码"'，加一对单引号和一对双引号

当使用!时：

HR@ORCL> alter user hr identified by qwet!2017;

alter user hr identified by qwet!2017

*

ERROR at line 1:

ORA-00922: missing or invalid option

HR@ORCL> alter user hr identified by "qwet!2017";

User altered.

[oracle@hhu Desktop]$ sqlplus 'hr/"qwet!2017"'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:01:38 2017

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

HR@ORCL>

当使用$时：

HR@ORCL> alter user hr identified by qwet$2017;

User altered.

HR@ORCL> conn hr/qwet$2017;

Connected.

[oracle@hhu Desktop]$ sqlplus hr/qwet$2017

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:21 2017

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

[oracle@hhu Desktop]$ sqlplus hr/"qwet$2017"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:35 2017

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

[oracle@hhu Desktop]$ sqlplus 'hr/"qwet$2017"'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:44 2017

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

HR@ORCL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29067253/viewspace-2144617/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29067253/viewspace-2144617/