安装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