在RedHat Advance Server上安装Oracle 9204 RAC参考手册

RAC数据库服务器配置文档一、系统基础配置1.安装软件包2.修改系统参数3.添加用户和组4 修改用户环境变量Grid用户5 通过ASMLIB管理磁盘二、安装集群软件密码：system123[root@pthello1 ~]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@pthello1 ~]# /u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /u01/app/11.2.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Creating trace directoryInstalling Trace File AnalyzerOLR initialization - successfulroot walletroot wallet certroot cert exportpeer walletprofile reader walletpa walletpeer wallet keyspa wallet keyspeer cert requestpa cert requestpeer certpa certpeer root cert TPprofile reader root cert TPpa root cert TPpeer pa cert TPpa peer cert TPprofile reader pa cert TPprofile reader peer cert TPpeer user certpa user certAdding Clusterware entries to upstartCRS-2672: Attempting to start 'ora.mdnsd' on 'pthello1'CRS-2676: Start of 'ora.mdnsd' on 'pthello1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'pthello1'CRS-2676: Start of 'ora.gpnpd' on 'pthello1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'pthello1'CRS-2672: Attempting to start 'ora.gipcd' on 'pthello1'CRS-2676: Start of 'ora.cssdmonitor' on 'pthello1' succeededCRS-2676: Start of 'ora.gipcd' on 'pthello1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'pthello1'CRS-2672: Attempting to start 'ora.diskmon' on 'pthello1'CRS-2676: Start of 'ora.diskmon' on 'pthello1' succeededCRS-2676: Start of 'ora.cssd' on 'pthello1' succeededASM created and started successfully.Disk Group OCR created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-4256: Updating the profileSuccessful addition of voting disk a6bad62405144f4bbf5ff6551ea45a59.Successful addition of voting disk 538bba4d8aa14f8dbf111803543072a8.Successful addition of voting disk 59db1c91b1f04fb9bf6454344c5774e4.Successfully replaced voting disk group with +OCR.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------1. ONLINE a6bad62405144f4bbf5ff6551ea45a59 (ORCL:OCR_VOL1) [OCR]2. ONLINE 538bba4d8aa14f8dbf111803543072a8 (ORCL:OCR_VOL2) [OCR]3. ONLINE 59db1c91b1f04fb9bf6454344c5774e4 (ORCL:OCR_VOL3) [OCR]Located 3 voting disk(s).CRS-2672: Attempting to start 'ora.asm' on 'pthello1'CRS-2676: Start of 'ora.asm' on 'pthello1' succeededCRS-2672: Attempting to start 'ora.OCR.dg' on 'pthello1'CRS-2676: Start of 'ora.OCR.dg' on 'pthello1' succeededConfigure Oracle Grid Infrastructure for a Cluster ... succeeded1:pdksh ########################################### [100%] [root@pthello2 ~]# /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@pthello2 ~]# /u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /u01/app/11.2.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]:Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryInstalling Trace File AnalyzerOLR initialization - successfulAdding Clusterware entries to upstartCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node pthello1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterConfigure Oracle Grid Infrastructure for a Cluster ... succeeded[root@pthello1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: [/usr/local/bin]:The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@pthello1 ~]#[root@pthello2 ~]# /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@pthello2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh Performing root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@pthello2 ~]#三、安装数据库软件[root@pthello1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh Performing root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@pthello2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh Performing root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.四、配置数据库密码：system123五、集群状态验证。

1 安装oracle1.1安装服务1)双击oracle安装程序，开始安装，单击下一步2)选择安装路径，单击下一步3)选择安装的产品（此处选Oracle Database 9.2.0.1.0），单击下一步4)选择安装的版本（默认选企业版），单击下一步5)选择数据库配置（默认选择通用），单击下一步6)设置端口号（默认2030），单击下一步7)设置数据库名及SID名称，单击下一步(sywebserver)8)选择数据库文件目录的路径，单击下一步9)设置数据库字符集（默认），单击下一步10)单击“安装”，开始安装数据库11)安装过程中会提示插入磁盘2，选择磁盘2的路径，单击“确定”继续安装12)之后还会提示插入磁盘3，选择磁盘3的路径，单击“确定”继续安装13)安装程序对数据库进行配置并创建数据库14)设置数据库的管理员SYS、System的密码，此处分别设为sys、system。

1.2创建用户及数据库1)在开始－>程序－>Ora92－>Enterprise Manager Console打开oracle的管理界面2)选择独立启动，单击确定3)打开数据库，输入用户名、口令（system、system）登陆4)打开安全性－>用户，右键单击，在菜单中选择创建5)在弹出的窗口输入名称及口令（syportal、syportal）6)切换到角色选项卡，选择DBA角色，单击下箭头添加7)将DBA的管理选项勾选，单击创建8)提示用户创建成功9)重复步骤4）～8），分别创建用户syprivilege（用户/密码：syprivilege/syprivilege）、usm（用户/密码：usm/usm）1.3 导入数据1）开始菜单——运行——cmd2）进入到数据文件的存放路径3）执行数据恢复语句imp syportal/syportal fromuser=hljportal touser=syportal file=portaldata0115.dmp (imp 登陆用户/密码fromuser=原数据库用户名touser=现数据库用户file=数据数据文件名log=log.text)4）执行imp syprivilege/syprivilege fromuser=hljsyprivilege touser=sysyprivilege file=portaldata0115.dmp5）执行imp ums/ums fromuser=ums touser=ums file=portaldata0115.dmp。

Redhat Linux 6.2下Oracle 10g安装配置手册1.安装准备1.1RedHat Linux Server 6.2安装文件1.2Oracle 10g Linux安装文件1.3检查安装包rpm -qa |grep makeautomake-1.11.1-1.2.el6.noarchmake-3.81-19.el6.x86_64rpm -qa|grep glibcglibc-common-2.12-1.47.el6.x86_64glibc-2.12-1.47.el6.i686glibc-headers-2.12-1.47.el6.x86_64glibc-devel-2.12-1.47.el6.i686compat-glibc-headers-2.5-46.2.x86_64glibc-2.12-1.47.el6.x86_64glibc-utils-2.12-1.47.el6.x86_64glibc-devel-2.12-1.47.el6.x86_64compat-glibc-2.5-46.2.x86_64rpm -qa |grep libaiolibaio-devel-0.3.107-10.el6.i686libaio-0.3.107-10.el6.x86_64libaio-devel-0.3.107-10.el6.x86_64libaio-0.3.107-10.el6.i686rpm -qa |grep gccgcc-objc-4.4.6-3.el6.x86_64gcc-objc++-4.4.6-3.el6.x86_64compat-gcc-34-g77-3.4.6-19.el6.x86_64gcc-gfortran-4.4.6-3.el6.x86_64gcc-gnat-4.4.6-3.el6.x86_64compat-gcc-34-c++-3.4.6-19.el6.x86_64gcc-java-4.4.6-3.el6.x86_64gcc-4.4.6-3.el6.x86_64compat-gcc-34-3.4.6-19.el6.x86_64gcc-c++-4.4.6-3.el6.x86_64libgcc-4.4.6-3.el6.i686libgcc-4.4.6-3.el6.x86_64rpm -qa |grep compat-libstdccompat-libstdc++-296-2.96-144.el6.i686compat-libstdc++-33-3.2.3-69.el6.i686compat-libstdc++-33-3.2.3-69.el6.x86_64 rpm -qa |grep compat-gcccompat-gcc-34-g77-3.4.6-19.el6.x86_64compat-gcc-34-c++-3.4.6-19.el6.x86_64compat-gcc-34-3.4.6-19.el6.x86_64rpm -qa |grep libXplibXp-1.0.0-15.1.el6.x86_64libXp-devel-1.0.0-15.1.el6.x86_64libXpm-3.5.8-2.el6.i686libXpm-devel-3.5.8-2.el6.x86_64libXp-devel-1.0.0-15.1.el6.i686libXpm-3.5.8-2.el6.x86_64libXpm-devel-3.5.8-2.el6.i686libXp-1.0.0-15.1.el6.i686rpm -qa |grep openmotifopenmotif-devel-2.3.3-4.el6.x86_64openmotif-2.3.3-4.el6.x86_64openmotif22-2.2.3-19.el6.x86_64openmotif22-2.2.3-19.el6.i686rpm -qa |grep compat-dbcompat-db43-4.3.29-15.el6.x86_64compat-db43-4.3.29-15.el6.i686compat-db42-4.2.52-15.el6.i686compat-db-4.6.21-15.el6.i686compat-db-4.6.21-15.el6.x86_64compat-db42-4.2.52-15.el6.x86_642.硬件要求1.1物理内存至少2G查看命令：grep MemTotal /proc/meminfo1.2交换分区：至少1G，最好是物理内存的2倍查看命令：grep SwapTotal /proc/meminfo1.3硬盘空闲区至少4G查看命令：df –h3.创建安装oracle 所需的组和用户以下操作需要使用root账户创建。

Oracle10g RAC安装手册2第五部分安装配置Oracle RAC5.1 配置环境变量5.1.1 编辑.bashrc设置 ORACLE_BASE 和 ORACLE_HOME 等环境变量基本路径：ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crs_1据oracle的安装文档要求，CRS的目录最好不是ORACLE_BASE的子目录，因为安装过程中会改变CRS的父目录的权限，这会影响ORACLE的安装。

在按以上要求生成对应目录之前，需检查所在磁盘的空间是否满足安装要求，确定之后生成目录，并将相关环境变量设置在oracle用户的profile中。

用oracle帐号编辑/home/oracle/.bashrcoracle用户的profile文件.bashrc内容:# .bashrc# User specific aliases and functions# Source global definitionsif [ -f /etc/bashrc ]; then. /etc/bashrcfiexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crs_1export ORACLE_SID=dbrac1export ORACLE_TERM=xtermexport LD_ASSUME_KERNEL=2.4.1export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/sbinexport PATH然后执行$ source .bash_profile使环境变量生效注意：ORACLE_SID每台机器不一样，如dbrac1的SID为dbrac1，dbrac2的SID 为dbrac2，以此类推。

在RedHat AS4.0(X86)上安装Oracle9iR2数据库(整理)昨天晚上把服务器重新装了一遍。

系统是RedHat AS4.0(X86)，主要是为了安装Oracle9i，结合网上的一些资料总结一下，整理出来，希望对大家有用。

由于网上的资料很多，但由于大家的传阅转载，有不少都有些误差了，我在这里也算是校对一下吧，对这些原始资料的创作人表示敬意。

一，准备工作1，先安装好RedHat AS4.0，保持系统的干净。

在oracle官方网站上下载Oracle9i的安装文件:ship_9204_linux_disk1.cpio.gzship_9204_linux_disk2.cpio.gzship_9204_linux_disk3.cpio.gz打3238244补丁同时要下载三个补丁：p4198954_21_linux.zip在运行runInstaller之前打p2617419_220_GENERIC.zip修复agent错误的补丁p3238244_9204_LINUX.zip打3238244补丁由于安装oracle需要很多系统软件包，少一样都不行，真是一个都不能少。

开一个终端，以root用户运行：#rpm-qa|grep compat检查当前系统所安装的compat软件包是否已有:compat-db-4.1.25-9compat-gcc-32-3.2.3-47.3compat-gcc-32-c++-3.2.3-47.3compat-oracle-rhel4-1.0-3compat-libcwait-2.0-1compat-libgcc-296-2.96-132.7.2compat-libstdc++-296-2.96-132.7.2compat-libstdc++-33-3.2.3-47.3gcc-3.4.3-9.EL4gcc-c++-3.4.3-9.EL4gnome-libs-1.4.1.2.90-44gnome-libs-devel-1.4.1.2.90-44libaio-devel-0.3.102-1libaio-0.3.102-1make-3.80-5openmotif21-2.1.30-11xorg-x11-deprecated-libs-devel-6.8.1-23.ELxorg-x11-deprecated-libs-6.8.1-23.EL发如果少了上数包，可按下面的命令和所属AS4光盘安装RPM包(最后两个由Oralce补丁p4198954_21_linux.zip解压产生)rpm-ivh sysstat-5.0.5-1.i386.rpm disk4rpm-ivh openmotif21-2.1.30-11.RHEL4.2.i386.rpm disk3rpm-ivh libaio-0.3.102-1.i386.rpm disk3rpm-ivh libaio-devel-0.3.102-1.i386.rpm disk3rpm-ivh freetype-devel-2.1.9-1.i386.rpm disk3rpm-ivh fontconfig-devel-2.2.3-7.i386.rpm disk3rpm-ivh xorg-x11-devel-6.8.1-23.EL.i386.rpm disk3rpm-ivh xorg-x11-deprecated-libs-devel-6.8.1-23.EL.i386.rpm disk3rpm-ivh glib-devel-1.2.10-15.i386.rpm disk4rpm-ivh ORBit-devel-0.5.17-14.i386.rpm disk4rpm-ivh gtk+-devel-1.2.10-33.i386.rpm disk4rpm-ivh alsa-lib-devel-1.0.6-4.i386.rpm disk3rpm-ivh audiofile-devel-0.2.6-1.i386.rpm disk3rpm-ivh esound-devel-0.2.35-2.i386.rpm disk3rpm-ivh libjpeg-devel-6b-33.i386.rpm disk3rpm-ivh libtiff-devel-3.6.1-7.i386.rpm disk3rpm-ivh libungif-devel-4.1.3-1.i386.rpm disk3rpm-ivh imlib-devel-1.9.13-23.i386.rpm disk3rpm-ivh gnome-libs-devel-1.4.1.2.90-44.1.i386.rpm disk4rpm-ivh compat-oracle-rhel4-1.0-5.i386.rpm(p4198954_21_linux.zip)rpm-ivh compat-libcwait-2.0-2.i386.rpm(p4198954_21_linux.zip)二，创建相关安装目录和环境变量1，创建user/group；#groupadd dba#groupadd oinstall#useradd oracle-g oinstall-G dba#passwd oracle2，建立oracle安装文件夹；#mkdir-p/opt/ora9/product/9.2.0.4#mkdir/var/opt/oracle#chmod oracle.dba/var/opt/oracle#chown-R oracle.dba/opt/ora93，配置环境变量；以root用户登录，设置root用户的环境打开.bash_profile文件，将如下内容加入：export ORACLE_BASE=/opt/ora9export ORACLE_HOME=/opt/ora9/product/9.2.0.4export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/binexport ORACLE_OWNER=oracleexport ORACLE_SID=oradb//此处为你的sid使用Oracle用户登陆:#su–oracle$vi.bash_profile以下是配置文件的内容#.bash_profile#Get the aliases and functionsif[-f~/.bashrc];then.~/.bashrcfi#User specific environment and startup programsPATH=$PATH:$HOME/binexport ORACLE_BASE=/opt/ora9export ORACLE_HOME=/opt/ora9/product/9.2.0.4export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/binexport ORACLE_OWNER=oracleexport ORACLE_SID=oradbexport ORACLE_TERM=xtermexport LD_ASSUME_KERNEL=2.4.19export THREADS_FLAG=nativeexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport NLS_LANG=”American_america.utf8”export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport PATHunset USERNAME4，设置系统参数；#su–root切换到root用户a)修改#vi/etc/sysctl.conf,以下是配置文件的内容（其中红色字体为添加的内容）：#Kernel sysctl configuration file for Red Hat Linux##For binary values,0is disabled,1is enabled.See sysctl(8)and#sysctl.conf(5)for more details.#Controls IP packet forwardingnet.ipv4.ip_forward=0#Controls source route verificationnet.ipv4.conf.default.rp_filter=1#Controls the System Request debugging functionality of the kernelkernel.sysrq=0#Controls whether core dumps will append the PID to the core filename.#Useful for debugging multi-threaded applications.kernel.core_uses_pid=1kernel.shmmax=536870912kernel.shmmni=4096kernel.shmall=2097152kernel.sem=25032000100128fs.file-max=65536net.ipv4.ip_local_port_range=102465000修改后运行#sysctl–p命令使得内核改变立即生效；（译者注：一般情况下可以设置最大共享内存为物理内存的一半，如果物理内存是2G，则可以设置最大共享内存为1073741824，如上；如物理内存是1G，则可以设置最大共享内存为512*1024*1024=536870912；以此类推。

ORACLE11g R2 RAC FOR REDHAT6.2安装实施报告文档控制修改记录审阅分发软硬件现状硬件清单●数据库服务器IBM3850-2台，主要配置如下：➢CPU 4个➢内存64G●数据库服务器磁盘阵列–V7000➢RAID 5●安装产品如下：rac01 安装数据库RAC的一个实例，并升级到11.2.0.3rac02 安装数据库RAC的一个实例，并升级到11.2.0.3 软件清单●操作系统：REDHAT 6.2●群集软件：ORACLE Grid Infrastructure 11.2.0.3●数据库：ORACLE 11g DATABASE RELEASE2●数据库补丁集：11.2.0.3系统环境需求安装前的系统环境准备●检查REDHAT服务器安装完成并打上最新的补丁集●网络环境连通并调试正常。

●磁盘阵列安装完成并按ORACLE系统进行磁盘裸设备的划分。

硬件要求●内存：> 2G。

●SWAP区：2G。

通常等于物理内存，最低不少于1G。

●硬盘容量：数据库软件> 4G。

数据库> 2G。

●/tmp：临时目录空间大于500M。

●CDROM：支持ISO 9660。

软件要求●操作系统及Patches：Redhat 6.2 x64一．安装准备工作1.检查系统要求# uname –r2.6.32-220.el6.x86_642.内存容量# grep MemTotal /proc/meminfo MemTotal: 67108864kB 3.操作系统位数检查# uname -aX86_644.交换空间#f r e e–m|g r e p S w a pS w a p81925.空间检查#d f-h6.建立grid、oracle用户和oinstall、dba组指定grid、oracle用户的组是oinstall、dba,两边GID,UID相同#groupadd –g 5001 grid#groupadd –g 5002 dba#useradd –u 6001 –g grid –G dba grid#useradd –u 6002 –g grid –G dba oracle设置密码：Passwd grid这里输入gridPasswd oracle这里输入oracle7.设置系统参数fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586设置安全权限/etc/security/limits.confgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 10240oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 102408.IP地址私有IP地址必需与公网分离,两个节点可互相访问可以ping通,必须在 /etc/hosts里有；虚拟IP地址同公网IP地址是一个网段的，如果有DNS就注册在DNS 中，如果没有DNS就写在/etc/hosts文件里；公网IP地址，是主机真正的IP地址，主机管理员预先分配，如果有DNS就注册在DNS中，如果没有DNS就写在/etc/hosts文件里），并且保证写入每个客户系统中的hosts文件。

Oracle10gRAC在IBM-AIX5.3上的安装手册一、安装概述Oracle10gRAC的软件版本号为10.2.0.1，补丁版本号为10.2.0.2。

AIX操作系统版本号为5300-05。

Oracle10g的安装介质为三个tar文件：crsinstall.tar、oracle10g.tar和p10202_AIX64-5L.tar。

请联系工程部陈晓静获取安装介质。

全部安装，包括安装crs软件，安装oracle软件，安装10202补丁和创建数据库，大约需要3个小时左右。

在安装过程中，操作系统和硬件的厂方工程师最好在场，如果出现问题，大家一起解决会比较容易。

二、硬件需求1、机器需求CPU数目不低于2个，内存不低于2G，硬盘空间不小于20G。

这些要求目前的工程机器一般都能满足。

需要注意的是以下几点：●SWAP虚拟内存对换区不低于物理内存的两倍，如果物理内存大于8G，则虚拟内存可以配置成和物理内存相同大小。

●临时空间目录/tmp不低于500M，建议为1G以上●需要为Oracle软件建立单独的分区/users/oracle，大小建议为20G。

最少应为10G。

●机器名称不能超过8位，最好不要包含“-”号。

上面的要求在两台库服务器上都需要满足，如果有不满足的，请让厂方工程师协助解决。

2、网络需求两个光纤网口，用于连光纤交换机和阵列连接。

至少三个，最好四个千兆网口(电口、光口均可)，用于外网连接和心跳连接。

建议将机器主板上的内置网卡用于心跳连接，将PCI插槽上的外接网卡用于外网连接。

为了满足OracleRAC中vip的需求，需要将连接外网的两个网口使用etherchannel技术虚拟成一个虚网口，vip的地址需要和这个虚网口配置在同一个网段。

如果有四个网口，建议将剩余的两个网口也使用etherchannel技术虚拟成一个虚网口，用于心跳连接。

Oracle建议心跳使用单独的交换机连接，或者使用交换机上一个单独的vlan连接，避免使用交叉线直接连接。

Oracle 10g RAC 教程第一部分 Oracle10g RAC数据库简介在硬件级别上，RAC 集群中的各节点共享三种功能：1.对共享磁盘存储的访问2.与专用网络的连接3.对公共网络的访问。

共享磁盘存储Oracle RAC 依赖于一个共享磁盘体系结构。

数据库文件、联机重做日志和数据库的控制文件必须都能为集群中的每个节点所访问。

共享磁盘还存储 Oracle Cluster Registry 和 Voting Disk（稍后讨论）。

配置共享存储有多种方法，包括直接连接磁盘（通常是使用铜缆或光纤的 SCSI）、存储区域网 (SAN) 和网络连接存储 (NAS)。

专用网络每个集群节点通过专用高速网络连接到所有其他节点，这种专用高速网络也称为集群互联或高速互联 (HSI)。

Oracle 的 Cache Fusion 技术使用这种网络将每个主机的物理内存 (RAM) 有效地组合成一个高速缓存。

Oracle Cache Fusion 通过在专用网络上传输某个 Oracle 实例高速缓存中存储的数据允许其他任何实例访问这些数据。

它还通过在集群节点中传输锁定和其他同步信息保持数据完整性和高速缓存一致性。

专用网络通常是用千兆以太网构建的，但是对于高容量的环境，很多厂商提供了专门为 Oracle RAC 设计的低延迟、高带宽的专有解决方案。

Linux 还提供一种将多个物理 NIC 绑定为一个虚拟 NIC 的方法（此处不涉及）来增加带宽和提高可用性。

公共网络为维持高可用性，为每个集群节点分配了一个虚拟 IP 地址 (VIP)。

如果主机发生故障，则可以将故障节点的 IP 地址重新分配给一个可用节点，从而允许应用程序通过相同的 IP 地址继续访问数据库。

Oracle 集群就绪服务(CRS)Oracle RAC 10g 引进了 Oracle 集群就绪服务 (CRS) —一组用于集群环境的与平台无关的系统服务。

在 RAC 和 Oracle 并行服务器先前版本中，Oracle 依靠厂商提供的集群管理软件来提供这些服务。

ORACLE RAC 安装总结SOLARIS 10 环境软件安装操作系统SOLARIS 10 集群软件PrimeCluster由于本次rac实施未采用ASM，因此在安装前在当前环境下运行sdxinfo 查看相关的卷的状态是否为active.1、配置操作系统内核，划分相应存储的裸设备空间2、建立oracle用户组和对应宿主，设置裸设备的权限（此步骤注意一定要在两台主机上同时设置）3、建立ssh主机之间的信任关系。

（也可以考虑采用rlogin的方式进行验证）这是找到节点的必须条件4、验证操作系统环境，安装相关的补丁软件。

具体需要软件包如下Check: Package existence for "SUNWarc"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWarc:11.10.0 passedrac1 SUNWarc:11.10.0 passedResult: Package existence check passed for "SUNWarc".Check: Package existence for "SUNWbtool"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWbtool:11.10.0 passedrac1 SUNWbtool:11.10.0 passedResult: Package existence check passed for "SUNWbtool".Check: Package existence for "SUNWhea"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWhea:11.10.0 passedrac1 SUNWhea:11.10.0 passedResult: Package existence check passed for "SUNWhea".Check: Package existence for "SUNWlibm"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWlibm:5.10 passedrac1 SUNWlibm:5.10 passedResult: Package existence check passed for "SUNWlibm".Check: Package existence for "SUNWlibms"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWlibms:5.10 passedrac1 SUNWlibms:5.10 passedResult: Package existence check passed for "SUNWlibms".Check: Package existence for "SUNWsprot"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWsprot:5.10 passedrac1 SUNWsprot:5.10 passedResult: Package existence check passed for "SUNWsprot".Check: Package existence for "SUNWsprox"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWsprox" was not found passedrac1 ERROR: information for "SUNWsprox" was not found passedResult: Package existence check passed for "SUNWsprox".Check: Package existence for "SUNWtoo"Node Name StatusComment------------------------------ ------------------------------ ----------------rac2 SUNWtoo:11.10.0 passedrac1 SUNWtoo:11.10.0 passedResult: Package existence check passed for "SUNWtoo".Check: Package existence for "SUNWi1of"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWi1of:6.6.2.7400 passedrac1 SUNWi1of:6.6.2.7400 passedResult: Package existence check passed for "SUNWi1of".Check: Package existence for "SUNWi1cs"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWi1cs:2.0 passedrac1 SUNWi1cs:2.0 passedResult: Package existence check passed for "SUNWi1cs".Check: Package existence for "SUNWi15cs"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWi15cs:2.0 passedrac1 SUNWi15cs:2.0 passedResult: Package existence check passed for "SUNWi15cs".Check: Package existence for "SUNWxwfnt"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWxwfnt:6.6.2.7400 passedrac1 SUNWxwfnt:6.6.2.7400 passedResult: Package existence check passed for "SUNWxwfnt".Check: Package existence for "SUNWlibC"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 SUNWlibC:5.10 passedrac1 SUNWlibC:5.10 passedResult: Package existence check passed for "SUNWlibC".Check: Package existence for "SUNWscucm:3.1"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWscucm" was not found failedrac1 ERROR: information for "SUNWscucm" was not found failedResult: Package existence check failed for "SUNWscucm:3.1".Check: Package existence for "SUNWudlmr:3.1"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWudlmr" was not found failedrac1 ERROR: information for "SUNWudlmr" was not found failedResult: Package existence check failed for "SUNWudlmr:3.1".Check: Package existence for "SUNWudlm:3.1"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWudlm" was not found failedrac1 ERROR: information for "SUNWudlm" was not found failedResult: Package existence check failed for "SUNWudlm:3.1".Check: Package existence for "ORCLudlm:Dev_Release_06/11/04,_64bit_3.3.4.8_reentrant"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "ORCLudlm" was not found failedrac1 ERROR: information for "ORCLudlm" was not found failedResult: Package existence check failed for "ORCLudlm:Dev_Release_06/11/04,_64bit_3.3.4.8_reentrant".Check: Package existence for "SUNWscr:3.1"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWscr" was not found failedrac1 ERROR: information for "SUNWscr" was not found failedResult: Package existence check failed for "SUNWscr:3.1".Check: Package existence for "SUNWscu:3.1"Node Name Status Comment------------------------------ ------------------------------ ----------------rac2 ERROR: information for "SUNWscu" was not found failedrac1 ERROR: information for "SUNWscu" was not found failedResult: Package existence check failed for "SUNWscu:3.1".Check: Group existence for "dba"Node Name Status Comment------------ ------------------------ ------------------------rac2 exists passedrac1 exists passedResult: Group existence check passed for "dba".Check: Group existence for "oinstall"Node Name Status Comment------------ ------------------------ ------------------------rac2 exists passedrac1 exists passedResult: Group existence check passed for "oinstall".Check: User existence for "oracle"Node Name Status Comment------------ ------------------------ ------------------------rac2 exists passedrac1 exists passedResult: User existence check passed for "oracle".Check: User existence for "nobody"Node Name Status Comment------------ ------------------------ ------------------------rac2 exists passedrac1 exists passedResult: User existence check passed for "nobody".如果相关的补丁缺失，请用pkgadd . 补丁名命令安装相对应的补丁，打部分软件包在操作系统的第一张安装盘上。