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 - ProductionSQL> 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 optionsoracle@tbslinux:~> emca -config dbcontrol dbSTARTED 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 performReposChecksSEVERE: '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 optionsoracle@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 AMoracle@linux:~> emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0Copyright (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>