11g r2 重建em-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心

沧海拾贝

凯发app官方网站首页　| 　博文目录　| 　关于我

brjl

  • 博客访问： 3503201
  • 博文数量： 718
  • 博客积分： 1860
  • 博客等级： 上尉
  • 技术积分： 7790
  • 用 户 组： 普通用户
  • 注册时间： 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文（718）

文章存档

2024年（4）

2023年（74）

2022年（134）

2021年（238）

2020年（115）

2019年（11）

2018年（9）

2017年（9）

2016年（17）

2015年（7）

2014年（4）

2013年（1）

2012年（11）

2011年（27）

2010年（35）

2009年（11）

2008年（11）

我的朋友
最近访客
推荐博文
相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
11g r2 重建em

分类： oracle

2010-07-16 10:08:11

11g r2 重建em
 
c:\>emca -deconfig dbcontrol db
emca 开始于 2010-7-16 9:29:21
em configuration assistant, 11.2.0.0.2 正式版
凯发k8官网下载客户端中心的版权所有 (c) 2003, 2005, oracle。保留所有权利。
输入以下信息:
数据库 sid: orcl
是否继续? [是(y)/否(n)]: y
2010-7-16 9:29:28 oracle.sysman.emcp.emconfig perform
信息: 正在将此操作记录到 c:\app\administrator\cfgtoollogs\emca\orcl\emca_2010_07
_16_09_29_21.log。
2010-7-16 9:29:28 oracle.sysman.emcp.emdbpreconfig performdeconfiguration
警告: 此数据库的 em 尚未配置。无法执行特定于 em 的操作。
已成功完成 enterprise manager 的配置
emca 结束于 2010-7-16 9:29:28
 
c:\>emca -repos drop
emca 开始于 2010-7-16 9:30:15
em configuration assistant, 11.2.0.0.2 正式版
凯发k8官网下载客户端中心的版权所有 (c) 2003, 2005, oracle。保留所有权利。
输入以下信息:
数据库 sid: orcl
监听程序端口号: 1521
sys 用户的口令:
sysman 用户的口令:  le
sysman 用户的口令:
是否继续? [是(y)/否(n)]: y
2010-7-16 9:30:27 oracle.sysman.emcp.emconfig perform
信息: 正在将此操作记录到 c:\app\administrator\cfgtoollogs\emca\orcl\emca_2010_07
_16_09_30_15.log。
2010-7-16 9:30:28 oracle.sysman.emcp.emreposconfig invoke
信息: 正在删除 em 资料档案库 (此操作可能需要一段时间)...
2010-7-16 9:34:21 oracle.sysman.emcp.emreposconfig invoke
信息: 已成功删除资料档案库
已成功完成 enterprise manager 的配置
emca 结束于 2010-7-16 9:34:21

c:\>emca -config dbcontrol db -repos create
emca 开始于 2010-7-16 9:37:21
em configuration assistant, 11.2.0.0.2 正式版
凯发k8官网下载客户端中心的版权所有 (c) 2003, 2005, oracle。保留所有权利。
输入以下信息:
数据库 sid: orcl
监听程序端口号: 1521
监听程序 oracle_home [ c:\app\administrator\product\11.2.0\dbhome_1 ]:
sys 用户的口令:
dbsnmp 用户的口令:
sysman 用户的口令:
sysman 用户的口令: 通知的电子邮件地址 (可选):
通知的发件 (smtp) 服务器 (可选):
-----------------------------------------------------------------
已指定以下设置
数据库 oracle_home ................ c:\app\administrator\product\11.2.0\dbhome_1

本地主机名 ................ 192.168.0.228
监听程序 oracle_home ................ c:\app\administrator\product\11.2.0\dbhome
_1
监听程序端口号 ................ 1521
数据库 sid ................ orcl
通知的电子邮件地址 ...............
通知的发件 (smtp) 服务器 ...............
-----------------------------------------------------------------
是否继续? [是(y)/否(n)]: y
2010-7-16 9:37:49 oracle.sysman.emcp.emconfig perform
信息: 正在将此操作记录到 c:\app\administrator\cfgtoollogs\emca\orcl\emca_2010_07
_16_09_37_21.log。
2010-7-16 9:37:51 oracle.sysman.emcp.emreposconfig createrepository
信息: 正在创建 em 资料档案库 (此操作可能需要一段时间)...
2010-7-16 9:50:00 oracle.sysman.emcp.emreposconfig invoke
信息: 已成功创建资料档案库
2010-7-16 9:50:17 oracle.sysman.emcp.emreposconfig uploadconfigdatatorepository
信息: 正在将配置数据上载到 em 资料档案库 (此操作可能需要一段时间)...
2010-7-16 9:52:21 oracle.sysman.emcp.emreposconfig invoke
信息: 已成功上载配置数据
2010-7-16 9:52:54 oracle.sysman.emcp.util.dbcontrolutil configuresoftwarelib
信息: 软件库已配置成功。
2010-7-16 9:52:54 oracle.sysman.emcp.emdbpostconfig configuresoftwarelibrary
信息: 正在部署预配档案...
2010-7-16 9:53:53 oracle.sysman.emcp.emdbpostconfig configuresoftwarelibrary
信息: 预配档案部署成功。
2010-7-16 9:53:53 oracle.sysman.emcp.util.dbcontrolutil securedbconsole
信息: 正在保护 database control (此操作可能需要一段时间)...
2010-7-16 9:54:09 oracle.sysman.emcp.util.dbcontrolutil securedbconsole
信息: 已成功保护 database control。
2010-7-16 9:54:09 oracle.sysman.emcp.util.dbcontrolutil startoms
信息: 正在启动 database control (此操作可能需要一段时间)...
2010-7-16 9:55:45 oracle.sysman.emcp.emdbpostconfig performconfiguration
信息: 已成功启动 database control
2010-7-16 9:56:15 oracle.sysman.emcp.emdbpostconfig performconfiguration
信息: >>>>>>>>>>> database control url 为 <<<<<<<<
<<<
2010-7-16 9:56:19 oracle.sysman.emcp.emdbpostconfig invoke
警告:
************************  warning  ************************
管理资料档案库已置于安全模式下, 在此模式下将对 enterprise manager 数据进行加密。
加密密钥已放置在文件 c:/app/administrator/product/11.2.0/dbhome_1/192.168.0.228_
orcl/sysman/config/emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数
据将不可用。
***********************************************************
已成功完成 enterprise manager 的配置
emca 结束于 2010-7-16 9:56:19
c:\>emctl status dbconsole
environment variable oracle_unqname not defined. please set oracle_unqname to da
tabase unique name.
c:\>set oracle_unqname=orcl
c:\>emctl status dbconsole
oracle enterprise manager 11g database control release 11.2.0.1.0
凯发app官方网站 copyright (c) 1996, 2010 oracle corporation.  all rights reserved.

oracle enterprise manager 11g is running.
------------------------------------------------------------------
logs are generated in directory c:\app\administrator\product\11.2.0\dbhome_1/192
.168.0.228_orcl/sysman/log
c:\>

 
不同情况下删除em往往不顺利，以下方法供参考
参考
建议在windows环境中 增加系统环境变量
oracle_unqname=orcl        --全局唯一名 一般指实例名
oracle_hostname=localhost  --侦听位置 一般是主机名或ip地址 我的机器设置为localhost了
我的机器侦听地址改为localhost了 ，当初em创建时，侦听主机名
卸载时 em会找原先的配置文件，所以需要有此目录 才不会提示遇到严重错误。
 
1)  卸载em
没有以下目录要改名 emca从这里面找些信息去清理（骗骗emca 详看日志c:\app\administrator\cfgtoollogs\emca\orcl\xxx.log）
mkdir c:\app\administrator\product\11.2.0\dbhome_1\www-e22c46b98bd_orcl
mkdir c:\app\administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_dbconsole_www-e22c46b98bd_orcl
emca -deconfig dbcontrol db
设置环境变量 否则连接串老是不对
set oracle_hostname=localhost
emca -repos drop

2) 清理em在数据库中的垃圾信息
drop user sysman cascade;
drop user mgmt_view cascade;
drop role mgmt_user;
drop public synonym mgmt_target_blackouts;
drop public synonym setemviewusercontext;
drop user sysman cascade;
drop public synonym mgmt_admin;
drop public synonym mgmt_as_ecm_util;
drop public synonym mgmt_availability;
drop public synonym mgmt_collection_properties;
drop public synonym mgmt_credential;
drop public synonym mgmt_current_availability;
drop public synonym mgmt_current_metrics;
drop public synonym mgmt_current_metric_errors;
drop public synonym mgmt_current_severity;
drop public synonym mgmt_delta;
drop public synonym mgmt_delta_entry;
drop public synonym mgmt_delta_entry_values;
drop public synonym mgmt_delta_ids;
drop public synonym mgmt_delta_id_values;
drop public synonym mgmt_delta_value;
drop public synonym mgmt_delta_values;
drop public synonym mgmt_global;
drop public synonym mgmt_guid_array;
drop public synonym mgmt_guid_obj;
drop public synonym mgmt_ip_tgt_guid_array;
drop public synonym mgmt_job;
drop public synonym mgmt_jobs;
drop public synonym mgmt_job_execplan;
drop public synonym mgmt_job_execution;
drop public synonym mgmt_job_exec_summary;
drop public synonym mgmt_job_output;
drop public synonym mgmt_job_parameter;
drop public synonym mgmt_job_schedule;
drop public synonym mgmt_job_target;
drop public synonym mgmt_log;
drop public synonym mgmt_long_text;
drop public synonym mgmt_messages;
drop public synonym mgmt_metrics;drop public synonym mgmt_metrics_1day;
drop public synonym mgmt_metrics_1hour;
drop public synonym mgmt_metrics_composite_keys;
drop public synonym mgmt_metrics_raw;
drop public synonym mgmt_metric_collections;
drop public synonym mgmt_metric_errors;
drop public synonym mgmt_metric_thresholds;
drop public synonym mgmt_name_value;
drop public synonym mgmt_name_values;
drop public synonym mgmt_preferences;
drop public synonym mgmt_severity;
drop public synonym mgmt_severity_array;
drop public synonym mgmt_severity_obj;
drop public synonym mgmt_string_metric_history;
drop public synonym mgmt_target;
drop public synonym mgmt_targets;
drop public synonym mgmt_target_blackouts;
drop public synonym mgmt_target_memberships;
drop public synonym mgmt_target_properties;
drop public synonym mgmt_type_properties;
drop public synonym mgmt_user;
drop public synonym mgmt_view_util;
drop public synonym mgmt$delta_oracle_home;
drop public synonym mgmt$delta_os_components;
drop public synonym mgmt$delta_os_comp_details;
drop public synonym mgmt$delta_os_kernel_params;
drop public synonym mgmt$delta_patchsets;
drop public synonym mgmt$delta_patchset_details;
drop public synonym mgmt$delta_tablespaces;
drop public synonym mgmt$delta_vendor_sw;
drop public synonym mgmt$delta_view;
drop public synonym mgmt$delta_view_details;
drop public synonym mgmt$ecm_current_snapshots;
drop public synonym mgmt$ecm_visible_snapshots;
drop public synonym mgmt$group_derived_memberships;
drop public synonym mgmt$group_flat_memberships;
drop public synonym mgmt$group_members;
drop public synonym mgmt$ha_backup;
drop public synonym mgmt$ha_files;
drop public synonym mgmt$ha_info;
drop public synonym mgmt$ha_init_params;
drop public synonym mgmt$ha_mttr;
drop public synonym mgmt$ha_rman_config;
drop public synonym mgmt$hw_nic;
drop public synonym mgmt$metric_collection;
drop public synonym mgmt$metric_current;
drop public synonym mgmt$metric_daily;
drop public synonym mgmt$metric_details;
drop public synonym mgmt$metric_hourly;
drop public synonym mgmt$missing_targets;
drop public synonym mgmt$missing_targets_in_groups;
drop public synonym mgmt$os_components;
drop public synonym mgmt$os_fs_mount;
drop public synonym mgmt$os_hw_summary;
drop public synonym mgmt$os_kernel_params;
drop public synonym mgmt$os_patches;
drop public synonym mgmt$os_summary;
drop public synonym mgmt$software_components;
drop public synonym mgmt$software_component_oneoff;
drop public synonym mgmt$software_comp_patchset;
drop public synonym mgmt$software_dependencies;
drop public synonym mgmt$software_homes;
drop public synonym mgmt$software_oneoff_patches;
drop public synonym mgmt$software_others;
drop public synonym mgmt$software_patches_in_homes;
drop public synonym mgmt$software_patchsets;
drop public synonym mgmt$target;
drop public synonym mgmt$target_components;
drop public synonym mgmt$target_composite;
drop public synonym mgmt$target_properties;
drop public synonym mgmt$target_type;
drop public synonym smp_emd_avail_obj;
drop public synonym emd_mntr;
drop public synonym smp_emd_avail_obj;
drop public synonym smp_emd_delete_rec_array;
drop public synonym smp_emd_integer_array;
drop public synonym smp_emd_integer_array_array;
drop public synonym smp_emd_nvpair;
drop public synonym smp_emd_nvpair_array;
drop public synonym smp_emd_string_array;
drop public synonym smp_emd_string_array_array;
drop public synonym smp_emd_target_obj;
drop public synonym smp_emd_target_obj_array;
drop public synonym ecm_util;
drop role mgmt_user;
drop user sysman cascade;
drop user mgmt_view cascade;
drop role mgmt_user;
alter user dbsnmp account unlock;
alter user dbsnmp identified by dbsnmp;
drop public synonym setemviewusercontext;
drop public synonym mgmt_target_blackouts;
drop public synonym mgmt_availability;
drop public synonym mgmt_current_availability;
drop public synonym mgmt_severity_obj;
drop public synonym mgmt_severity_array;
drop public synonym mgmt_guid_obj;
drop public synonym mgmt_guid_array;
drop public synonym smp_emd_avail_obj;
drop public synonym smp_emd_target_obj;
drop public synonym smp_emd_target_obj_array;
drop public synonym smp_emd_delete_rec_array;
drop public synonym mgmt_metrics;
drop public synonym mgmt_targets;
drop public synonym mgmt_type_properties;
drop public synonym mgmt_target_properties;
drop public synonym mgmt_metrics_raw;
drop public synonym mgmt_current_metrics;
drop public synonym mgmt_string_metric_history;
drop public synonym mgmt_long_text;
drop public synonym mgmt_metrics_composite_keys;
drop public synonym mgmt_metrics_1hour;
drop public synonym mgmt_metrics_1day;
drop public synonym mgmt_metric_errors;
drop public synonym mgmt_current_metric_errors;
drop public synonym emd_mntr;
drop public synonym mgmt_metric_collections;
drop public synonym mgmt_collection_properties ;
drop public synonym mgmt_metric_thresholds;
drop public synonym smp_emd_nvpair;
drop public synonym smp_emd_nvpair_array;
drop public synonym smp_emd_string_array;
drop public synonym smp_emd_string_array_array;
drop public synonym smp_emd_integer_array;
drop public synonym smp_emd_integer_array_array;
drop public synonym mgmt_delta_ids;
drop public synonym mgmt_delta_id_values;
drop public synonym mgmt_delta_entry;
drop public synonym mgmt_delta_entry_values;
drop public synonym mgmt_delta_value;
drop public synonym mgmt_delta_values;
drop public synonym mgmt_name_value;
drop public synonym mgmt_name_values;
drop public synonym ecm_util;
drop public synonym mgmt_delta;
drop public synonym mgmt_target_memberships;
drop public synonym mgmt_job;
drop public synonym mgmt_job_parameter;
drop public synonym mgmt_job_target;
drop public synonym mgmt_job_schedule;
drop public synonym mgmt_job_execplan;
drop public synonym mgmt_job_exec_summary;
drop public synonym mgmt_job_output;
drop public synonym mgmt_job_execution;
drop public synonym mgmt_log;
drop public synonym mgmt_admin;
drop public synonym mgmt_global;
drop public synonym mgmt_target;
drop public synonym mgmt_credential;
drop public synonym mgmt_jobs;
drop public synonym mgmt_preferences;
drop public synonym mgmt_user;
drop public synonym mgmt_severity;
drop public synonym mgmt_current_severity;
drop public synonym mgmt_paf_procs_latest;
drop public synonym mgmt_paf_jobs;
drop public synonym mgmt_paf$procedures;
drop public synonym mgmt_paf$instances;
drop public synonym mgmt_paf$states;
drop public synonym mgmt_paf$applications;
drop public synonym mgmt_view_util;
drop public synonym mgmt_messages;
整理成一个sql文件dropem.sql 以便以后执行
sqlplus "/as sysdba" @c:\dropem.sql
 
3)重建em
c:\>emca -config dbcontrol db -repos create
emca 开始于 2010-9-8 17:10:37
em configuration assistant, 11.2.0.0.2 正式版
凯发k8官网下载客户端中心的版权所有 (c) 2003, 2005, oracle。保留所有权利。
输入以下信息:
数据库 sid: orcl
监听程序端口号: 1521
监听程序 oracle_home [ c:\app\administrator\product\11.2.0\dbhome_1 ]:
sys 用户的口令:
dbsnmp 用户的口令:
dbsnmp 用户的口令: 用户名/口令无效。
dbsnmp 用户的口令:
sysman 用户的口令:
sysman 用户的口令: 通知的电子邮件地址 (可选):
通知的发件 (smtp) 服务器 (可选):
-----------------------------------------------------------------
已指定以下设置
数据库 oracle_home ................ c:\app\administrator\product\11.2.0\dbhome_1

本地主机名 ................ localhost
监听程序 oracle_home ................ c:\app\administrator\product\11.2.0\dbhome
_1
监听程序端口号 ................ 1521
数据库 sid ................ orcl
通知的电子邮件地址 ...............
通知的发件 (smtp) 服务器 ...............
-----------------------------------------------------------------
是否继续? [是(y)/否(n)]: y
2010-9-8 17:12:08 oracle.sysman.emcp.emconfig perform
信息: 正在将此操作记录到 c:\app\administrator\cfgtoollogs\emca\orcl\emca_2010_09
_08_17_10_36.log。
2010-9-8 17:12:10 oracle.sysman.emcp.emreposconfig createrepository
信息: 正在创建 em 资料档案库 (此操作可能需要一段时间)...
2010-9-8 17:24:11 oracle.sysman.emcp.emreposconfig invoke
信息: 已成功创建资料档案库
2010-9-8 17:24:25 oracle.sysman.emcp.emreposconfig uploadconfigdatatorepository
信息: 正在将配置数据上载到 em 资料档案库 (此操作可能需要一段时间)...
2010-9-8 17:26:26 oracle.sysman.emcp.emreposconfig invoke
信息: 已成功上载配置数据
2010-9-8 17:26:39 oracle.sysman.emcp.util.dbcontrolutil configuresoftwarelib
信息: 软件库已配置成功。
2010-9-8 17:26:39 oracle.sysman.emcp.emdbpostconfig configuresoftwarelibrary
信息: 正在部署预配档案...
2010-9-8 17:27:34 oracle.sysman.emcp.emdbpostconfig configuresoftwarelibrary
信息: 预配档案部署成功。
2010-9-8 17:27:34 oracle.sysman.emcp.util.dbcontrolutil securedbconsole
信息: 正在保护 database control (此操作可能需要一段时间)...
2010-9-8 17:27:47 oracle.sysman.emcp.util.dbcontrolutil securedbconsole
信息: 已成功保护 database control。
2010-9-8 17:27:47 oracle.sysman.emcp.util.dbcontrolutil startoms
信息: 正在启动 database control (此操作可能需要一段时间)...
2010-9-8 17:28:24 oracle.sysman.emcp.emdbpostconfig performconfiguration
信息: >>>>>>>>>>> database control url 为 <<<<<<<<<<<
2010-9-8 17:28:29 oracle.sysman.emcp.emdbpostconfig invoke
警告:
************************  warning  ************************
管理资料档案库已置于安全模式下, 在此模式下将对 enterprise manager 数据进行加密。
加密密钥已放置在文件 c:/app/administrator/product/11.2.0/dbhome_1/localhost_orcl
/sysman/config/emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据将
不可用。
***********************************************************
2010-9-8 17:28:29 oracle.sysman.emcp.emdbpostconfig invoke
 
c:\>set oracle_unqname=orcl
c:\>emctl start dbconsole
 
修改访问端口（把5500改为1158）
重建em后可能端口被改为5500即，如果需要修改访问端口为1158，执行：
c:\> emca -config dbcontrol db -dbcontrol_http_port 1158
最好先手工停止em.
 
阅读(4135) | 评论(0) | 转发(0) |
0

上一篇：temporary failure in name resolution: illegal seek

下一篇：enq: ji 等待事件

给主人留下些什么吧！~~
| | | | |

凯发app官方网站 copyright 2001-2010 chinaunix.net all rights reserved 北京皓辰网域网络信息技术有限公司. 凯发k8官网下载客户端中心的版权所有

感谢所有关心和支持过chinaunix的朋友们
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图