oracle ORA-28001 密码过期后在 SQL Developer 中更改密码
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/16870466/
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
Change password in SQL Developer after ORA-28001 the password has expired
提问by Mahmoud Saleh
When trying to connect to my database with Oracle SQL Developer, I am getting the error:
尝试使用 Oracle SQL Developer 连接到我的数据库时,出现错误:
ORA-28001 the password has expired
ORA-28001 密码已过期
How can I change my password in SQL Developer?
如何在 SQL Developer 中更改密码?
回答by Mahmoud Saleh
Open SQL Developer and perform the following steps:
打开 SQL Developer 并执行以下步骤:
Right click on Connections > New Connection.
- Connection Name: sys
- Username: sys as sysdba
- Password: sys (or your sys password)
- Hostname: your database server IP
- Port: 1521
- SID: your sid
click connect.
Expand other users, and choose the user with the expired password. Right click and "edit" the user, enter the new password and confirm it.
If you want your password to never expire again uncheck the box for password expiry.
右键单击“连接”>“新建连接”。
- 连接名称:sys
- 用户名:sys as sysdba
- 密码:sys(或您的 sys 密码)
- 主机名:您的数据库服务器 IP
- 端口: 1521
- SID: 你的 sid
点击连接。
展开其他用户,选择密码过期的用户。右键单击并“编辑”用户,输入新密码并确认。
如果您希望密码永不过期,请取消选中密码过期框。