sqlplus / as sysdba
登录数据库
alter user scott account unlock;
解锁Scott用户
select username,account_status from dba_users;
查看密码状态为expired
alter user scott identified by oracle;
将Scott用户密码修改为oracle;
conn scott/oracle;
连接scoot用户成功
sqlplus / as sysdba
登录数据库
alter user scott account unlock;
解锁Scott用户
select username,account_status from dba_users;
查看密码状态为expired
alter user scott identified by oracle;
将Scott用户密码修改为oracle;
conn scott/oracle;
连接scoot用户成功