在虚拟机中装的oracle10g,安装时虚拟机以太网连接方式为仅主机,装完后服务能启动,em也能够登陆。后来把以太网连接方式改为桥接,oracle服务能正常启动,em登陆不上。因此想重新创建em资料库,在用emca -repos drop 删除资料库时,执行到: 信息:正在删除 EM资料档案库<此操作可能需要一段时间>...就一直没动静了。本以为必须在原Ip地址下才能删除,因此将以太网连接方式切换为仅主机模式,重启系统,执行相同命令,还是执行到这一步就不动了。网上有人说会等一段时间,但感觉等的时间太长了,两个小时没动静,应该是哪里出问题了。日志如下,高手帮忙研究研究:
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-repos' set to true
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'drop' set to true
2009-2-20 14:24:22 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: D:\oracle\product\10.2.0\db_1
2009-2-20 14:24:24 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: orcl
2009-2-20 14:24:30 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: PORT value: 1521
2009-2-20 14:24:34 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2009-2-20 14:24:34 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:35 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:43 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value:
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value: yes
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 LOG_FILE 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:45 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:45 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-02-20_02-24-21-下午.log。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: EM_HOME value: D:\oracle\product\10.2.0\db_1
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.DatabaseChecks getDbServiceName
配置: No service name available. Will try to set db_unique_name.db_domain
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value:
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SERVICE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
配置: No Global database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.EMReposConfig dropRepository
配置: Spooling to D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_drop_2009-02-20_02-24-46-下午.log
2009-2-20 14:24:46 oracle.sysman.emcp.EMReposConfig dropRepository
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
配置: New Env List: [ORACLE_HOME=D:\oracle\product\10.2.0\db_1, ORACLE_SID=orcl, PATH=D:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem, SystemRoot=C:\WINDOWS, WINDIR=C:\WINDOWS]
2009-2-20 14:24:46 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 开始执行: CMD /C D:\oracle\product\10.2.0\db_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.191.128)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_drop_2009-02-20_02-24-46-下午.log
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag '-repos' set to true
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:21 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'drop' set to true
2009-2-20 14:24:22 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: ORACLE_HOME value: D:\oracle\product\10.2.0\db_1
2009-2-20 14:24:24 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SID value: orcl
2009-2-20 14:24:30 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: PORT value: 1521
2009-2-20 14:24:34 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 SYS_PWD 的值。
2009-2-20 14:24:34 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:35 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:43 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value:
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: CONFIRMATION ANSWER value: yes
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 LOG_FILE 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:45 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:45 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-02-20_02-24-21-下午.log。
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: EM_HOME value: D:\oracle\product\10.2.0\db_1
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager setFlag
配置: Flag 'db' set to true
2009-2-20 14:24:45 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:45 oracle.sysman.emcp.DatabaseChecks getDbServiceName
配置: No service name available. Will try to set db_unique_name.db_domain
2009-2-20 14:24:45 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value:
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_UNIQUE_NAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
配置: No Database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: SERVICE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MODIFY_SID 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
配置: No Global database unique name available. Will try to retrieve it from DB itself
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DB_DOMAIN 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.DatabaseChecks getDbDomain
配置: No db domain available. Will query db for db_domain parameter
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
2009-2-20 14:24:46 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2009-2-20 14:24:46 oracle.sysman.emcp.EMReposConfig dropRepository
配置: Spooling to D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_drop_2009-02-20_02-24-46-下午.log
2009-2-20 14:24:46 oracle.sysman.emcp.EMReposConfig dropRepository
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
2009-2-20 14:24:46 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: SQLEngine created successfully and connected
2009-2-20 14:24:46 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
配置: New Env List: [ORACLE_HOME=D:\oracle\product\10.2.0\db_1, ORACLE_SID=orcl, PATH=D:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem, SystemRoot=C:\WINDOWS, WINDIR=C:\WINDOWS]
2009-2-20 14:24:46 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 开始执行: CMD /C D:\oracle\product\10.2.0\db_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.191.128)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_drop_2009-02-20_02-24-46-下午.log
1,修改DBSNMP密码:
重新配置DBCONSOLE,需要输入DBSNMP密码,但任何密码都会显示错误,需要预先修改。
sql>alter user dbsnmp identified by xxx;
2,删除早期DBCONSOLE创建的用户:
sql>drop role MGMT_USER;
sql>drop user MGMT_VIEW cascade;
sql>drop user sysman cascade;
3,删除早期DBCONSOLE创建的对象:
sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
sql>drop public synonym SETEMVIEWUSERCONTEXT;
4,重新创建DBCONSOLE:(如果是在windows下,要先到注册表删除DBCONSOLE的服务,重启电脑)
$emca -config dbcontrol db -repos create
根据提示,先输入SID,再输入Y继续;
输入端口1521,输入SYS密码,输入DBSNMP密码,输入SYSMAN 密码,输入Y继续
完成。
Solution
When changing the Hostname, 4 files would be affected.
1) Tnsnames.ora
2) listener.ora
3) Oraclecsservice
4) Enterprise Manager 楼主用4楼的方法试试..
参考一下这个
彻底删除EM
重建的步骤都有