很多用户都想了解Oracle RAC ,但是又缺少硬件条件来安装和了解RAC。这里我们应用Oracle VM，在XEN虚拟机上来实现安装。Oracle VM
在Oracle VM 虚拟机上安装Oracle Clusterware 11g
Ling Mei
Oracle Asia Development & Research Center
Oracle Partner Solution Center
目录
在Oracle VM 虚拟机上安装Oracle RAC 11g1 创建虚拟机
2 安装Clusterware前的准备
2.1 检查系统硬件环境 (在所有节点上)
2.2 配置和检查系统软件环境 (在所有节点上)
2.3 配置和检查网络 (在所有节点上)
2.4 配置内核参数 (在所有节点上)
2.5 创建用于安装oracle的用户和用户组 (在所有节点上)
2.6 配置ssh/rsh协议 (在所有节点上)
2.7 配置用户环境 (在所有节点上)
2.8 NFS 服务设置
2.9 创建安装目录
2.10 创建ocr和voting file文件
3 安装 Clusterware
3.1 下载并解压Oracle Clusterware安装软件
3.2 安装Clusterware
3.3 查看CRS状态
参考文档
很多用户都想了解Oracle RAC ,但是又缺少硬件条件来安装和了解RAC。这里我们应用Oracle VM，在XEN虚拟机上来实现安装。
Oracle VM于2007年11月12日正式推出,目前最新的版本是2.1.1。它是一款基于开源Xen管理器的虚拟化软件，支持Oracle和非Oracle的应用程序。在OTN 上可以免费下载到相关资源。用户可以在OVM中通过多种方式快捷地创建虚拟机和虚拟磁盘。
这里我们创建2台虚拟机作为集群里的2个节点。
·通过Oracle Virtual Machine Template创建虚拟机 RAC1_13 和 RAC2_13。
·虚拟机的内存至少为 1G
·每台机器应创建 2 块虚拟网卡，如下图所示：
Select
Virtual Network Interface Name
Virtual Network Interface MAC Address
Xen Bridge
Status
Network Interface
Select
VIF0
00:16:3E:2A:69:C6
xenbr0
Active
netfront
Select
VIF1
00:16:3E:37:80:7C
xenbr1
Active
netfront
·作为RAC节点的虚拟机的OS 版本应一致，这里我们都选择 Oracle Enterprise Linux Release 4 Update 5.
·创建完毕，“Power On”所有的节点。
2 安装Clusterware前的准备 2.1 检查系统硬件环境 (在所有节点上)系统硬件条件至少应满足
·1G RAM
# grep MemTotal /proc/meminfo·Swap 1.5G
# grep SwapTotal /proc/meminfo·/tmp >400MB
# df -k /tmp·650MB的磁盘空间作为Oracle Clusterware home
·1G磁盘空间用来放Oracle Clusterware file
如果考虑冗余的话，需要再增加分区
·至少4G磁盘空间作为Oracle Database home
·虚拟机的磁盘空间不够的话，可以通过增加虚拟磁盘的方法解决
2.2 配置和检查系统软件环境 (在所有节点上)检查系统是否已经安装以下的包
binutils-2.15.92.0.2-18elfutils-libelf-0.97-5
elfutils-libelf-devel-0.97.5
glibc-2.3.9.4-2.19
glibc-common-2.3.9.4-2.19
glibc-devel-2.3.9.4-2.19
gcc-3.4.5-2
gcc-c++-3.4.5-2
libaio-devel-0.3.105-2
libaio-0.3.105-2
libgcc-3.4.5
libstdc++-3.4.5-2
libstdc++-devel-3.4.5-2
make-3.80-5
通过模板创建的虚拟机，，OS可能没有安装全部需要的包。
用户在安装前请参照Oracle官方文档检查系统是否已经安装所需的包。
RAC2_13 eth0 10.182.108.88 eth1 192.168.0.12
·修改节点的/etc/hosts文件
127.0.0.1 localhost.localdomain localhost10.182.108.86 rac1_13.cn.oracle.com rac1_1310.182.108.87 rac1_13-vip.cn.oracle.com rac1_13-vip192.168.0.11 rac1_13-priv.cn.oracle.com rac1_13-priv
192.168.0.12 rac2_13-priv.cn.oracle.com rac2_13-priv10.182.108.88 rac2_13.cn.oracle.com rac2_13
10.182.108.89 rac2_13-vip.cn.oracle.com rac2_13-vip
·修改节点的hostname
vi /etc/sysconfig/network
设置节点的hostname分别为RAC1_13和RAC2_13。
kernel.core_uses_pid = 1
fs.file-max=327679
kernel.msgmni=2878
kernel.msgmax=8192
kernel.msgmnb=65536
kernel.sem=250 32000 100 142
kernel.shmmni=4096
kernel.shmall=3279547
kernel.sysrq=1
net.core.rmem_default=262144
net.core.rmem_max=2097152
net.core.wmem_default=262144
net.core.wmem_max=262144
fs.aio-max-nr=3145728
net.ipv4.ip_local_port_range=1024 65000
vm.lower_zone_protection=100
kernel.shmmax=536934400
Explain the InnoDB Buffer Pool and its importance for performance.Apr 19, 2025 am 12:24 AMInnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.
MySQL vs. Other Programming Languages: A ComparisonApr 19, 2025 am 12:22 AMCompared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
Learning MySQL: A Step-by-Step Guide for New UsersApr 19, 2025 am 12:19 AMMySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.
MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AMMySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.
MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AMMySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.
MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AMMySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.
The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AMSQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.
MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AMThe basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
SublimeText3 Mac version
God-level code editing software (SublimeText3)
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Dreamweaver Mac version
Visual web development tools
