欢迎和大家交流技术相关问题:
邮箱: jiangxinnju@163.com
博客园地址:
GitHub地址: https://github.com/jiangxincode
知乎地址: https://www.zhihu.com/people/jiangxinnju
忘记除SYS、SYSTEM用户之外的用户的登录密码
CONN SYS/PASS_WORD AS SYSDBA; --用SYS (或SYSTEM)用户登录
ALTER USER user_name IDENTIFIED BY "newpassword"; --修改用户的密码,密码不能是数字开头,否则会出现:ORA-00988: 口令缺失或无效
忘记SYS用户,或者是SYSTEM用户的密码
CONN SYS/PASS_WORD AS SYSDBA; --如果是忘记SYSTEM用户的密码,可以用SYS用户登录。
ALTER USER SYSTEM IDENTIFIED BY "newpassword";
CONN SYSTEM/PASS_WORD AS SYSDBA; --如果是忘记SYS用户的密码,可以用SYSTEM用户登录。
ALTER USER SYS IDENTIFIED BY "newpassword";
SYS,SYSTEM用户的密码都忘记
Oracle提供了两种验证方式,一种是OS验证,另一种密码文件验证方式,如果是第一种方式用以下方法修改密码:
sqlplus /nolog;
connect / as sysdba
alter user sys identified by newpassword;
alter user system identified by newpassword;