win7下Oracle10g 安装EM部署失败的解决方法

   由于某些原因，需要更改服务器机器名，重启后，修改了oracle监听配置文件，但依旧无法启动服务，在google上找了N种方案，均告失败。无耐，只好重装oracle，安装到最好，告知em部署失败，依据提示查看log文件，如下：

 

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: LOG_FILE value: E:\oracle\product\10.2.0\db_2\cfgtoollogs\dbca\orcl\emConfig.log

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: HOST value: orchidsure

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: PORT value: 1521

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: SID value: orcl

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: LISTENER value: LISTENER

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: LISTENER_OH value: E:\oracle\product\10.2.0\db_2

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag '-config' set to true

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'db' set to true

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: EM_HOME value: E:\oracle\product\10.2.0\db_2

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DB_UNIQUE_NAME value: orcl

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: SERVICE_NAME value: orcl

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: ORACLE_HOME value: E:\oracle\product\10.2.0\db_2

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'dbcontrol' set to true

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'UPDATE_EMAIL' set to false

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag '-backup' set to false

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'create' set to false

2011-9-30 16:17:31 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\cfgtoollogs\emca\emca_2011-09-30_04-17-30-下午.log 复制到 E:\oracle\product\10.2.0\db_2\cfgtoollogs\emca\orcl\emca_2011-09-30_04-17-30-下午.log

2011-9-30 16:17:31 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 E:\oracle\product\10.2.0\db_2\cfgtoollogs\dbca\orcl\emConfig.log。

2011-9-30 16:17:31 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'CHECK_CONFIG' set to true

2011-9-30 16:17:31 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:32 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:32 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: DBSNMP

2011-9-30 16:17:33 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:33 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 MODIFY_SID 的值。

2011-9-30 16:17:33 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:34 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:34 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'asm_db' set to false

2011-9-30 16:17:34 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 MODIFY_SID 的值。

2011-9-30 16:17:34 oracle.sysman.emcp.DatabaseChecks getDbServiceName

配置: No service name available. Will try to set db_unique_name.db_domain

2011-9-30 16:17:34 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:35 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DB_UNIQUE_NAME value: 

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DB_UNIQUE_NAME 的值。

2011-9-30 16:17:35 oracle.sysman.emcp.DatabaseChecks getDbUniqueName

配置: No Database unique name available. Will try to retrieve it from DB itself

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DB_UNIQUE_NAME value: orcl

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DB_DOMAIN 的值。

2011-9-30 16:17:35 oracle.sysman.emcp.DatabaseChecks getDbDomain

配置: No db domain available. Will query db for db_domain parameter

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DB_UNIQUE_NAME value: orcl

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: SERVICE_NAME value: orcl

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 MODIFY_SID 的值。

2011-9-30 16:17:35 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DBID 的值。

2011-9-30 16:17:35 oracle.sysman.emcp.DatabaseChecks getDbid

配置: No dbid available. Will query db to extract it.

2011-9-30 16:17:35 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:36 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:36 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DBID value: 1291010401

2011-9-30 16:17:36 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYSMAN

2011-9-30 16:17:37 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:37 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:37 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:37 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:38 oracle.sysman.emcp.EMDBPreConfig invoke

配置: Passed repository configuration check

2011-9-30 16:17:38 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 MODIFY_SID 的值。

2011-9-30 16:17:38 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 MODIFY_SID 的值。

2011-9-30 16:17:38 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。

2011-9-30 16:17:38 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName

配置: No Global database unique name available. Will try to retrieve it from DB itself

2011-9-30 16:17:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DB_DOMAIN 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.DatabaseChecks getDbDomain

配置: No db domain available. Will query db for db_domain parameter

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties.emca.tmp

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil backupFile

配置: 原始文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties 已被复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties.emca.tmp

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties.emca 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil backupFile

配置: 原始文件 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties.emca 已被复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\emd\targets.xml 复制到 E:\oracle\product\10.2.0\db_2\sysman\emd\targets.xml.emca.tmp

2011-9-30 16:17:39 oracle.sysman.emcp.util.FileUtil backupFile

配置: 原始文件 E:\oracle\product\10.2.0\db_2\sysman\emd\targets.xml 已被复制到 E:\oracle\product\10.2.0\db_2\sysman\emd\targets.xml.emca.tmp

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: Cluster.isCluster: false. Skip call to getLocalNode

2011-9-30 16:17:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:39 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured

配置: Sid: orcl Host: orchidsure Node: null OH: E:\oracle\product\10.2.0\db_2 agentHome: null isCentral: false

2011-9-30 16:17:39 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured

配置: Sid: orcl Host: orchidsure Node: null OH: E:\oracle\product\10.2.0\db_2 isDBC: false

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager setFlag

配置: Flag 'IS_DBCONTROL_CONFIGURED' set to false

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DBCONTROL_HTTP_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 AGENT_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 RMI_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 JMS_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:39 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured

配置: Sid: orcl Host: orchidsure Node: null OH: E:\oracle\product\10.2.0\db_2 isDBC: false

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 PORTS_FILE 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 JMS_PORT_orcl 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 JMS_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 RMI_PORT_orcl 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 RMI_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DBCONTROL_HTTP_PORT_orcl 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DBCONTROL_HTTP_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 AGENT_PORT_orcl 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 AGENT_PORT 的值。

2011-9-30 16:17:39 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

配置: Setting oracle.installer.oui_loc to E:\oracle\product\10.2.0\db_2\oui

2011-9-30 16:17:39 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

配置: Setting oracle.installer.oui_loc to E:\oracle\product\10.2.0\db_2\oui

2011-9-30 16:17:41 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Homes to scan for used ports: [E:\oracle\product\10.2.0\db_2]

2011-9-30 16:17:41 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Searching all DBConsole instances for used ports under ORACLE_HOME E:\oracle\product\10.2.0\db_2

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Marking JMS port: null from E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Marking RMI port: null from E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Marking HTTP port: null from E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager getAgentPort

配置: Cannot parse EMD_URL correctly. No port identified

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Marking Agent port: null from E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager markAllUsedPorts

配置: Cannnot parse EMD_URL correctly. No port identified

2011-9-30 16:17:42 oracle.sysman.emcp.util.FileUtil getProperties

配置: 读取文件 E:\oracle\product\10.2.0\db_2\install\staticports.ini 时出错

2011-9-30 16:17:42 oracle.sysman.emcp.util.PortManager getFreePorts

配置: E:\oracle\product\10.2.0\db_2:orchidsure:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 AGENT_PORT_orcl 的值。

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: AGENT_PORT_orcl value: 3938

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 DBCONTROL_HTTP_PORT_orcl 的值。

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: DBCONTROL_HTTP_PORT_orcl value: 1158

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 JMS_PORT_orcl 的值。

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: JMS_PORT_orcl value: 5540

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 RMI_PORT_orcl 的值。

2011-9-30 16:17:42 oracle.sysman.emcp.ParamsManager setParam

配置: Setting param: RMI_PORT_orcl value: 5520

2011-9-30 16:17:42 oracle.sysman.emcp.EMDBPreConfig getFreePorts

配置: Ports assigned for SID: orcl : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}

2011-9-30 16:17:42 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:43 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:43 oracle.sysman.emcp.EMReposConfig invoke

配置: Successfully granted priviliges to dbsnmp.

2011-9-30 16:17:43 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYS

2011-9-30 16:17:44 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:44 oracle.sysman.emcp.EMReposConfig unlockAccounts

配置: Unlocking dbsnmp and sysman

2011-9-30 16:17:44 oracle.sysman.emcp.EMReposConfig unlockAccounts

配置: Unlocking mgmt view user account

2011-9-30 16:17:44 oracle.sysman.emcp.EMReposConfig unlockAccounts

配置: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end;

2011-9-30 16:17:44 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: 开始执行: CMD /C E:\oracle\product\10.2.0\db_2\sysman\admin\scripts\emca\emcaDbUtil.bat "E:\oracle\product\10.2.0\db_2\sysman\admin\scripts;E:\oracle\product\10.2.0\db_2\bin;" E:/oracle/product/10.2.0/db_2/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe E:\oracle\product\10.2.0\db_2\sysman\admin\scripts\emca\emcaDbUtil.pl E:\oracle\product\10.2.0\db_2 orcl SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD 

2011-9-30 16:17:46 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: Exit value of 0

2011-9-30 16:17:46 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: 已成功执行 CMD /C E:\oracle\product\10.2.0\db_2\sysman\admin\scripts\emca\emcaDbUtil.bat "E:\oracle\product\10.2.0\db_2\sysman\admin\scripts;E:\oracle\product\10.2.0\db_2\bin;" E:/oracle/product/10.2.0/db_2/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe E:\oracle\product\10.2.0\db_2\sysman\admin\scripts\emca\emcaDbUtil.pl E:\oracle\product\10.2.0\db_2 orcl SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD 

2011-9-30 16:17:46 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: Arguments passed E:\oracle\product\10.2.0\db_2 orcl SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD 

 

Connecting to database orcl in home E:\oracle\product\10.2.0\db_2 with user "SYS" role "SYSDBA". 

connected to database. 

sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 

noOfParams to bind: 1. 

sql execute successfully. 

 

2011-9-30 16:17:46 oracle.sysman.emcp.EMReposConfig unlockAccounts

配置: Unlocked mgmt_view account

2011-9-30 16:17:46 oracle.sysman.emcp.EMReposConfig invoke

配置: Successfully unlocked relevant accounts

2011-9-30 16:17:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYSMAN

2011-9-30 16:17:47 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:51 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs

配置: Finished executing emreposoutofbox.sql

2011-9-30 16:17:51 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine connecting with SID: orcl, oracleHome: E:\oracle\product\10.2.0\db_2, and user: SYSMAN

2011-9-30 16:17:52 oracle.sysman.emcp.util.GeneralUtil initSQLEngine

配置: SQLEngine created successfully and connected

2011-9-30 16:17:52 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs

配置: Submitting dbms job: E:\oracle\product\10.2.0\db_2\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql

2011-9-30 16:17:52 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs

配置: Successfully submitted dbms job

2011-9-30 16:17:52 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:52 oracle.sysman.emcp.EMDBCConfig updateEmomsProps

配置: 正在更新文件 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties...

2011-9-30 16:17:52 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:52 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties.emca 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emoms.properties

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\server.xml.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\server.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:53 oracle.sysman.emcp.EMDBCConfig copyOC4JDir

配置: 正在将 OC4J 配置文件从 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _makeDirectory

配置: 创建目录 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\application.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\application.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\data-sources.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\data-sources.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\global-web-application.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\global-web-application.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\http-web-site.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\http-web-site.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\internal-settings.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\internal-settings.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\java2.policy 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\java2.policy

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\jazn-data.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\jazn-data.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\jazn.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\jazn.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\jms.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\jms.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\mime.types 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\mime.types

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\oc4j-connectors.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\oc4j-connectors.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\principals.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\principals.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\rmi.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\rmi.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\config\server.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\server.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _makeDirectory

配置: 创建目录 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\META-INF

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\META-INF\MANIFEST.MF 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\META-INF\MANIFEST.MF

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _makeDirectory

配置: 创建目录 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\application-deployments\default\defaultWebApp

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole\application-deployments\default\defaultWebApp\orion-web.xml 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\application-deployments\default\defaultWebApp\orion-web.xml

2011-9-30 16:17:53 oracle.sysman.emcp.EMDBCConfig copyOC4JDir

配置: 完成复制 OC4J 配置文件

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\jms.xml.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\jms.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\rmi.xml.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\rmi.xml

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\http-web-site.xml.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\oc4j\j2ee\OC4J_DBConsole_orchidsure_orcl\config\http-web-site.xml

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.EMAgentConfig updateEmdProps

配置: 正在更新文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties...

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties.emca 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties

2011-9-30 16:17:53 oracle.sysman.emcp.util.FileUtil _copyFile

配置: 正在将文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties.emca.util.tmp 复制到 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties

2011-9-30 16:17:53 oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles

配置: 正在更新文件 E:\oracle\product\10.2.0\db_2\sysman\config\emd.properties...

2011-9-30 16:17:53 oracle.sysman.emcp.EMAgentConfig updateTargets

配置: value for use102tgt: false

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getLocalListener

配置: Using specified listener name: LISTENER

2011-9-30 16:17:53 oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles

配置: 正在更新文件 E:\oracle\product\10.2.0\db_2\sysman\emd\targets.xml...

2011-9-30 16:17:53 oracle.sysman.emcp.ParamsManager getParam

配置: 未设置参数 ORACLE_HOSTNAME 的值。

2011-9-30 16:17:54 oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles

配置: Local host name: orchidsure

2011-9-30 16:17:54 oracle.sysman.emcp.util.ClusterUtil getLocalNode

配置: isLocalNodeDone: true localNode: null

2011-9-30 16:17:54 oracle.sysman.emcp.util.PlatformInterface addEnvVarToList

配置: Value for env var 'TZ' is '', discarding the same

2011-9-30 16:17:54 oracle.sysman.emcp.util.PlatformInterface addEnvVarToList

配置: Value for env var 'ORACLE_HOSTNAME' is '', discarding the same

2011-9-30 16:17:54 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray

配置: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\orchidsure\AppData\Roaming, ARCGISHOME=C:\Program Files\ArcGIS\, ASSISTANTS_COMMON_CLASSPATH=E:\oracle\product\10.2.0\db_2\assistants\jlib\assistantsCommon.jar, BALISHARE_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\share.jar, CLASSPATH=E:\oracle\product\10.2.0\db_2\jdk\jre\lib\rt.jar;E:\oracle\product\10.2.0\db_2\jdk\jre\lib\i18n.jar;E:\oracle\product\10.2.0\db_2\assistants\dbca\jlib\dbca.jar;E:\oracle\product\10.2.0\db_2\assistants\jlib\assistantsCommon.jar;E:\oracle\product\10.2.0\db_2\jlib\ewt3.jar;E:\oracle\product\10.2.0\db_2\jlib\ewtcompat-3_3_15.jar;E:\oracle\product\10.2.0\db_2\jlib\share.jar;E:\oracle\product\10.2.0\db_2\jlib\swingall-1_1_1.jar;E:\oracle\product\10.2.0\db_2\jlib\oracle_ice5.jar;E:\oracle\product\10.2.0\db_2\jlib\help4.jar;E:\oracle\product\10.2.0\db_2\jlib\jewt4.jar;E:\oracle\product\10.2.0\db_2\jlib\kodiak.jar;E:\oracle\product\10.2.0\db_2\lib\xmlparserv2.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-mapping.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-utility.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-collation.jar;E:\oracle\product\10.2.0\db_2\jlib\netcfg.jar;E:\oracle\product\10.2.0\db_2\jlib\ojmisc.jar;E:\oracle\product\10.2.0\db_2\jlib\oraclepki103.jar;E:\oracle\product\10.2.0\db_2\jlib\ldapjclnt10.jar;E:\oracle\product\10.2.0\db_2\jlib\opm.jar;E:\oracle\product\10.2.0\db_2\jdbc\lib\classes12.zip;E:\oracle\product\10.2.0\db_2\jlib\srvm.jar;E:\oracle\product\10.2.0\db_2\jlib\srvmhas.jar;E:\oracle\product\10.2.0\db_2\jlib\srvmasm.jar;E:\oracle\product\10.2.0\db_2\classes;E:\oracle\product\10.2.0\db_2\jlib\oemlt-10_1_0.jar;E:\oracle\product\10.2.0\db_2\jlib\emca.jar;E:\oracle\product\10.2.0\db_2\sysman\jlib\emCORE.jar;E:\oracle\product\10.2.0\db_2\oc4j\j2ee\home\oc4j.jar;E:\oracle\product\10.2.0\db_2\oc4j\j2ee\home\db_oc4j_deploy.jar;E:\oracle\product\10.2.0\db_2\jlib\emConfigInstall.jar;E:\oracle\product\10.2.0\db_2\oui\jlib\OraInstaller.jar, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMPUTERNAME=ORCHIDSURE, COMSPEC=C:\Windows\system32\cmd.exe, CONFIGSETROOT=C:\Windows\ConfigSetRoot, DBCA_CLASSPATH=E:\oracle\product\10.2.0\db_2\assistants\dbca\jlib\dbca.jar, EM_CLASSPATH=E:\oracle\product\10.2.0\db_2\classes;E:\oracle\product\10.2.0\db_2\jlib\oemlt-10_1_0.jar;E:\oracle\product\10.2.0\db_2\jlib\emca.jar;E:\oracle\product\10.2.0\db_2\sysman\jlib\emCORE.jar;E:\oracle\product\10.2.0\db_2\oc4j\j2ee\home\oc4j.jar;E:\oracle\product\10.2.0\db_2\oc4j\j2ee\home\db_oc4j_deploy.jar;E:\oracle\product\10.2.0\db_2\jlib\emConfigInstall.jar, EWT_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\ewt3.jar;E:\oracle\product\10.2.0\db_2\jlib\ewtcompat-3_3_15.jar, FP_NO_HOST_CHECK=NO, GDK_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\orai18n.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-mapping.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-utility.jar;E:\oracle\product\10.2.0\db_2\jlib\orai18n-collation.jar, HELP_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\help4.jar;E:\oracle\product\10.2.0\db_2\jlib\jewt4.jar, HOMEDRIVE=C:, HOMEPATH=\Users\orchidsure, I18N_CLASSPATH=E:\oracle\product\10.2.0\db_2\jdk\jre\lib\i18n.jar, ICE_BROWSER_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\oracle_ice5.jar, INSTALLER_CLASSPATH=E:\oracle\product\10.2.0\db_2\oui\jlib\OraInstaller.jar, JAVA_HOME=C:\jdk1.6.0_10, JDBC_CLASSPATH=E:\oracle\product\10.2.0\db_2\jdbc\lib\classes12.zip, JRE_CLASSPATH=E:\oracle\product\10.2.0\db_2\jdk\jre\lib\rt.jar, JRE_HOME=C:\Program Files\Java\jre6, KODIAK_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\kodiak.jar, LOCALAPPDATA=C:\Users\orchidsure\AppData\Local, LOGONSERVER=\\ORCHIDSURE, NEED_EXIT_CODE=1, NETCFG_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\netcfg.jar;E:\oracle\product\10.2.0\db_2\jlib\ojmisc.jar;E:\oracle\product\10.2.0\db_2\jlib\oraclepki103.jar;E:\oracle\product\10.2.0\db_2\jlib\ldapjclnt10.jar;E:\oracle\product\10.2.0\db_2\jlib\opm.jar, NUMBER_OF_PROCESSORS=4, OH=E:\oracle\product\10.2.0\db_2, ORACLE_SID=orcl, OS=Windows_NT, PATH=E:\oracle\product\10.2.0\db_2\jdk\jre\bin\server;E:\oracle\product\10.2.0\db_2\bin;C:\Program Files\Broadcom\Broadcom 802.11 Network Adapter\Driver;;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\ArcGIS\ArcSDE\ora10gexe\bin, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PERL5LIB=E:\oracle\product\10.2.0\db_2\perl\5.8.3\lib\MSWin32-x86;E:\oracle\product\10.2.0\db_2\perl\5.8.3\lib;E:\oracle\product\10.2.0\db_2\perl\5.8.3\lib\MSWin32-x86;E:\oracle\product\10.2.0\db_2\perl\site\5.8.3;E:\oracle\product\10.2.0\db_2\perl\site\5.8.3\lib;E:\oracle\product\10.2.0\db_2\sysman\admin\scripts;E:\oracle\product\10.2.0\db_2\perl\lib\5.8.3\MSWin32-x86;E:\oracle\product\10.2.0\db_2\perl\lib\5.8.3;E:\oracle\product\10.2.0\db_2\perl\5.8.3\lib\MSWin32-x86-multi-thread;E:\oracle\product\10.2.0\db_2\perl\site\5.8.3;E:\oracle\product\10.2.0\db_2\perl\site\5.8.3\lib;E:\oracle\product\10.2.0\db_2\sysman\admin\scripts, PROCESSOR_ARCHITECTURE=x86, PROCESSOR_IDENTIFIER=x86 Family 6 Model 37 Stepping 5, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2505, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, PYTHONPATH=C:\Program Files\ArcGIS\bin, SDEHOME=C:\Program Files\ArcGIS\ArcSDE\ora10gexe\, SRVM_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\srvm.jar;E:\oracle\product\10.2.0\db_2\jlib\srvmhas.jar;E:\oracle\product\10.2.0\db_2\jlib\srvmasm.jar, SWING_CLASSPATH=E:\oracle\product\10.2.0\db_2\jlib\swingall-1_1_1.jar, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ORCHID~1\AppData\Local\Temp, TMP=C:\Users\ORCHID~1\AppData\Local\Temp, USERDOMAIN=ORCHIDSURE, USERNAME=orchidsure, USERPROFILE=C:\Users\orchidsure, WINDIR=C:\Windows, XMLPARSER_CLASSPATH=E:\oracle\product\10.2.0\db_2\lib\xmlparserv2.jar, __COMPAT_LAYER=VistaSetup, __PROCESS_HISTORY=F:\软件\oracle10G_win7\db\Disk1\setup.exe]

2011-9-30 16:17:54 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: 开始执行: CMD /C E:\oracle\product\10.2.0\db_2\bin\emctl.bat deploy dbconsole E:\oracle\product\10.2.0\db_2\orchidsure_orcl orchidsure:3938 orchidsure orcl 

2011-9-30 16:17:55 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: Exit value of 255

2011-9-30 16:17:55 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: Creating shared install...

Source location: E:\oracle\product\10.2.0\db_2

Destination (shared install) : E:\oracle\product\10.2.0\db_2\orchidsure_orcl

DeployMode : dbconsole

 

Creating directories...

Setting console properties ... 

Setting log and trace files locations for Console ... 

Setting log and trace files locations for Agent ... 

 

2011-9-30 16:17:55 oracle.sysman.emcp.util.PlatformInterface executeCommand

配置: CreateService FAILED: 指定的服务已存在。

Service creation failed. Aborting...

 

2011-9-30 16:17:55 oracle.sysman.emcp.util.PlatformInterface executeCommand

警告: 执行 CMD /C E:\oracle\product\10.2.0\db_2\bin\emctl.bat deploy dbconsole E:\oracle\product\10.2.0\db_2\orchidsure_orcl orchidsure:3938 orchidsure orcl  时出错

2011-9-30 16:17:55 oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles

配置: Failed to deploy state dirs

2011-9-30 16:17:55 oracle.sysman.emcp.EMConfig perform

严重: 实例化 EM 配置文件时出错

有关详细资料, 请参阅 E:\oracle\product\10.2.0\db_2\cfgtoollogs\dbca\orcl\emConfig.log 中的日志文件。

2011-9-30 16:17:55 oracle.sysman.emcp.EMConfig perform

配置: Stack Trace: 

oracle.sysman.emcp.exception.EMConfigException: 实例化 EM 配置文件时出错

at oracle.sysman.emcp.EMAgentConfig.updateAgentConfigFiles(EMAgentConfig.java:2615)

at oracle.sysman.emcp.EMAgentConfig.performConfiguration(EMAgentConfig.java:1196)

at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:226)

at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:204)

at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:146)

at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:436)

at java.lang.Thread.run(Thread.java:534)

解决方法如下：

1,emca -repos drop
2,emca -config dbcontrol db -repos create

注意 输入监听端口时输入监听器的端口  

下面是我的操作
C:\Documents and Settings\Administrator>emca -repos drop

EMCA 开始于 2009-4-1 16:53:50
EM Configuration Assistant 10.2.0.1.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:
数据库 SID: orcl
监听程序端口号: 1521
SYS 用户的口令:
SYSMAN 用户的口令:
SYSMAN 用户的口令:
是否继续? [yes(Y)/no(N)]: y
2009-4-1 16:54:01 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emc
a_2009-04-01_04-53-50-下午.log。
2009-4-1 16:54:01 oracle.sysman.emcp.EMReposConfig dropRepository
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...
2009-4-1 16:54:53 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功删除资料档案库
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2009-4-1 16:54:53

C:\Documents and Settings\Administrator>emca -config dbcontrol db -repos create

EMCA 开始于 2009-4-1 16:56:32
EM Configuration Assistant 10.2.0.1.0 正式版
版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:
数据库 SID: orcl
已为数据库 orcl 配置了 Database Control
您已选择配置 Database Control, 以便管理数据库 orcl
此操作将移去现有配置和默认设置, 并重新执行配置
是否继续? [yes(Y)/no(N)]: y
监听程序端口号: 1521
SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
SYSMAN 用户的口令: 通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE_HOME ................ d:\oracle\product\10.2.0\db_1

数据库主机名 ................ PERFECT
监听程序端口号 ................ 1521
数据库 SID ................ orcl
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............

-----------------------------------------------------------------
是否继续? [yes(Y)/no(N)]: y
2009-4-1 16:57:17 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emc
a_2009-04-01_04-56-32-下午.log。
2009-4-1 16:57:18 oracle.sysman.emcp.util.DBControlUtil stopOMS
信息: 正在停止 Database Control (此操作可能需要一段时间)...
2009-4-1 16:57:21 oracle.sysman.emcp.EMReposConfig createRepository
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
2009-4-1 16:58:56 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功创建资料档案库
2009-4-1 16:59:04 oracle.sysman.emcp.util.DBControlUtil startOMS
信息: 正在启动 Database Control (此操作可能需要一段时间)...
2009-4-1 16:59:44 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2009-4-1 16:59:44 oracle.sysman.emcp.EMDBPostConfig performConfiguration
警告: 无法创建 Database Control 快捷方式
2009-4-1 16:59:44 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为 http://PERFECT:5500/em <<<<<<<<<<<
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2009-4-1 16:59:44