小弟的oracle10g dbconsole服务没了,也不知道什么原因。但是执行emca -deconfig dbcontrol db -repos drop 这个命令等了很久都没成功。希望大侠帮忙查看下;在线等!oem em oracle
解决方案 »
- ORA-00059: 超出 DB_FILES 的最大值
- oracle 数据库 group by 的问题
- 类似 secureCRT 的软件都有哪些啊
- orcale映射公网连接超时的问题。急!!!
- 搞制造业企业内部做erp维护和二次开发的进来聊聊
- sql问题请教,查出一个表中所有相同记录后,只保留相同记录中的一条记录,其它的全部删除,如何写sql,如果在存储过程里如何做呢
- 分组后排序
- 这样一个左连接PL/SQL语句该怎么写?
- 我机子是Windows2000系统,我前天装Oracle8.0不知道怎么啦,一直连接不上
- 怎么删表中的一个column?
- 如何在oracle里面批量的插入数据,就是说这个脚本怎么写
- CTAS的问题
...\cfgto0llogs\emca\orcl\emca...log
日志文件如下2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-deconfig' set to true
2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'dbcontrol' set to true
2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'centralAgent' set to true
2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'drop' set to true
2013-10-18 10:13:01 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: F:\oracle\product\10.2.0\db_1
2013-10-18 10:13:11 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: orcl
2013-10-18 10:13:14 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: PORT value: 1521
2013-10-18 10:13:19 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2013-10-18 10:13:19 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYS
2013-10-18 10:13:20 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2013-10-18 10:13:35 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value:
2013-10-18 10:13:40 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value: yes
2013-10-18 10:13:40 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 LOG_FILE 的值。
2013-10-18 10:13:40 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2013-10-18 10:13:40 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2013-10-18 10:13:40 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYS
2013-10-18 10:13:41 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2013-10-18 10:13:41 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2013-10-18 10:13:41 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2013-10-18 10:13:41 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 F:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-10-18_10-13-01-上午.log。
2013-10-18 10:13:41 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: EM_HOME value: F:\oracle\product\10.2.0\db_1
2013-10-18 10:13:41 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2013-10-18 10:13:41 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2013-10-18 10:13:41 oracle.sysman.emcp.DatabaseChecks getDbServiceName
配置: No service name available. Will try to set db_unique_name.db_domain
2013-10-18 10:13:41 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYS
2013-10-18 10:13:42 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value:
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2013-10-18 10:13:42 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2013-10-18 10:13:42 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2013-10-18 10:13:42 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SERVICE_NAME value: orcl
2013-10-18 10:13:42 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYS
2013-10-18 10:13:43 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2013-10-18 10:13:43 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2013-10-18 10:13:43 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2013-10-18 10:13:43 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。
2013-10-18 10:13:43 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
配置: No Global database unique name available. Will try to retrieve it from DB itself
2013-10-18 10:13:43 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYS
2013-10-18 10:13:44 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2013-10-18 10:13:44 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2013-10-18 10:13:44 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: Cluster.isCluster: false. Skip call to getLocalNode
2013-10-18 10:13:44 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2013-10-18 10:13:44 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
配置: Sid: orcl Host: 20130607-0921 Node: null OH: F:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
2013-10-18 10:13:44 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
配置: Sid: orcl Host: 20130607-0921 Node: null OH: F:\oracle\product\10.2.0\db_1 isDBC: true
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'IS_DBCONTROL_CONFIGURED' set to true
2013-10-18 10:13:44 oracle.sysman.emcp.util.DBControlUtil stopOMS
信息: 正在停止 Database Control (此操作可能需要一段时间)...
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface serviceCommand
配置: cmdType: 1
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface serviceCommand
配置: Service does not exist
2013-10-18 10:13:44 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface isInView
配置: IN_VIEW er not instantiated in F:\oracle\product\10.2.0\db_1\sysman\config\emca.properties
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
配置: New Env List: [EMDROOT=F:\oracle\product\10.2.0\db_1, LD_LIBRARY_PATH=F:\oracle\product\10.2.0\db_1\lib32;F:\oracle\product\10.2.0\db_1\lib;F:\oracle\product\10.2.0\db_1\perl\lib;null, PATH=F:\oracle\product\10.2.0\db_1\jdk\jre\bin\server;F:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Sybase\Shared\PowerBuilder\;C:\Documents and Settings\Administrator\Local Settings\Application Data\Kingsoft\WPS Office\9.1.0.4180\office6;C:\Program Files\Java\jdk1.7.0_15\jre\bin;C:\Program Files\Java\jdk1.7.0_15\bin;F:\oracle\product\10.2.0\db_1\BIN, PERL5LIB=F:\oracle\product\10.2.0\db_1\sysman\admin\scripts;F:\oracle\product\10.2.0\db_1\bin;, SystemRoot=C:\WINDOWS, WINDIR=C:\WINDOWS]
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 开始执行: F:/oracle/product/10.2.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe F:\oracle\product\10.2.0\db_1\sysman\admin\scripts\db\sgastop.pl stop orcl 20130607-0921 1521 F:\oracle\product\10.2.0\db_1
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: Exit value of 0
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 已成功执行 F:/oracle/product/10.2.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe F:\oracle\product\10.2.0\db_1\sysman\admin\scripts\db\sgastop.pl stop orcl 20130607-0921 1521 F:\oracle\product\10.2.0\db_1
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: nmccollector process does not exist2013-10-18 10:13:44 oracle.sysman.emcp.util.DBControlUtil stopNmccollector
配置: Successfully stopped nmc-collector process
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface serviceCommand
配置: cmdType: 2
2013-10-18 10:13:44 oracle.sysman.emcp.util.PlatformInterface serviceCommand
配置: Service does not exist
2013-10-18 10:13:44 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2013-10-18 10:13:44 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2013-10-18 10:13:44 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: F:\oracle\product\10.2.0\db_1, and user: SYSMAN