Oracle 11g EM无法启动

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

内容简介: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进行访问。


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

查看所有标签

猜你喜欢:

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

TensorFlow:实战Google深度学习框架(第2版)

TensorFlow:实战Google深度学习框架(第2版)

顾思宇、梁博文、郑泽宇 / 电子工业出版社 / 2018-2-1 / 89

TensorFlow是谷歌2015年开源的主流深度学习框架,目前已得到广泛应用。《TensorFlow:实战Google深度学习框架(第2版)》为TensorFlow入门参考书,旨在帮助读者以快速、有效的方式上手TensorFlow和深度学习。书中省略了烦琐的数学模型推导,从实际应用问题出发,通过具体的TensorFlow示例介绍如何使用深度学习解决实际问题。书中包含深度学习的入门知识和大量实践经......一起来看看 《TensorFlow:实战Google深度学习框架(第2版)》 这本书的介绍吧!

URL 编码/解码
URL 编码/解码

URL 编码/解码

XML、JSON 在线转换
XML、JSON 在线转换

在线XML、JSON转换工具

HEX HSV 转换工具
HEX HSV 转换工具

HEX HSV 互换工具