Oracle帐户被锁解决方法,ORA-28000: the account is locked
登录Oracle
sqlplus /nolog
切换到系统用户
conn sys/sys as sysdba;
使用最高权限解锁此用户
alter user 用户名 account unlock;
尝试登录
[oracle@*** ~]$ sqlplus user/****** SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 5 17:02:15 2020 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
发表评论