Deploying Oracle9i RAC on eServer Cluster 1600 with GPFS. (Record no. 76606)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 08489nam a22004933i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC3306845 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240729124925.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2003 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780738499697 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9780738499697 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC3306845 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL3306845 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaPaEBR)ebr10113002 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)939263498 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D3 -- D4645 2003eb |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.75/75 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Redbooks, IBM. |
| 245 10 - TITLE STATEMENT | |
| Title | Deploying Oracle9i RAC on eServer Cluster 1600 with GPFS. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Durham : |
| Name of producer, publisher, distributor, manufacturer | I B M, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2003. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2003. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (266 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Why clusters? -- 1.1.1 Availability -- 1.1.2 Scalability -- 1.1.3 Load sharing -- 1.1.4 Parallel processing -- 1.2 Oracle9i RAC overview -- 1.3 Cluster building blocks -- 1.3.1 Hardware components -- 1.3.2 Software components -- Chapter 2. Typical Oracle9i RAC configurations -- 2.1 Basic building blocks -- 2.2 Oracle9i RAC on RAW devices -- 2.2.1 Hardware requirements -- 2.2.2 Software requirements -- 2.2.3 Application architecture -- 2.3 Oracle9i RAC on VSD -- 2.3.1 Hardware requirements -- 2.3.2 Software requirements -- 2.3.3 Application architecture -- 2.4 Oracle9i RAC on GPFS -- 2.4.1 Hardware requirements -- 2.4.2 Software requirements -- 2.4.3 Application architecture -- Chapter 3. Planning and implementation -- 3.1 Configuration objectives -- 3.2 Hardware architecture -- 3.3 Software architecture -- 3.3.1 Oracle9i RAC on an RPD-based GPFS cluster -- 3.4 Network architecture -- 3.4.1 Networking design -- 3.4.2 Client and administrative network -- 3.4.3 Oracle interconnect networks -- 3.4.4 GPFS network -- 3.4.5 Serial (non-IP) network -- 3.5 Storage subsystem architecture -- 3.6 Node installation and configuration -- 3.6.1 AIX 5.2 ML1 -- 3.6.2 APARs/PTFs -- 3.6.3 AIX 5L 32/64-bit kernel considerations -- 3.6.4 File system considerations -- 3.6.5 Memory requirements -- 3.6.6 Paging space (swap) requirements -- 3.6.7 Temporary space -- 3.6.8 Environment and user settings -- 3.7 Network configuration -- 3.7.1 Name resolution -- 3.7.2 Enabling remote command execution -- 3.7.3 Tuning network options -- 3.8 ESS Configuration -- 3.8.1 Configuring host adapter ports -- 3.8.2 Creating the hosts (on the storage side) -- 3.8.3 Creating the Logical Unit Numbers (LUNs). |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 3.9 Cluster nodes SAN configuration -- 3.9.1 FC adapter microcode -- 3.9.2 Configuring logical disks -- 3.9.3 Enable Fast I/O Failure for FC adapters -- 3.9.4 Dynamic tracking of Fibre Channel adapters -- 3.9.5 ESS Subsystem Device Driver setup -- 3.9.6 Configuring the virtual path devices -- 3.10 Configuring a clustering infrastructure -- 3.10.1 RSCT Peer Domain (RPD) cluster -- 3.10.2 GPFS cluster configuration -- 3.10.3 HACMP 4.5 installation -- 3.10.4 HACMP configuration -- 3.10.5 HACMP cluster and nodes definition -- 3.10.6 HACMP IP networks -- 3.10.7 HACMP serial networks -- 3.10.8 HACMP configuration considerations -- 3.10.9 HACMP start/stop and monitoring -- 3.10.10 HACMP in an Oracle9i RAC environment -- 3.11 Check list -- 3.12 Troubleshooting -- 3.12.1 ESS Specialist does not list the WWPN -- 3.12.2 HACMP does not synchronize -- 3.12.3 HACMP does not start -- 3.12.4 The HACMP clstat command does not work -- 3.12.5 Oracle9i RAC does not start -- 3.12.6 GPFS issues -- 3.12.7 Miscellaneous -- Chapter 4. Oracle9i RAC installation and configuration -- 4.1 Prerequisites and dependencies -- 4.1.1 OS prerequisites checking -- 4.2 Oracle9i RAC installation and configuration (on GPFS) -- 4.2.1 Running Universal Installer for Oracle9i -- 4.2.2 Oracle9i RAC Database Server Patch set 9.2.0.3.0 -- 4.2.3 Oracle Net Services initial configuration -- 4.3 Creating and validating the database -- 4.3.1 Database storage planning -- 4.3.2 DBCA configuration file creation -- 4.3.3 Database creation using the Database Configuration Assistant -- 4.3.4 Post database creation steps -- 4.3.5 Oracle Net Services configuration for RAC -- 4.3.6 Manual creation of an Oracle9i RAC database -- 4.4 Oracle9i general tuning considerations on AIX platforms -- 4.4.1 Memory and paging on JFS/JFS2 file systems -- 4.4.2 AIX Logical Volume Manager -- 4.4.3 Resilvering with Oracle9i. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 4.4.4 CPU scheduling and process priorities -- 4.4.5 Oracle9i Real Application Clusters and HACMP/ES -- 4.4.6 Oracle9i backup issues -- Chapter 5. Implementing RAC over GPFS -- 5.1 Benefits of Oracle9i RAC implementation with GPFS -- 5.2 Oracle9i RAC overview -- 5.2.1 Oracle9i RAC Cache Fusion -- 5.2.2 Cluster interconnect network considerations -- 5.2.3 Dynamic System Global Area (SGA) -- 5.2.4 Program Global Area (PGA) aggregate target -- 5.2.5 Undo management -- 5.2.6 Redo log threads -- 5.2.7 Oracle DB_BLOCK_SIZE -- 5.2.8 Tablespace -- 5.2.9 Control files -- 5.2.10 Initialization parameters -- 5.3 Environment planning -- 5.3.1 pSeries hardware planning -- 5.3.2 AIX planning -- 5.3.3 Highly available RAC planning -- 5.3.4 GPFS planning -- 5.3.5 Oracle planning -- 5.3.6 Memory planning -- 5.3.7 Storage planning -- 5.4 Physical database design -- 5.4.1 Oracle Striped and Mirrored Everything (SAME) strategy -- 5.4.2 GPFS architecture is based on a similar concept as Oracle SAME -- 5.5 RAC basic implementation steps -- 5.6 RAC client side failover and load balancing -- 5.7 References -- Chapter 6. High availability test scenarios -- 6.1 Test objectives and procedure -- 6.1.1 Client setup -- 6.1.2 Test query -- 6.1.3 Test script -- 6.2 Database availability tests -- 6.2.1 Listener fails on one node -- 6.2.2 Database instance fails on one node -- 6.2.3 Interconnect network interface fails on one node -- 6.2.4 Client network interface fails on one node -- 6.2.5 Complete node fails -- 6.3 Platform availability tests -- 6.3.1 GPFS subsystem failure on one node -- 6.3.2 GPFS network interface failure on one node -- 6.4 Summary of tests -- Appendix A. Operating system fileset levels -- AIX 5.2 ML1 base operating system filesets -- RSCT 2.3.1 filesets -- GPFS 2.1 filesets -- HACMP 4.5 filesets -- Enterprise Storage Server (ESS) filesets. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Fibre Channel drivers filesets -- Java filesets -- Troubleshooting -- Check logs -- AIX related problems -- Network Related -- HACMP check issues -- GPFS check issues -- Oracle check issues -- AIX Tuning considerations -- Appendix B. Troubleshooting -- Check logs -- AIX-related problems -- Network-related problems -- HACMP check issues -- GPFS check issues -- Oracle check issues -- AIX tuning considerations -- Appendix C. HACMP cluster configuration output -- Cluster description (cllscf command) -- Cluster networks (cllsif command) -- Some useful AIX commands -- EtherChannel setup procedures -- Appendix D. Oracle9i RAC configuration files and sample scripts -- D.1 Sample of initialization parameters file -- D.2 Sample database creation script -- Oracle tuning considerations -- Network options tuning for Transparent Application Failover -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Local government-Law and legislation-Belgium. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Municipal corporations-Belgium. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Local officials and employees-Legal status, laws, etc.-Belgium. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Belgium-Administrative and political divisions. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Redbooks, IBM |
| Title | Deploying Oracle9i RAC on eServer Cluster 1600 with GPFS |
| Place, publisher, and date of publication | Durham : I B M,c2003 |
| International Standard Book Number | 9780738499697 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306845">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306845</a> |
| Public note | Click to View |
No items available.