Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
Oracle Exadata Database Machine consists of several components such as Compute nodes, Storage Cells, ILOM, Infiniband Switches, Cisco Switch and PDUs. So we need a tool that can manage all these components from one single console. Oracle Enterprise manager Cloud Control is the recommended best practices for monitoring and managing Exadata Database machine. Once the Exadata database Machine is installed the next step is enable monitoring for it.

The following Exadata components can be monitored and managed by OEM:

  • Compute Nodes
  • Storage Cells
  • Infiniband Switches
  • Cisco Switches
  • Power Distribution Units
  • KVM

The first step in monitoring and managing Exadata using OEM is to install the EM Agent. You can install EM Agent in several ways, such as:

  • Using EM Kit Method
  • Using the Agent push method
  • Using an RPM file
  • Using the AgentPull script
  • Using the AgentDeploy script


In this article we will demonstrate how to Install EM Agent 12c on Exadata using Agent Push method using OEM 12c. Agent Software is installed only on Compute nodes.

Environment Details

Here we will be installing EM Agent on a Exadata X5-2 Elastic Rack consists of:

  • 8 Compute Nodes
  • 7 Storage Cells
  • 2 Infiniband Switches
  • 1 Cisco Switches
  • 2 Power Distribution Units


  • Enter the OEM 12c URL into the web browser and hit enter
  • Enter the SYSMAN Credentials or any other user that have necessary permissions to Install Agent software

  • From the Home page, click on Setup à Add Target à Add Targets manually

  • Select Add Host Targets and Click on Add Host

  • On this page, click on the +Add button to add the Host targets. 

  • Enter all fully qualified Hostnames (8 compute nodes) and for Platform “Same for All Hosts” and click next

  • On this page, do the following:
Enter the Installation Base Directory.
The instance base directory will be populated automatically for you.
Click on the + symbol on the Named credentials and enter oracle user and its password.
Click Next

  • Review this information and click Deploy Agent

  • Initialization in progress


  • Initialization completed. Remote prerequisites Checks in progress

  • Remote prerequisites Checks in progress. Review the warnings. We can ignore this error as the Oracle user doesn’t have permissions to execute the root.sh script at the end of the Agent Deployment.

  • Click Continue and Continue, All Hosts

  • Now the Agent deployment in progress


  • Agent Deployment completed successfully. We need to run the root.sh script as root user on all the compute nodes to finish Agent Installation process.

  • Login in to compute node as root user and execute the root.sh script on all nodes using dcli command

  • Verify the OEM Agent status

This concludes the OEM 12c Agent Installation on Exadata Compute nodes.

Conclusion

In this article we have learned how to install OEM Agent 12c on Exadata Database Machine using push Method.

1


Introduction:


Oracle Database Console that existed in Oracle Database 10g and 11g is now dead in Oracle Database 12c. Oracle Database 12cR1 gave birth to a completely new GUI interface known as Oracle Enterprise Manager Database Express or simply EM Express. EM Express replaces the Database Console that existed in Oracle 10g and 11g.


Enterprise Manager Database Express is a lightweight browser-based tool for managing Oracle Database 12c is well suitable for common DBA tasks such as Tablespace Management, User Management and comprehensive performance diagnostics and tuning. You can’t perform a lot of DBA activities using EM Express as you were able do it using Database Console.


EM Express is built inside the Oracle Database and uses internal infrastructure components, such as XDB and SQL*Net. The database must be open in order to use EM Express as EM Express is built inside the database. 


If you selected the option “Configure Enterprise Manager (EM) database express”, the EM Express will be configured as part of the database creation process. Once the database is created, DBCA displays a success message with the EM Express URL. The default EM Export https port number is 5500.


Database Express is used to manage a single database and it is automatically installed when you create a database using DBCA.


The URL to connect to EM Express has the following format “https://<hostname>:5500/em” for Example, “https://dm01db01.netsoftmate.com:5500/em”



Important Note: 
  • EM Express cannot create a CDB 
  • EM Express can be configured at both root and PDB level, with each container using a different HTTP/HTTPS port
  • EM Express can view any PDB as if it were a standalone database (non-CDB)
  • EM Express cannot stop and start the database and listener
  • EM Express is RAC aware 
  • You can grant users read-only access so that they can view the UI but not make any changes
SQL> grant EM_EXPRESS_BASIC to <user>;
  • EM is supported on Enterprise Edition, Standard Edition and Express Edition
  • Diagnostic Pack and Tuning Pack features are not available in Standard Edition and Express Edition
  • Basic EM Express features are available free of cost
  • You need Diagnostic Pack and Tuning Pack license to use performance diagnostics and tuning features


In this article I will demonstrate how to connect to EM Express and use different EM Express features.


  • Connecting to EM Express

Enter the EM Express URL into the web browser and confirm the security warning. Here I am using Chrome for accessing EM Express.



https://dm01db01.netsoftmate.com:5500/em



Enter the credentials to login to the EM Express console.




This is the EM Express home page. We can see there are 4 different tabs that can be used for different purposes.


  • EM Express Tab

Let’s look at the each Tab and the options available in each table.



Configuration Tab list the different parameters, database properties,  feature usage and Memory configuration




Storage Tab can be used for Tablespace Management, Undo, Redo Log & Archive Log Management and Control File Management


Under Security Tab you manage Users, Roles & Profiles


Performance Tab is the important tab that is used to Manage the Database Performance


To check base feature usage, navigate to Configuration Tab and click on Database Feature Usage. The below page shows all the database feature usage.


This is the Memory Management page



  • How to create a new tablespace using EM Express
Navigate to Configuration tab and click Tablespaces. Select Create Tablespace and follow the instructions below to create a new tablespace



Enter Name, select tablespace type, bigfile and status. Click Next



Check if you want to use OMF, Enter number of Datafiles, Size, Auto Extend, Increment and Max Size. Click Next


Select Block Size and Extent Allocation. Click Next


Choose the logging option. Click Next


Select space management and Compress type.


Click on on Show SQL if you want to capture the SQL statement so you can use it to create tablespaces manually. Click Ok to create tablespace


The confirmation screen show that he tablespace is create successfully


Verify the tablespace creation


Check all tablespace in the database


Performance Hub Page


Click on the activity tab to check the current database acitivty


Click on ADDM tab to check the ADDM recommendation


Click on SQL Tuning Advisor under Performance tab


Enable Automatic SQL Tuning Advisor


Request being processed


Click ok to complete


User page displaying all the database users. You can also create a new user using the Create User button on the page.




Conclusion


In this article we have learned about Oracle Enterprise Manager Database Express 12c or simply EM Express. EM Express replaced the Database console that was existed in Oracle database 10g and 11g. It is a lightweight browser-based tool for managing Oracle Database 12c is well suitable for common DBA tasks.



0


Overview:

Oracle Enterprise Manager is Oracle’s integrated enterprise information technology management product line, which provides the industry’s only complete, integrated, and business-driven enterprise cloud management solution. Oracle Enterprise Manager Cloud Control 13c is Oracle’s single, integrated solution for managing all aspects of the Oracle Cloud and the applications running on it.



Media:

Download the software from following link.




Required Packages for Oracle Cloud Control Installation (Linux 6)

make
binutils
gcc
libaio
glibc-common
libstdc++
libXtst
sysstat
glibc
glibc-devel
glibc-devel.i686

Assumptions:

Here we are assuming that:

Oracle RDMS software Installed and
Oracle Database has been created for Repository.
 


Steps to Install OEM Cloud Control 13c.

      1. Download media and unzip
     2. Execute runInstaller.
     3. Uncheck the box to prevent from receive security updates from Oracle Support and click next.
    4. Click yes on warning pop-up window.
    5. Provide Inventory Location.   

6. Prerequisites window will appear where all pre-check must succeeded.  

   7. In Installation types, Choose Advanced method.   



8. Provide Middleware Home Location, Agent Base Directory and Hostname.
9.Provide weblogic details then click next.
10. Provide Database Connection Details.
11.Provide Sysman credentials and click next.
     12.  Check on Select configure Oracle Software Library, Uncheck configure shared location and tick on Enable Oracle BI Publisher.
    13. Provide port details and click next.
    14. Review the information, which we have provided then click on Install.
    15. Execute configuration script as Root user.
  


[MN-Dboem]root@*****:/opt/oem/MW_13c# sh allroot.sh



Starting to execute allroot.sh ………

Starting to execute /opt/oem/MW_13c/root.sh ……

/etc exist

/opt/oem/MW_13c

Finished product-specific root actions.

/etc exist

Finished execution of  /opt/oem/MW_13c/root.sh ……

Starting to execute /opt/oem/Agent_13c/agent_13.1.0.0.0/root.sh ……

Finished product-specific root actions.

/etc exist

Finished execution of  /opt/oem/Agent_13c/agent_13.1.0.0.0/root.sh ……

[MN-Dboem]root@*****:/opt/oem/MW_13c#
  

16. Review the Details then click on Close

 
Conclusion:


In the preceding Blog we have learned Oracle Enterprise Manager Cloud Control 13c Installation. We have select advanced method Installation which is meant for small, medium and large deployments and also allows you customize the ports according to your environment.


By
Name : Mirza Hidayathullah Baig
Designation : Senior Database Engineer
Organization: NetSoftMate IT Solutions














1