Dbconsole 中 dbsnmp账户被锁后的处理
来源:互联网 发布:软件外包服务商排名 编辑:程序博客网 时间:2024/06/13 22:09
本文不做翻译。仅作转载。
Applies to:
Enterprise Manager for Oracle Database - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Information in this document applies to any platform.
***Checked for relevance on 09-Apr-2012***
Checked for relevance on 01-Jul-2014
Symptoms
The EM DBConsole service will not start on Windows and dbsnmp account keeps getting locked.
Cause
The password set in the targets.xml for the dbsnmp account is invalid and the dbsnmp account has been set to use a profile that locks the account after x attempts of unsuccessful logins . This can be seen by:-
1) SELECT username "User Name" , profile from sys.dba_users
where username in ( 'DBSNMP') ORDER BY username;
2) SELECT resource_name, limit, profile FROM sys.dba_profiles
where profile in ('&profileName1') and resource_name ='FAILED_LOGIN_ATTEMPTS'
for ProfileName1 enter the value returned from query 1
3) select username, account_status, lock_date from dba_users where username in ('DBSNMP');
Solution
1) stop dbconsole
emctl stop dbconsole
either move/backup the log files in $ORACLE_HOME/host_sid/sysman/log or delete them
2) at sqlplus:-
alter user dbsnmp account unlock;
select username, account_status, lock_date from dba_users where username in ( 'DBSNMP');
3) Make sure that the dbsnmp password is known. To test this, log into the database and do:-
connect dbsnmp/<the dbsnmp password>
if it is not known,
alter user dbsnmp identified by <newpassword>
eg.
alter user dbsnmp identified by dbsnmp1;
4) cd to $ORACLE_HOME/hostname_sid/sysman/emd/targets.xml
under the oracle database section you will see something like:-
<Target TYPE="oracle_database" NAME="ora10204">
<Property NAME="MachineName" VALUE="machine1-uk2.uk.oracle.com" />
<Property NAME="Port" VALUE="1521" />
<Property NAME="SID" VALUE="ora10204" />
<Property NAME="OracleHome" VALUE="D:\10204" />
<Property NAME="UserName" VALUE="ff46ddd9b88bac5c" ENCRYPTED="TRUE" />
<Property NAME="password" VALUE="ff46ddd9b88bac5c" ENCRYPTED="TRUE" />
</Target>
Change:-
the password to be the dbsnmp password and specify ENCRYPTED="FALSE" eg.
in my example:-
<Property NAME="password" VALUE="dbsnmp1" ENCRYPTED="FALSE" />
5) now re-start dbconsole:-
emctl start dbconsole
- Dbconsole 中 dbsnmp账户被锁后的处理
- 主机名变动后不能启动Oracle DBConsole服务的处理
- 关于10g EM DBConsole 中操作系统认证的问题
- Oracle数据库中SYS、SYSTEM、DBSNMP、SYSMAN四用户的区别
- Oracle数据库中SYS、SYSTEM、DBSNMP、SYSMAN四类权限的区别
- 一次修改dbsnmp,sysman密码的尝试
- ORACLE DBCONSOLE 启动的问题
- 配置Oracle dbconsole的密钥
- Oracle EM中 启动数据库时 操作系统用户名账户 总是提示错误的处理
- Android如何在账户设置中添加App的账户
- oracle 10g em 中如何修改dbsnmp用户密码
- oracle 10g em 中如何修改dbsnmp用户密码
- emctl start dbconsole启动失败的解决办法
- emctl start dbconsole起不来问题的解决
- emctl start dbconsole起不来问题的解决
- 重 新配置dbconsole的步骤
- 启动em dbconsole遇到的timezone问题
- 启动dbconsole遇到的timezone问题
- 窗口移动、改变大小的有关消息
- 最大匹配分词切分错误分类
- 绘图与动画学习笔记(一)
- UVA 11534 - Say Goodbye to Tic-Tac-Toe(博弈sg函数)
- android模拟器 报错:X Error of failed request: BadRequest (invalid request code or no such operation)
- Dbconsole 中 dbsnmp账户被锁后的处理
- 字符串 下
- java switch语句详解
- Lake Counting
- 黑马程序员_java基础篇之集合框架
- Codeforces Beta Round #57 (Div. 2) E. Enemy is weak
- 娓娓道来c指针 (0)c语言的梦魇:c指针
- HDU 1021 Fibonacci Again
- 一张图告诉你HTML 5 的历史