设为首页 加入收藏

TOP

Oracle 11g OCM备考之创建EM与EM登陆异常的处理(二)
2019-05-28 10:08:12 】 浏览:284
Tags:Oracle 11g OCM 备考 创建 登陆 异常 处理
  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/enmoedu1.example.com_PROD1/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. 


***********************************************************


Enterprise Manager configuration completed successfully


FINISHED EMCA at May 22, 2019 5:53:43 PM


[oracle@enmoedu1 ~]$ 


    如果没有解锁和修改 SYSMAN的密码会有提示:



    如果忽略sysman的账号解锁和密码修改,EM创建完成后将无法登陆,细心的网友会发现没有sys角色的选项:



    问题处理方法:


    根据EM创建完成的提示,EM的配置文件


在:/u01/app/oracle/product/11.2.0/dbhome_1/enmoedu1.example.com_PROD1/sysman/config/


    首先,停止当前的EM dbconsole,否则,修改无效;如果先修改sysman账户,再停EM,sysman会再次被锁:


[oracle@enmoedu1 config]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Thu May 23 08:29:38 2019


Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:


Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> alter user sysman account unlock;


User altered.


SQL> quit


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options


 


[oracle@enmoedu1 config]$ sqlplus sysman/oracle@PROD1


SQL*Plus: Release 11.2.0.3.0 Production on Thu May 23 08:34:59 2019


Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:


Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> quit


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options


[oracle@enmoedu1 config]$


[oracle@enmoedu1 config]$ emctl stop dbconsole


Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 


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


https://enmoedu1.example.com:1158/em/console/aboutApplication


Stopping Oracle Enterprise Manager 11g Database Control ... 


 ...  Stopped. 


[oracle@enmoedu1 config]$ 


[oracle@enmoedu1 config]$ sqlplus sysman/oracle@PROD1


SQL*Plus: Release 11.2.0.3.0 Production on Thu May 23 08:35:41 2019


Copyright (c) 1982, 2011, Oracle.  All rights reserved.


ERROR:


ORA-28000: the account is locked


Enter user-name: 


ERROR:


ORA-01017: invalid username/password; logon denied


Enter user-name: 


ERROR:


ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus


[oracle@enmoedu1 config]$ 


现在应该清楚,sysman账户被锁是因为EM启动和关闭,重试密码次数过多导致的。


    正确重置EM账号SYSMAN的密码步骤:


1、关闭em dbconsole


[oracle@enmoedu1 config]$ emctl stop dbconsole


Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 


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


https://enmoedu1.example.com:1158/em/console/aboutApplication


Stopping Oracle Enterprise Manager 11g Database Control ... 


 ...  Stopped. 


[oracle@enmoedu1 config]$


2、解锁sysman账号,修改sysman密码


[oracle@enmoedu1 config]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Thu May 23 08:29:38

首页 上一页 1 2 3 4 下一页 尾页 2/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle 11.2.0.4 使用ASM磁盘组条.. 下一篇Oracle RAC for aix 存储双控锁盘..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目