centos oracle11g安装教程

数据库安装：Centos下Oracle11gR2安装教程，自动化配置脚本的使用

Oracle 11g R2是Oracle公司推出的一款企业级关系型数据库管理系统，广泛应用于各种企业和组织，本文将详细介绍在CentOS系统下如何安装Oracle 11g R2，并使用自动化配置脚本进行配置。

环境准备

1、操作系统：CentOS 6.5 x86_64

2、Oracle 11g R2安装包

3、Oracle 11g R2客户端安装包

4、Oracle 11g R2数据库补丁包

5、Oracle 11g R2自动化配置脚本

安装步骤

1、创建Oracle用户和组

groupadd oinstall
groupadd dba
useradd g oinstall G dba oracle
passwd oracle

2、配置内核参数

cat >> /etc/sysctl.conf << EOF
fs.filemax = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF

3、使配置生效

sysctl p

4、创建安装目录

mkdir p /u01/app/oracle/product/11.2.0/dbhome_1
mkdir p /u01/app/oracle/oradata/orcl
chown R oracle:oinstall /u01
chmod R 775 /u01

5、解压Oracle 11g R2安装包到指定目录

cd /tmp
unzip linuxx64_11gR2_database_1of2.zip
unzip linuxx64_11gR2_database_2of2.zip
cd database

6、运行安装程序

./runInstaller silent ignorePrereq waitforcompletion responseFile /tmp/db_install.rsp debug all force ignoreSysPrereqs ignoreInternalDriverErrors ignoreOsPrereqs noconfig ignoreDependencies instanceName orcl silentInstall false assumeDefaultConfigForComponents false autostartClusterNodes true characterSet AL32UTF8 displayCountDown false forceCharacterSetEncoding false ignoreWarning prompt false locale en_US oracleHome /u01/app/oracle/product/11.2.0/dbhome_1 orclPassword password orclUsername sys as sysdba overwriteConfiguration false responseFileIsEmbedded false silentResponseFile false useJREHome /usr/java/jre1.7.0_80 useSOAPfalse useSIBfalse useWLSCluster true waitforcompletion yes Xms512m Xmx512m memoryPercentage 80 installExampleSchemas false asmMinimumMemory 512m asmMaximumMemory 512m asmMemoryPercentage 80 asmEnableRebalance true asmPerProcessEnabled true asmDiskGroupMappingFile /tmp/diskGroupMappingOrcl.xml asmStandbyRebalancing false asmDynmicRebalancing false asmDiskGroupName ORCLASMDISKGROUP asmDiskGroupType ASMDISKGROUPTYPE asmDiskGroupMembers "orcl" "orclASM" "orclDGD" "orclFRA" "orclIDBFS" "orclPDB" "orclPWDG" "orclSTBY" "orclTEMP" "orclUNDOTBS" "orclUSERDB" "orclXDB" "orclASMDISK" "orclASMDISKGROUP" "orclASMDISKGROUPTYPE" "orclASMDISKGROUPMEMBERS" "orclASMDISKGROUPMEMBERSTYPE" "orclASMISCRIPTDIR" "orclASMINITIALEXTENTS" "orclASMFIRSTDATAFILE" "orclASMFIRSTLOGFILE" "orclASMSINCELDEVIDENAME" "orclASMTARGETNAME" "orclASMTEMPFILEPREFIX" "orclASMTEMPFILEUNITSIZE" "orclASMWORKFILEPREFIX" "orclASMWORKFILEUNITSIZE" "orclAUTOBACKUPMAXTRANSFERSIZE" "orclAUTOBACKUPINTERVAL" "orclAUTOBACKUPREDOLOGCOUNT" "orclAUTOBACKUPREDOLOGINTERVAL" "orclAUTOSTARTPROFILETRUENAME" "orclCONTROLFILERECORDVERSION" "orclCRASHRECOVERYFILESIZE" "orclDB_BLOCK_SIZE" "orclDBCREATEFILEDESTINATION" "orclDBCREATEONLINELOGDESTINATION" "orclDBCREATEONLINELOGFILESIZE" "orclDBCREATEONLINELOGMAXLOGFILES" "orclDBCREATEONLINELOGPARALLELISM" "orclDBCREATEONLINELOGTIMEOUT" "orclDBCREATEPFILEDESTINATION" "orclDBCREATEPFILENAME" "orclDBCREATEPFILESEQUENCENUMBER" "orclDBCREATESPFILEDESTINATION" "orclDBCREATESPFILENAME" "orclDBCREATESPFILESEQUENCENUMBER" "orclDBCREATETEXTINDEXEDVIEWDESTINATION" "orclDBCREATETEXTINDEXEDVIEWSCHEMAONLYDESTINATION" "orclDBCREATETEXTINDEXEDVIEWSCHEMAONLYTABLESPACEDESTINATION" "orclDBCREATETEXTINDEXEDVIEWTABLESPACEANDSCHEMADESTINATION" "orclDBCREATEUSERDATAFILEDESTINATION" "orclDBCREATEUSERDATAFILENAME" "orclDBCREATEUSERDATAFILENUMBERTOBECREATED" "orclDBCREATEUSERDATAFILESTAGEDESTINATION" "orclDBCREATEUSERDATAFILESTAGINGCOMMITMENTLIMIT" "orclDBCREATEUSERDATAFILESTAGINGQUEUEDELAYPERCLASSESPERINSTANCE" "orclDBCREATEUSERDATAFILESTAGINGTIMEOUTPERCLASSESPERINSTANCE" "orclDBDIAGNOSISDESTINATION" "orclDBDIAGNOSISTIMEOUTPERCLASSESPERINSTANCE" "orclDBDIAGNOSISTIMEOUTPERINSTANCE" "orclDB_KEEP_CACHED_FLASHBACK_ARCHIVE_DESTINATION" "orclDB_KEEP_CACHED_FLASHBACK_ARCHIVEDESTINATIONTYPE" "orclDB_KEEP_FLASHBACK_ARCHIVE_DESTINATIONTYPE" "orclDB_OBJECT_CACHE_SIZE" "orclDB_OPEN_CURSORS_DEFAULT" "orclDB_OPEN_CURSORS_PER_INSTANCEMAXVALUE" "orclDB_OPEN_CURSORS_PER_INSTANCEMINVALUE" "orclDB_OPEN_CURSORS_PER_INSTANCEMINVALUEAUTOMATICALLYTURNEDOFFFORPOOLEDCONNECTIONSTRUEFALSENOTAPPLICABLENONEUNSPECIFIEDUNUSEDORCLAUDITCONFIGUREDONNEVEROFFORCENONEOFFORCENONEOFFORCENSESSIONSONLYOFFORCENTRALELEDGESERVEROFFORCLAUDITDESTINATIONAUDITPOLICYORCLAUDITDESTINATIONNONEUNSPECIFIEDUNUSEDORCLAUDITPOLICYSYSAUDITPOLICYSUCCESSFULLOGINSUCCESSFULLOGONNOTICESUCCESSFULLOGONTIMINGWARNINGSUNUSEDAUDITPOLICYUNSPECIFIEDUNUSEDORCLCDBROOTPASSWORDFILEPASSWORDFILELOCATIONORCLCDBROOTPASSWORDFILEPASSWORDISSETTONEWVALUEYESNOUNUSEDAUDITPOLICYUNSPECIFIEDUNUSEDORCLCONFIGUREDFEATURECOMPATIBILITYTRUEFALSE