Oracle静默安装详细教程，oracle静默教程

Oracle静默安装详细教程，oracle静默教程

环境Centos7 mini：内存2G，oracle 12.2.0.1，VM虚拟机下

联网

# vi /etc/sysconfig/network-scripts/ifcfg-ens33

TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=ens33
UUID=5452944f-bc02-4ffd-aaae-8f6025c52643
DEVICE=ens33
ONBOOT=yes

DNS1=114.114.114.114
IPADDR=192.168.2.50
PREFIX=24
GATEWAY=192.168.2.1
PEERDNS=no 

重启网路连接

# service network restart

测试下

# ping baidu.com

编辑hosts文件

# vi /etc/hosts

添加一行

192.168.2.50 centos7

测试下

ping centos7

准备

更新下系统软件

# yum -y update

配置/etc/sysctl.conf

# vi /etc/sysctl.conf

内容如下

fs.file-max = 6815744  
kernel.sem = 250 32000 100 128  
kernel.shmmni = 4096  
kernel.shmall = 1073741824  
kernel.shmmax = 4398046511104  
kernel.panic_on_oops = 1  
net.core.rmem_default = 262144  
net.core.rmem_max = 4194304  
net.core.wmem_default = 262144  
net.core.wmem_max = 1048576  
net.ipv4.conf.all.rp_filter = 2  
net.ipv4.conf.default.rp_filter = 2  
fs.aio-max-nr = 1048576  
net.ipv4.ip_local_port_range = 9000 65500  

使配置生效

# /sbin/sysctl -p

配置/etc/security/limits.d/20-nproc.conf

追加内容如下

oracle   soft   nofile    1024  
oracle   hard   nofile    65536  
oracle   soft   nproc    16384  
oracle   hard   nproc    16384  
oracle   soft   stack    10240  
oracle   hard   stack    32768  
oracle   hard   memlock    134217728  
oracle   soft   memlock    134217728  

安装zip和unzip

# yum install zip unzip

安装依赖

yum install -y binutils \
compat-libcap1 \
compat-libstdc++-33 \
compat-libstdc++-33.i686 \
glibc \
glibc.i686 \
glibc-devel \
glibc-devel.i686 \
ksh \
libaio \
libaio.i686 \
libaio-devel \
libaio-devel.i686 \
libX11 \
libX11.i686 \
libXau \
libXau.i686 \
libXi \
libXi.i686 \
libXtst \
libXtst.i686 \
libgcc \
libgcc.i686 \
libstdc++ \
libstdc++.i686 \
libstdc++-devel \
libstdc++-devel.i686 \
libxcb \
libxcb.i686 \
make \
nfs-utils \
net-tools \
smartmontools \
sysstat \
unixODBC \
unixODBC-devel  
 gcc \
 gcc-c++ \
 libXext \
 libXext.i686 \
 zlib-devel \
 zlib-devel.i686

创建用户和用户组

# groupadd -g 1001  oinstall
# groupadd -g 1002 dba 
# groupadd -g 1003 oper
# useradd -u 1001 -g oinstall -G dba,oper oracle
# passwd oracle

关闭防火墙及selinux

# vi /etc/selinux/config

SELINUX=disabled

# systemctl stop firewalld
# systemctl disable firewalld

创建目录修改权限

# mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
# chown -R oracle:oinstall /u01
# chmod 775 /u01

#配置oracle环境变量

#  vi /home/oracle/.bash_profile

内容如下

        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

# Oracle Settings
export TMP=/tmp  
export TMPDIR=$TMP  
  
export ORACLE_HOSTNAME=centos7  
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle  
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1  
export ORACLE_SID=orcl
  
export PATH=/usr/sbin:$PATH  
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 

重启，切换oracle用户

# reboot

解压

 unzip linuxx64_12201_database.zip

安装

编辑应答文件

vi database/response/db_install.rsp

修改内容如下：

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0  
oracle.install.option=INSTALL_DB_SWONLY  
UNIX_GROUP_NAME=oinstall  
INVENTORY_LOCATION=/u01/app/oracle/oraInventory  
ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/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  
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE  
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8  
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false  
DECLINE_SECURITY_UPDATES=true 

安装[注意应答文件需要绝对路径]

$ ./runInstaller -force -silent -noconfig -responseFile /home/oracle/database/response/db_install.rsp

使用root用户组执行脚本

# /u01/app/oracle/oraInventory/orainstRoot.sh

# /u01/app/oracle/product/12.2.0.1/db_1/root.sh

添加监听

 cat netca.rsp | grep -Ev "^#|^$"

netca -silent -responsefile /home/oracle/database/response/netca.rsp

查看监听状态

$ lsnrctl status

创建数据库

修改文件/home/oracle/database/response/dbca.rsp

内容如下

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0  
gdbName=orcl 
sid=orcl
databaseConfigType=SI  
RACOneNodeServiceName=  
policyManaged=false  
createServerPool=false  
serverPoolName=  
cardinality=  
force=false  
pqPoolName=  
pqCardinality=  
createAsContainerDatabase=true  
numberOfPDBs=1  
pdbName=cdb1pdb  
useLocalUndoForPDBs=true  
pdbAdminPassword=  
nodelist=  
templateName=/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/General_Purpose.dbc  
sysPassword=  
systemPassword=  
serviceUserPassword=  
emConfiguration=  
emExpressPort=5500  
runCVUChecks=false  
dbsnmpPassword=  
omsHost=  
omsPort=0  
emUser=  
emPassword=  
dvConfiguration=false  
dvUserName=  
dvUserPassword=  
dvAccountManagerName=  
dvAccountManagerPassword=  
olsConfiguration=false  
datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/  
datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/  
recoveryAreaDestination={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}  
storageType=FS  
diskGroupName=  
asmsnmpPassword=  
recoveryGroupName=  
characterSet=AL32UTF8  
nationalCharacterSet=AL16UTF16  
registerWithDirService=false  
dirServiceUserName=  
dirServicePassword=  
walletPassword=  
listeners=LISTENER  
variablesFile=  
variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1,SID=orcl  
initParams=undo_tablespace=UNDOTBS1,memory_target=796MB,processes=300,db_recovery_file_dest_size=2780MB,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_recovery_file_dest={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME},db_block_size=8192BYTES,diagnostic_dest={ORACLE_BASE},audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,nls_territory=AMERICA,local_listener=LISTENER_ORCL,compatible=12.2.0,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl"),db_name=orcl,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,open_cursors=300  
sampleSchema=false  
memoryPercentage=40  
databaseType=MULTIPURPOSE  
automaticMemoryManagement=true  
totalMemory=0  

中间需要输入密码

$ dbca -silent -createDatabase  -responseFile  /home/oracle/database/response/dbca.rsp

登录

sqlplus / as sysdba

查看数据库状态

select open_mode from v$database;

安装完成