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标准库

P. J. Plauger / 卢红星、徐明亮、霍建同 / 人民邮电出版社 / 2009-7 / 79.00元

本书是由世界级C语言专家编写的C标准库经典著作。英文版已经重印十多次,影响了几代程序员。 本书结合C标准的相关部分,精辟地讲述了每一个库函数的使用方法和实现细节,而这正是一个真正的C程序员所必须掌握的。更重要的是,书中给出了实现和测试这些函数的完整源代码,可以让你更深入地学习C语言。不仅如此,本书还讨论了一些即使是最有经验的C程序员通常也不熟悉的知识,比如国际化和独立于区域设置的程序的编写、......一起来看看 《C标准库》 这本书的介绍吧!

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

在线图片转Base64编码工具

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

URL 编码/解码

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

正则表达式在线测试