Centos下Oracle11gR2安装教程与自动化配置脚本的方法(2)-木庄网络博客

[Prerequisite Checks] Next

[Summary] Finish，开始安装oracle 11g

安装到84%的时候可能会出现ins_ctx.mk相关的错误，如下

修改/u01/app/oracle/product/11.2.0/db_1/ctx/lib/ins_ctx.mk文件

# 源文件
ctxhx: $(CTXHXOBJ)
    $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK)
# 修改为
ctxhx: $(CTXHXOBJ)
    -static $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK) /usr/lib64/stdc.a

修改/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk文件

# 源文件
$(SYSMANBIN)emdctl:
    $(MK_EMAGENT_NMECTL)
# 修改为
$(SYSMANBIN)emdctl:
    $(MK_EMAGENT_NMECTL) -lnnz11

retry继续安装到94%时，弹出

使用root用户ssh到主机到上述目录分别执行orainstRoot.sh与root.sh，执行root.sh时根据提示填入路径

/u01/app/oracle/product/11.2.0/dbhome_1/bin，执行完成后到UI点击OK，安装完成

环境配置脚本

使用root用户登录
确保系统iso驱动器已连接（/dev/cdrom可mount）
复制脚本到主机并给予可执行权限，执行脚本完成后即可开始安装oracle 11g

oracle 11g环境配置脚本

#!/bin/bash

# 配置yum源为本地iso
function set_yum_media() {
  cd /etc/yum.repos.d/
  for repo_file in `ls /etc/yum.repos.d/ | grep -v Media`
  do
    new_file=$repo_file.bak
    mv $repo_file $new_file
  done
  mkdir -p /mnt/media-dir
  mount /dev/cdrom /mnt/media-dir
  sed -i -e 's/baseurl=file:\/\/\/.*/baseurl=file:\/\/\/mnt\/media-dir\//g' -e 's/enabled=0/enabled=1/g' `ls /etc/yum.repos.d/ | grep Media`
  cd -
	rm -rf /var/run/yum.pid
  yum -y update
}

function install_packages() {
  for package in glibc glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh compat-libcap1  compat-libstdc++ elfutils-libelf-devel gcc-c++
  do
    yum -y install $package
  done
}

function create_oracle_user() {
	groupadd oinstall
	groupadd dba
	useradd -g oinstall -G dba oracle
	# 设置oracle用户密码为oracle
	echo oracle|passwd --stdin oracle
}

function set_system_parm() {
	sed -i '$a\fs.aio-max-nr = 1048576' /etc/sysctl.conf
	sed -i '$a\fs.file-max = 6815744' /etc/sysctl.conf
	sed -i '$a\kernel.shmall = 2097152' /etc/sysctl.conf
	sed -i '$a\kernel.shmmax = 536870912' /etc/sysctl.conf
	sed -i '$a\kernel.shmmni = 4096' /etc/sysctl.conf
	sed -i '$a\kernel.sem = 250 32000 100 128' /etc/sysctl.conf
	sed -i '$a\net.ipv4.ip_local_port_range = 9000 65500' /etc/sysctl.conf
	sed -i '$a\net.core.rmem_default = 262144' /etc/sysctl.conf
	sed -i '$a\net.core.rmem_max = 4194304' /etc/sysctl.conf
	sed -i '$a\net.core.wmem_default = 262144' /etc/sysctl.conf
	sed -i '$a\net.core.wmem_max = 1048586' /etc/sysctl.conf
	sysctl -p
}

function set_system_limit_parm() {
	sed -i '$a\oracle		soft		nproc		2048' /etc/security/limits.conf
	sed -i '$a\oracle		hard		nproc		16384' /etc/security/limits.conf
	sed -i '$a\oracle		soft		nofile		1024' /etc/security/limits.conf
	sed -i '$a\oracle		hard		nofile		65536' /etc/security/limits.conf
	sed -i '$a\oracle		soft		stack		10240' /etc/security/limits.conf
}

function set_profile_parm() {
	sed -i '$a\session required  pam_limits.so' /etc/pam.d/login
	sed -i '$a\if [[ $USER = "oracle" ]]; then' /etc/profile
	sed -i '$a\  if [[ $SHELL = "/bin/ksh" ]]; then' /etc/profile
	sed -i '$a\    ulimit -p 16384' /etc/profile
	sed -i '$a\    ulimit -n 65536' /etc/profile
	sed -i '$a\  else' /etc/profile
	sed -i '$a\    ulimit -u 16384 -n 65536' /etc/profile
	sed -i '$a\  fi' /etc/profile
	sed -i '$a\fi' /etc/profile
	source /etc/profile
}

function set_oracle_env() {
	sed -i '$a\export ORACLE_BASE=/u01/app/oracle' /home/oracle/.bash_profile
	sed -i '$a\export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1' /home/oracle/.bash_profile
	sed -i '$a\export ORACLE_SID=orcl' /home/oracle/.bash_profile
	sed -i '$a\export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$PATH' /home/oracle/.bash_profile
	sed -i '$a\export LANG="en_US.UTF-8"' /home/oracle/.bash_profile
	sed -i '$a\export NLS_LANG=american_AMERICA.UTF8' /home/oracle/.bash_profile
	sed -i '$a\export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"' /home/oracle/.bash_profile
	source /home/oracle/.bash_profile
}

function create_oracle_dir() {
	mkdir -p /u01/app/oracle/product/11.2.0/db_1
	chown -R oracle:oinstall /u01/app
	chmod -R 775 /u01/app
}

function disable_firewall() {
	systemctl stop firewalld.service
	systemctl disable firewalld.service
	sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/sysconfig/selinux
	setenforce 0
}

if [ `whoami` == "root" ]
then
	set_yum_media
	install_packages
	create_oracle_user
	echo "set system parm"
	set_system_parm
	echo "set limits"
	set_system_limit_parm
	echo "set /etc/profile"
	set_profile_parm
	echo "set oracle env"
	set_oracle_env
	echo "create oracle dir"
	create_oracle_dir
	echo "disable firwall"
	disable_firewall
fi

到此这篇关于Centos下Oracle11gR2安装教程与自动化配置脚本的方法的文章就介绍到这了,更多相关Oracle11gR2安装与自动化配置内容请搜索

标签：Oracle

返回前面的内容