roacleRAC学习文档service.pptVIP

Oracle 10G Real Application Clusters RAC Database Storage Principles RAC and Shared Storage Technologies Storage is a critical component of grids: Sharing storage is fundamental New technology trends Supported shared storage for Oracle grids: Network Attached Storage Storage Area Network Supported file systems for Oracle grids: Raw volumes Cluster file system ASM Global Dynamic Performance Views Store information about all started instances One global view for each local view Use one parallel slave on each instance Make sure that PARALLEL_MAX_SERVERS is big enough RAC and Services Virtual IP Addresses and RAC What Is a Service? Is a means of grouping sessions that are doing the same kind of work Provides single-system image instead of multiple instances image Is a part of the regular administration tasks that provide dynamic service-to-instance allocation Is the base for high availability of connections Provides a new performance-tuning dimension High Availability of Services in RAC Services are available continuously with load shared across one or more instances. Additional instances are made available in response to failures. Preferred instances: Set the initial cardinality for the service Are the first to start the service Available instances are used in response to preferred instance failures. Possible Service Configuration with RAC Service Attributes Single instance: Global unique name Threshold Priority RAC: Global unique name Threshold Priority High-availability configuration Preconnection Service Types Application services Internal services: SYS$BACKGROUND SYS$USERS Limit of 64 services per database: 62 application services 2 internal services Creating Services Services are maintained in the data dictionary. Use DBMS_SERVICE.CREATE to create a service for single-instance Oracle. Services are created automatically based on SERVICE_NAMES initialization parameter. Create a service in RAC with the following: DBCA SRVCTL High-availability business rules are mai