Oracle Enterprise Manager 13c upgrade 13.3 to 13.4 Troubleshooting

記錄一下處理與Oracle Support提供的文件內容

原環境 EM 從 13.3 升上 13.4 並打上 ru9 後,發生2個問題 (agent 無法連線至 oem、Target Show Down Status )

1. EM agent 無法連線至 OEM 主機

打上 ru9 後就發現有部份 client agent 連線異常,從 agent Client 端查詢 emctl pingOMS 會無法辨識 OMS Server

開立 case 後,檢查 sysman object 是否有壞掉,結果是有的

SQL> select OBJECT_NAME,OBJECT_TYPE,OWNER from dba_objects where STATUS!='VALID' and OWNER in ('SYSMAN');

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
----------------------------------------------
OWNER
--------------------------------------------------------------------------------
EMD_LOADER
PACKAGE BODY
SYSMAN

Solution:

最初 Support 提供的解法步驟如下,但是執行2→3後,還是有錯誤無法繼續

1. 停止OMS 
emctl stop oms -all 

2. 使用sys用户登录到repository DB,然后执行utlrp.sql 

SQL> @<DB的ORACLE_HOME>/rdbms/admin/utlrp.sql 

3. 确认不存在INVALID的对象。 
select OBJECT_NAME,OBJECT_TYPE,OWNER from dba_objects where STATUS!='VALID' and OWNER in ('SYSMAN'); 

4. 启动OMS 
emctl start oms 

5.注册metadata 

<OMS的Middleware Home>\bin\emctl register oms metadata -service targetType -file "<OMS的Middleware Home>\sysman\metadata\targetType\oracle_emd.xml" -core 

EM_TARGET 剛升 13.4 沒問題,可能是在上 ru9 時才出錯,因此退版回 13.4 未上 ru9 的狀態,讓 sysman object 都是正常,重新打上 ru9 patch,但EMD_LOADER 仍是損壞,需要重新 complie EMD_LOADER

1. 停止OMS 
emctl stop oms -all 

2. 使用sysman用户登录repository DB,执行以下内容: 
sqlplus sysman/<password> 
@D:\32198287\32079584\files\oracle.sysman.top.oms\13.4.0.0.0\oracle.sysman.top.oms.symbol\sysman\admin\emdrep\sql\core\latest\basic\basic_loader_pkgbody.sql 

3. 切换至sys用户,执行以下内容: 
conn / as sysdba 
@<DB的ORACLE_HOME>\rdbms\admin\utlrp.sql 
select OBJECT_NAME,OBJECT_TYPE,OWNER from dba_objects where STATUS!='VALID' and OWNER in ('SYSMAN'); 

4. 如果如果上一条SQL语句返回记录为空,说明EMD_LOADER的状态也正常了,那么启动OMS 
emctl start oms 

5. 注册metadata。 

<OMS的Middleware Home>\bin\emctl register oms metadata -service targetType -file "<OMS的Middleware Home>\sysman\metadata\targetType\oracle_emd.xml" -core 

 

 

2. Middleware Targets Show Down Status

嘗試重啟 em、agent 都無效,重新加入 Middleware 監控也無效,開立 case 後,

最後嘗試 Doc ID 2352216.1,讓 agent 設定只使用 IPv4 才解決

Solution:

EM 13c: WebLogic Targets Show Down Status after Enterprise Manager Cloud Control Installation on MS Windows (Doc ID 2428439.1)

EM 13c: EMGC_ADMINSERVER, EMGC_OMS1, ohs1 Targets Show Down or Pending Status after Enterprise Manager 13c Cloud Control Installation (Doc ID 2352216.1)

# Get JavaDefine
<agent_inst>/bin/emctl getproperty agent -name agentJavaDefines
agentJavaDefines=-Xmx512M -XX:MaxPermSize=96M

# Set Agent IPv4 Only
<agent_inst>/bin/emctl setproperty agent -name agentJavaDefines -value "-Xmx512M -XX:MaxPermSize=96M -Djava.net.preferIPv4Stack=true"

# Restart Agent
<agent_inst>/bin/emctl stop agent
<agent_inst>/bin/emctl start agent