Oracle Rac

In: Computers and Technology

Submitted By ankurluvin
Words 4075
Pages 17
A white paper prepared with Oracle and IBM technical collaboration March 2010

Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability

Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability

Executive Overview ........................................................................... 2 Introduction ....................................................................................... 2 Problem validation ......................................................................... 3 Examining the AIX Error Logging................................................... 3 Examining the Oracle oprocd logging ............................................ 4 Recommendations for system stability............................................... 5 1. Implement AIX tuning recommendations for Oracle ................... 5 2. Modify Oracle ‘diagwait’ parameter............................................ 6 3. Install the required updates and patches ................................... 8 4. Reduce heavy paging activity. ................................................. 11 Appendix A: Oprocd logging examples ............................................ 14 Clean oprocd log files .................................................................. 14 Oprocd log files showing scheduling delays................................. 14 Oprocd log files after a node reboot or CRS restart ..................... 14 Appendix B: Example script for setting the correct VMM settings .... 16 References...................................................................................... 17

Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability

Executive Overview
IBM and Oracle have a long standing history of technical collaboration to enhance…...

Similar Documents

Oracle

...gv$session s, sys.gv$lock c, sys.gv$locked_object l, dba_objects o, sys.gv$lock k, gv$lock v WHERE o.object_id = l.object_id AND l.session_id = s.sid AND k.sid = s.sid AND s.saddr = c.saddr AND k.kaddr = c.kaddr AND k.kaddr = v.kaddr AND v.saddr = s.saddr AND k.lmode = l.locked_mode AND k.lmode = c.lmode AND k.request = c.request ORDER BY object; ***************** 11G TO 10G (XE) 1. expdp ETAG_CHTBW/etag@vw FULL=N VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.dmp LOGFILE=ETAG_CHTBW.log dump generated in : D:\app\Administrator\admin\vw\dpdump in 10g (XE for eg) put the dump generated above in this location (where 10g is installed) before running the below command: c:\oraclexe\app\oracle\admin\XE\dpdump 1.1 GRANT read, write on directory data_pump_dir to ETAG_CHTBW 2. impdp etag_chtbw/etag_chtbw FULL=Y DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.DMP LOGFILE=ETAG_CHTBW.DMP_imp.log ***** TABLESPACE (MINEXTENTS) ERROR RESOLUTION (IN CASE U GET IT): ALTER TABLESPACE ETAG_DAT01 ADD DATAFILE 'C:\oraclexe\oradata\XE\MY_TS2.DBF' SIZE 90M AUTOEXTEND ON NEXT 200K MAXSIZE 200M; **************************** REF CURSOR **************************** Passing REF CURSOR as parameters to sub-programs In the previous section, we already started working with sub-programs (or sub-routines). In this section, I shall extend the same with the concept of "parameters" (or arguments). Every sub-program......

Words: 1277 - Pages: 6

Oracle

...Morningstar ® Document Research ℠ FORM 10-K ORACLE CORP - ORCL Filed: June 28, 2011 (period: May 31, 2011) Annual report with a comprehensive overview of the company The information contained herein may not be copied, adapted or distributed and is not warranted to be accurate, complete or timely. The user assumes all risks for any damages or losses arising from any use of this information, except to the extent such damages or losses cannot be limited or excluded by applicable law. Past financial performance is no guarantee of future results. Table of Contents UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10-K x ANNUAL REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the fiscal year ended May 31, 2011 OR ¨ TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the transition period from to Commission file number: 000-51788 Oracle Corporation (Exact name of registrant as specified in its charter) Delaware (State or other jurisdiction of incorporation or organization) 54-2185193 (I.R.S. Employer Identification No.) 500 Oracle Parkway Redwood City, California (Address of principal executive offices) 94065 (Zip Code) (650) 506-7000 (Registrant’s telephone number, including area code) Securities registered pursuant to Section 12(b) of the Act: Title of each class Common Stock, par value $0.01 per share The NASDAQ......

Words: 95668 - Pages: 383

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also......

Words: 1424 - Pages: 6

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle......

Words: 3160 - Pages: 13

Oracle Dba

...Golden rules of RAC diagnostics By Riyaj Shamsudeen ©OraInternals Riyaj Shamsudeen Me n  n  n  n  n  n  n  n  n  20+ years using Oracle products/DBA OakTable member, Oracle ACE Director Certified DBA -7.0,7.3,8,8i,9i &10g Specializes in RAC, performance tuning, EBS, & Exadata Chief DBA with OraInternals Co-author a few books Email: rshamsud@orainternals.com Blog : orainternals.wordpress.com Web: www.orainternals.com ©OraInternals Riyaj Shamsudeen 2 Golden rules of RAC diagnostics 1. Beware of top event tunnel vision. 2. Eliminate infrastructure as an issue. 3. Identify problem instance(s). 4. Review Send side metrics, and not just Receive side metrics. 5. Use histograms to identify any abnormalities, and not just averages. ©OraInternals Riyaj Shamsudeen Top event tunnel vision n  In RAC, the root cause can be hidden in other node and might not show up in the Top-5 wait events. Impact of side effect events can be much, much worse then actual root cause event itself. Performance of the instances are intertwined. Performance of background processes in one node, can affect the application performance in the all other nodes. n  n  n  ©OraInternals Riyaj Shamsudeen Top event tunnel vision ..2 Example 1 ©OraInternals Riyaj Shamsudeen 5 Top event tunnel vision ..3 Example 2 ©OraInternals Riyaj Shamsudeen 6 Top event tunnel vision ..4 Example 3 ©OraInternals Riyaj......

Words: 964 - Pages: 4

Oracle Ebs

...to Oracle EBS 1.1 About EBS 1.2 EBS Application Products 2. The EBS architecture 2.1 Desktop Tier 2.2 Application Tier 2.3 Database Tier 3. Oracle EBS database features 3.1 Monitoring Features 3.2 Performance Features 3.3 Scalability Features 3.4 Business Intelligence Features 3.5 Security Features 4. Oracle EBS user list 5. Oracle EBS success stories 5.1 Home Box Office (HBO) 5.2 Mallcom limited 5.3 AT&T INC. 5.4 Facebook 5.5 HCL 1.1 ORACLE EBS Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management(CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms. Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java). Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM — "E-Business Suite Technical Reference Manuals". The applications found in the Oracle EBS include: * Oracle......

Words: 7162 - Pages: 29

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring......

Words: 652 - Pages: 3

Oracle and Microsoft

...Financial Statement Analysis: Oracle Corporation and Microsoft Corporation ACCT-504-10236: Acct Fin: Managerial Use,Anlys Professor: Leonard Hope Oracle Corporation is a US based company that headquarter in Redwood city, CA. It is a multinational computer technology company that develops and markets computer hardware systems. Oracle is second only to Microsoft as the largest software maker by revenue. The company was founded in 1977 under the name of Software Development Laboratories. It went through many name changes only to land the name Oracle Corporation in 1995. They offer many products and services such as software, hardware, middleware, Oracle Beehive, and many applications. Like Oracle Microsoft is a US based computer technology company. It is headquarter out of Redwood, WA. It was founded in 1975 in Albuquerque, NM by Bill Gates and Paul Allen. It is multinational company that serves as the largest software maker by revenue. In 1985 Microsoft partnered with IBM to write the operating systems. However, by the 90s Microsoft own operating system, Microsoft Windows, took 90% of the worlds personal computers. As of 2013 Microsoft has a global annual revenue of $77.85 billion dollars. They employ 110,000 people in 105 different companies. They develop, license, support, and manufacture a large range of software products. Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab and also include your commentary. The......

Words: 1088 - Pages: 5

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or......

Words: 106399 - Pages: 426

Oracle Rac Setup

...Build Your Own Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI (Continued) The information in this guide is not validated by Oracle, is not supported by Oracle, and should only be used at your own risk; it is for educational purposes only. 12. Create "oracle" User and Directories Perform the following tasks on both Oracle RAC nodes in the cluster! In this section we will create the oracle UNIX user account, recommended O/S groups, and all required directories. The following O/S groups will be created: Description | Oracle Privilege | Oracle Group Name | UNIX Group name | Oracle Inventory and Software Owner |   |   | oinstall | Database Administrator | SYSDBA | OSDBA | dba | Database Operator | SYSOPER | OSOPER | oper | We will be using the Oracle Cluster File System, Release 2 (OCFS2) to store the files required to be shared for the Oracle Clusterware software. When using OCFS2, the UID of the UNIX user " oracle" and GID of the UNIX group " oinstall" must be the same on both of the Oracle RAC nodes in the cluster. If either the UID or GID are different, the files on the OCFS2 file system will show up as "unowned" or may even be owned by a different user. For this article, I will use 501 for the " oracle" UID and 501 for the " oinstall" GID. Note that members of the UNIX group oinstall are considered the "owners" of the Oracle software. Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. Members...

Words: 13991 - Pages: 56

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number of...

Words: 580 - Pages: 3

Implementation Study: Dell It Scales Supply Chain Management with Oracle Rac 10g

...dell enterprise technology center series Implementation Study: Dell IT Scales Supply Chain Management with Oracle RAC 10g By Dave Jaffe, Ph.D. Todd Muirhead Tiong Tey Raveendra Avutu T When the expensive proprietary servers running the Dell supply chain management systems had reached their limits, the Dell IT group migrated to cost-effective, standards-based Dell ™ PowerEdge™ servers running Oracle® Real Application Clusters 10g. This architecture helped enhance database performance while providing scalability for future growth. tiple locations around the world. Using the same processes worldwide manufacturing operations, including the for disaster recovery, backup, and monitoring across all Dell operations enables Dell IT to take advantage of a cost- delivery of computers, accessories, parts, and supplies. These effective and readily supported deployment model. This systems must be designed for reliability and cost-effective scal- Database implemented this type of system for Dell operations at mul- systems handle key business functions that support efficient Dell inventory management model and fast, direct Related Categories: he Dell supply chain management (SCM) database article describes how Dell IT migrated its critical SCM appli- ability: a failure can cost thousands of dollars per minute in cations from proprietary UNIX-based servers to industry- factory downtime, and the SCM systems must be able......

Words: 2272 - Pages: 10

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download......

Words: 1320 - Pages: 6

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2

Hp Oracle

...penulis memberikan suatu pemberian solusi akan data warehouse dari Oracle. HP Oracle Database Machine memberikan performa ekstrim untuk data skala besar gudang pertanyaan mengenai pra-konfigurasi sistem, berdasarkan Oracle yang mana memimpin pasar database dan server standar industri, penyimpanan dan komponen jaringan dari HP. Dengan kecepatan, handal, aman sistem yang dapat dengan mudah memberi skala untuk memenuhi integrasi data yang kompleks, pelaporan, analisis dan penggalian data untuk aplikasi yang paling menuntut organisasi hari ini. Kertas memperkenalkan Anda kepada seorang baru keluarga produk Oracle, Oracle Exadata keluarga dan menjelaskan secara rinci bagaimana produk ini akan membahas isu-isu skalabilitas yang berkaitan dengan volume data yang pernah berkembang. Salah satu anggota keluarga Exadata, HP Oracle Database Machine, adalah bandwidth tinggi pra-konfigurasi hardware dan software solusi ekstrim memberikan skalabilitas untuk data pergudangan. Anggota lain dari keluarga, Oracle Exadata HP Storage Server digunakan dalam mesin database sebagai smart solusi penyimpanan dirancang untuk menangani penyimpanan database. Ketika digunakan untuk menambah sebuah sistem saat ini, server penyimpanan pintar ini mempercepat kinerja permintaan saat ini. Dengan memperkenalkan HP Oracle Database Machine dan Oracle Exadata HP Storage Server, Oracle telah membawa suatu industri gudang data terkemuka solusi dan Oracle komitmen kepada pelanggan, untuk masalah domain yang......

Words: 1793 - Pages: 8