http://blog.sina.com.cn/s/blog_470504830100yuhj.html
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 Settings\Administrator>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 Settings\Administrator>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:\app\Administrator\product\11.1.0\db_1
本地主机名 ................ jianke-0v0lcq
监听程序端口号 ................ 1521
数据库 SID ................ orcl
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............
-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2012-1-17 17:02:39 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 C:\app\Administrator\cfgtoollogs\emca\orcl\emca_2012_01
_17_17_02_13.log。
2012-1-17 17:02:54 oracle.sysman.emcp.EMConfig perform
严重: 监听程序未启动。启动监听程序并重新运行 EM Configuration Assistant。
有关详细资料, 请参阅 C:\app\Administrator\cfgtoollogs\emca\orcl\emca_2012_01_17_
17_02_13.log 中的日志文件。
无法完成配置。 有关详细资料, 请参阅 C:\app\Administrator\cfgtoollogs\emca\orcl\e
mca_2012_01_17_17_02_13.log 中的日志文件。
————————监听也没有配置,配好监听再试——————————
C:\Documents and Settings\Administrator>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:\app\Administrator\product\11.1.0\db_1
本地主机名 ................ jianke-0v0lcq
监听程序端口号 ................ 1521
数据库 SID ................ orcl
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............
-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2012-1-17 17:04:43 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 C:\app\Administrator\cfgtoollogs\emca\orcl\emca_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:\app\Administrator\product\11.1.0\db_1\jianke-0v0lcq_or
cl\sysman\config\emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据
将不可用。
***********************************************************
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2012-1-17 17:09:09
C:\Documents and Settings\Administrator>
相关推荐
dbconsole备份Oracle数据库
个人学习笔记——oracle_dbconsole解决办法;oracle 9i,oracle 10g经常由于更改IP地址,一起dbconsole不能起来,用此方法可以解决!
oracle10g dbconsole无法启动解决方案
详细地描述了如何配置和使用ORACLE DBCONSOLE,是个人的学习笔记.
oracle.sysman.emcp.exception.EMConfigException: 启动 Database Control 时出错 at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:649) at oracle.sysman.emcp.EMDBPostConfig....
设置ORACLE_HOME和ORACLE_SID系统环境变量,将%ORACLE_HOME%\opatch加入PATH环境变量,将patch 8350262解压缩,打开cmd窗口,进入解压缩后目录,执行 cmd>opatch apply 完成后检查%ORACLE_HOME%\cfgtoollogs\opatch\...
在WindowsXp Pro下安装Oracle11g无法创建数据库,如图所示。如果不创建数据库后,在程序组中找不到像Oracle9i那样的Enterprise Manager,请问该如何到企业管理器中去呢? 后来重装WindowsXp系统,安装Oracle10g出现...
Windows XP下Oracle DBConsole 配置教程
oracle 经常由于更改IP地址,导致dbconsole不能启动,此文档可以解决
oracle 中若遇到dbconsole 起不来的问题,此文档中提供了解决办法
直用9i,即使服务器迁到了10g上还是习惯性用9i客户端去连,这两天试了下在自己机器搭了个环境结果问题一大堆。尝试了很多方法后,终于找到根除问题的方法,希望对大家有所帮助。
export ORACLE_SID=orcl export PATH=$PATH:$ORACLE_HOME/bin ORA_OWNR="oracle" # if the executables do not exist -- display error if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ] then echo ...
Ooracle 数据库性能监控常用sql 监控当前会话、执行的sql及io等信息
环境:Oracle Enterprise Linux 5.4 + Oracle 10g R2 . 一、手动删除文件系统数据库 1.停止监听与OEM 代码如下: $ lsnrctl stop listener_name $ emctl stop dbconsole 2.获得数据文件,日志...
在WindowsXp Pro下安装Oracle11g无法创建数据库,如图所示。如果不创建数据库后,在程序组中找不到像Oracle9i那样的Enterprise Manager,请问该如何到企业管理器中去呢? 后来重装WindowsXp系统,安装Oracle10g...
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2011-10-12_08-07-32PM. 请稍候... SHAPE \* MERGEFORMAT 典型的安装设置 单实例数据库、企业版、管理口令 基本目录:/opt/oracle/ 软件位置...
oracle10g em 重新配置 emca -repos drop emca -repos create 建议 emca -repos recreate (当时用create 出现莫名错误,但没注意错误日志) emca -config dbcontrol db emca -config dbcontrol db emctl stop ...
最后,启动 Oracle 实例(和相关服务)以及企业管理器数据库控制台。 $ export ORACLE_SID=orcl1 $ srvctl start nodeapps -n rac1 $ srvctl start asm -n rac1 $ srvctl start instance -d orcl -i orcl1 $ emctl...
解决有关Oracle安装后服务器无法开启的问题,特别是报错是误码2
oracle数据库服务器更换IP后,导致ORACLEDBCONSOLEORCL服务无法启动的解决方案。