由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：
由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：
[oracle@localhost ~]$ emca -repos recreate
jul 30, 2014 7:15:53 pm oracle.sysman.emcp.emreposconfig droprepository
info: dropping the em repository (this may take a while) ...
jul 30, 2014 7:15:54 pm oracle.sysman.emcp.util.platforminterface executecommand
warning: error executing /u01/app/oracle/10.2.0/db_1/sysman/admin/emdrep/bin/repmanager -connect (description=(address_list=(address=(protocol=tcp)(host=localhost)(port=1521)))(connect_data=(service_name=orcl_asm))) -repos_user sysman -action drop -verbose -output_file /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_repos_drop_2014-07-30_07-15-53-pm.log
提示找不到监听，可是监听确实存在
[oracle@localhost ~]$ lsnrctl status
lsnrctl for linux: version 10.2.0.1.0 - production on 30-jul-2014 19:40:45
copyright (c) 1991, 2005, oracle. all rights reserved.
connecting to (description=(address=(protocol=tcp)(host=10.37.44.111)(port=1521)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 10.2.0.1.0 - production
start date 30-jul-2014 19:15:14
uptime 0 days 0 hr. 25 min. 31 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
listener log file /u01/app/oracle/10.2.0/db_1/network/log/listener.log
listening endpoints summary...
(description=(address=(protocol=tcp)(host=10.37.44.111)(port=1521)))
services summary...
service orclasm has 1 instance(s).
instance orclasm, status unknown, has 1 handler(s) for this service...
the command completed successfully
索性直接创建新的oem
[oracle@localhost ~]$ emca -repos create
started emca at jul 30, 2014 7:22:28 pm
em configuration assistant, version 10.2.0.1.0 production
copyright (c) 2003, 2005, oracle. all rights reserved.
enter the following information:
database sid: orclasm
listener port number: 1521
password for sys user:
password for sysman user:
do you wish to continue? [yes(y)/no(n)]: y
jul 30, 2014 7:22:37 pm oracle.sysman.emcp.emconfig perform
info: this operation is being logged at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_2014-07-30_07-22-28-pm.log.
jul 30, 2014 7:22:37 pm oracle.sysman.emcp.emreposconfig createrepository
info: creating the em repository (this may take a while) ...
jul 30, 2014 7:22:37 pm oracle.sysman.emcp.emreposconfig invoke
severe: error creating the repository
jul 30, 2014 7:22:37 pm oracle.sysman.emcp.emreposconfig invoke
info: refer to the log file at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_repos_create_.log for more details.
jul 30, 2014 7:22:37 pm oracle.sysman.emcp.emconfig perform
severe: error creating the repository
refer to the log file at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_2014-07-30_07-22-28-pm.log for more details.
could not complete the configuration. refer to the log file at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl_asm/emca_2014-07-30_07-22-28-pm.log for more details.
config: ora-20001: sysman already exists..
ora-06512: at line 17
观察生成的日志发现sysman用户已经存在，这是由于用老的em资料库配置数据库导致的，删除该用户
oracle.sysman.assistants.util.sqlengine.sqlfatalerrorexception: ora-20001: sysman already exists..
ora-06512: at line 17
at oracle.sysman.assistants.util.sqlengine.sqlengine.executeimpl(sqlengine.java:1467)
at oracle.sysman.assistants.util.sqlengine.sqlengine.executescript(sqlengine.java:841)
at oracle.sysman.assistants.util.sqlengine.sqlplusengine.executescript(sqlplusengine.java:265)
再次执行仍然报错，还没完了。。。
config: ora-01921: role name 'mgmt_user' conflicts with another user or role name
oracle.sysman.assistants.util.sqlengine.sqlfatalerrorexception: ora-01921: role name 'mgmt_user' conflicts with another user or role name
at oracle.sysman.assistants.util.sqlengine.sqlengine.executeimpl(sqlengine.java:1467)
at oracle.sysman.assistants.util.sqlengine.sqlengine.executescript(sqlengine.java:841)
at oracle.sysman.assistants.util.sqlengine.sqlplusengine.executescript(sqlplusengine.java:265)
登入数据库，这下彻底删除与em有关的用户信息