oracle ORA-00988: 密码丢失或无效
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/30625490/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-00988: missing or invalid password(s)
提问by inanutshellus
I'm trying to change an oracle password:
我正在尝试更改 oracle 密码：
alter user FOO identified by 'BAR';
and I'm getting the following back:
我得到以下回复：
Error starting at line 120 in command:
alter user FOO identified by 'BAR'
Error report:
SQL Error: ORA-00988: missing or invalid password(s)
00988. 00000 - "missing or invalid password(s)"
What's going on?
这是怎么回事？
回答by inanutshellus
Turns out one doesn't put the password in single quotes. Double quotes are required if the password contains some special characters.
事实证明，没有将密码放在单引号中。如果密码包含一些特殊字符，则需要双引号。
alter user FOO identified by 'BAR'; -- Broken
alter user FOO identified by BAR; -- Works
alter user FOO identified by "BAR"; -- Works
回答by David Lipschitz
alter user davidl identified by "newpassword" replace "oldpassword";
更改由“newpassword”标识的用户davidl替换“oldpassword”；
回答by Zeus
For me I was altering two users in the same script file, which did not work. I had to alter them in a different script files.
对我来说，我在同一个脚本文件中更改了两个用户，但没有用。我不得不在不同的脚本文件中更改它们。
Sql tool: Golden
Sql工具：金色
