开发者社区> prudentwoo> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

探索ORACLE之11g DataGuard_04 Oracle EnterPrise Manager OEM部署

简介: 探索ORACLE之11g DataGuard_04 Oracle EnterPrise Manager OEM部署 作者:吴伟龙 我们可以看到EM这个时候无法起来,需要重新配置: emctl startup console Environment variable ORACLE_UNQNAME not defined.
+关注继续查看

探索ORACLE11g DataGuard_04 Oracle EnterPrise Manager OEM部署

作者:吴伟龙

我们可以看到EM这个时候无法起来,需要重新配置:

emctl startup console
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

重新配置Oracle EnterPrise Manager

[oracle@pri ~]$ emca -config dbcontrol db -repos recreate
 
STARTED EMCA at May 21, 2013 10:58:04 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: Woo
Listener port number: 1521
Listener ORACLE_HOME [ /DBSoft/Product/11.2.0/db_1 ]:
Password for SYS user: 
Password for DBSNMP 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 ................ /DBSoft/Product/11.2.0/db_1
 
Local hostname ................ pri
Listener ORACLE_HOME ................ /DBSoft/Product/11.2.0/db_1
Listener port number ................ 1521
Database SID ................ Woo
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
 
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
May 21, 2013 10:59:07 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /DBSoft/cfgtoollogs/emca/PRI/emca_2013_05_21_22_58_03.log.
May 21, 2013 10:59:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
May 21, 2013 11:01:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
May 21, 2013 11:01:35 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
May 21, 2013 11:06:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
May 21, 2013 11:06:42 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
May 21, 2013 11:07:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
May 21, 2013 11:07:49 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for pri
May 21, 2013 11:07:52 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
May 21, 2013 11:07:52 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
May 21, 2013 11:08:27 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
May 21, 2013 11:08:27 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
May 21, 2013 11:08:42 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
May 21, 2013 11:08:42 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
May 21, 2013 11:09:51 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 21, 2013 11:09:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://pri:1158/em <<<<<<<<<<<
May 21, 2013 11:10:31 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: /DBSoft/Product/11.2.0/db_1/pri_PRI/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 May 21, 2013 11:10:32 PM


 

这样我们可以看到EM已经配置成功

 

 

Oracle EnterPrise Manager 常用管理

--创建一个EM资料库
emca -repos create

--重建一个EM资料库
emca -repos recreate

--删除一个EM资料库
emca -repos drop

--配置数据库的 Database Control
emca -config dbcontrol db

--删除数据库的 Database Control配置
emca -deconfig dbcontrol db

--重新配置db control的端口,默认端口在1158
emca -reconfig ports
emca -reconfig ports -dbcontrol_http_port 1160
emca -reconfig ports -agent_port 3940

--先设置ORACLE_SID环境变量后,启动EM console服务 
emctl start dbconsole

--先设置ORACLE_SID环境变量后,停止EM console服务
emctl stop dbconsole

--先设置ORACLE_SID环境变量后,查看EM console服务的状态
emctl status dbconsole
 
--配置dbconsole的步骤
emca -repos create
emca -config dbcontrol db
emctl start dbconsole

--重新配置dbconsole的步骤
emca -repos drop
emca -repos create
emca -config dbcontrol db
emctl start dbconsole


 

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
探索Oracle 11gR2 DataGuard_02配置
探索Oracle 11gR2 DataGuard_02配置 作者:吴伟龙 配置步骤: 一、开启强制日志 二、配置pri端传输参数 三、备份pri端数据库 四、拷贝文件到sty端 五、配置sty端传输参数 六、将sty端启动到mou...
759 0
探索ORACLE之11g DataGuard_01概念
探索ORACLE之11g DataGuard_01概念 作者:吴伟龙 1、什么是DataGuard DataGuard是oracle推出的一项专门针对oracle数据库的高可用技术,在8i之前被称之为Standby Dtabase,从9i开始正式更名为DataGuard。
858 0
Oracle 19C RPM安装及创建非容器数据库
Oracle 19c rpm安装及创建非容器数据库
0 0
Jdbc连接Oracle数据库详细案例,占位符的使用
Jdbc连接Oracle数据库详细案例,占位符的使用
0 0
Oracle数据库的增、删、改,索引、视图以及序列的创建和销毁
Oracle数据库的增、删、改,索引、视图以及序列的创建和销毁
0 0
Oracle数据库的简单认识详细总结
Oracle数据库的简单认识详细总结
0 0
Oracle数据库 创建触发器和序列(上)
Oracle数据库 创建触发器和序列
0 0
Oracle 数据库删除某一行数据
Oracle 数据库删除某一行数据
0 0
PLSQL连接Oracle数据库详细教程
PLSQL连接Oracle数据库详细教程
0 0
+关注
prudentwoo
10g/11g OCP 11g OCM,ITPUB和CSDN专家及专家讲师;有着多年数据库从业经验,资深Oracle数据库专家,现就职于北京海量数据技术股份有限公司担任高级dba职务,为央视,银行,电信等各行业及企业提供过技术支持服务
文章
问答
文章排行榜
最热
最新
相关电子书
更多
EasyDBforOracle— 基于阿里云的Oracle最佳实践
立即下载
Oracle云上最佳实践
立即下载
迁移 ORACLE 最佳实践
立即下载