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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-10 05:04:03  来源:igfitidea点击:

Change password in SQL Developer after ORA-28001 the password has expired

oracleoracle-sqldeveloper

提问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 并执行以下步骤:

  1. 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.

  2. 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.

  1. 右键单击“连接”>“新建连接”。

    • 连接名称:sys
    • 用户名:sys as sysdba
    • 密码:sys(或您的 sys 密码)
    • 主机名:您的数据库服务器 IP
    • 端口: 1521
    • SID: 你的 sid

    点击连接。

  2. 展开其他用户,选择密码过期的用户。右键单击并“编辑”用户,输入新密码并确认。

    如果您希望密码永不过期,请取消选中密码过期框。