oracle 系统用户密码已过期

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/17556483/
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:08:53  来源:igfitidea点击:

System users password has expired

oracleoracle11g

提问by RNJ

I have just tried to login to my db via sql developer as system so i can create a new user. It has come with an error that the password has expired.

我刚刚尝试通过 sql developer 作为系统登录到我的数据库,以便我可以创建一个新用户。它带有密码已过期的错误。

I have googled a bit but cannot see how to reset the system user password. I guess this is a security issue.

我用谷歌搜索了一下,但看不到如何重置系统用户密码。我想这是一个安全问题。

My problem is how can I log in as system if the password has expired? How can I unexpire the password without logging in as System users. I seem to be stuck here in a loop where I cannot reset the password expiration.

我的问题是,如果密码已过期,我如何以系统身份登录?如何在不以系统用户身份登录的情况下取消密码过期。我似乎陷入了无法重置密码过期的循环中。

回答by jDeveloper

Open up cmd.exeand type in SQLPLUS

打开cmd.exe并输入 SQLPLUS

 Enter user-name: SYSTEM
 Enter password: the expired password 

It will now let you type in a new password for the SYSTEM user

现在,您可以为 SYSTEM 用户输入新密码

回答by BA TabNabber

If SQLPLUS is not available, you can also reset an expired password from within SQL Developer:

如果 SQLPLUS 不可用,您还可以从 SQL Developer 中重置过期密码:

  • Save your connection information (if not done already)
  • Right click on your connection
  • Click on the “Reset Password” option in the menu, enter old/new password blah blah blah
  • 保存您的连接信息(如果尚未完成)
  • 右键单击您的连接
  • 单击菜单中的“重置密码”选项,输入旧/新密码等等

回答by Sandro

If someone drops by from a Google search but uses IntelliJ: You can reset the system password in the connection properties' "Advanced" tab. There you can set the new one as a value for the oracle.jdbc.newPasswordkey.

如果有人通过 Google 搜索访问但使用 IntelliJ:您可以在连接属性的“高级”选项卡中重置系统密码。在那里您可以将新的设置为oracle.jdbc.newPassword键的值。