这几天经常与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表空间和数据文件的关系，否则拒绝申请