本篇內容主要講解“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用戶密碼設置為什么不能有特殊字符”有了更深的了解，不妨來實際操作一番吧！這里是億速云網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
