windows系统安装 oracle 11.2.0.1.0,没有安装EM,现在需要手动安装EM
---------------删除系统中原有配置--------------------------------------
F:\Windows\system32>emca -deconfig dbcontrol db -repos drop
EMCA 开始于 2015-6-08 15:21:46
EM Configuration Assistant, 11.2.0.1.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
输入以下信息:
数据库 SID: BankAssist
监听程序端口号: 1521
SYS 用户的口令:
SYSMAN 用户的口令:
是否继续? [是(Y)/否(N)]: y
2013-3-17 15:21:55 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\app\oracle\cfgtoollogs\emca\orcl\emca_2015_06_08_15_21_46.log。
2015-6-8 15:21:55 oracle.sysman.emcp.util.DBControlUtil stopOMS
信息: 正在停止 Database Control (此操作可能需要一段时间)...
2015-6-8 15:22:30 oracle.sysman.emcp.EMReposConfig invoke
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...
2015-6-8 15:26:58 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功删除资料档案库
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2015-6-8 15:27:03
-------------------重建EM-----------------------------------------------------
C:\Users\Administrator>emca -deconfig dbcontrol db -repos create
EMCA 开始于 2015-6-8 16:52:16
EM Configuration Assistant, 11.2.0.0.2 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
用法错误。有关详细资料, 请运行 'emca -help'。
C:\Users\Administrator>emca -config dbcontrol db -repos create
EMCA 开始于 2015-6-8 16:52:24
EM Configuration Assistant, 11.2.0.0.2 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。
输入以下信息:
数据库 SID: BankAssist
监听程序端口号: 1521
监听程序 ORACLE_HOME [ D:\app\Administrator\product\11.2.0\dbhome_1 ]:
SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
SYSMAN 用户的口令: 通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
-----------------------------------------------------------------
已指定以下设置
数据库 ORACLE_HOME ................ D:\app\Administrator\product\11.2.0\dbhome_1
本地主机名 ................ BR9
监听程序 ORACLE_HOME ................ D:\app\Administrator\product\11.2.0\dbhome_1
监听程序端口号 ................ 1521
数据库 SID ................ BankAssist
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............
-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2015-6-8 16:58:23 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\app\Administrator\cfgtoollogs\emca\BankAssist\emca_2015_06_08_16_52_24.log。
2015-6-8 16:58:24 oracle.sysman.emcp.EMReposConfig createRepository
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
2015-6-8 17:04:54 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功创建资料档案库
2015-6-8 17:05:02 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...
2015-6-8 17:05:51 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功上载配置数据
2015-6-8 17:05:55 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
信息: 软件库已配置成功。
2015-6-8 17:05:55 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
信息: 正在部署预配档案...
2015-6-8 17:06:29 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
信息: 预配档案部署成功。
2015-6-8 17:06:29 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 正在保护 Database Control (此操作可能需要一段时间)...
2015-6-8 17:06:41 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 已成功保护 Database Control。
2015-6-8 17:06:41 oracle.sysman.emcp.util.DBControlUtil startOMS
信息: 正在启动 Database Control (此操作可能需要一段时间)...
2015-6-8 17:07:37 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2015-6-8 17:07:37 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为 https://BR9:5500/em <<<<<<<<<<<
2015-6-8 17:07:39 oracle.sysman.emcp.EMDBPostConfig invoke
警告:
************************ WARNING ************************
管理资料档案库已置于安全模式下, 在此模式下将对 Enterprise Manager 数据进行加密。加密密钥已放置在文件 D:/app/Administrator/product/11.2.0/dbhome_1/BR9_BankAssist/sysman/config/emkey.ora 中。请务必备份
此文件, 因为如果此文件丢失, 则加密数据将不可用。
***********************************************************
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2015-6-8 17:07:39
--------------------此时仍有问题,不能使用EM,先关闭再重新开启服务。------------------------------
C:\Users\Administrator>emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://BR9:5500/em/console/aboutApplication
OracleDBConsoleBankAssist 服务正在停止..
OracleDBConsoleBankAssist 服务已成功停止。
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://BR9:5500/em/console/aboutApplication
OracleDBConsoleBankAssist 服务正在停止..
OracleDBConsoleBankAssist 服务已成功停止。
C:\Users\Administrator>emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------------------------
Agent is Not Running
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------------------------
Agent is Not Running
----------------------------启动EM---------------------------------------------
C:\Users\Administrator>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://BR9:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...OracleDBConsoleBankAssist 服务正在启动 ..................
OracleDBConsoleBankAssist 服务已经启动成功。
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://BR9:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...OracleDBConsoleBankAssist 服务正在启动 ..................
OracleDBConsoleBankAssist 服务已经启动成功。
C:\Users\Administrator>emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.2
OMS Version : 10.2.0.4.2
Protocol Version : 10.2.0.4.2
Agent Home : D:\app\Administrator\product\11.2.0\dbhome_1\BR9_BankAssist
Agent binaries : D:\app\Administrator\product\11.2.0\dbhome_1
Agent Process ID : 8372
Agent URL : https://BR9:3938/emd/main
Repository URL : https://BR9:5500/em/upload/
Started at : 2015-06-08 17:20:55
Started by user : SYSTEM
Last Reload : 2015-06-08 17:20:55
Last successful upload : 2015-06-08 17:22:12
Total Megabytes of XML files uploaded so far : 0.32
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 47.54%
Data channel upload directory : D:/app/Administrator/product/11.2.0/dbhome_1/BR9_BankAssist/sysman/recv
Last successful heartbeat to OMS : 2015-06-08 17:21:16
---------------------------------------------------------------
Agent is Running and Ready
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.2
OMS Version : 10.2.0.4.2
Protocol Version : 10.2.0.4.2
Agent Home : D:\app\Administrator\product\11.2.0\dbhome_1\BR9_BankAssist
Agent binaries : D:\app\Administrator\product\11.2.0\dbhome_1
Agent Process ID : 8372
Agent URL : https://BR9:3938/emd/main
Repository URL : https://BR9:5500/em/upload/
Started at : 2015-06-08 17:20:55
Started by user : SYSTEM
Last Reload : 2015-06-08 17:20:55
Last successful upload : 2015-06-08 17:22:12
Total Megabytes of XML files uploaded so far : 0.32
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 47.54%
Data channel upload directory : D:/app/Administrator/product/11.2.0/dbhome_1/BR9_BankAssist/sysman/recv
Last successful heartbeat to OMS : 2015-06-08 17:21:16
---------------------------------------------------------------
Agent is Running and Ready
-----------------------------------倘若仍不能登录,reload agent----------------------------------------
C:\Users\Administrator>emctl reload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD reload completed successfully
C:\Users\Administrator>emctl reload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD reload completed successfully