操作系统 安装前的准备修改主机名添加主机名与IP对应记录 安装依赖包yumyinstallgccgcccmakeelfutilslibelfdevelelfutilslibelfdevelstaticbinutilscompatlibcap1compatlibstdc33compatlibstdc33i686compatlibstdc33。develcompatlibstdc33compatlibstdc33。develgccgcccglibcglibc。i686glibcdevelglibcdevel。i686kshlibaiolibaio。i686libaiodevellibaiodevel。devellibgcclibgcc。i686libstdclibstdc。i686libstdcdevellibstdcdevel。devellibXilibXi。i686libXtstlibXtst。i686makesysstatunixODBCunixODBC。i686unixODBCdevelunixODBCdevel。i686 创建用户和组 配置内核参数vimetcsysctl。conffs。aiomaxnr1048576fs。filemax6815744kernel。shmall2097152kernel。shmmax536870912kernel。shmmni4096kernel。sem25032000100128net。ipv4。iplocalportrange900065500net。core。rmemdefault262144net。core。rmemmax4194304net。core。wmemdefault262144net。core。wmemmax1048576sysctlp 修改用户限制vimetcsecuritylimits。conforaclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536oraclesoftstack10240oraclehardstack10240vimetcpam。dlogin文件最后添加sessionrequiredlibsecuritypamlimits。sosessionrequiredpamlimits。sovimetcprofileif〔USERoracle〕;thenif〔SHELLbinksh〕;thenulimitp16384ulimitn65536elseulimitu16384n65536fifisourceetcprofile创建安装目录 切换到oracle用户,设置oracle用户的环境变量suoraclevim。bashprofileexportORACLEBASEu01apporacleexportORACLEHOMEORACLEBASEproduct11。2。0exportPATHORACLEHOMEbin:PATHexportORACLESIDdbsrv2exportLANGamericanamerica。ZHS16GBKexportLDLIBRARYPATHORACLEHONElibaliasoratracecdORACLEBASEdiagrdbmsORACLESIDORACLESIDtracelsgrepalertaliasoradatacdu01apporacledbsrv2aliastopcpseopcpu,pid,user,tty,argssortk1rheadaliastopmpseopmem,pid,user,tty,argssortk1rheadsource。bashprofile上传oracle安装包,编辑静默安装响应文件vimhomeoracledatabaseresponsedbinstall。rsporacle。install。optionINSTALLDBSWONLY29行,安装类型ORACLEHOSTNAMElinux239行,主机名UNIXGROUPNAMEoinstall42行,安装组INVENTORYLOCATIONu01apporacleinventory47行,inventory目录,不填就是默认值SELECTEDLANGUAGESen,zhCN78行,选择语言ORACLEHOMEu01apporacleproduct11。2。083行,oraclehomeORACLEBASEu01apporacle88行,oraclebaseoracle。install。db。InstallEditionEE99行,oracle版本oracle。install。db。isCustomInstallfalse108行,自定义安装,否则使用默认组件oracle。install。db。DBAGROUPdba142行oracle。install。db。OPERGROUPdba147行oracle。install。db。config。starterdb。typeGENERALPURPOSE160行,数据库类型oracle。install。db。config。starterdb。globalDBNameorcl165行oracle。install。db。config。starterdb。SIDdbsrv2170行DECLINESECURITYUPDATEStrue根据响应文件安装oracle11g。runInstallersilentignorePrereqignoreSysPrereqsresponseFilehomeoracledatabaseresponsedbinstall。rsp 开始oracle在后台静默安装,安装过程中,如果提示WARNING不必理会,此时安装程序仍在后台进行,如果出现FATAL,则安装程序停止。 出现以上界面,说明安装程序正在后台运行,打开另一个终端查看日志: tailfu01apporacleinventorylogsinstallActions20180608032816PM。log 看到如下部分,则表明安装已经完成: 完成安装后,切换到root用户执行两个脚本: 用oracle用户登录配置监听 出现以下情况时,需要配置DISPLAY变量,配置完成后在重新netca 成功运行后,在会u01apporacleproduct11。2。0networkadmin目录下生成listener。ora和sqlnet。ora两个文件: 查看监听端口: 创建新库,同时建立对应的实例: 〔oraclelinux2〕vimhomeoracledatabaseresponsedbca。rsp 修改以下参数: GDBNAMEorcl78行 SIDorcl149行 SYSPASSWORDoracle SYSTEMPASSWORDoracle SYSMANPASSWORDoracle DBSNMPPASSWORDoracle DATAFILEDESTINATIONu01apporacleoradata RECOVERYAREADESTINATIONu01apporaclefastrecoveryarea CHARACTERSETZHS16GBK TOTALMEMORY1638 进行静默配置: 〔oraclelinux2〕dbcasilentresponseFilehomeoracledatabaseresponsedbca。rsp 完成建库后进行实例检查: 查看监听状态: 登录查看实例状态: 启动数据库: 解决方法: 重启启动数据库