一个可能的原因是用户DBSNMP的密码和sys用户的密码不一致,导致OracleDBConsoleSID服务错误,网上很多朋友说使用emca(EM Configuration Assistant)工具进行修复。在命令行里键入下面两个命令就可以修复数据库的ememca -repos recreateemca -config dbcontrol db
ORA-28000: the account is locked Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account Action: Wait for PASSWORD_LOCK_TIME or contact DBA 导致原因:用户多次频繁输入错误密码 超过了FAILED_LOGIN_ATTEMPTS 限制次数 或者是DBA锁定账户
Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
Action: Wait for PASSWORD_LOCK_TIME or contact DBA
导致原因:用户多次频繁输入错误密码 超过了FAILED_LOGIN_ATTEMPTS 限制次数 或者是DBA锁定账户