这几天经常与OEM 顶上，前几天刚解决一个OEM问题，今天又遇到了。

 

原打算安装一下Oracle 11gR2. 然后升级到11.2..0.3的，结果安装最后报错。 EM 搞不定。

 

 

准备看一下EM 的状态，执行命令提示环境变量没配置：

[oracle@singledb ~]$ emctl status dbconsole

Environment variable ORACLE_UNQNAME notdefined. Please set ORACLE_UNQNAME to database unique name.

 

修改环境变量后，在看，还是有问题：

[oracle@singledb ~]$ vi /home/oracle/.bash_profile

[oracle@singledb ~]$ source/home/oracle/.bash_profile

 

[oracle@singledb ~]$ emctl status dbconsole

OC4J Configuration issue./u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_singledb_anqing notfound.

[oracle@singledb ~]$

 

查看EM的log 文件：

[oracle@singledb ~]$ tail -80/u01/app/oracle/cfgtoollogs/dbca/anqing/emConfig.log

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was setfor the parameter DBCONTROL_HTTP_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was setfor the parameter AGENT_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was setfor the parameter RMI_PORT.

Sep 30, 2012 6:34:20 PM oracle.sysman.emcp.ParamsManagergetParam

CONFIG: No value was set for the parameterJMS_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterORACLE_HOSTNAME.

Sep 30, 2012 6:34:20 PM oracle.sysman.emcp.util.ClusterUtilgetLocalNode

CONFIG: isLocalNodeDone: true localNode:null

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured

CONFIG: Sid: anqing Host:singledb Node: null OH: /u01/app/oracle/product/11.2.0/db_1 isDBC: false

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterORACLE_HOSTNAME.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterPORTS_FILE.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.ClusterUtil getLocalNode

CONFIG: isLocalNodeDone: true localNode:null

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterJMS_PORT_singledb.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterJMS_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterRMI_PORT_singledb.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterRMI_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterDBCONTROL_HTTP_PORT_singledb.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterDBCONTROL_HTTP_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterAGENT_PORT_singledb.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.ParamsManager getParam

CONFIG: No value was set for the parameterAGENT_PORT.

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG: Setting oracle.installer.oui_loc to/u01/app/oracle/product/11.2.0/db_1/oui

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.OUIInventoryUtil isValidOH

CONFIG: Invalid oracleHome:/u01/app/oracle/product/10.2.0/db_1

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Homes to scan for used ports:[/u01/app/oracle/product/11.2.0/db_1]

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Searching all DBConsole instancesfor used ports under ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Marking JMS port: null from/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Marking RMI port: null from/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Marking HTTP port: nullfrom /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager getAgentPort

CONFIG: Cannot parse EMD_URL correctly. Noport identified

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Marking Agent port: null from/u01/app/oracle/product/11.2.0/db_1/sysman/config/emd.properties

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.PortManager markAllUsedPorts

CONFIG: Cannnot parse EMD_URL correctly. Noport identified

Sep 30, 2012 6:34:20 PMoracle.sysman.emcp.util.FileUtil getProperties

CONFIG: Error reading file/u01/app/oracle/product/11.2.0/db_1/install/staticports.ini

Sep 30, 2012 6:34:21 PMoracle.sysman.emcp.EMConfig perform

SEVERE: Failed to allocate port(s) in thespecified 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/app/oracle/cfgtoollogs/dbca/anqing/emConfig.log for more details.

Sep 30, 2012 6:34:21 PMoracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

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

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

       atoracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:864)

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

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

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

       atoracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)

       at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)

       atoracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

       atoracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)

       at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)

       atoracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

       at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)

       at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)

       at java.lang.Thread.run(Thread.java:595)

Sep 30, 2012 6:34:21 PMoracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG: Restoring oracle.installer.oui_locto /u01/app/oracle/product/11.2.0/db_1/oui

[oracle@singledb ~]$

 

 

查看了一下监听的配置文件：

[oracle@singledb admin]$ cat listener.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

 (SID_LIST =

   (SID_DESC =

     (GLOBAL_DBNAME = anqing)

     (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

     (SID_NAME = anqing)

    )

  )

 

LISTENER =

 (DESCRIPTION_LIST =

   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = singledb)(PORT = 1521))

    )

  )

 

ADR_BASE_LISTENER = /u01/app/oracle

 

[oracle@singledb admin]$

 

这里的HOST 写的是机器名。

 

故查看了一下hosts 配置文件：

[oracle@singledb admin]$ cat /etc/hosts

# Do not remove the following line, orvarious programs

# that require network functionality willfail.

#192.168.3.200          singledb

127.0.0.1 singledb

 

找到原因了。因为我是在虚拟机上装的，之前更换了IP地址，而/etc/hosts 文件没有及时修改。修改了一下hosts文件中的地址。 然后重启了一下监听。

 

[oracle@singledb ~]$ lsnrctl stop

 

LSNRCTL for Linux: Version 11.2.0.1.0 -Production on 30-SEP-2012 18:44:52

 

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

 

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

 

[oracle@singledb ~]$ lsnrctl start

 

LSNRCTL for Linux: Version 11.2.0.1.0 -Production on 30-SEP-2012 18:45:11

 

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

 

Starting/u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 11.2.0.1.0 -Production

System parameter file is/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to/u01/app/oracle/diag/tnslsnr/singledb/listener/alert/log.xml

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=singledb)(PORT=1521)))

 

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version11.2.0.1.0 - Production

Start Date                30-SEP-2012 18:45:11

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                     OFF

Listener Parameter File  /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File        /u01/app/oracle/diag/tnslsnr/singledb/listener/alert/log.xml

Listening Endpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=singledb)(PORT=1521)))

Services Summary...

Service "anqing" has 1instance(s).

 Instance "anqing", status UNKNOWN, has 1 handler(s) for thisservice...

The command completed successfully

[oracle@singledb ~]$

 

最后用DBCA 命令重建了一些OEM。 这次重建正常，没有问题。

 

 

 

 

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

Blog： http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群：62697716(满);   DBA2 群：62697977(满)  DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群：83829929(满) DBA5群： 142216823(满) 

DBA6 群：158654907(满)   DBA7 群：69087192(满)  DBA8 群：172855474

DBA 超级群2：151508914  DBA9群：102954821     聊天 群：40132017(满)

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请