在Oracle中更改密码 [英] changing password in Oracle

问题描述

大家好！只是要求另一个帮助，如果还可以。



我的问题就在这里。我在oracle数据库11g中的密码已经过期，因为它达到了180天的默认生命周期，我试图使用sqldeveloper重置它，但我总是遇到这样的错误：





执行请求的操作时遇到错误：oracle.jdbc.driver.t2cConnection.t2cCreateState（[BI [BI [BI [BI [BI [BI [S [B [BZ [J]我







供应商代码0





i尝试了seogle搜索谷歌的一些答案，但我也失败了，我找不到任何与我的问题相同的东西。所以我希望有人可以帮助我..



有没有其他方法来检索我的数据库或更改/重置我的密码所以我可以再次使用它。





提前感谢！上帝保佑：）

解决方案

您是否尝试过使用：

  alter   user  user_name标识  new_password; 

如下所述： Oracle / PLSQL：在Oracle中更改用户密码 [< a href =http://www.techonthenet.com/oracle/password.phptarget =_ blanktitle =新窗口> ^ ]



其他资源：

Oracle密码 - 更改，过期和锁定用户 [ ^ ]

重置11g中过期的密码 [ ^ ]

ALTER USER sys由new_password识别;



或



由SysPassWord指定的ALTER USER SYS;

hi everyone! just asking for another help, if its okay.

my problem is here. my password in oracle database 11g has expired because it reaches the default lifespan of 180days and im trying to reset it using sqldeveloper but i always got an error like this:


"An error was encountered performing the requested operation: oracle.jdbc.driver.t2cConnection.t2cCreateState([BI[BI[BI[BI[BI[BI[BI[S[B[BZ[J)I



vendor code 0"


i tried seacrhing google for some answer but i also failed, i can't find anything the same with my problem. So i am hoping with someone who can help me..

is there any other way to retrieve my database or to change/reset my password so i can use it again.


thanks in advance! God bless :)

解决方案

Have you tried to use:

alter user user_name identified by new_password;

as is described here: Oracle/PLSQL: Change a user's password in Oracle[^]

Other resources:
Oracle passwords - changing, expiring and locking users[^]
Reset an expired password in 11g[^]

ALTER USER sys IDENTIFIED BY new_password;

or

ALTER USER SYS IDENTFIED BY SysPassWord ;

这篇关于在Oracle中更改密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！