安装OEM遇到问题ORA-06512的处理方法

一、emca -config dbcontrol db
报错信息, 错误信息集中在创建资料库的时候，即  emca -repos create   ：
CONFIG: ORA-20001: SYSMAN already exists..

ORA-06512: at line 17

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..     --提示SYSMAN用户存在

ORA-06512: at line 17

解决办法：
则需要在数据库端删除：用户以及相关权限
SQL> drop  user  sysman  cascade;

User dropped.

SQL>  drop   role  MGMT_USER;

Role dropped.

SQL>  drop user  MGMT_VIEW  cascade;

User dropped.

SQL>  drop  public   synonym  MGMT_TARGET_BLACKOUTS;

Synonym dropped.

SQL> drop  public  synonym SETEMVIEWUSERCONTEXT;

Synonym dropped.
 

run  2012.01.15
二、再次emca -repos create
报错信息：
第 1 行出现错误:
ORA-01921: 角色名 'MGMT_USER' 与另一个用户名或角色名发生冲突
解决办法：
在数据库中删除该角色
drop role mgmt_user;
三、第三次emca -repos create
这次大约经历了15分钟后成功
四、配置em 
emca -config dbcontrol
配置过程中报错信息：
2011-6-9 16:41:39 oracle.sysman.emcp.util.Platforminterface executeCommand
配置：ERROR in tempfile() using c:\temp\xxxxxxxxxx:Could not create temp file C:\temp\qjC58z4hDf:Permission denied at bin/EMDeploy.pm line 674

解决办法：
根据错误信息得知没有权限在c:\temp下创建文件，授权后重新配置，成功！

配置
testhost:{/oracle}$emca -config dbcontrol db
STARTED EMCA at Oct 20, 2008 3:13:13 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: testdb
Database Control is already configured for the database testdb
You have chosen to configure Database Control for managing the database testdb
This will remove the existing configuration and the default settings and perform. a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
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/app/oracle/product/10.2
Database hostname ................ testhost
Listener port number ................ 1521
Database SID ................ testdb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 20, 2008 3:13:43 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2/cfgtoollogs/emca/testdb/emca_2008-10-20_03-13-13-PM.log.
Oct 20, 2008 3:13:45 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Oct 20, 2008 3:13:52 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Oct 20, 2008 3:14:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Oct 20, 2008 3:14:24 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Oct 20, 2008 3:16:05 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 20, 2008 3:16:05 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://testhost:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 20, 2008 3:16:05 PM

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7356664/viewspace-749589/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7356664/viewspace-749589/