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进行访问。


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

查看所有标签

猜你喜欢:

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

Letting Go of the Words

Letting Go of the Words

Janice (Ginny) Redish / Morgan Kaufmann / 2007-06-11 / USD 49.95

"Redish has done her homework and created a thorough overview of the issues in writing for the Web. Ironically, I must recommend that you read her every word so that you can find out why your customer......一起来看看 《Letting Go of the Words》 这本书的介绍吧!

JSON 在线解析
JSON 在线解析

在线 JSON 格式化工具

图片转BASE64编码
图片转BASE64编码

在线图片转Base64编码工具

Base64 编码/解码
Base64 编码/解码

Base64 编码/解码