oracle忘记密码并修改

oracle忘记密码并修改密码进入

# su - oracle

# sqlplus /nolog;

# conn /as sysdba;


# alter user system identified by system;

# alter user sys identified by sys;

# alter database open;


#可以用系统用户进入修改对应的数据库账号密码

# sqlplus system/system@orcl;

alter user xxdb identified by xxdb12346;


#密码永不过期
改完之后输入：ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;


lsnrctl status;