oracle sysman locked(timed),dbconsole和sysman用户 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@...

于 2021-04-16 09:13:21 发布
阅读量244 收藏
点赞数
文章标签： oracle sysman locked(timed)

dbconsole一直是我不怎么推荐的oracle工具,但是总有一些客户使用,这里对于dbconsole中sysman用户状态,密码修改做了一些基本的测试

sysman用户被锁

SQL> alter user sysman account lock;

User altered.

重启dbconsole

[oracle@localhost ~]$ emctl stop dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

[oracle@localhost ~]$ emctl start dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ..... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/log

43f7b06570145f22d27fa0b7d498aade.png

部分错误日志提示(这里可以明显dbconsole无法正常使用是由于sysman被锁)

bd3c2a1b3605644412f502df2672d7cf.png

解锁sysman用户

SQL> alter user sysman account unlock;

User altered.

重启dbconsole

[oracle@localhost ~]$ emctl stop dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

[oracle@localhost ~]$ emctl start dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ..... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/log

79cd785541380d27040a08119650cfb2.png

sysman解锁之后重启dbconsole恢复正常

修改sysman密码

SQL> alter user sysman identified by xifenfei;

User altered.

SQL> select account_status from dba_users where username='SYSMAN';

ACCOUNT_STATUS

--------------------------------

OPEN

重启dbconsole

[oracle@localhost ~]$ emctl stop dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

[oracle@localhost ~]$ emctl start dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ..... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/log

SQL> select account_status from dba_users where username='SYSMAN';

ACCOUNT_STATUS

--------------------------------

LOCKED(TIMED)

由于dbconsole的密码存储在配置文件中，修改sysman密码，而配置文件的没有修改，因此使用错误是syman密码登录，超过了profile里面设置的10次，导致用户被锁.

解决sysman密码不对导致异常问题

[oracle@localhost ~]$ emctl stop dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

[oracle@localhost config]$ pwd

/u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/config

[oracle@localhost config]$ ls -l emoms.properties

-rw-r--r--. 1 oracle oinstall 1669 Nov 25 15:20 emoms.properties

[oracle@localhost config]$ grep emdRepPwd emoms.properties|grep -v emdRepPwdSeed

oracle.sysman.eml.mntr.emdRepPwd=e3299b5db6162f5d

oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

[oracle@localhost config]$ grep emdRepPwd emoms.properties|grep -v emdRepPwdSeed

oracle.sysman.eml.mntr.emdRepPwd=xifenfei

oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

SQL> alter user sysman account unlock;

User altered.

[oracle@localhost ~]$ emctl start dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ..... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/log

通过人工修改$ORACLE_HOME/localhost_sid/sysman/config/emoms.properties文件中的oracle.sysman.eml.mntr.emdRepPwd=密码，oracle.sysman.eml.mntr.emdRepPwdEncrypted=false实现修改密码

[oracle@localhost config]$ grep emdRepPwd emoms.properties|grep -v emdRepPwdSeed

oracle.sysman.eml.mntr.emdRepPwd=aa537afcbab41e05

oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

dbconsole重启之后，密码又重新被修改为加密方式,在11.2之前修改sysman密码，注意要同步修改emoms.properties中相关密码信息

sysman修改密码( 11.2 and higher)

[oracle@localhost config]$ emctl stop dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

... Stopped.

SQL> alter user sysman identified by xifenfei123;

User altered.

[oracle@localhost ~]$ emctl setpasswd dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Please enter new repository password:

Repository password successfully updated.

[oracle@localhost ~]$ emctl start dbconsole

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LANG = "c"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

https://localhost:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ..... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost_test/sysman/log

嘿嘿超
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle sysman 不存在_Oracle11g重建EM 报ORA-20001: SYSMAN already exists
weixin_39658726的博客
12-19 333
Apr 4, 2015 10:08:09PM oracle.sysman.emcp.EMReposConfig createRepositoryCONFIG: ORA-20001: SYSMAN already exists..ORA-06512: at line 17oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: O...
oracle sysman locked(timed),OEM 404 error after changing SYSMAN password
weixin_42464967的博客
04-16 79
Using Oracle 11gR2 RAC on Oracle Linux OS.Our policies require periodically changing passwords. After I changed the sysman password, oem would not work. I shut down and restarted dbconsole and looke...
dbsnmp 和sysman "LOCKED(TIMED)".
cqw1960的博客
07-09 288
问题提出： dbsnmp和sysman帐号被锁定，解锁后，只要运行oem，马上这两个账号又被锁定。 原因： dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动oracle智能代理，用于收集oracl...
ORACLE EM AGENT 无法连接,SYSMAN账号被锁定。
05-11 220
环境： M1: redhat5 DB_VERSION: 10GR232bit(target) 原因： sysman 密码过期 导致em无法登陆解决： 1.使用命令emctl setpasswd dbc...
dbsnmp和sysman帐号被锁定，解锁后，只要运行oem，马上这两个账号又被锁定。 原因： dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动oracle智能代理，用于收集
札记
08-02 2905
dbsnmp和sysman帐号被锁定，解锁后，只要运行oem，马上这两个账号又被锁定。 原因： dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动oracle智能代理，用于收集oracle系统运行状态的相关数据，sysman是oem的超级管理员。如果配置了oem后，又使用alter user identified by ；修改了这两用户的口令，就会出现dbsn
oracle创建数据库图解.pdf
最新发布
04-02
FRA用于存储备份和恢复文件，归档模式能提供更完整的数据库恢复能力。 9. **数据库内容**: 可以选择是否安装示例方案，以及运行自定义脚本来进一步定制数据库。 10. **初始化参数**: 初始化参数定义了数据库的行为...
“军卫一号”数据库Oracle 10g故障维修2例.pdf
10-09
本文将介绍两例“军卫一号”数据库Oracle 10g故障维修，旨在帮助DBA和系统管理员更好地维护和管理Oracle 10g数据库。 一、故障一：sysman用户账户锁定 在升级“军卫一号”数据库Oracle 10g系统时，可能会出现...
oracle数据库1000问.docx
05-03
以上是Oracle数据库的一些基本操作和概念，实际使用中还需要了解更多的SQL语法、数据类型、索引、安全性、备份恢复、性能调优等复杂主题。对于Oracle数据库管理员来说，掌握这些知识至关重要，因为它们将直接影响到...
Oracle数据库的安装.docx
05-03
- Oracle应用服务器10g是一个全面的、基于标准的平台，它包含了诸如数据库配置、管理工作、数据仓库和事务处理等组件。 - Oracle 10g分为不同的版本，以满足不同需求：企业版包含所有部件和附加选件；标准版适合...
oracle sys sysman system 介绍
weixin_33966095的博客
06-05 140
Oracle数据库中SYS、SYSTEM、DBSNMP、SYSMAN四用户的区别 SYS用户： SYS，默认密码为CHANGE_ON_INSTALL,当创建一个数据库时，SYS用户将被默认创建并授予DBA角色，所有数据库数据字典中的基本表和视图都存储在名为SYS的方案中，这些基本表和视图对于Oracle数据库的操作时非常重要的。为了维护数据字典的真实性，SYS方案中的表只能由系统来维护，他们不能被...
oracle解锁sysman用户,oracle 解锁用户
weixin_30518613的博客
04-02 160
查看oracle实例有哪些用户？涉及的表为dba_users[oracle@rtest~]$sqlplus/nologSQL*Plus:Release11.2.0.3.0ProductiononMonSep211:05:492013Copyright(c)1982,2011,Oracle.Allrightsreserved.idle>conn/as...
oracle locked time,Oracle里面的用户无法登录 LOCKED(TIMED)解决方法
weixin_34123023的博客
04-05 405
为保证安全，本站点已取消所有百度云分享链接，如有下载需要，请在评论里留下邮箱。Oracle数据库查看用户状态一、当前ORACLE用户的状态可查看视图DBA_USERS;一般情况下在使用的正常用户均处于OPEN状态。SQL> select username,account_status from dba_users;USERNAME ACCOUNT_STATUS---...
oracle用户sysman,oracle 10g里面sysman用户的作用是干什么的？
weixin_30316931的博客
04-03 602
UsernamePasswordDescriptionSee AlsoCTXSYSCTXSYSThe Oracle Text accountOracle Text ReferenceDBSNMPDBSNMPThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and ma...
Oracle12c 在导入数据时user locked(timed) 故障处理
专注企业信息化
08-29 1140
一、Navicat 登录时提示 1. ERROR:ORA-28000: the account is locked 2. web管理台显示 SYSTEM 账户状态：LOCKED(TIMED) 3. 表明:oracle 中 system用户因密码不对，10次以后，就被locked。 二、解锁及修改密码方法 1.更改前 SQL> select account_status,lock_d
(ZT)修改SYSMAN的密码我忙活了一天【笔记】。
cuantiaowei3015的博客
04-04 122
原文：http://www.itpub.net/viewthread.php?tid=1147818&pid=13285817&page=1&extra=#pid13285817 修改SYSMAN的...
oracle中的dbsnmp和sysman用户介绍
09-16 256
dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动oracle智能代理，用于收集oracle系统运行状态的相关数据SYSMAN是Oracle数据库中用于EM管理的用户 ...
oracle用户sysman,Oracle 修改sysman, dbsnmp 用户密码
weixin_39874809的博客
04-03 556
Oracle10g以上密码失效问题oracleem无法登录，其中有两个用户可能密码失效1、sysman2、dbsnmp首先，以SYS DBA身份进入sqlpulsSQL->sys/pwdas sysdba登录成功以后查询DBA用户状态SQL->selectusername,account_status from dba_users;查看其中常用的用户状态是否是EXPIRED还是LOCK...
oracle解锁sysman用户,详解Oracle如何解锁用户的方法
weixin_30880009的博客
04-02 527
在这里我们要介绍的是Oracle如何解锁用户的方法，对于Oracle如何解锁用户，一般我们都是试用默认密码来进行。希望本文对大家有所帮助。1. 安装时选择的自动安装，由于时间久远忘记用户名、密码了，导致现在试了几个默认的用户名密码後(表格中附带默认用户名及密码)，都提示无效的用户名、密码，终于在试了下dbsnmp/dbsnmp，提示被锁；2. 在CMD中启动SQLPLUS；用sqlplus/as ...
配置EM时的DBSNMP用户和SYSMAN用户
鲨鱼胃的博客
12-04 833
关于DBSNMP与SYSMAN的描述：–来自官方文档 手工建库完成后，数据库中默认只有SYS、SYSTEM等，没有SYSMAN用户，并且DBSNMP是锁定的。 DBSNMP用户在EMCA的交互时输入密码后即被解锁，而SYSMAN用户则需要等到EM整个创建完成才会在数据库中创建（如创建过程出错时数据库中并未创建此用户）。 user 默认passwd details DBSNMP DB...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值