Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. What You See Is What You Get Element Monitoring Oracle Exadata Storage Servers by Brian Bream and Suzanne Zorn This article describes how to use Oracle Enterprise Manager Cloud Control and command-line utilities to monitor Oracle Exadata Storage Servers. Monitoring Metrics Using the Oracle Enterprise Manager Cloud Control Console Oracle Enterprise Manager Cloud Control provides an intuitive view of Oracle Exadata status, including the status of all hardware and software components.
Note: This command produces output only if there are alerts that have not been reviewed by another administrator. Note: The CREATE THRESHOLD command creates a threshold that specifies the conditions for the generation of a metric alert. Oracle Enterprise Manager Cloud Control 12c provides a visual overview of the availability of the storage cells, with color-coded green and red status symbols to indicate available and unavailable, respectively (see Figure 4).
This chapter provides an overview of Enterprise Manager Cloud Control 12c and helps you understand its architecture and the various core components that are integrated within the product. Oracle Enterprise Manager is Oracle's integrated enterprise information technology (IT) management product line, which provides the industry's only complete, integrated, and business-driven enterprise cloud management solution. Figure 1-1 illustrates how Enterprise Manager Cloud Control offers a solution that enables you to monitor and manage the complete Oracle IT infrastructure from a single console.
Figure 1-2 shows a sample Enterprise Manager Cloud Control architecture and illustrates how these core components fit into the architecture. In Figure 1-2, the load balancer and the multiple Oracle Management Services are depicted only to indicate how a sample Enterprise Manager Cloud Control architecture would look in a large organization.
Oracle Management Agent (Management Agent) is an integral software component that is deployed on each monitored host. Oracle Management Service is a Web-based application that orchestrates with the Management Agents and the Management Plug-ins to discover targets, monitor and manage those targets, and store the collected information in a repository for future reference and analysis.
The Oracle Management Repository (Management Repository) is a storage location where all of the information collected by the Management Agent is stored.
Technically, the Oracle Management Service uploads the monitoring data it receives from the Management Agents to the Management Repository. At the time of installation, the Enterprise Manager Cloud Control Installation Wizard configures the Management Repository in your existing, certified database.
The core Enterprise Manager Cloud Control features for managing and monitoring Oracle technologies, such as Oracle Database, Oracle Fusion Middleware, and Oracle Fusion Applications, are now provided through components known as plug-ins that can be downloaded and deployed using the new Self Update feature.
Table 1-1 lists the default plug-ins that are installed on Oracle Management Service and the Management Agent by default with a new Enterprise Manager system. Enables you to monitor and manage Oracle Database and related targets such as Oracle Real Application Clusters (Oracle RAC), Oracle Automatic Storage Management (Oracle ASM), and so on.
Enables you to log in to My Oracle Support from within the Cloud Control console, search the knowledge library for notes and documents, raise service requests, and create patch plans and templates for patching monitored targets. The Enterprise Manager Cloud Control console is the user interface that you see after you install Enterprise Manager Cloud Control. Oracle Enterprise Manager framework is enterprise-ready and is designed to manage and monitor critical business operations to ensure smooth running of enterprise data centers.
World class enterprise monitoring is about monitoring the status of your infrastructure and applications, notifying the appropriate IT staff when incidents occur, and reporting on status, history, and trends to interested parties throughout IT and the business. Oracle provides advanced, out-of-the-box application management solutions for Oracle E-Business Suite, Siebel, Peoplesoft, JD Edwards, and Fusion Applications. Enterprise Manager also offers advanced management capabilities for managing custom applications, integrations, and extensions. Oracle revolutionized the field of enterprise database management systems with the release of Oracle Database 10g by introducing the industry's first self-management capabilities built right into the database kernel. Oracle Enterprise Manager provides a comprehensive management solution for Oracle WebLogic Server, Oracle Fusion Middleware, non-Oracle middleware technology, and lifecycle management including configuration management, compliance management, provisioning, and patching. Oracle Enterprise Manager provides an integrated and cost-effective solution for complete physical and virtual server lifecycle management. Oracle Enterprise Manager, besides being the best suite of management products for Oracle technologies, also provides a comprehensive solution for the management of heterogeneous data centers (including Microsoft SQL Server and JBoss Application Server) through its rich collection of extensions known as plug-ins and connectors. Lifecycle Management is a comprehensive solution that helps database, system, and application administrators automate the processes required to manage the lifecycle of Oracle technology. Enterprise Manager 12c provides a complete Application Performance Management (APM) solution for custom applications and Oracle applications (including E-Business Suite, Siebel, PeopleSoft, JD Edwards, and Fusion Applications). User Experience Management–real user monitoring and synthetic transaction monitoring with Real User Experience Insight (RUEI) and Service Level Management (SLM) beacons, respectively.
There are two ways to monitor Web site user experience: using real traffic from real customers or using synthetic traffic (traffic artificially created by software to mimic the load that the Web site would be expected to receive).
Business Transaction Management–monitor and trace transactions and transaction instances. Java monitoring and diagnostics–Zero-overhead, production Java diagnostics for Oracle and non-Oracle platforms. Discovery and topology–multi-layer discovery of infrastructure and application topology.
Application Performance Analytics–rich reporting and analytic capabilities on real user activities and transaction monitoring data. Oracle's Application Quality Management products provide a complete testing solution for Oracle Database, Oracle Packaged Applications, and custom Web applications. Infrastructure Testing: Application Replay and Real Application Testing enable realistic, production-scale testing of the application and database infrastructure.
Test Data Management: Oracle Test Data Management and Data Masking provide efficient, automated, and secure test system creation capabilities for Oracle and non-Oracle databases, with out-of-the-box templates for Oracle packaged applications. Scripting on this page enhances content navigation, but does not change the content in any way.
Learn what's new in Oracle Enterprise Manager 11g, and how you will benefit by learning to use it. For home use and learning purposes, it’s very common to create a new Oracle database using the Database Configuration Assistant (DBCA). Without an agent, what you get with a single database is the Database Control version of Enterprise Manager. What is definitely new for OEM release 11g is the incorporation of Oracle WebLogic Server (WLS). With Oracle Corporation having acquired BEA, that license key migration process is dead and gone, so if you have an existing WLS installation, your upgrade path is going to include licensing of WLS from Oracle. Yet another key aspect of Oracle using WebLogic Server can be found in application management. What’s in it for you to learn how to install and use the Grid Control version of Enterprise Manager? Second, and probably the biggest reason to get on board with Grid Control, is the exposure you’re going to get with WebLogic Server. In the next article, I’ll cover the installation of Enterprise Manager and demonstrate how to use and configure agents for databases installed on a Windows 2003 server and on a server using Oracle Enterprise Linux (both of which will run as virtual machines on the same computer). Oracle Database 12c is designed for the cloud and introduces Multitenant Architecture with more than 500 new features. Oracle 12c now introduces multitenant architecture featuring pluggable databases, which makes it easy to consolidate your databases on to the cloud, deliver high density of schema based consolidation without making changes to application, increase utilization of resources, and rapidly provision and clone  database for various purposes by lowering down of Infrastructure & administrative costs. Fewer Patches and upgrades – With Oracle 12c, you don’t need to apply a patch, patch set, or product updates to multiple databases separately. Fewer Standby Databases – With Oracle 12c, you don’t need to ship and apply redo logs separately on each standby.  You can apply the redo logs at container level and every pluggable database in a container is fully protected from outages and uses can also use their standby pluggable databases for reporting purpose.
DBAs can still use data integration tools such as Data Pump and GoldenGate to migrate data to pluggable databases. Oracle multitenant is fully compatible with existing database options and features such as Oracle Real Application Cluster, Active Data Guard, Real Application Testing and Recovery Manager. Consolidating Database – Many pluggable databases into a single multitenant container database by sharing its memory and background processes and reduce patching and upgrade activities by increasing server virtualization with high density database consolidation per server. Rapid provisioning and cloning – You can plug and unplug the database and move database rapidly across the different containers. Automatic Data compression – This feature automatically age out older data and store it on different storage compression level tiers. Oracle Advanced compression will help to reduce storage requirements of large OLTP tables or partitions containing “Hot” frequently updated rows by 2-4x and Oracle Hybrid columnar compression provides up to 10x compression for “warm” read-only data and up to 50x compression for “cold” archival data. Continuous Business operation – Oracle 12c provides continuous access with Oracle’s Maximum Availability Architecture.  For Application Continuity from database failures, it makes better user experience by enabling transaction replay in a non-disruptive manner following a recoverable database failure. Comprehensive security & compliance – Oracle offers a multi-layered approach to protect enterprise data from hackers and other groups intent on stealing data. Comprehensive administrative controls such as Enforce password complexity, Monitoring accounts, Manage privilege entitlements, tracking and up to date of security patches.
Simplify Big Data Analysis – Oracle 12c provides comprehensive analytics and data integration in a single platform that meets Enterprise Business demanding needs. Resource allocation Controls – Define resource utilization at pluggable database level and pull system resources when required from low priority applications in a container by ensuring performance service leave remain consistent.
Oracle 12c provides to enhanced upgrade automation, the pre-upgrade and post-upgrade steps have been enhanced by providing fix-up scripts to reduce the manual work. Oracle 12c offers two upgrade options to customers, which is upgrading to new Multitenant architecture or current architecture.


Oracle Enterprise Manager provides business value by leveraging the built-in management capabilities for traditional and cloud environments.
Satishbabu Gunukula reviews articles for IOUG SELECT Journal and review books for PACKT Publishing.
First of all, thanks for your worth infomation and really, i am thirsty to know more and more about multinenat HA such as data guard and RAC in depth not as a concept.
A problem I have with the 'pluggable' database, is that is shares an SGA - that is library cache, and buffer cache. I have asked several people, including Oracle instructors the following question, but have not yet received a definitive, convincing answer. By using pluggable database you are lowering down of Infrastructure & administrative costs. The Method R Guide to Mastering Oracle Trace Data, Second Edition contains the richest description of Oracle extended SQL trace data that you’ll ever find, and over 100 pages of worked examples, using the software tools built by Cary’s Method R Corporation. For practicing and learning OEM 12c Cloud Control, this is the quickest way to get Cloud Control up and running. Each storage server is a separate target in Oracle Enterprise Manager Cloud Control, and the Oracle Exadata storage servers are grouped together for collective monitoring of all storage.
With Oracle Enterprise Manager Cloud Control, administrators can determine the status at a glance, and then drill down to the affected components for more information. Oracle Enterprise Manager creates business value from IT by leveraging the built-in management capabilities of the Oracle stack for traditional and cloud environments, enabling customers to achieve unprecedented efficiency gains while dramatically increasing service levels. They are not a prerequisite or a requirement for an Enterprise Manager system installation. It is responsible for monitoring all of the targets running on those hosts, communicating that information to the middle-tier Oracle Management Service, and managing and maintaining the hosts and its targets. Oracle Management Service also renders the user interface for Enterprise Manager Cloud Control. It consists of objects such as database jobs, packages, procedures, views, and tablespaces. The Management Repository then organizes the data so that it can be retrieved by the Oracle Management Service and displayed in the Enterprise Manager Cloud Control console. In addition to these default plug-ins, you can optionally install other plug-ins available in the software kit (DVD, downloaded software bundle, and so on).
With the help of the console, you can monitor and administer your entire computing environment from one location on the network. Oracle Enterprise Manager provides rich monitoring features as a foundation for monitoring all components of your IT infrastructure (Oracle and non-Oracle) as well as the applications and services that are running on them.
They provide end-to-end, integrated application monitoring and management capabilities, resulting in improved availability, predictability, and reliability. Capabilities such as Business Transaction Management (BTM), JVM Diagnostics (JVMD) and others are presented in further detail in Application Performance Management.
Today, after several releases and continuous improvement of this intelligent management infrastructure, Oracle Database provides the most extensive self-management capabilities in the industry, ranging from zero-overhead instrumentation to integrated self-healing and business-driven management. By delivering comprehensive provisioning, patching, monitoring, administration, and configuration management capabilities through a web-based user interface, Enterprise Manager significantly reduces the complexity and cost associated with managing Oracle VM, Linux, UNIX, and Windows operating system environments.
It is the industry's first complete solution including self-service provisioning balanced against centralized, policy-based resource management, integrated chargeback, and capacity planning, and complete visibility of the physical and virtual environment from applications to disk. It eliminates manual and time-consuming tasks related to discovery, initial provisioning, patching, configuration management, and ongoing change management. The APM solution is designed for both cloud and enterprise data center deployments and is supported on Oracle and non-Oracle platforms. They use real, production workloads to generate load against applications or databases under test and do not require any script development or maintenance. Along the way, one of the screens in Oracle Universal Installer presents you with an option to configure Enterprise Manager. The repository for what is collected data-wise in EM is the database you just created, and the schema or owner is SYSMAN. Put another way, any product related to Fusion is going to be managed via Oracle Enterprise Manager. There are several benefits, each with excellent payoff in terms of making you more valuable. Oracle Application Server and Oracle HTTP Server, let’s say, served their purpose back in the day, but now we have something better and more robust.
A database may use only a fraction of server hardware capacity and others might have overloaded. The new pluggable architecture only requires you to perform a backup at the multitenant container level. All these can be applied at the container level and not at each individual pluggable database level. This gives the flexibility of creating new patched or upgraded containers and selectively unplugging database from older container and plugging database into a new patched or upgraded container. The Heap map feature in Oracle 12c tracks usage information at row and segment level, applying policies to automatically move and compress database objects based on the age and activity of the data. It supports wide range of tools including OLAP aggregation, advanced indexing, partitioning elimination, automatic query transformation and parallelize database operations. Now can manage many databases as ONE by efficient use of resources and reduce IT costs for your Enterprise Business. He has extensive experience in Oracle, SQLServer, SAP Database Technologies, and specialized in high availability Solutions such as Oracle RAC, Data Guard, Grid Control, SQLServer Cluster and SAP HANA. He has experience on wide range of products such as Essbase, Hyperion, Agile, SAP Basis, SharePoint, MySQL, Linux, Windows, Business Apps administration and he has implemented many business critical systems for fortune 500, 1000 companies.
He has written articles for major publications and websites and spoken at oracle related events.
The Oracle Enterprise Manager Cloud Control console makes it easy to see the status at a glance, and provides an easy way to drill down to get more detailed information. If you do not have a load balancer, then the Management Agents communicate directly with the Oracle Management Services.
Oracle Management Services is deployed to the Oracle middleware home (middleware home), which is the parent directory that contains the Oracle WebLogic Server home, the Oracle Management Service home, the Management Agent home, the plug-in home, the Java Development Kit (JDK), the Oracle Management Service instance base directory, the Oracle Web tier directory, the Oracle common directory, and other relevant configuration files and directories. Because data is stored in the Management Repository, it can be shared between any number of administrators accessing the Enterprise Manager Cloud Control. For example, when a new version of Oracle Database is released, you can simply download and deploy the latest Oracle Database plug-in, which will include management support for the latest release. All the systems and services including enterprise application systems, databases, hosts, middleware application servers, listeners, and so on, are easily managed from one central location. With a next-generation user interface, it provides a rich, intuitive console that can be customized to suit different roles. These features enable IT to proactively monitor and resolve issues by business priority, implement operational best practices for monitoring, and provide consistent, high quality service in support of business goals. Oracle Enterprise Manager's management capabilities include user experience management, performance management, change and configuration management, patching, provisioning, testing, integrated diagnostics, and automatic tuning. In addition, enterprises using Oracle Sun hardware can obtain deep insight into their server, storage, and network infrastructure layers and manage thousands of systems in a scalable manner. These extensions are built upon the same management framework that is used for Oracle products, and therefore provides the same level of stability and richness as the Oracle products.
In addition, the solution provides compliance frameworks for reporting and managing industry and regulatory compliance standards.
SLM beacons are components within the monitored environment that send out synthetic traffic.
With Application Replay or Real Application Testing you can reduce your testing time by more than 80%. A disabled item on the DBCA window indicates that no management service agent was found, and that is a key piece in getting DBCA to recognize that Enterprise Manager is even a possibility. With an agent (along with other components external to the database), your new database can be managed by Enterprise Manager and the repository can live elsewhere.
The second step is to install an Oracle WebLogic Server for the management service, and the final step is to install a complete Enterprise Manager system including an agent and an OMS. There are other products where you still have a choice in terms of which J2EE compliant application server you can use. First, getting smart on Enterprise Manager Grid Control has payoff in terms of being able to manage multiple databases from one interface. In several industry reports (going back several years before the acquisition by Oracle), WLS was the leading application server. The DBA team must manage the Resources, Database files, Security, backups and accounts and so on of each database separately. That means you will have fewer backups to manage as each pluggable database backup with container. Consolidating the multiple pluggable databases into a multitenant contain can reduce the amount of patching and upgrade activities.
Customers who are on Oracle 10g R1 and earlier can use tools such as Data Pump and GoldenGate to migrate data to Oracle 12c. While deploying the Oracle Management Service, the Enterprise Manager Cloud Control Installation Wizard installs Oracle WebLogic Server if it does not already exist in your environment.


Oracle Enterprise Manager framework also has advanced capabilities such as self-update where key components such as target plug-ins, compliance policies, and deployment procedures can be updated automatically as newer versions become available.
Oracle Enterprise Manager helps customers to accelerate the adoption of virtualization and cloud computing to optimize IT resources, improve hardware utilization, streamline IT processes, and reduce costs. Finally, all of the on-premise instrumentation can be connected in real-time to My Oracle Support for complete communication between Oracle and customers. Typically, they test the performance and availability of business-critical services in the infrastructure as part of SLM. They provide the most efficient, optimized and highest quality testing for validating application and database infrastructure changes. However, before that can even take place, there is a good bit of setup outside of DBCA done beforehand. For what it’s worth, WLS used to operate via a license key, and your accessible features were driven or controlled by this file. APEX, as an example, offers several choices, but by and large, it appears all roads (with respect to web servers supporting Oracle products) lead to WLS. The idea or concept of installing an agent, which is used to monitor and report to a centralized management server, is used in quite a few other products outside the world of Oracle. In this new architecture, a multitenant container database can hold many pluggable databases. You’ll also get the flexibility to perform the recovery operation at the pluggable database level or container level. Administrators can select any Oracle Exadata target, view alerts on that target, and drill down to display more details about each alert.
The illustration below shows the architecture you’re likely to encounter in a basic setup. It manages many databases as one and retains the isolation, resource control of each database. The alert is triggered by two consecutive measurements (occurrences=2) over the threshold values. There is a slight to negligible hit on performance due to the presence of the agent, but that’s not any different than running Database Control. Values of one second over the threshold trigger a warning alert; values of two seconds over the threshold trigger a critical alert.
If you are comfortable with the overhead of AWR on a local database, you won’t mind the presence of an agent. Comparison: Monitoring Storage Server Availability Both the CLI and Oracle Enterprise Manager Cloud Control 12c can be used to monitor storage server availability.
Using Oracle Enterprise Manager Cloud Control 12c to compare metrics across multiple servers. The distributed CLI utility, dcli, can be used to execute commands across multiple servers on Oracle Exadata. However, it is much more complex to manually aggregate statistics reported in its command output and make comparisons across multiple storage servers.
Final Thoughts Oracle Enterprise Manger Cloud Control 12c provides easy-to-use, intuitive monitoring of Oracle Exadata Storage Servers. Components include database servers (also called compute nodes), Oracle Exadata Storage Servers (also called storage cells), Oracle's Sun Datacenter InfiniBand Switch 36 switches, and Exadata Smart Flash Cache. Status information is visually displayed, making it easy to pinpoint problems and then drill down for more detailed information. Monitoring Technologies Oracle Exadata uses several technologies to enable the monitoring of its components. In addition, Oracle Enterprise Manger Cloud Control provides capabilities for easily comparing metrics across multiple storage servers. These technologies include Oracle Integrated Lights Out Manager (Oracle ILOM), Simple Network Management Protocol (SNMP), and Intelligent Platform Management Interface (IPMI). The CLI (cellcli command and dcli utility) can be useful for scripts and creating processes that need to be repeated. This command can be used to display detailed information about the metrics that are available for a storage cell. Oracle ILOM is integrated service processor hardware and software that is preinstalled on Oracle servers, including the storage and database servers in Oracle Exadata.
Brian also functions as an Oracle University instructor delivering courses that focus on Oracle's engineered systems, Oracle Solaris, Oracle Linux, and Oracle's virtualization and storage solutions.
The service processor runs its own embedded operating system and has a dedicated Ethernet port to provide out-of-band server monitoring and management capabilities. It is of metricType Instantaneous, it is associated with objectType CELL, and it has a measurement unit of percentage. Collier IT is a full-service Platinum-level Oracle partner that provides Oracle solutions, including Oracle engineered systems, software, services, and Oracle University training. Oracle ILOM can be accessed via a browser-based web interface or a command-line interface, and it also provides an SNMP interface and IPMI support.
Collier IT provides its customers with complete, open, and integrated solutions, from business concept to complete implementation. Since 1991, Collier IT has specialized in creating and implementing robust infrastructure solutions for organizations of all sizes. Collier IT was a go-to partner for Sun Microsystems for ten years prior to the acquisition of Sun by Oracle in 2009. SNMP is an open, industry-standard protocol used to monitor and manage devices on an IP network.
As a former Sun Executive Partner and now as a Platinum-level Oracle partner, Collier IT is aligned to provide customers with complete solutions that address their business needs. Suzanne Zorn has over twenty years of experience as a writer and editor of technical documentation for the computer industry.
SNMP also enables active management of devices, such as modifying the device configuration remotely.
Previously, Suzanne worked as a consultant for Sun Microsystems' Professional Services division specializing in system configuration and planning. Suzanne has a BS in computer science and engineering from Bucknell University and an MS in computer science from Rensselaer Polytechnic Institute. IPMI is an open, industry-standard protocol used primarily for remote server configuration and management across a network.
In Oracle Exadata, the database and storage servers contain built-in IPMI support in Oracle ILOM. The cellcli command is used for management and monitoring of individual Oracle Exadata storage cells.
In addition, the dcli (distributed CLI) utility can be used to execute scripts and commands, such as those for shutting down compute nodes, across multiple storage cells from a single interface.
This system management platform provides integrated hardware and software management (see Figure 1).
Its hardware view includes a schematic of storage cells, compute nodes, and switches, as well as hardware component alerts. Its software view includes software alerts as well as information about performance, availability, and usage organized by databases, services, and clusters. Oracle Enterprise Manager Cloud Control 12c screenshot showing the status of various hardware components in Oracle Exadata Database Machine. However, Oracle Exadata can be configured to send SNMP alerts to other SNMP managers on the network. Monitoring Architecture of Oracle Enterprise Cloud Control Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (see Figure 2).
This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers.
The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services and is the primary storage software component. The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events. The Restart Server (RS) process is used to start up and shut down the CELLSRV and MS processes.
The primary components of Oracle Enterprise Manger Cloud Control 12c are the Oracle Management Service, the Oracle Management Repository, and the Cloud Control Console. The Oracle Management Service communicates with the agents on the managed targets and stores information in the Oracle Management Repository.



How to access my wd cloud from another computer
Personal cloud storage buffalo


Comments

  1. 29.07.2016 at 13:33:28


    Both in the cloud, in transit, and after.

    Author: Buraxma_meni_Gulum
  2. 29.07.2016 at 15:54:49


    Post pictures and other tried Amazon Cloud.

    Author: delfin
  3. 29.07.2016 at 18:22:12


    Your fellow students online focuses on if the online storage the time, and the tools to access.

    Author: TM_087
  4. 29.07.2016 at 19:57:19


    Costing $6 per user per month with 100GB of storage; for plan includes all feature of lower-priced.

    Author: Tukani
  5. 29.07.2016 at 15:12:41


    For unlimited storage, but it doesn't client and Cloud Spot, which helps.

    Author: Naxchigirlka