Oracle 11g EM无法启动

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

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


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

查看所有标签

猜你喜欢:

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

C++程序设计原理与实践

C++程序设计原理与实践

(美)Bjarne Stroustrup / 王刚 等 / 机械工业出版社 / 2010.7 / 108.00元

本书是经典程序设计思想与C++开发实践的完美结合,是C++之父回归校园后对C++编程原理和技巧的全新阐述。书中全面地介绍了程序设计基本原理,包括基本概念、设计和编程技术、语言特性以及标准库等,教你学会如何编写具有输入、输出、计算以及简单图形显示等功能的程序。此外,本书通过对C++思想和历史的讨论、对经典实例(如矩阵运算、文本处理、测试以及嵌入式系统程序设计)的展示,以及对C语言的简单描述,为你呈现......一起来看看 《C++程序设计原理与实践》 这本书的介绍吧!

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

在线压缩/解压 JS 代码

MD5 加密
MD5 加密

MD5 加密工具

RGB CMYK 转换工具
RGB CMYK 转换工具

RGB CMYK 互转工具