centos 6.7下静默安装oracle 11.2.0.4 RAC的简单介绍

由于服务器上没有安装图形界面,在安装RAC时,不得不使用静默安装的方式,之前一直都是图形化安装,参照http://www.luocs.com/archives/306.html上写的步骤折腾了一天,终于搞定了,大致过程如下:

--环境准备(软件包安装、创建oracle、grid用户及相关组、网络、存储、ssh互信等)


与图形化安装一致,具体请参考相关文档

---grid安装响应文件
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0    
ORACLE_HOSTNAME=pointdb1
INVENTORY_LOCATION=/home/db/oraInventory                                                          
SELECTED_LANGUAGES=en                                                                             
oracle.install.option=CRS_CONFIG                                                                  
ORACLE_BASE=/home/db/grid/base                                                                    
ORACLE_HOME=/home/db/grid/product/11.2.0                                                              
oracle.install.asm.OSDBA=asmdba                                                                   
oracle.install.asm.OSOPER=asmoper                                                                 
oracle.install.asm.OSASM=asmadmin                                                                 
oracle.install.crs.config.gpnp.scanName=pointdb-scan                                            
oracle.install.crs.config.gpnp.scanPort=1521                                                      
oracle.install.crs.config.clusterName=pointdb-cluster                                                 
oracle.install.crs.config.gpnp.configureGNS=false                                                 
oracle.install.crs.config.gpnp.gnsSubDomain=                                                      
oracle.install.crs.config.gpnp.gnsVIPAddress=                                                     
oracle.install.crs.config.autoConfigureClusterNodeVIP=false                                       
oracle.install.crs.config.clusterNodes=pointdb1:pointdb1-vip,pointdb2:pointdb2-vip                                
oracle.install.crs.config.networkInterfaceList=bond1:192.168.78.0:1,bond0:192.168.81.0:2            
oracle.install.crs.config.storageOption=ASM_STORAGE                                               
oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=                               
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=                            
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=                           
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=                                   
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=                                  
oracle.install.crs.config.useIPMI=false                                                           
oracle.install.crs.config.ipmi.bmcUsername=                                                       
oracle.install.crs.config.ipmi.bmcPassword=                                                       
oracle.install.asm.SYSASMPassword=password                                                  
oracle.install.asm.diskGroup.name=SYS                                                             
oracle.install.asm.diskGroup.redundancy=EXTERNAL                                                  
oracle.install.asm.diskGroup.AUSize=4                                                             
oracle.install.asm.diskGroup.disks=/dev/mapper/ocr01,/dev/mapper/ocr02,/dev/mapper/ocr03
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/mapper/*                           
oracle.install.asm.monitorPassword=password                                                   
oracle.install.crs.upgrade.clusterNodes=                                                          
oracle.install.asm.upgradeASM=false                                                               
oracle.installer.autoupdates.option=SKIP_UPDATES                                                  
oracle.installer.autoupdates.downloadUpdatesLoc=                                                  
AUTOUPDATES_MYORACLESUPPORT_USERNAME=                                                             
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=                                                             
PROXY_HOST=                                                                                       
PROXY_PORT=0                                                                                      
PROXY_USER=                                                                                       
PROXY_PWD=                                                                                        
PROXY_REALM=       

----检查环境
su - grid
./runcluvfy.sh stage -pre crsinst -n pointdb1,pointdb2 -verbose

-----执行安装
su - grid
./runInstaller -ignorePrereq -silent -force -responseFile /tmp/gi.rsp    

----安装后执行完root脚本后,需要执行configToolAllCommands
/home/db/grid/product/11.2.0/cfgtoollogs/configToolAllCommands RESPONSE_FILE=./cfgrsp.properties

grid@pointdb1:/home/db/grid/product/11.2.0/cfgtoollogs$ cat cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=password
oracle.assistants.asm|S_ASMMONITORPASSWORD=password

--安装oracle软件
./runInstaller -ignorePrereq -silent -force -responseFile /tmp/db_install.rsp

---db_install.rsp内容
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=pointdb1
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/home/db/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/home/db/oracle/product/11.2.0
ORACLE_BASE=/home/db/oracle
oracle.install.db.InstallEdition=
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=
oracle.install.db.CLUSTER_NODES=pointdb1,pointdb2
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=pointdb
oracle.install.db.config.starterdb.SID=pointdb
oracle.install.db.config.starterdb.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=700
oracle.install.db.config.starterdb.installExampleSchemas=true
oracle.install.db.config.starterdb.enableSecuritySettings=false
oracle.install.db.config.starterdb.password.ALL=password
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=ASM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=DATA
oracle.install.db.config.asm.ASMSNMPPassword=password
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
          
----安装完毕后,打PSU补丁,先打grid,再打database,这个根据补丁里的文档来就行了。注意需要使用比较新的opatch

----创建DATA磁盘组
su - grid
sqlplus / as sysasm
create diskgroup DATA external redundancy disk '/dev/mapper/data01'

---建库
dbca -silent -createDatabase -templateName General_Purpose.dbc  -gdbName pointdb -sid pointdb -sysPassword password -systemPassword  password -storageType ASM -diskGroupName DATA -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo pointdb1,pointdb2 -characterset ZHS16GBK -obfuscatedPasswords false -sampleSchema false -asmSysPassword password

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10972173/viewspace-2027287/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-2027287/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
安装 Oracle 9i 需要满足以下条件: - CentOS 7 系统已经安装并配置好了必要的软件包和组件。 - 系统已经为 Oracle 数据库安装了必要的软件包和组件。 - 系统已经创建了一个用户以便安装和管理 Oracle 数据库。 - 系统已经配置好了必要的内核参数和环境变量。 以下是在 CentOS 7 上安装 Oracle 9i 的步骤: 1. 下载 Oracle 9i 安装包。 2. 创建一个新用户以便安装和管理 Oracle 数据库。例如,我们可以创建一个名为 oracle 的用户: ``` sudo useradd -m -d /home/oracle -s /bin/bash oracle ``` 3. 将 oracle 用户添加到 dba 组中: ``` sudo usermod -a -G dba oracle ``` 4. 安装必要的软件包和组件: ``` sudo yum install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel -y ``` 5. 配置内核参数: 编辑 /etc/sysctl.conf 文件,将以下值添加到文件末尾: ``` fs.file-max = 65536 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 ``` 执行以下命令使更改生效: ``` sudo sysctl -p ``` 6. 配置环境变量: 将以下值添加到 oracle 用户的 ~/.bash_profile 文件中: ``` export ORACLE_BASE=/home/oracle/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/9.2.0 export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib ``` 然后执行以下命令使更改生效: ``` source ~/.bash_profile ``` 7. 解压 Oracle 9i 安装包: 将下载的 Oracle 9i 安装包解压到 /tmp 目录中: ``` unzip linux_9204_database.zip -d /tmp ``` 8. 运行安装程序: 切换到 oracle 用户并进入安装程序所在的目录: ``` su - oracle cd /tmp/database ``` 执行安装程序: ``` ./runInstaller ``` 根据安装程序的指示完成安装过程。 注意:安装程序可能会提示您安装旧版本的软件包。如果您看到这个提示,请安装所需的软件包并重新运行安装程序。 9. 安装完成后,运行 Oracle 9i 数据库: ``` sqlplus /nolog SQL> connect sys as sysdba SQL> startup ```

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值