1.sqlplus /nolog
2.conn /as sysdba
3.输入“select username from dba_users”;查看用户列表
4.alter user system identified by 123456;修改密码
5.alter user 用户名 account unlock;解锁用户
- SELECT username,account_status FROM dba_users;查看用户是否被锁
7.SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile=’DEFAULT’; 查看现在设置的最大次数
8.alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited; 修改错误次数为不限制