oracle软件静默安装程序,Oracle 12C R2单实例静默安装

ゞ浴缸里的玫瑰 2023-01-18 02:24 96阅读 0赞

Oracle 12C R2 单实例静默安装

一、数据库安装

1、禁用SELINUX

vi /etc/selinux/config

SELINUX=disabled

让SELINUX生效：

setenforce 0

2、关闭防火墙

EL6关闭firewall防火墙

chkconfig iptables off

EL7关闭firewall防火墙

chkconfig firewalld off

service firewalld stop

centos7 命令 systemctl stop firewalld 临时停止

centos7 命令 systemctl disabled firewalld 永久

3、依赖包安装

EL6

yum install -y binutils

yum install -y compat-libcap1

yum install -y compat-libstdc++

yum install -y e2fsprogs

yum install -y e2fsprogs-libs

yum install -y glibc

yum install -y glibc-devel

yum install -y ksh

yum install -y libgcc

yum install -y libstdc++

yum install -y libstdc++-devel

yum install -y libaio

yum install -y libaio-devel

yum install -y libXtst

yum install -y libX11

yum install -y libXau

yum install -y libxcb

yum install -y libXi

yum install -y make

yum install -y sysstat

yum install -y smartmontools

EL7

yum install -y binutilscompat-libcap1

yum install -y compat-libstdc++-33

yum install -y compat-libstdc++-33.i686

yum install -y gcc

yum install -y gcc-c++

yum install -y glibc

yum install -y glibc.i686

yum install -y glibc-develglibc-devel.i686

yum install -y ksh

yum install -y libgcc

yum install -y libgcc.i686

yum install -y libstdc++

yum install -y libstdc++.i686

yum install -y libstdc++-devel

yum install -y libstdc++-devel.i686

yum install -y libaiolibaio.i686

yum install -y libaio-devel

yum install -y libaio-devel.i686

yum install -y libXext

yum install -y libXext.i686

yum install -y libXtst

yum install -y libXtst.i686

yum install -y libX11libX11.i686

yum install -y libXau

yum install -y libXau.i686

yum install -y libxcb

yum install -y libxcb.i686

yum install -y libXi

yum install -y libXi.i686

yum install -y make

yum install -y sysstat

yum install -y unixODBCunixODBC-devel

yum install -y readline

yum install -y libtermcap-devel

yum install -y pdksh

yum install -y compat-libcap1

yum install -y smartmontools

4、增加oracle用户以及组

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba,oper oracle

passwd oracle

5、创建oracle目录结构

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01

chmod -R 775 /u01

6、修改/etc/security/limits.d/20-nproc.conf文件内容

EL6为90-nproc.conf

as described below. See MOS Note \[ID 1487773.1\]

vi /etc/security/limits.d/20-nproc.conf

\# Change this

\#注释这行\* soft nproc 1024

\# To this增加下面一行

\* - nproc 16384

7、修改/etc/security/limits.conf文件，增加内容如下：

vi /etc/security/limits.conf

\#ORACLE SETTING

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

8、修改/etc/pam.d/login文件

vi /etc/pam.d/login

\#ORACLE SETTING

session required pam\_limits.so

9、修改sysctl.conf配置文件

vi /etc/sysctl.conf

\#ORACLE SETTING

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmax = 15461882265

kernel.shmall = 3774873

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 = 1048586

\--16G 内存配置如上

\--\#kernel.shmmax = 2147483648

(大于SGA，小于物理内存，物理内存\*0.9\*1024MB\*1024KB\*1024B)

\--\#kernel.shmall = 524288 (物理内存/4K)

如果以上参数设置不正确，可能导致以下报错：

ORA-27102: out of memory Linux-X86\_64 Error: 28: No space left on device .

sysctl -p 让配置生效

10、修改oracle用户环境变量

vi ~/.bash\_profile

export TMP=/tmp

export LANG=en\_US

export TMPDIR=$TMP

export ORACLE\_HOSTNAME='orcldb'

export ORACLE\_UNQNAME='orcldb'

ORACLE\_BASE=/u01/app/oracle; export ORACLE\_BASE

ORACLE\_HOME=$ORACLE\_BASE/product/12.2.0/db\_1; export ORACLE\_HOME

ORACLE\_SID=orcl; export ORACLE\_SID

ORACLE\_TERM=xterm; export ORACLE\_TERM

NLS\_DATE\_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS\_DATE\_FORMAT

NLS\_LANG=AMERICAN\_AMERICA.ZHS16GBK;export NLS\_LANG

PATH=.:$PATH:$HOME/bin:$ORACLE\_BASE/product/12.2.0/db\_1/bin:$ORACLE\_HOME/bin; export PATH

THREADS\_FLAG=native; export THREADS\_FLAG

if \[ $USER = "oracle" \] || \[ $USER = "grid" \]; then

if \[ $SHELL = "/bin/ksh" \]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

umask 022

sourece ~/.bash\_profile

env |grep ORA

11、解压数据库软件

unzip linuxx64\_12201\_database.zip

12、静默安装数据库软件：

修改响应文件

vi /opt/ora\_soft/database/response/db\_install.rsp

如下字段修改：

oracle.install.option=INSTALL\_DB\_SWONLY

UNIX\_GROUP\_NAME=oinstall

INVENTORY\_LOCATION=/u01/app/oraInventory

ORACLE\_HOME=/u01/app/oracle/product/12.2.0/db\_1

ORACLE\_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA\_GROUP=dba

oracle.install.db.OSOPER\_GROUP=oper

oracle.install.db.OSBACKUPDBA\_GROUP=dba

oracle.install.db.OSDGDBA\_GROUP=dba

oracle.install.db.OSKMDBA\_GROUP=dba

oracle.install.db.OSRACDBA\_GROUP=dba

使用静默命令手动执行数据库软件安装

./runInstaller -silent –responseFile /opt/ora\_soft/database/response/db\_install.rsp

忽略先决条件

./runInstaller -silent –responseFile /opt/ora\_soft/database/response/db\_install.rsp –ignorePrereq

安装过程中的log可查看失败列表

End of failed Tasks List

13、静默配置监听

vi /opt/ora\_soft/database/response/netca.rsp

修改以下内容

INSTALL\_TYPE=""typical""

手动执行静默命令：

netca -silent -responsefile /u01/app/netca.rsp

lsnrctl status

14、静默安装实例

vi /opt/ora\_soft/database/response/dbca.rsp

修改如下配置：

gdbName = "orcl"

sid = "orcl"

templateName =General\_Purpose.dbc

characterSet =ZHS16GBK

automaticMemoryManagement = "TRUE"

totalMemory = "4196"

createAsContainerDatabase=true \#如果是作为容器数据库此项需要设置为true

手动执行静默命令：

dbca -silent -createDatabase -responseFile /opt/ora\_soft/database/response/dbca.rsp

二、可选系统参数修改

1、增加swap 增加1g

\# dd if=/dev/zero of=/root/swapfile bs=1M count=1024

\# mkswap /root/swapfile

\# swapon /root/swapfile

加入开机自启

\#vi /etc/fstab

/root/swapfile swap swap defaults 0 0

2、修改共享内存大小

解决方法：

例如：为了将/dev/shm的大小增加到1GB，修改/etc/fstab的这行：默认的

none /dev/shm tmpfs defaults 0 0

改成：

none /dev/shm tmpfs defaults,size=2048m 0 0

size参数也可以用G做单位：size=2G

重新mount /dev/shm 生效

命令：mount -o remount /dev/shm

或者

umount /dev/shm

mount -a

核查可以用df -h查看shm大小

oracle软件静默安装程序,Oracle 12C R2单实例静默安装

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 11 G2oracle数据库安装,oracle 11.2R2 数据库静默安装

相关 oracle软件静默安装程序,Oracle 12C R2单实例静默安装

相关 CentOS7.3静默安装Oracle12C

相关 oracle静默规范安装

相关使用CentOS 7.x 静默安装 Oracle 12c r2

相关 Oracle静默安装

相关 centos7 oracle12c静默安装

相关 Centos7静默安装Oracle12c

相关 CentOS静默安装Oracle12c详细过程

相关 CentOS静默安装Oracle