oracle10g em配置

进行10g 的EM配置时，遇到的问题及解决方法：

[oracle@myoracle admin]$ emca -repos create

STARTED EMCA at Dec 17, 2009 11:51:53 AM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:

Database SID: clonedb

Listener port number: 1521

Password for SYS user: 

Password for SYSMAN user: 

Do you wish to continue? [yes(Y)/no(N)]: y

Dec 17, 2009 11:52:02 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/clonedb/emca_2009-12-17_11-51-52-AM.log.

Dec 17, 2009 11:52:02 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Dec 17, 2009 11:52:02 AM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

INFO: Refer to the log file at /u01/oracle/cfgtoollogs/emca/clonedb/emca_repos_create_<date>.log for more details.--提示错误

Refer to the log file at /u01/oracle/cfgtoollogs/emca/clonedb/emca_2009-12-17_11-51-52-AM.log for more details.

Could not complete the configuration. Refer to the log file at /u01/oracle/cfgtoollogs/emca/clonedb/emca_2009-12-17_11-51-52-AM.log for more details.

[oracle@myoracle clonedb]$ cat emca_repos_create_2009-12-17_12-08-35-PM.log   --查看错误信息

Check if repos user already exists.

old   6:    WHERE username=UPPER('&EM_REPOS_USER');

new   6:    WHERE username=UPPER('SYSMAN');

old   8:   IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN

new   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN

old  11:       raise_application_error(-20000, '&EM_REPOS_USER does not exists..');

new  11:       raise_application_error(-20000, 'SYSMAN does not exists..');

old  14:   ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN

new  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN

old  17:       raise_application_error(-20001, '&EM_REPOS_USER already exists..');

new  17:       raise_application_error(-20001, 'SYSMAN already exists..');

old  21:       raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');

new  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');

DECLARE

*

ERROR at line 1:

ORA-20001: SYSMAN already exists..                                           --提示SYSMAN用户存在

ORA-06512: at line 17

SQL> drop user sysman cascade;                                               --删除用户及相关权限

SQL> drop role MGMT_USER;

SQL> drop user MGMT_VIEW cascade;

SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

SQL> drop public synonym SETEMVIEWUSERCONTEXT;

[oracle@myoracle admin]$ emca -repos create                               

STARTED EMCA at Dec 17, 2009 12:21:44 PM

Dec 17, 2009 12:21:53 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/clonedb/emca_2009-12-17_12-21-44-PM.log.

Dec 17, 2009 12:21:54 PM oracle.sysman.emcp.EMReposConfig createRepository

Dec 17, 2009 12:31:59 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Enterprise Manager configuration completed successfully

FINISHED EMCA at Dec 17, 2009 12:31:59 PM

[oracle@myoracle admin]$ vi /etc/hosts                 --原先的hosts IP设置错误。

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               localhost.localdomain localhost

192.168.10.180          myoracle

[oracle@myoracle ~]$ emca -config dbcontrol db

STARTED EMCA at Dec 17, 2009 12:42:48 PM

Password for DBSNMP user: 

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/oracle

Database hostname ................ myoracle

Listener port number ................ 1521

Database SID ................ clonedb

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

Dec 17, 2009 12:43:02 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/clonedb/emca_2009-12-17_12-42-48-PM.log.

Dec 17, 2009 12:43:26 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Dec 17, 2009 12:45:25 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Dec 17, 2009 12:45:26 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is http://myoracle:1158/em <<<<<<<<<<<

FINISHED EMCA at Dec 17, 2009 12:45:26 PM

[oracle@myoracle ~]$ emctl start dbconsole;

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 

Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

http://myoracle:1158/em/console/aboutApplication

 - An instance of Oracle Enterprise Manager 10g Database Control is already running.

[oracle@myoracle ~]$ emctl status

Invalid arguments

Unknown command option status

Usage::

   Oracle Enterprise Manager 10g Database Control commands:

       emctl start| stop| status| setpasswd dbconsole

       emctl secure <options>

       emctl set ssl test|off|on em

       emctl set ldap <host> <port> <user dn> <user pwd> <context dn>

emctl blackout options can be listed by typing "emctl blackout"

emctl config options can be listed by typing "emctl config"

emctl secure options can be listed by typing "emctl secure"

emctl ilint  options can be listed by typing "emctl ilint"

emctl deploy  options can be listed by typing "emctl deploy"

看到的另一个文章的解决办法：

oldboy 发表于:2007.12.22 20:12

主要描述了在安装ＥＭ时，始终报下面的错误的解决办法：

Enterprise manager configuration failed due to the following error -

Failed to allocate port(s) int the specified range for the following process(es):

JMS [5540-5559], RMI [5520-5539], Database Control [5500-5519], EM agent [1830-1849]

今天在ＨＰＵＸ　１１．３１上安装ＯＲＡＣＬＥ　１０Ｇ　１０．２．０．３时，数据库都配置好了，但ＥＭ报错，通过安装日志文件查看，发现以下错误：

SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]

Refer to the log file at /U01/oracle/product/10.2.0/db_1/cfgtoollogs/emca/si2000/emca_2007-12-22_04-36-47-PM.log for more details.

Dec 22, 2007 4:37:17 PM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]

at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2255)

at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:678)

at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:241)

at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:168)

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

at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:485)

at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1141)

at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:469)

at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:418)

经过网上查询，知道是网络端口重复了，使用以下方法解决：

emca -config dbcontrol db -DBCONTROL_HTTP_PORT 5508 -AGENT_PORT 3940 -RMI_PORT 5524 -JMS_PORT 5545

再停用一次ＥＭ，再启动ＥＭ，就好了．

emctl stop dbconsole

emctl start dbconsole