Oracle 11g EM无法启动

栏目: 数据库 · Oracle · 发布时间: 6年前

内容简介:Oracle 11g EM无法启动

〇、错误

使用dbca安装数据库,虽然中间勾选了EM选项,却发现并没有随着安装的完成而启动,以下就是整个排错过程。

一、排错

1.1、检查hosts文件

发现hosts文件中没有x.x.x.x hostname这一行,将改行数据加入后保存文件。比如:

192.168.224.150 dbsrv.test.com dbsrv

上段代码中,第一段为本机静态地址,第二段为hostname完整形式,第三段为hostname简单形式。

1.2、检查ORACLE_UNQNAME环境变量

执行如下命令查看结果:

echo $ORACLE_UNQNAME

发现并未有返回值,说明该变量没有设置,执行:

export ORACLE_UNQNAME=orcl

其中orcl为数据库的SID。

也可以将上面的语句写入到~/.bash_profile文件中使每次登陆都自动生效。

1.3、重新配置EM

执行:

emca -config dbcontrol db -repos recreate

根据提示填入内容。

STARTED EMCA at Jun 7, 2017 8:29:08 AM

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 [ /app/oracle/product/11.2.0/dbhome_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 ……………. /app/oracle/product/11.2.0/dbhome_1

Local hostname ……………. dbsrv.test.org

Listener ORACLE_HOME ……………. /app/oracle/product/11.2.0/dbhome_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)]: yes

Jun 7, 2017 8:29:44 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /app/oracle/cfgtoollogs/emca/orcl/emca_2017_06_07_08_29_07.log.

Jun 7, 2017 8:29:46 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) …

Jun 7, 2017 8:31:41 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Jun 7, 2017 8:31:41 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) …

Jun 7, 2017 8:38:16 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Jun 7, 2017 8:38:19 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) …

Jun 7, 2017 8:39:34 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Jun 7, 2017 8:39:38 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib

INFO: Software library configured successfully.

Jun 7, 2017 8:39:38 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Deploying Provisioning archives …

Jun 7, 2017 8:40:24 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Provisioning archives deployed successfully.

Jun 7, 2017 8:40:24 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) …

Jun 7, 2017 8:41:42 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Jun 7, 2017 8:41:42 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) …

Jun 7, 2017 8:42:30 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jun 7, 2017 8:42:30 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://dbsrv.test.org:1158/em <<<<<<<<<<<

Jun 7, 2017 8:42:33 AM 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: /app/oracle/product/11.2.0/dbhome_1/dbsrv.test.org_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 7, 2017 8:42:33 AM

整个过程大概持续几分钟,安装成功后执行emctl status dbconsole查看状态:

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

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

https://dbsrv.test.org:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

——————————————————————

Logs are generated in directory /app/oracle/product/11.2.0/dbhome_1/dbsrv.zjsjg.org_orcl/sysman/log

在浏览器中输入https://dbsrv.test.org:1158/em进行访问。


以上就是本文的全部内容,希望本文的内容对大家的学习或者工作能带来一定的帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

疯狂的独角兽

疯狂的独角兽

丹·莱昂斯 / 王天任 / 海南出版社 / 2017-10 / 42

★商业与文学的有机结合,真实与虚幻间嬉笑怒骂,幽默风趣、引人入胜、发人深省的商业小说。 ★《纽约时报》《华尔街日报》《旧金山纪事报》Amazon畅销书,《财富》《纽约邮报》《新闻周刊》《华盛顿邮报》、畅销书《硅谷钢铁侠》作者阿什利·万斯、畅销书《一网打尽》作者布拉德·斯通联袂推荐。 ★作者丹·莱昂斯集小说家、记者、编剧为一身——HBO经典热门剧、豆瓣高分美剧《硅谷》作者;畅销书《乔布斯......一起来看看 《疯狂的独角兽》 这本书的介绍吧!

JS 压缩/解压工具
JS 压缩/解压工具

在线压缩/解压 JS 代码

正则表达式在线测试
正则表达式在线测试

正则表达式在线测试

HEX CMYK 转换工具
HEX CMYK 转换工具

HEX CMYK 互转工具