ORACLE11g 静默安装单实例

ORACLE11g 静默安装单实例

1.关闭selinux 关闭防火墙 修改hosts
systemctl stop firewalld
systemctl disable firewalld

2.安装依赖
yum -y install gcc make binutils gcc-c++ compat-libstdc+±33 elfutils-libelf-devel elfutils-libelf-devel-static ksh libaio libaio-devel numactl-devel sysstat unixODBC unixODBC-devel pcre-devel

检查依赖：
rpm -q
binutils
compat-libstdc+±33
elfutils-libelf
elfutils-libelf-devel
expat
gcc
gcc-c++
glibc
glibc-common
glibc-devel
glibc-headers
libaio
libaio-devel
libgcc
libstdc++
libstdc+±devel
make
pdksh
sysstat
unixODBC
unixODBC-devel | grep “not installed”

下载pdksh
wget -O /tmp/pdksh-5.2.14-37.el5_8.1.x86_64.rpm http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm

3.创建用户
添加oinstall 、dba 组，新建oracle用户并加入oinstall、dba组中
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle

4.修改内核参数：

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 25501368320
kernel.shmmax = 102005473280
kernel.shmmni = 4096
kernel.sem = 1024 32000 150 150
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
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304

kernel.shmmax >SGA102410241024
kernel.shmall = kernel.shmmax/4
fs.file-max = 512process
kernel.sem = SEMMSL processes参数设置较大的系统建议设置为processes+10 | SEMMNS 最小32000 或者SEMMSL * SEMMNI |SEMOPM 至少100；或者等于SEMMSL | SEMMNI 最少128

生效
sysctl -p

5.修改用户的限制文件
vi /etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

修改/etc/pam.d/login文件
添加：

#session required /lib64/security/pam_limits.so

/etc/systemd/logind.conf文件中RemoveIPC=yes明确设置为RemoveIPC=no，不带注释
重启服务器或重启systemd-logind
重启systemd-logind：
systemctl daemon-reload
systemctl restart systemd-logind

6 环境变量
/home/oracle/
vi .bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACL{E}_{B}ASE/product/11.2.0/d{b}_{1}exportORACL{E}_{S}ID=etldataxexportNL{S}_{L}ANG="SIMPLIFIEDCHINES{E}_{C}HINA.ZHS16GBK"exportPATH=$PATH:KaTeX parse error: Expected 'EOF', got '#' at position 17: …RACLE_HOME/bin #̲建议加上 export LD_…ORACLE_HOME/lib:/lib/:/lib64:/usr/lib:/usr/lib64
export NLS_DATE_FORMAT=‘yyyy-mm-dd hh24:mi:ss’

生效
source /home/oracle/.bash_profile

7.创建安装目录、修改文件权限
mkdir -p /u01/app/oracle/product/11.2.0

mkdir /u01/app/oracle/oradata

mkdir /u01/app/oracle/inventory

mkdir /u01/app/oracle/fast_recovery_area

chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01/app/oracle

8 编辑静默安装响应文件，可以替换下面文件，修改ORACLE_HOSTNAME为主机名称
数据库安装目录下 database/response/db_install.rsp
修改对应参数

oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=localhost
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/app/oracle/product/11.2.0
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true

9 安装数据库监听
oralce用户执行
./runInstaller -silent -force -ignorePrereq -responseFile /data/software/oracle/database/response/db_install.rsp

出现提示后用root用户执行脚本；
As a root user, execute the following script(s):
1. /u01/app/oracle/inventory/orainstRoot.sh
2. /u01/app/oracle/product/11.2.0/root.sh

切换oralce执行
netca -silent -responseFile /data/software/oracle/database/response/netca.rsp

root用户查看监听端口： netstat -tnulp | grep 1521

10.建立新库和实例

vi /data/software/oracle/database/response/dbca.rsp

修改参数
GDBNAME = “etldatax”
SID = “etldatax”
SYSPASSWORD = “”
SYSTEMPASSWORD = “”
SYSMANPASSWORD = “”
DBSNMPPASSWORD = “”
DATAFILEDESTINATION =/u01/app/oracle/oradata
RECOVERYAREADESTINATION=/u01/app/oracle/fast_recovery_area
CHARACTERSET = “ZHS16GBK”
TOTALMEMORY = “1638”

建库
dbca -silent -responseFile /data/software/oracle/database/response/dbca.rsp

11.调整参数
alter system set processes = 600 scope = spfile;–修改连接池大小
alter system set session = 300 scope = spfile;–修改连接池大小
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ; —密码过期限制

其他配置略
停用闪回区
设置数据库归档并更改归档目录
为数据库日志组添加成员
select * from v$logfile;
alter database add logfile member ‘/u01/arch/arch/redo0102.log’ to group 1;
alter system switch logfile;
为数据库控制文件做冗余

更改sga pga