ORA-01017(:用户名/口令无效; 登录被拒绝)”解决办法
报错:ORA-01017(:用户名/口令无效; 登录被拒绝)1.打开CMD命令窗,输入sqlplus / as sysdba2.再输入conn / as sysdba1)修改密码SQL>alter user 用户名 identified by 密码2)用户被锁定,解锁查询是否被锁select username, account_status, lock_date from dba_users
·
报错:ORA-01017(:用户名/口令无效; 登录被拒绝)
1.打开CMD命令窗,输入sqlplus / as sysdba
2.再输入conn / as sysdba
1)修改密码
SQL>alter user 用户名 identified by 密码
2)用户被锁定,解锁
查询是否被锁
select username, account_status, lock_date from dba_users;
oracle解锁用户
ALTER USER username ACCOUNT UNLOCK;
更多推荐
已为社区贡献2条内容
所有评论(0)