没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Real Application Clusters Administration and Deployment G
需积分: 5 0 下载量 69 浏览量
2023-06-18
15:39:58
上传
评论
收藏 2.59MB PDF 举报
温馨提示
试读
374页
Oracle Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)-374
资源推荐
资源详情
资源评论
[1]
Oracle® Real Application Clusters
Administration and Deployment Guide
11g Release 2 (11.2)
E41960-04
June 2015
Oracle Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)
E41960-04
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.
Primary Author: Richard Strohm
Contributing Authors: Troy Anthony, Lance Ashdown, Ram Avudaiappan, Prasad Bagal, Mark Bauer,
Anand Beldalker, Eric Belden, Gajanan Bhat, David Brower, George Claborn, Carol Colrain, Jonathan
Creighton, Rajesh Dasari, Steve Fogel, Richard Frank, GP Prabhaker Gongloor, Wei Hu, Yong Hu,
Dominique Jeunot, Sameer Joshi, Raj K. Kammend, Sana Karam, Roland Knapp, Ken Lee, Karen Li, Barb
Lundhild, Venkat Maddali, Bill Manry, Gaurav Manglik, John McHugh, Saar Maoz, Matthew Mckerley,
Markus Michalewicz, Anil Nair, Philip Newlan, Michael Nowak, Muthu Olagappan, Bharat Paliwal, Hanlin
Qian, Mark Ramacher, Kevin Reardon, Dipak Saggi, Sudheendra Sampath, Viv Schupmann, Daniel Semler,
Ara Shakian, Cathy Shea, Khethavath P. Singh, Kesavan Srinivasan, Janet Stern, Leo Tominna, Peter Wahl,
Tak Wang, Richard Wessman, Douglas Williams, Mike Zampiceni, Michael Zoll
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content,
products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and
expressly disclaim all warranties of any kind with respect to third-party content, products, and services
unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its
affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of
third-party content, products, or services, except as set forth in an applicable agreement between you and
Oracle.
iii
Contents
Preface ............................................................................................................................................................... xix
Audience..................................................................................................................................................... xix
Documentation Accessibility................................................................................................................... xix
Related Documents ................................................................................................................................... xx
Conventions ............................................................................................................................................... xx
What's New in Oracle RAC Administration and Deployment? ..................................... xxiii
Oracle Database 11g Release 2 (11.2.0.4) New Features in Oracle RAC.......................................... xxiii
Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle RAC.......................................... xxiii
Oracle Database 11g Release 2 (11.2.0.1) New Features in Oracle RAC.......................................... xxv
1 Introduction to Oracle RAC
Overview of Oracle RAC ........................................................................................................................ 1-1
Overview of Oracle Clusterware for Oracle RAC.............................................................................. 1-3
Overview of Oracle RAC Architecture and Processing .................................................................... 1-4
Understanding Cluster-Aware Storage Solutions......................................................................... 1-4
Overview of Connecting to Oracle Database Using Services and VIP Addresses ................... 1-4
About Oracle RAC Software Components..................................................................................... 1-5
About Oracle RAC Background Processes..................................................................................... 1-6
Overview of Automatic Workload Management ............................................................................... 1-7
Overview of Installing Oracle RAC ..................................................................................................... 1-9
Understanding Compatibility in Oracle RAC Environments ..................................................... 1-9
Overview of Oracle RAC Installation and Database Creation ................................................. 1-10
Overview of Extending the Oracle Grid Infrastructure and Oracle RAC Software.............. 1-11
Overview of Managing Oracle RAC Environments....................................................................... 1-12
About Designing and Deploying Oracle RAC Environments.................................................. 1-12
About Administrative Tools for Oracle RAC Environments ................................................... 1-13
About Monitoring Oracle RAC Environments........................................................................... 1-14
About Evaluating Performance in Oracle RAC Environments................................................ 1-15
2 Administering Storage
Overview of Storage in Oracle RAC..................................................................................................... 2-1
Optimal Flexible Architecture ............................................................................................................... 2-2
Data File Access in Oracle RAC ............................................................................................................ 2-2
Redo Log File Storage in Oracle RAC .................................................................................................. 2-3
iv
Automatic Undo Management in Oracle RAC................................................................................... 2-3
Oracle Automatic Storage Management with Oracle RAC.............................................................. 2-4
Storage Management in Oracle RAC .............................................................................................. 2-5
Modifying Disk Group Configurations for Oracle ASM.............................................................. 2-5
Oracle ASM Disk Group Management........................................................................................... 2-5
Configuring Preferred Mirror Read Disks in Extended Distance Clusters ............................... 2-6
Converting Nonclustered Oracle ASM to Clustered Oracle ASM.............................................. 2-6
Administering Oracle ASM Instances with SRVCTL in Oracle RAC......................................... 2-7
3 Administering Database Instances and Cluster Databases
Tools for Administering Oracle RAC................................................................................................... 3-1
Overview of Oracle RAC Database Administration..................................................................... 3-2
Administering Oracle RAC with Oracle Enterprise Manager..................................................... 3-3
Administering Oracle RAC with SQL*Plus ................................................................................... 3-4
Changing the SQL*Plus Prompt ............................................................................................... 3-4
How SQL*Plus Commands Affect Instances.......................................................................... 3-5
Administering Oracle RAC with SRVCTL ..................................................................................... 3-6
Starting and Stopping Instances and Oracle RAC Databases......................................................... 3-6
Overview of Starting and Stopping Oracle RAC Instances ......................................................... 3-6
Starting and Stopping with Oracle Enterprise Manager.............................................................. 3-7
Starting Up and Shutting Down with SQL*Plus ........................................................................... 3-7
Starting Up and Shutting Down with SRVCTL............................................................................. 3-8
Verifying That Instances are Running ................................................................................................. 3-9
Terminating Sessions On a Specific Cluster Instance.................................................................... 3-10
Overview of Initialization Parameter Files in Oracle RAC .......................................................... 3-11
Setting SPFILE Parameter Values for Oracle RAC..................................................................... 3-12
Parameter File Search Order in Oracle RAC............................................................................... 3-13
Backing Up the Server Parameter File ......................................................................................... 3-14
Initialization Parameter Use in Oracle RAC.................................................................................... 3-14
Parameters That Must Have Identical Settings on All Instances ............................................. 3-16
Parameters That Have Unique Settings on All Instances.......................................................... 3-17
Parameters That Should Have Identical Settings on All Instances.......................................... 3-18
Converting an Administrator-Managed Database to a Policy-Managed Database ................. 3-19
Quiescing Oracle RAC Databases...................................................................................................... 3-20
Administering Multiple Cluster Interconnects on Linux and UNIX Platforms ....................... 3-21
Recommendations for Setting the CLUSTER_INTERCONNECTS Parameter...................... 3-22
Usage Examples for the CLUSTER_INTERCONNECTS Parameter....................................... 3-23
Customizing How Oracle Clusterware Manages Oracle RAC Databases ................................. 3-24
Advanced Oracle Enterprise Manager Administration ................................................................. 3-25
Using Oracle Enterprise Manager Grid Control to Discover Nodes and Instances.............. 3-25
Other Oracle Enterprise Manager Capabilities........................................................................... 3-26
Administering Jobs and Alerts in Oracle RAC ........................................................................... 3-26
Administering Jobs in Oracle RAC ....................................................................................... 3-27
Administering Alerts in Oracle RAC with Oracle Enterprise Manager .......................... 3-27
Performing Scheduled Maintenance Using Defined Blackouts in Oracle Enterprise
Manager 3-27
v
4 Administering Oracle RAC One Node
Overview of Oracle Real Application Clusters One Node .............................................................. 4-1
Adding an Oracle RAC One Node Database...................................................................................... 4-2
Converting Databases.............................................................................................................................. 4-3
Converting a Database from Oracle RAC to Oracle RAC One Node......................................... 4-3
Converting a Database from Oracle RAC One Node to Oracle RAC......................................... 4-3
Online Database Relocation................................................................................................................... 4-4
5 Introduction to Automatic Workload Management
Overview of Automatic Workload Management ............................................................................... 5-2
Automatic Workload Repository........................................................................................................... 5-3
Service Deployment Options................................................................................................................. 5-3
Using Oracle Services ........................................................................................................................ 5-4
Service Characteristics....................................................................................................................... 5-4
Service Name............................................................................................................................... 5-4
Net Service Name ....................................................................................................................... 5-5
Service Edition............................................................................................................................. 5-5
Service Management Policy ...................................................................................................... 5-5
Database Role for a Service ....................................................................................................... 5-5
Instance Preference ..................................................................................................................... 5-6
Server Pool Assignment............................................................................................................. 5-6
Load Balancing Advisory Goal for Runtime Connection Load Balancing......................... 5-6
Connection Load Balancing Goal ............................................................................................. 5-7
Distributed Transaction Processing ......................................................................................... 5-7
Subscription to High Availability Events................................................................................ 5-7
Transparent Application Failover Policy ................................................................................ 5-7
Service Usage in an Oracle RAC Database..................................................................................... 5-8
Resource Profile for a Service.................................................................................................... 5-8
Database Resource Manager Consumer Group Mappings for Services............................. 5-8
Performance Monitoring by Service with AWR..................................................................... 5-8
Parallel Operations and Services .............................................................................................. 5-9
Oracle Streams and Oracle RAC............................................................................................... 5-9
Default Service Connections............................................................................................................. 5-9
Connection Load Balancing ................................................................................................................ 5-10
Client-Side Load Balancing............................................................................................................ 5-10
Generic Database Clients ........................................................................................................ 5-11
Other Client-Side Connection Features ....................................................................................... 5-11
JDBC Clients ............................................................................................................................. 5-11
Oracle Call Interface Clients................................................................................................... 5-11
Server-Side Load Balancing........................................................................................................... 5-12
Fast Application Notification.............................................................................................................. 5-12
Overview of Fast Application Notification ................................................................................. 5-13
Application High Availability with Services and FAN............................................................. 5-14
Managing Unplanned Outages..................................................................................................... 5-14
Managing Planned Outages .......................................................................................................... 5-14
Fast Application Notification High Availability Events ........................................................... 5-15
剩余373页未读,继续阅读
资源评论
weixin_40191861_zj
- 粉丝: 62
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功