博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
[转载]手工启动oracle EM
阅读量:5264 次
发布时间:2019-06-14

本文共 10774 字,大约阅读时间需要 35 分钟。

原文地址:
作者:
在WINDOWS上安完ORACLE发现没有EM没有启动,在网上找了一个手工启动的方法,试了,在WIN下同样可用。
人家的原文如下:

oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:44:14 2012

 

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@tbslinux:~> emca -config dbcontrol db

STARTED EMCA at Jan 5, 2012 9:49:10 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: ticket
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11g/db_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 ................ /oracle/product/11g/db_1

Local hostname ................ tbslinux

Listener ORACLE_HOME ................ /oracle/product/11g/db_1
Listener port number ................ 1521
Database SID ................ ticket
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y
Jan 5, 2012 9:50:32 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log.
Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: 'job_queue_processes' must be greater than or equal to 1.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.
Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.EMConfig perform
SEVERE: 'job_queue_processes' must be greater than or equal to 1.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.
Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.

 

oracle@linux:~> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:56:05 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected.
SQL> alter system set job_queue_processes=5;

System altered.

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@tbslinux:~>

 

oracle@linux:~> emca -config dbcontrol db

STARTED EMCA at Jan 5, 2012 9:58:37 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: ticket
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11g/db_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 ................ /oracle/product/11g/db_1

Local hostname ................ tbslinux

Listener ORACLE_HOME ................ /oracle/product/11g/db_1
Listener port number ................ 1521
Database SID ................ ticket
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y
Jan 5, 2012 9:59:03 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_58_36.log.
Jan 5, 2012 9:59:20 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jan 5, 2012 10:01:08 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://linux:1158/em <<<<<<<<<<<
Jan 5, 2012 10:07:51 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: /oracle/product/11g/db_1/tbslinux_ticket/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 Jan 5, 2012 10:07:51 AM

oracle@linux:~> emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://tbslinux:1158/em/console/aboutApplication
 - An instance of Oracle Enterprise Manager 11g Database Control is already running.
我自己的如下:

C:Documents and SettingsAdministrator>sqlplus /nolog

 

SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 1月 17 17:01:25 2012

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

SQL> conn / as sysdba

已连接。

SQL> alter system set job_queue_processes=5;

 

系统已更改。

 

SQL> quit

从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options 断开

 

C:Documents and SettingsAdministrator>emca -config dbcontrol db

 

EMCA 开始于 2012-1-17 17:02:13

EM Configuration Assistant, 11.1.0.5.0 正式版

版权所有 (c) 2003, 2005, Oracle。保留所有权利。

 

输入以下信息:

数据库 SID: orcl

监听程序端口号: 1521

SYS 用户的口令:

DBSNMP 用户的口令:

SYSMAN 用户的口令:

通知的电子邮件地址 (可选):

通知的发件 (SMTP) 服务器 (可选):

-----------------------------------------------------------------

 

已指定以下设置

 

数据库 ORACLE_HOME ................ C:appAdministratorproduct11.1.0db_1

 

本地主机名 ................ jianke-0v0lcq

监听程序端口号 ................ 1521

数据库 SID ................ orcl

通知的电子邮件地址 ...............

通知的发件 (SMTP) 服务器 ...............

 

-----------------------------------------------------------------

是否继续? [是(Y)/否(N)]: y

2012-1-17 17:02:39 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 C:appAdministratorcfgtoollogsemcaorclemca_2012_01

_17_17_02_13.log。

2012-1-17 17:02:54 oracle.sysman.emcp.EMConfig perform

严重: 监听程序未启动。启动监听程序并重新运行 EM Configuration Assistant。

有关详细资料, 请参阅 C:appAdministratorcfgtoollogsemcaorclemca_2012_01_17_

17_02_13.log 中的日志文件。

无法完成配置。 有关详细资料, 请参阅 C:appAdministratorcfgtoollogsemcaorcle

mca_2012_01_17_17_02_13.log 中的日志文件。

————————监听也没有配置,配好监听再试——————————

C:Documents and SettingsAdministrator>emca -config dbcontrol db

 

EMCA 开始于 2012-1-17 17:04:24

EM Configuration Assistant, 11.1.0.5.0 正式版

版权所有 (c) 2003, 2005, Oracle。保留所有权利。

 

输入以下信息:

数据库 SID: orcl

监听程序端口号: 1521

SYS 用户的口令:

DBSNMP 用户的口令:

SYSMAN 用户的口令:

通知的电子邮件地址 (可选):

通知的发件 (SMTP) 服务器 (可选):

-----------------------------------------------------------------

 

已指定以下设置

 

数据库 ORACLE_HOME ................ C:appAdministratorproduct11.1.0db_1

 

本地主机名 ................ jianke-0v0lcq

监听程序端口号 ................ 1521

数据库 SID ................ orcl

通知的电子邮件地址 ...............

通知的发件 (SMTP) 服务器 ...............

 

-----------------------------------------------------------------

是否继续? [是(Y)/否(N)]: y

2012-1-17 17:04:43 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 C:appAdministratorcfgtoollogsemcaorclemca_2012_01

_17_17_04_24.log。

2012-1-17 17:04:57 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

 

信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...

2012-1-17 17:06:46 oracle.sysman.emcp.EMReposConfig invoke

信息: 已成功上载配置数据

2012-1-17 17:06:49 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib

信息: 软件库已配置成功。

2012-1-17 17:06:49 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

信息: 正在部署预配档案...

2012-1-17 17:07:11 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

信息: 预配档案部署成功。

2012-1-17 17:07:11 oracle.sysman.emcp.util.DBControlUtil secureDBConsole

信息: 正在保护 Database Control (此操作可能需要一段时间)...

2012-1-17 17:07:26 oracle.sysman.emcp.util.DBControlUtil secureDBConsole

信息: 已成功保护 Database Control。

2012-1-17 17:07:26 oracle.sysman.emcp.util.DBControlUtil startOMS

信息: 正在启动 Database Control (此操作可能需要一段时间)...

2012-1-17 17:09:04 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: 已成功启动 Database Control

2012-1-17 17:09:04 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: >>>>>>>>>>> Database Control URL 为 https://jianke-0v0lcq:1158/em <<<<<<

<<<<<

2012-1-17 17:09:09 oracle.sysman.emcp.EMDBPostConfig invoke

警告:

************************  WARNING  ************************

 

管理资料档案库已置于安全模式下, 在此模式下将对 Enterprise Manager 数据进行加密。

加密密钥已放置在文件 C:appAdministratorproduct11.1.0db_1jianke-0v0lcq_or

clsysmanconfigemkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据

将不可用。

 

***********************************************************

已成功完成 Enterprise Manager 的配置

EMCA 结束于 2012-1-17 17:09:09

 

C:Documents and SettingsAdministrator>

 

 

转载于:https://www.cnblogs.com/songzhenhua/archive/2012/10/19/9312843.html

你可能感兴趣的文章
电子眼抓拍大解密
查看>>
tomcat7的数据库连接池tomcatjdbc的25个优势
查看>>
Html 小插件5 百度搜索代码2
查看>>
java.io.IOException: read failed, socket might closed or timeout, read ret: -1
查看>>
java 常用命令
查看>>
卷积中的参数
查看>>
51nod1076 (边双连通)
查看>>
ViewPager的onPageChangeListener里面的一些方法参数:
查看>>
Linux pipe函数
查看>>
java equals 小记
查看>>
2019春 软件工程实践 助教总结
查看>>
Zerver是一个C#开发的Nginx+PHP+Mysql+memcached+redis绿色集成开发环境
查看>>
多线程实现资源共享的问题学习与总结
查看>>
java实现哈弗曼树
查看>>
程序的静态链接,动态链接和装载 (补充)
查看>>
关于本博客说明
查看>>
线程androidAndroid ConditionVariable的用法
查看>>
python常用模块之sys, os, random
查看>>
HDU 2548 A strange lift
查看>>
Linux服务器在外地,如何用eclipse连接hdfs
查看>>