ANBOB™

前段时间有个客户想要安装OEM 12CC 并且监控不同平台的数据库,OMS安装在OEL 6.6 ，Product DB Agent 都是在AIX, HPUX, EXADATA(linux)平台, linux平台的比较方便安装，因为OMS 自带相同平台的AGENT,其它平台需要先在OMS下载相应的AGENT支持，这里有OMS是在OFFLINE模式，对于OEM12CC 安装和AGNET FOR LINUX 的WEB 推送安装之前有写过两篇笔记em12c install ,em 12c agent install， 这里我会演示如果离线的update OMS agent support for other platform 和offline安装EM AGENT.

1, 安装EM VERISION 12.1.0.4
2, 更新EM 对于对于AGNET 平台支持的列表(仅菜单)(ON OMS)
3，更新EM 对于指定AGENT 平台支持(ON OMS)
4，生成离线EM AGENT 安装IMAGE(ON OMS)
5, 传输EM AGENT到被监控端
6，安装部署EM AGENT（ON AGENT）
7, 从OEM WEB 页面增加AGENT 目标项

准备工作：

1， Port Requirements:

Web Browser(user client) --> OMS

•Admin Server HTTP SSL Port = 7101 – 7200
•Enterprise Manager Central Console HTTP Port = 7788 – 7798
•Enterprise Manager Central Console HTTP SSL Port = 7799 – 7809

AGENT –> OMS
•Enterprise Manager Upload HTTP Port = 4889 – 4898
•Enterprise Manager Upload HTTP SSL Port = 1159, 4899 – 4908

OMS –> AGENT
•Oracle Management Agent Port = 3872, 1830 – 1849
•DB Listener Port (eg. 1521 default)

2， HOSTNAME and IP mapping

需要在OMS和AGENT增加机器名和IP的映射,编辑/etc/hosts,
e.g. OSM(oem), AGNET(anbob1,anbob2)

# on EM OMS
133.96.43.1 anbob1
133.96.43.2 anbob2

# on EM Agent
10.120.159.34 oem

Note: 安装OEM 12 在这里省略。

[cloud@oem bin]$  ./emctl status oms detail
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Error Occurred: Unknown option: detail Please re-check syntax.
Please check /oem12c/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for error details
[cloud@oem bin]$ ./emctl status oms -all
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Error Occurred: Unknown option: -all Please re-check syntax.
Please check /oem12c/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for error details
[cloud@oem bin]$ ./emctl status oms -details
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password : 
Console Server Host        : oem
HTTP Console Port          : 7788
HTTPS Console Port         : 7802
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /oem12c/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /oem12c/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://oem:7802/em
Upload URL: https://oem:4903/empbs/upload

WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : oem
Admin Server HTTPS Port: 7102
Admin Server is RUNNING

Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: oem
WebTier is Up
Oracle Management Server is Up

BI Publisher is not configured to run on this host.

开始配置对于不同平台的Agent支持及安装：

1,更新EM 对于对于AGNET 平台支持的列表(仅菜单)
Note: $OMS_HOME was /oem12c/mid/oms this case

cd $OMS_HOME/bin

[cloud@oem bin]$ ./emcli login -username=sysman
Enter password : xxxxxxxxxxx     # 输入安装OEM时输入的密码
Login successful


[cloud@oem bin]$ ./emcli sync
Synchronized successfully

[cloud@oem bin]$ ./emcli  get_supported_platforms
-----------------------------------------------
Version = 12.1.0.4.0
 Platform = Linux x86-64
-----------------------------------------------
Platforms list displayed successfully.

取其它平台（AIX,HPUX…）的agent离线下载路径方法：打开OEM主面 https://10.120.159.34:7802/em 使用sysman 登录
点右上角的setup（设置）—>Extensibility（可扩展性）–>Self Update（自动更新） 打开页面， 点Check Updates（检查更新）按钮会弹出一个窗口， 窗口中有下载地址如下：

Use the following link to download the latest updates catalog
https://updates.oracle.com/Orion/Download/download_patch/p9348486_112000_Generic.zip

然后就可以找个能上网的机器去MOS 上下载该PATCH.再上传到OMS 服务器。

[root@oem cloud]# cd $OMS_HOME/bin

[root@oem bin]#  ./emcli import_update_catalog -file=/home/cloud/p9348486_112000_Generic.zip  -omslocal
Processing catalog for Middleware Profiles and Gold Images
Processing update: Middleware Profiles and Gold Images - Three Fusion Middleware Provisioning Profiles with different heap size configuration
Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX Itanium
Processing catalog for Management Connector
Processing update: Management Connector - 
             IBM TEC Connector - 12.1.0.3.0 
        
Processing update: Management Connector - 
             IBM TEC Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             Microsoft SCOM R2 Connector - 12.1.0.3.0 
        
Processing update: Management Connector - 
             Microsoft SCOM R2 Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             Microsoft SCOM preR2 Connector - 12.1.0.3.0 
        
Processing update: Management Connector - 
             Microsoft SCOM preR2 Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             Microsoft SCOM 2012 Connector - 12.1.0.1.0 
        
Processing update: Management Connector - BMC Remedy 7.6, 8.0, 8.1 Service Desk Connector - 12.1.0.3.0
Processing update: Management Connector - BMC Remedy 7.6.04 Service Desk Connector - 12.1.0.2.0
Processing update: Management Connector - BMC Remedy Change Management Connector - 12.1.0.1.0
Processing update: Management Connector - 
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.3.0
        
Processing update: Management Connector - 
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.2.0
        
Processing update: Management Connector - 
             HP Service Manager 9 Connector - 12.1.0.1.0 
        
Processing update: Management Connector - 
             HP Service Manager 7.1 Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             HP Service Manager 7.0 Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             HP Operations Manager UNIX Connector - 12.1.0.3.0 
        
Processing update: Management Connector - 
             HP Operations Manager UNIX Connector - 12.1.0.2.0 
        
Processing update: Management Connector - 
             CA Service Desk Connector - 12.1.0.3.0 
        
Processing update: Management Connector - 
             CA Service Desk Connector - 12.1.0.2.0 
        
Processing catalog for Extensibility Development Kit
Processing catalog for Plug-in
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Utilities Application provides management, metrics and monitoring capabilities for the Oracle Utilities products that use the Oracle Utilities Application Framework.
Processing update: Plug-in - Enterprise Manager for Oracle Utilities provides management and monitoring for the Oracle Utilities area.
Processing update: Plug-in - Application Management Pack for Oracle Utilities provides management and monitoring for the Oracle Utilities area
Processing update: Plug-in - Enterprise Manager for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area.
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Enables management capabilities for Oracle VM in Enterprise Manager.
Processing update: Plug-in - Enables cloud self service framework and portal in Oracle Enterprise Manager.
Processing update: Plug-in - 
        Enterprise Manager Storage Management Framework provides Snap Clone functionality by leveraging the snapshot and Copy-on-Write (CoW) features of the underlying storage.
  
Processing update: Plug-in - Enterprise Manager for Fusion Middleware consists of monitoring and management for Oracle Fusion Middleware and diagnostics in middleware area.
Processing update: Plug-in - Enterprise Manager for Oracle Database provides comprehensive management for Oracle Database and related targets such as Real Application Cluster, Automatic Storage Management (ASM) etc.
Processing update: Plug-in - Enterprise Manager for Cloud Framework provides the foundation services for Private Cloud management.
Processing update: Plug-in - Enterprise Manager for Zero Data Loss Recovery Appliance provides comprehensive management functionality for Zero Data Loss Recovery Appliance.
Processing update: Plug-in - Enterprise Manager for Sun Ray Software
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Management Plug-in for Oracle ZFS Storage Appliances
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Enterprise Manager for Oracle Secure Global Desktop
Processing update: Plug-in - Enterprise Manager for Oracle Secure Global Desktop Gateway
Processing update: Plug-in - Enterprise Manager for OUD
Processing update: Plug-in - Enterprise Manager for OUD
Processing update: Plug-in - Enterprise Manager for Oracle Key Manager
Processing update: Plug-in - Enterprise Manager for Oracle Flash Storage System
Processing update: Plug-in - Enterprise Manager for Oracle Instant Messaging Server is used for monitoring/managing the Oracle Instant Messaging Server
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Management Pack for Oracle Tuxedo 12.1.0.1.0
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Sybase ASE. Plugin provides comprehensive monitoring Sybase ASE Environments.
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Enterprise Manager for Microsoft SQL Server
Processing update: Plug-in - Enterprise Manager for DB2. Plugin provides comprehensive monitoring of DB2 environments.
Processing update: Plug-in - Enterprise Manager for Oracle Audit Vault and Database Firewall (AVDF) provides monitoring and management of AVDF system.
Processing update: Plug-in - Enterprise Manager for Oracle Database Appliance provides comprehensive monitoring and management for Oracle Database Appliance and related targets.
  
Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle Communications enables management of Oracle Communications products
Processing update: Plug-in - Enterprise Manager for Oracle Communications enables management of Oracle Communications products
Processing update: Plug-in - Enterprise Manager for Big Data Discovery consists of monitoring, diagnosing, and management for Oracle Big Data Discovery and its components.
Processing update: Plug-in - 
                Enterprise Manager for Pillar Axiom

Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in - Enterprise Manager for PeopleSoft
...

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.

[root@oem bin]# ./emcli sync
Synchronized successfully
[root@oem bin]# ./emcli  get_supported_platforms
-----------------------------------------------
Version = 12.1.0.4.0
 Platform = Linux x86-64
-----------------------------------------------
Platforms list displayed successfully.

[root@oem bin]# ./emcli logout
Logout successful

再返回OEM WEB 页面然重新打开右上角setup—>Extensibility–>Self Update 打开页面
可以看到 “Agent Software” aviliable updates 数量有增加， 然后点 ”Agent Software“文字链接(和上面有区别),后会列出所有支持的AGENT操作系统平台列表
这里我选择“Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)” ，然后点击“下载”又会弹出一个下载链接， 同样下载后上传到OMS服务器。
如下

To view the download steps, access the following URLs on a host that has Internet connectivity to My Oracle Support:

https://updates.oracle.com/Orion/Services/download/p18797144_112000_Generic.zip?aru=17700663&patch_file=p18797144_112000_Generic.zip

2, 更新EM 对于指定AGENT 平台支持(ON OMS)

[cloud@oem bin]$ ./emcli login -username=sysman
Enter password : 

Login successful

[cloud@oem bin]$  ./emcli sync
Synchronized successfully

# for aix
[cloud@oem bin]$  ./emcli import_update -omslocal -file=/home/cloud/p18797144_112000_Generic.zip
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.

Synchronized successfully

再刷新OEM中AGENT操作系统平台列表那个页面，点agent soft ,找到刚刚安装的那个平台，status应该是downloaded, 选中那一行，点apply ,status变成applied, 其他没安装的Agent 默认status是available

[cloud@oem bin]$ ./emcli  get_supported_platforms
-----------------------------------------------
Version = 12.1.0.4.0
 Platform = IBM AIX on POWER Systems (64-bit)    <<<<<<<
----------------------------------------------- 
Version = 12.1.0.4.0
 Platform = Linux x86-64
-----------------------------------------------
Version = 12.1.0.4.0
 Platform = HP-UX Itanium
-----------------------------------------------
Platforms list displayed successfully.

3, 生成离线EM AGENT 安装IMAGE(ON OMS)

mkdir -p /oem12c/agentimg/forhpux

$OMS_HOME/bin/emcli get_agentimage -destination=/oem12c/agentimg/forhpux -platform="HP-UX Itanium" -version=12.1.0.4.0

4, 然后压缩，binary MODE 传送到被监控端(agent)

把生成的/oem12c/agentimg/forhpux 目录tar 打包 ftp 到目标机。

5，安装部署EM AGENT（ON AGENT）

# note：EM oms 和Agent 不允许使用root安装，我是安装在oracle下，最后使用root运行一个shell.

su - root

mkdir -p /oracle/em_agent

-- copy agent_install file to /oracle/em_agent/
cp /zwd_arch1/foraix.tar  /oracle/em_agent/

echo 10.120.159.34 oem >> /etc/hosts
chown -R oracle:oinstall /oracle/em_agent
su - oracle

cd /oracle/em_agent/

tar xvf foraix.tar
cd foraix
unzip 12.1.0.4.0_AgentCore_212.zip

#AGENT_REGISTRATION_PASSWORD输入安装OEM时和SYSMAN的密码相同(当然也可以增加新的密码从OEM WEB)
./agentDeploy.sh AGENT_BASE_DIR=/oracle/em_agent OMS_HOST=oem EM_UPLOAD_PORT=4903 AGENT_REGISTRATION_PASSWORD=oracle12_c  -ignorePrereqs

# run  as root 
 /oracle/em_agent/core/12.1.0.4.0/root.sh

TIP: hpux 安装相对快在几分钟，AIX 要更慢一些。

6, 检查agent

export AGENT_HOME=/oracle/em_agent/core/12.1.0.4.0
$AGENT_HOME/bin/emctl status agent
$AGENT_HOME/bin/emctl pingOMS
$AGENT_HOME/bin/emctl upload agent
$AGENT_HOME/bin/emctl config agent listtargets

如果不显示最后的[]的内容检查OMS端的/etc/hosts是否配置了agent的IP 和机器名映射和在agent端执行下面的命令：

$AGENT_HOME/bin/emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
[anbob2, host]
[anbob2:3872, oracle_emd]

执行下面的命令再重试emctl config agent listtargets

$AGENT_HOME/bin/emctl  config agent addinternaltargets 

7, 解锁DBSNMP 数据库用户，页面增加目标db时使用

alter user dbsnmp account unlock;
alter user dbsnmp identified by oracle_123;

8, 打开个OEM web ，增加OMS新发现的主机目标

右上角 设置–>添加目标–>配置自动搜索

主机上的目标–>搜索到的目标–>点击个数 –> 选中目标 点升级 保存即可。

— I hope it’s useful

Know issue:

1， ./agentDeploy.sh AGENT_BASE_DIR=/oracle/em_agent OMS_HOST=oem EM_UPLOAD_PORT=4903 AGENT_REGISTRATION_PASSWORD=oracle_12

Performing check for CheckHostName
Is the host name valid?
Expected result: Should be a Valid Host Name.
Actual Result: xxxxx01
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The host name specified for the installation or retrieved from the system is incorrect.
Recommendation: Ensure that your host name meets the following conditions:
  (1) Does NOT contain localhost.localdomain.
  (2) Does NOT contain any IP address.
  (3) Ensure that the /ect/hosts file has the host details in the following format.
              

        If you do not have the permission to edit the /etc/hosts file,
        then while invoking the installer pass the host name using the argument ORACLE_HOSTNAME 

Solution:

./agentDeploy.sh AGENT_BASE_DIR=/oracle/em_agent OMS_HOST=oem EM_UPLOAD_PORT=4903 AGENT_REGISTRATION_PASSWORD=oracle_12  -ignorePrereqs

2, EM 中 意外事件管理器显示
Metric evaluation error start – Unable to connect to the agent at https://anbob1:3872/emd/main/ [Connection establishment timed out]
…
和这个案例一样

Solution:

检查OMS到AGENT 端的3872端口

3， agent status upload 时间不变

# $AGENT_HOME/bin/emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
 
Solution: 

#  $AGENT_HOME/bin/emctl  config agent addinternaltargets 
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.

# $AGENT_HOME/bin/emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
[anbob1, host]
[anbob1:3872, oracle_emd]

4, “Specified file is not a valid Self Update catalog file. Please check and try again with a valid file.”
不要使用EM web中提示的链接em_catalog.zip