centos7安装oracle11g r2数据库

1、Oracle 11g r2下载

可以在Oracle 官网下载Oracle 11g r2数据库：

http://www.oracle.com/technetwork/database/enterpriseedition/downloads/index.html

2、将下载下来的安装包存放在/opt目录

3、获取主机名和IP地址

IPP=`ifconfig -a|grep inet|grep -v 127.0.0.1|grep -v inet6|grep -v 192.168.122.1|awk '{print $2}'|tr -d "addr:"`
HN=`hostnamectl status | grep "Static hostname" | cut -d : -f2`

4、更改hosts文件配置

echo $IPP    $HN >> /etc/hosts
echo "HOSTNAME=$HN">> /etc/sysconfig/network

5、停止防火墙和selinux

systemctl stop firewalld
systemctl disable firewalld
setenforce 0
sed  -i  s#SELINUX=enforcing#SELINUX=disabled#   /etc/selinux/config

6、修改内核参数sysctl.conf

echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
echo "kernel.shmmax = 4294967295" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 1048576" >> /etc/sysctl.conf
sysctl  -p

7、修改用户pamd权限

echo "oracle        soft    nproc           2047" >> /etc/security/limits.conf
echo "oracle        hard    nproc           16384" >> /etc/security/limits.conf
echo "oracle        soft    nofile           4096" >> /etc/security/limits.conf
echo "oracle        hard    nofile           65536" >> /etc/security/limits.conf
echo "session  required  /lib64/security/pam_limits.so" >> /etc/pam.d/login
echo "session  required  pam_limits.so" >> /etc/pam.d/login

8、修改环境变量

1 if [ $USER = "oracle" ];then
2    if [ $SHELL = "/bin/ksh" ];then
3        ulimit -p 16384
4        ulimit -p 65536
5    else
6      ulimit -u 16384 -n 65536
7    fi
8 fi

9、安装依赖包

yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh compat-libcap1 oracleasm-support readline  readline-devel ld-linux.so.2  libXp.so.6  libXt.so.6  libXtst.so.6  compat-db

10、创建组(oinstall,dba)、用户(oracle) 以及用户密码

1 groupadd  oinstall
2 groupadd  dba
3 useradd  -g  oinstall  -G  dba     -d  /home/oracle   oracle
4 echo "oracle" | passwd --stdin oracle

11、创建Oracle数据库相关目录并赋予权限

1 mkdir  -p  /u01/app/o    racle/product/11.2.0.4
2 mkdir  -p  /home/{OracleData,OracleArch,OracleBackup}
3 mkdir  -p  /home/{OracleData,OracleArch/ArchiveLog,OracleBack/{rmanbak,expdpbak,ArchiveLogBak}}
4 chown  -R  oracle:oinstall  /u01/app/   /home/Oracle*
5 chmod  -R  775  /u01/app/   /home/Oracle*

12、修改oracle用户环境变量

 1 export TMP=/tmp
 2 export TMPDIR=$TMP
 3 export ORACLE_BASE=/u01/app/oracle
 4 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
 5 export EDITOR=/usr/bin/vim
 6 export ORACLE_SID=zytk35
 7 export PATH=$ORACLE_HOME/bin:/usr/bin:$PATH
 8 export PATH=$PATH:/usr/bin/:/bin:/usr/bin/X11:/usr/local/bin
 9 export PATH=$PATH:$ORACLE_BASE/common/oracle/bin
10 export ORACLE_TERM=xterm
11 export TNS_ADMIN=$ORACLE_HOME/network/admin
12 export ORA_NLS10=$ORACLE_HOME/nls/data
13 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib
14 export LIBPATH=$LIBPATH:$ORA_CRS_HOME/lib:$ORACLE_HOME/lib
15 export CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/JRE
16 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

source  ~/.bash_profile

13、进入/opt目录解压下载的oracle安装包

1 unzip /opt/p13390677_112040_Linux-x86-64_1of7.zip -d /opt

2 unzip /opt/p13390677_112040_Linux-x86-64_2of7.zip -d /opt

从此处兵分两路，可以选择图形化安装也可以选择静默安装

一）图形化安装的前提是系统安装了图形化桌面

此处省略1千字

二）静默安装的原因是系统最小化安装没有桌面

1、复制响应文件模板

1 su – root
3 cd /home/oracle/
5 mkdir etc
7 cp /home/oracle/database/response/* /home/oracle/etc/
9 chmod 777 /home/oracle/etc/*.rsp

2、安装前的配置，先配置好主机名修改db_install.rsp

 1 su – oracle
 2 
 3 vim /home/oracle/etc/db_install.rsp
 4 oracle.install.option=INSTALL_DB_SWONLY
 5 ORACLE_HOSTNAME=cib129
 6 UNIX_GROUP_NAME=oinstall
 7 INVENTORY_LOCATION=/u01/app/oracle/oraInventory
 8 SELECTED_LANGUAGES=en,zh_CN,zh_TW
 9 ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
10 ORACLE_BASE=/u01/app/oracle
11 oracle.install.db.InstallEdition=EE
12 oracle.install.db.isCustomInstall=true
13 oracle.install.db.DBA_GROUP=dba
14 oracle.install.db.OPER_GROUP=oinstall
15 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
16 oracle.install.db.config.starterdb.globalDBName=orcl
17 oracle.install.db.config.starterdb.SID=orcl
18 oracle.install.db.config.starterdb.memoryLimit=512
19 oracle.install.db.config.starterdb.password.ALL=oracle
20 DECLINE_SECURITY_UPDATES=true

3、开始安装

1 ./runInstaller -silent -force -responseFile /home/oracle/etc/db_install.rsp -ignorePrereq

cd $ORACLE_BASE/oraInventory/logs

tail -100f installActions*.log    查看安装日志是否有报错信息，如上截图表示安装成功

su root/u01/app/oracle/product/11.2.0/db_1/root.sh           执行脚本

4、修改oracle环境变量可以参考第二步

 1 su - oracle
 2 vi ~/.bash_profile
 3 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
 4 export TNS_ADMIN=$ORACLE_HOME/network/admin
 5 export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
 6 export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
 7 export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
 8 export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
 9 export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
10 export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE
11 export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE/lib
12 export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
13 export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
14 export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
15 export LIBPATH=${CLASSPATH}:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
16 export ORACLE_OWNER=oracle
17 export SPFILE_PATH=$ORACLE_HOME/dbs
18 export ORA_NLS10=$ORACLE_HOME/nls/data
19 使环境变量生效   source /home/oracle/.bash_profile

5、配置网络

$ORACLE_HOME/bin/netca /silent /responseFile /home/oracle/etc/netca.rsp

6、安装数据库

 1 vim /home/oracle/etc/dbca.rsp
 2 
 3 GDBNAME="orcl.ruo" 
 4 SID="orcl"
 5 SYSPASSWORD = "oracle" 
 6 SYSTEMPASSWORD = "oracle" 
 7 CHARACTERSET="AL32UTF8" 
 8 NATIONALCHARACTERSET="UTF8"
 9 配置好以后执行下面命令：
10 $ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/etc/dbca.rsp
11 执行如下，进度100% 没报错，表示安装成功：

posted @ 2022-01-25 22:22 阿杜杜杜阅读(324) 评论(0) 收藏举报

刷新页面返回顶部

centos7安装oracle11g r2数据库

公告