oracle用户密码设置为什么不能有特殊字符
本篇内容主要讲解“oracle用户密码设置为什么不能有特殊字符”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“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>
到此，相信大家对“oracle用户密码设置为什么不能有特殊字符”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
![[mysql]mysql8修改root密码](https://static.528045.com/imgs/31.jpg?imageMogr2/format/webp/blur/1x0/quality/35)
