sqlplus登入出错，密码含有特殊字符

最新推荐文章于 2022-01-19 10:11:03 发布

cm771207

最新推荐文章于 2022-01-19 10:11:03 发布

阅读量1.5k

点赞数

文章标签：数据库操作系统

有时候设置密码时候，里面包含了特殊字符，如$, @ ....等等

当密码中含有特殊字符解决办法﹕

例如﹕
SYS AS SYSDBA> alter user win identified by win@123$;
alter user win identified by win@123$
*
ERROR at line 1:
ORA-00922: missing or invalid option

Elapsed: 00:00:00.01
SYS AS SYSDBA> alter user win identified by "win@123$";

User altered.

Elapsed: 00:00:00.03
SYS AS SYSDBA> exit

[oracle@node ~]$ sqlplus win/"win@123$"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 13 19:20:15 2009

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

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

[oracle@node ~]$ sqlplus 'win/"win@123$"'
WIN >
再此win 用戶進入了﹐所以在有特殊字符时是需要转义的

----------

alter user win identified by win@123$;
alter user win identified by win@123$
*
ERROR at line 1:
ORA-00922: missing or invalid option

Elapsed: 00:00:00.01
這條語句是會拋出錯的﹐

下面我們可以用oracle 中的password 命令來修改user 的密碼﹕

SYS AS SYSDBA> password win
Changing password for win
New password: win@123$
Retype new password: win@123$
Password changed
SYS AS SYSDBA> exit;

[oracle@node ~]$ sqlplus 'win/"win@123$"'
WIN >

此時密碼當成一連串的字符來處理了。