重建EM repository

最新推荐文章于 2021-04-11 23:47:23 发布
最新推荐文章于 2021-04-11 23:47:23 发布
阅读量911 收藏
点赞数
文章标签： oracle 测试
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/vict_/article/details/32203233
版权 
--删除原有信息
14:46:42 SQL> drop public synonym SETEMVIEWUSERCONTEXT
14:47:22   2  ;

Synonym dropped.

14:47:24 SQL> drop public synonym mgmt_target_blackouts;

Synonym dropped.

14:47:50 SQL> drop role mgmt_user;
        
Role dropped.

14:48:11 SQL> drop user mgmt_view cascade;

User dropped.

14:48:32 SQL> drop user sysman cascade;

User dropped.



--删除EM
$<span style="color:#ff6666;"> emca  -deconfig dbcontrol db -repos drop</span>

STARTED EMCA at Jun 17, 2014 2:52:55 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: y
Jun 17, 2014 2:53:37 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2014_06_17_14_52_54.log.
Jun 17, 2014 2:53:38 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jun 17, 2014 2:53:42 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Jun 17, 2014 2:53:42 PM oracle.sysman.emcp.EMReposConfig invoke
WARNING: Unable to remove DBMS jobs.
Jun 17, 2014 2:53:42 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Jun 17, 2014 2:53:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jun 17, 2014 2:53:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jun 17, 2014 2:53:57 PM
$ 


--新建EM
$ <span style="color:#ff6666;">emca  -config  dbcontrol db -repos create</span>

STARTED EMCA at Jun 17, 2014 2:55:25 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]: 
Password for SYS user:  
Password for DBSNMP user:  
Invalid username/password.
Password for DBSNMP user:  
Invalid username/password.
Password for DBSNMP user:  
Password for SYSMAN user:  
Password for SYSMAN user: Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Local hostname ................ TYTC
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 17, 2014 2:56:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2014_06_17_14_55_24.log.
Jun 17, 2014 2:56:24 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 17, 2014 3:08:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jun 17, 2014 3:08:25 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jun 17, 2014 3:11:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jun 17, 2014 3:11:14 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jun 17, 2014 3:11:14 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jun 17, 2014 3:12:28 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jun 17, 2014 3:12:28 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jun 17, 2014 3:12:48 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jun 17, 2014 3:12:48 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jun 17, 2014 3:21:41 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jun 17, 2014 3:21:47 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://TYTC:1158/em <<<<<<<<<<<
Jun 17, 2014 3:22:20 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: 
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/TYTC_orcl/sysman/config/emkey.ora.   Please 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 Jun 17, 2014 3:22:21 PM

--emctl命令
$ emctl
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
   Oracle Enterprise Manager 10g Database Control commands:
        emctl start | stop dbconsole
        emctl status | secure | setpasswd dbconsole
        emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
       emctl status agent
       emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
       emctl getversion
       emctl reload | upload | clearstate | getversion agent
       emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
       emctl config agent <options>
       emctl config agent updateTZ
       emctl config agent getTZ
       emctl resetTZ agent
       emctl config agent credentials [<Target_name>[:<Target_Type>]]
       emctl gensudoprops
       emctl clearsudoprops
 Blackout Usage : 
       emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
       emctl stop blackout <Blackoutname>
       emctl status blackout [<Target_name>[:<Target_Type>]]....

The following are valid options for blackouts
<Target_name:Target_type> defaults to local node target if not specified.
If -nodeLevel is specified after <Blackoutname>,the blackout will be applied to all targets and any target list that follows will be ignored.
 Duration is specified in [days] hh:mm

        emctl getemhome
        emctl ilint
Em Key Commands Usage : 
emctl config emkey -emkeyfile <emkey.ora path> [-force] [-sysman_pwd <sysman password>]
emctl config emkey -emkey [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
emctl config emkey -repos [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
emctl config emkey -remove_from_repos [-sysman_pwd <sysman password>]
emctl config emkey -copy_to_repos [-sysman_pwd <sysman password>]
emctl status emkey [-sysman_pwd <sysman password>]

Secure DBConsole Usage : 
emctl secure dbconsole -sysman_pwd <sysman password> [-passwd_file <abs file loc>]
        [-host <slb hostname>] [-sid <service name>] [-reset] [-secure_port <secure_port>]
        [-root_dc <root_dc>] [-root_country <root_country>] [-root_state <root_state>] [-root_loc <root_loc>]
        [-root_org <root_org>] [-root_unit <root_unit>] [-root_email <root_email>]
        [-wallet <wallet loc>] [-wallet_pwd <wallet pwd>] [-trust_certs_loc <certs loc>]
emctl secure status dbconsole
 Register Targettype Usage : 
emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep host> <rep port> <rep sid> OR 
emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep connect descriptor>

vict_
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
修复 WMI repository
baozhan4908的博客
07-13 444
2011年07月25日 23:31:57 frankggh 阅读数 4696 WMI是OS的一个基础组件，很多MS软件包括一些第三方工具都是用WMI作为数据存储。好处是性能安全兼顾，坏处自然就是WMI坏了就麻烦了。客户机上最常见的就是 WMI repository 损坏，补丁无法安装。例如： SCCM Client 机器上 execmgr.log 和 rebootCoordinator.log ...
em 无法启动，报not found错误
weixin_33922670的博客
12-09 170
oracle11gr2安装完，建完库之后，启动em 报OC4J_DBConsole_source_ora11g not found的错误，em起不来。 [oracle@source ~]$ emctl start dbconsole OC4J Configuration issue. /oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J...
oracle数据库重建em,oracle 11g em重建报唯一约束错误解决方法
weixin_30696613的博客
04-03 217
oracle 11g em重建报唯一约束错误解决方法更新时间：2012年11月27日 15:07:33 作者：今天在手工配置Oracle11g的EM时总是报如下错误,也没有找到解决办法，以下是我的解决过程,希望可以帮助你们今天在手工配置Oracle11g的EM时总是报如下错误：WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMAR...
配置EM遇到的问题：*_orcl not found\listener not up\Error creating the repository
weixin_30832405的博客
08-01 217
要想打开OEM的web管理程序，必须先启动Database listener，再启动Datebase Control端口监控程序，但是碰到下面的情况。 问题0： [oracle@localhost OC4J_DBConsole]$ emctl start dbconsole TZ set to PRC OC4J Configuration issue. /u01/app/ora...
修改计算机名后OEM无法启动的问题
流云追风
02-04 1696
修改计算机名称后，启动OEM后报错,重新配置OEM也报错, 如下:   2015-2-4 12:17:03 oracle.sysman.emcp.util.DBControlUtil copyEmkeyToRepos 严重: 将 EM 密钥复制到管理资料档案库时出错。EM 密钥在文件系统中的配置不正确或已损坏, 并且在管理资料档案库中不 存在。要更正此问题, 请执行以下操作:  1) 将
oracle 10G EM 配置总结
10-16
这是因为DBControl需要在数据库中创建一个名为"sysman"的模式，该模式用来存储EM的数据，也就是所谓的EM资料库（repository）。这个过程可以通过执行命令行工具`emca`(Enterprise Manager Configuration Assistant)...
XP安装Oracle 10时实例化EM配置文件时出错解决方案
11-11
然而，在某些情况下，特别是在Windows XP操作系统上，用户在尝试初始化EM配置时会遭遇失败，这往往是因为EM的资料档案库（repository）存在问题或配置不当。 ### 错误分析 从提供的日志片段来看，用户首先使用`...
emca配置database control
06-11
2. 重建EM仓库： ``` emca -repos recreate ``` 3. 删除EM仓库： ``` emca -repos drop ``` 4. 配置Database Control： ``` emca -config dbcontrol db ``` 5. 删除Database Control配置： ``` emca -...
Oracle数据库10g-对自我管理数据库进行管理2-P.pptx
09-22
它可以识别缺失的索引，提供访问路径分析，重建SQL计划，并通过SQL配置文件进行调整。DBA可以通过不修改应用程序代码来优化SQL性能。 - **Automatic Workload Repository (AWR)** 是一个重要的组件，用于收集和存储...
Oracle 配置与优化
05-19
通过EMCA（Enterprise Manager Configuration Assistant）可以创建、重建或删除EM数据库，配置和重新配置Database Control，以及调整相关端口。`emctl`命令用于控制EM console服务的启动、停止和状态检查。 最后，...
oracle emctl 配置,11g emctl config配置EM 密钥报错
weixin_39650784的博客
04-03 680
本帖最后由 zhenjiang412518 于 2014-8-29 18:59 编辑一、测试环境中遇到的问题：1、由于EM不能正常访问，于是执行以下语句成功删除EMemca -deconfig dbcontrol db -repos drop2、执行dbca重建EM,创建结束后提示下面信息QQ截图20140829165302.png (36.62 KB, 下载次数: 10)2014-8-29 18...
EM 重建 报错 解决3则
晚班的火车的技术生活
04-28 3772
---===emca 问题描述； -=错误1； $ emctl status dbconsole OC4J Configuration issue. /u01/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_HOSTNAME_SID not found.     >>> 解决；由于hostname更改，重建EM解决。 -=
EMCA重建OEM时导致DB停顿在quiescing状态
络客
07-21 2379
Created on 04.02.2011环境:Oracle版本: Oracle 10g Release 2  10.2.0.5OS版本: Windows Server 2003 Enterprise摘要: 用EMCA重建OEM时，导致数据库挂起，DB一直处于quiescing状
配置EM遇到的两个问题
热门推荐
DATA
08-16 1万+
问题一：SEVERE: Listener is not up or database service is not registered with it 问题表现如下： [oracle@xbfye7l01 db_home]$ emca -config dbcontrol db ……………… ------------------------------------------------
oracle 重建em失败,oracle 11g em重建报唯一约束错误解决方法
weixin_39641257的博客
04-04 128
今天在手工配置Oracle11g的EM时总是报如下错误,也没有找到解决办法，以下是我的解决过程,希望可以帮助你们今天在手工配置Oracle11g的EM时总是报如下错误：WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violatedORA-06512:at”SYSMAN.EMD_LOADER”,line4986ORA...
EM 不能启动，重新设置无效
好记忆也需烂博客
08-05 2752
RAC 环境，两个节点，在一个节点进行EM 启动无效，使用命令重建不成功，问题继续解决中。 [oracle@rac1 11.2.0]$ emctl start dbconsole OC4J Configuration issue. /opt/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_rac1_racdb1 not
ORACLE RAC EM 安装步骤
白昼的技术专栏
09-30 5634
Oracle环境： 版本：Oracle 11gR2 RAC （Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production） Rac节点信息： 主机名  SID SERVICE_NAME rac1 racdb1 racdb rac2 racdb2 racdb...
oracle重建EM资料库详细步骤,EM资料库重建手动删除资料库
weixin_29007135的博客
04-11 334
由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：[Oracle@localhost ~]$ emca -repos recreateJul 30, 2014 7:15:53 PM oracle.sysman.emcp.EMReposConfig dropRepositoryINFO: D...
2012-10-27 - 2012-10-28 11gR2 "ADMINISTRATOR'S GUIDE" page 305 - 352
Poli Liu's Oracle World
10-28 1437
接下去的这一章讲了很多的如何向Oracle Support提供incident package的方法。 可以细看 page 308 - 325   这一章节基本都是讲EM的操作，其实我们更多时候最好是不用EM，但是我一直十分喜欢用EM进行数据库的性能监控。   Directory Structure in the Management Service Home for Release 1
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值