Home / 12c / Discover Exadata Database Machine Prerequisite in Oracle Enterprise Manager 12c

Discover Exadata Database Machine Prerequisite in Oracle Enterprise Manager 12c

Discover Oracle Exadata Machine:

Oracle Exadata targets that can be monitored and managed by OEM 12c:

  • Oracle Exadata Storage Servers
  • Database Server or Compute nodes
  • Infiniband Switches
  • Cisco Switches
  • Power Distribution Units (PDU)
  • KVM (Keyboard, Video & Mouse)

In this article, I will describe how to discover an Exadata Database Machine OEM 12c.

Prerequisite of Discover Oracle Exadata Machine

To install Oracle Exadata agent on the target system, we have to fulfill the prerequisite.

Create a Database Server ILOM Service Processors User:

For the Enterprise Manager agent to communicate with an ILOM service processor, there must be a specific user ID established on the ILOM service processor. Adding the specific user ID requires administrator level privilege on the ILOM service processor.

Here this user will create with ILOM CLI.

  1. Log in to the Service Processor as root:
  2. Change to the user directory.
  3. Create the oemuser user and password:
  4. Change to the new user’s directory and set the role:
  5. Repeat steps 1 through 5 for the rest of the compute node and cell node( Storage server) ILOM service processors in your Oracle Database Machine.

Run Prerequisite Script:

Discover oracle Exadata machine, Before install Oracle Exadata management agent, we have to run a prerequisite script which can be download from http://support.oracle.com and Doc ID is ‘1473912.1’

Now we discuss in details what will be checked using this script. If prerequisite check failed due to any information then that information we will fix manually.

  1. Verify Component Version.
Oracle Exadata Component Version
Component Command Supported Version
Oracle Exadata Storage Software Log into any of the storage servers as root, cellladmin or cellmonitor and execute command Cellcli –e ‘list cell detail’ 11.2.2.3 onwords
ILOM ipmitool For Oracle Linux, run the following command as the root user on one of the database servers in the cluster:

dcli -g ~/dbs_group -l root ipmitool –V

or just ipmitool –V

 Note: The dbs_group file contains the list of compute node hostnames, one on each line. If the file does not exist, you can create it before running the dcli command.

1.8.10.3
Infiniband Switch Log on to the management interface for the InfiniBand Switch as nm2user (using ssh) and execute nm2version # nm2version

Output ‘Sun DCS 36p

 2.Verify the permissions agent

A) agent user(i.e oemuser) should have read and execute permission on

$ORACLE_HOME/bin/kfod binaries

B) agent user(i.e oemuser) should have read permission on

/opt/oracle.SupportTools/onecommand/catalog.xml

OR

/opt/oracle.SupportTools/onecommand/databasemachine.xml

3. Verify the version of the catalog.xml

This prerequisite script checks the version of catalog.xml. To discover targets Oracle Enterprise Manger use catalog.xml or databasemachine.xml file. If catalog.xml file version is under 868 please do not proceed to discover using this file also contact with Oracle support.Verify the version of the databasemchine.xml

4. Verify the version of the databasemchine.xml

The databasemachine.xml is the file created by the onecommand process during provisioning of Oracle Exadata. Oracle Enterprise Manager 12c uses the configuration information in this file during the discovery process and also uses the information to render the schematic diagram in the Exadata home page

Log in primary database machine as root or oracle user then execute command:

Check version databasemachine.xml

DO NOT proceed if the version is less than 502. Please raise a service request with the version mismatch and get the appropriate databasemachine.xml from Oracle Support.Verify ADMINNAME and ADMINIP in databasemachine.xml or catalog.xml

5. Verify ADMINNAME and ADMINIP in databasemachine.xml or catalog.xml

If Oracle Exadata was re-IP’ed(i.e IP address change) due to a network change and the corresponding management IP addresses were not updated in the databasemachine.xml then discovery will fail. The prerequisite script has this check built-in. If you want to manually verify the ADMINNAME and ADMINIP you can do a nslookup of a host and then verify the IP address in the catalog.xml or databasemachine.xml. Repeat this check for all components.

Discover Exadata Database Machine

If you find such IP address mismatch problems, please log an SR with Oracle Support.

6. Make sure root.sh has been executed.

If you see “s” bit have been added in <agent installation dir>/sbin following files and root user own, it proved that root.sh was been executed.

Discover Exadata Database Machine root user check

7. Check for correct cipher.

Agent push fails with an error “Failed to launch process: Algorithm negotiation fail” This script checks the cipher entries and suggests if any changes are required. You can follow instruction is Support Note 1437596.1 to correct any missing entries.

8. Check for setup file consistency.

This check ensures that em.param and schematic files (catalog.xml / databasemachine.xml) must be consistent and contain the same cell, infiniband, kvm and pdu nodes information.

9. Check ping status for each component IP address found in schematic file: 

  1. All components present in the schematic file must be alive.
  2. When using databasemachine.xml schematic file we need to check ADMINIP responds.
  3. When using catalog.xml schematic file we need to check IP under ADMIN tree responds. If the node is a compute node we should also check that IP under CLIENT tree responds.

Create User and agent installation directory:

To install OEM management agent in the target system, we have to create an installation directory and user.

  1. Create a user
  1. Change password for oemagent user
  1. See uid and gid of oemagent user
  1. Create a directory
  1. Change permission to newly created directory
Note:  Step 1 to 5 complete in all compute  nodes and remember oemuser user UID and GID must be same in all nodes.

Verify Firewall Configuration:

1. Allow Ping

In many secure network environments, it is normal for the ping service to be disabled. Enterprise Manager uses ping to establish the basic availability and status of the Exadata Database Machine components.

  • The compute nodes need to have the ping service and port enabled from the OMS Server(s).
  • All other Exadata Database Machine components (ILOM servers, PDU’s, storage cell nodes, InfiniBand switches, and Cisco switch) need to have the ping service and port enabled from the compute nodes (where the agents are running)

2. Open Database Ports:

The database listener ports must be opened for the Enterprise Manager OMS server(s). Note that Exadata Database Machine databases will use SCAN listeners; so, ports will need to be opened for the base compute node, the compute node virtual IP, and scan listeners addresses.

3. Open Enterprise Manager Upload Port

The Enterprise Manager Cloud Control 12c agents require access to the Enterprise Manager Servers upload service, normally configured on port 4889 for HTTP uploads and 4900 for HTTPS. To verify the ports assigned, run the following command on the OMS server command line.

These ports will need to be opened for each of the compute nodes.Open Agent Ports

4. Open Agent Ports

The OMS server(s) will need to be able to connect to the Enterprise Manager Cloud Control 12c Agent HTTP/HTTPS port on each compute node. The Agent port defaults to 3872. If port 3872 is not available, the next available port starting from port 1830 is used.

To identify the port used:

Run the following command on the compute node command line:

Alternatively, you can look for the value of the EMD_URL property in the emd.properties file the following directory:

5. Open SSH Ports

The Enterprise Manager Cloud Control 12c Agents require ssh access to the Exadata Database Machine components they monitor. As the Agents will run on the compute nodes the ssh ports, 22, on each of the storage cells, ILOMs, PDUs, KVMs, InfiniBand switches, and Cisco switch will need to be opened for each of the compute nodes.

To enable ssh connectivity between agent host and cell host, follow document

https://docs.oracle.com/cd/E50790_01/doc/doc.121/e27442/ch8_troubleshooting.htm#EMXIG190

when the password is want please ignore this.

6. Allow UDP Traffic (SNMP Ports)

All Exadata Database Machine components need to be able to send SNMP traps to the Agents running on the compute nodes. SNMP uses the UDP protocol so the Agent port and port 162 need to be opened for UDP traffic between the Storage Cells, ILOMs, InfiniBand Switches, Cisco Switch, and the Agent.

Enable SSH Connectivity:

  1. Log in to the computer where the Enterprise Manager Agent is running, open a terminal, and run the following commands as the Agent user to generate a pair of the SSH private/public keys if they are not present:
    • For Release 12.1.0.1.0:
      Where <ORACLE_HOME> is the installation directory of the Enterprise Manager Agent.
    • For Release 12.1.0.2.0:
      Where $HOME is the home directory of the Agent user , skip passphrase.
  2. Copy the public key (id_dsa.pub) to the /tmp directory on the storage cell:
  3. Add the contents of the id_dsa.pub file to the authorized_keys file in the .ssh directory within the home directory of the cellmonitor user:

    Note:

    If the authorized_keys file does not exist, then create one by copying the id_dsa.pub file to the .ssh directory within the home directory of the user cellmonitor:

  4. Make sure that the .ssh directory and authorized_keys have the right file permission:

Check Also

Oracle Database 12c Release 2 Installation On Fedora 25

This article describes Step by Step Oracle Database 12c Release 2 Installation On Fedora 25 (F25)

Installation Oracle Database 12C Release 2 (12.2) on Oracle Linux 6 (OEL6) and 7(OEL7)

This article describes the installation of Oracle Database 12c Release 2 (12.2) 64-bit on Oracle Linux 6 (OL6) and 7 (OL7) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here

Leave a Reply

৩৮তম বিসিএস এর জন্য ৫০টি মডেল টেস্ট।
* ৩০ টি বিষয় ও অধ্যায় ভিত্তিক মডেল টেস্ট
* ২০ টি পুর্নাঙ্গ মডেল টেস্ট
* বিষয় ভিত্তিক রিপর্ট
* সময় ভিত্তিক রিপর্ট
* ভুল প্রশ্ন গুলো একসাথে ব্যাখাসহ
* বেশির ভাগ প্রশ্ন ব্যাখাসহ
* প্রথম ১০ জন মেধা তালিকা প্রকাশ
* প্রথম ১০ জন মেধা তালিকার সাথে আপনার রেজাল্ট তুলনা করতে পারবেন
*ইমেইল এর মাধ্যমে সবধরণের নোটিফিকেশান
GET UPDATE INSTANTLY
Increase your knowledge!
Your Information will never be shared with any third party.
৩৮তম বিসিএস জন্য ৫০টি মডেল টেস্ট
* ৩০ টি বিষয় ও অধ্যায় ভিত্তিক মডেল টেস্ট
* ২০ টি পুর্নাঙ্গ মডেল টেস্ট
* বিষয় ভিত্তিক রিপর্ট
* সময় ভিত্তিক রিপর্ট
* ভুল প্রশ্ন গুলো একসাথে ব্যাখাসহ
* বেশির ভাগ প্রশ্ন ব্যাখাসহ
* প্রথম ১০ জন মেধা তালিকা প্রকাশ
* প্রথম ১০ জন মেধা তালিকার সাথে আপনার রেজাল্ট তুলনা করতে পারবেন
*ইমেইল এর মাধ্যমে সবধরণের নোটিফিকেশান