oracle ORA-2800: qtp 中的帐户被锁定错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13230462/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-2800: account is locked error in qtp
提问by Bharath Krishnamurthy
I am getting the following error while connecting to db for checking db timings through QTPscripts:
连接到数据库以通过QTP脚本检查数据库计时时出现以下错误：
"Cannot update system time with database time due to error: ERROR: [Oracle][ODBC][Ora]ORA-28000: the account is locked"
But the database SIDand credentials given are correct and verified the same in some db client. I am not sure why its throwing error in QTP?
但是SID给出的数据库和凭据是正确的，并且在某些 db 客户端中已验证相同。我不确定为什么它会抛出错误QTP？
Can anyone please help me resolve the issue?
任何人都可以帮我解决这个问题吗？
回答by J.Hudler
1) Login to your Oracle Database using admin privileges:
1) 使用管理员权限登录到您的 Oracle 数据库：
cmd> sqlplus / as sysdba
cmd> sqlplus / as sysdba
or
或者
cmd> sqlplus system/{systemPassword}@{OracleSID}
cmd> sqlplus system/{systemPassword}@{OracleSID}
2) Unlock your user's account using the following command:
2) 使用以下命令解锁您的用户帐户：
sql> alter user {yourDbUser} account unlock;
sql> alter user {yourDbUser} account unlock;
3) Still in SQL*Plus command prompt, prevent account locks to not occur again:
3）还是在SQL*Plus命令提示符下，防止账户锁不再发生：
sql> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_LIFE_TIME UNLIMITED;
sql> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_LIFE_TIME UNLIMITED;
sql> ALTER PROFILE "DEFAULT" LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
sql> ALTER PROFILE "DEFAULT" LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Edit due comment
编辑适当的评论
The above instructions should solve your problem. I'm posting an additional command I've found related to this subject you can try (I'm not confident it is the solution though):
以上说明应该可以解决您的问题。我正在发布一个我发现与此主题相关的附加命令，您可以尝试（尽管我不确定它是解决方案）：
sql> grant connect, resource to {yourDbUser};
sql> grant connect, resource to {yourDbUser};
You can also check for the status of other locked users in your database. Maybeyour tool is trying to connect with some other user that, besides the one you are using, still have this issue.
您还可以检查数据库中其他锁定用户的状态。也许您的工具正在尝试与其他用户建立联系，除了您正在使用的用户之外，该用户仍然存在此问题。
回答by user3110281
This solution is for Oracle 10g and error ORA-28000:the account is locked Type in the SQL Command Line:
此解决方案适用于 Oracle 10g 和错误 ORA-28000:the account is locked 在 SQL 命令行中键入：
conn sys as sysdba
enter password
输入密码
alter user system account unlock;
