centos7系统 oracle 12c r2静默安装

访问量:1818 创建时间:2020-03-04

安装前准备

下载安装包：linuxx64_12201_database.zip
配置swap

[root@localhost ~]# dd if=/dev/zero of=/tmp/mem.swap bs=1M count=4096
[root@localhost ~]# /sbin/mkswap /tmp/mem.swap
[root@localhost ~]#  /sbin/swapon /tmp/mem.swap

配置hosts文件，添加一行记录，ip为本机IP地址

[oracle@localhost ~]$ vim /etc/hosts
192.168.117.128 oracledb
[oracle@localhost ~]$ hostnamectl set-hostname oracledb

关闭防火墙

[root@localhost ~]# systemctl stop firewalld.service
[root@localhost ~]# systemctl disable firewalld.service

关闭selinux

[root@localhost ~]# setenforce 0
setenforce: SELinux is disabled
[root@localhost ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

安装依赖的库

[root@localhost ~]# yum -y install rlwrap binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33  gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libXi libXi*.i686 libXtst sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686

修改系统内核参数

[root@localhost ~]# cat >> /etc/sysctl.conf << EOF
# oracle install configured
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
EOF
[root@localhost ~]# sysctl -p

修改系统limit限制

[root@localhost ~]# cat >> /etc/security/limits.conf << EOF
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
EOF

修改环境变量配置

[root@localhost ~]# vim /etc/profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=oracledb
export ORACLE_UNQNAME=oral
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=oral
export PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
[root@localhost ~]# source /etc/profile

添加oracle用户

[root@localhost ~]# groupadd -g 54321 oinstall
[root@localhost ~]# groupadd -g 54322 dba
[root@localhost ~]# groupadd -g 54323 oper
[root@localhost ~]# useradd -u 54321 -g oinstall -G dba,oper oracle

[root@localhost ~]# mkdir -pv /u01/app/oracle/oradata
[root@localhost ~]# chmod -R 775 /u01
[root@localhost ~]# chown -R oracle:oinstall /u01

配置oracle用户环境变量

[root@localhost ~]# vim /home/oracle/.bash_profile 
####
alias sqlplus='rlwrap sqlplus'
alias ggsci='rlwrap ggsci'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'

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

开始安装

解压

mv linuxx64_12201_database.zip /u01/
cd /u01/
unzip linuxx64_12201_database.zip 
chown -R oracle:oinstall  /u01/

配置数据库服务安装应答文件

cat /u01/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/oralnventory
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.rac.configurationType=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.rac.serverpoolName=
oracle.install.db.rac.serverpoolCardinality=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=oral
oracle.install.db.config.starterdb.SID=oral
oracle.install.db.ConfigureAsContainerDB=
oracle.install.db.config.PDBName=
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=
oracle.install.db.config.starterdb.password.ALL=oracle@pwd
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.password.PDBADMIN=
oracle.install.db.config.starterdb.managementOption=
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
COLLECTOR_SUPPORTHUB_URL=

切换用户安装,安装成功后切换到root用户执行2个脚本

[root@localhost ~]# su - oracle
[oracle@oracledb ~]$ cd /u01/database
[oracle@oracledb database]$ ./runInstaller -force -silent -responseFile /u01/database/response/db_install.rsp
 ...省略部分输出...
    1. /u01/app/oracle/oralnventory/orainstRoot.sh
    2. /u01/app/oracle/product/12.2.0.1/db_1/root.sh
[oracle@oracledb database]$ exit
[root@oracledb ~]# /u01/app/oracle/oralnventory/orainstRoot.sh
[root@oracledb ~]# /u01/app/oracle/product/12.2.0.1/db_1/root.sh

配置网络

[root@oracledb ~]# su - oracle
[oracle@oracledb ~]$ netca -silent -responsefile /u01/database/response/netca.rsp 
[oracle@oracledb ~]$ lsnrctl start
[oracle@oracledb ~]$ lsnrctl status

安装数据库

[root@oracledb ~]# cat /u01/database/response/dbca.rsp | egrep -v '^#|^$'
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=oral
sid=oral
databaseConfigType=SI
RACOneNodeServiceName=
policyManaged=false
createServerPool=false
serverPoolName=
cardinality=
force=false
pqPoolName=
pqCardinality=
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=oralpdb
useLocalUndoForPDBs=true
pdbAdminPassword=
nodelist=
templateName=/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/General_Purpose.dbc
sysPassword=
systemPassword= 
oracleHomeUserPassword=
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=oral,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=oral,ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1,SID=oral
initParams=undo_tablespace=UNDOTBS1,memory_target=796MB,processes=300,db_recovery_file_dest_size=2780MB,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=oralXDB),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_oral,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=oral,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,open_cursors=300
sampleSchema=false
memoryPercentage=40
databaseType=MULTIPURPOSE
automaticMemoryManagement=true
totalMemory=0
[oracle@oracledb ~]$ dbca -silent -createDatabase -responseFile /u01/database/response/dbca.rsp 
1% complete

13% complete
25% complete
Creating and starting Oracle instance
26% complete
30% complete
31% complete
35% complete
38% complete
39% complete
41% complete
Completing Database Creation
42% complete
43% complete
44% complete
46% complete
49% complete
50% complete
Creating Pluggable Databases
55% complete
75% complete
Executing Post Configuration Actions
100% complete
#...省略部分输出...

[oracle@oracledb ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 7 23:04:36 2021
SQL> select status from v$instance;
STATUS
------------
OPEN

[oracle@oracledb ~]$ lsnrctl status
#...省略部分输出...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "a01adc639d2b6baae0538075a8c0613f" has 1 instance(s).
  Instance "oral", status READY, has 1 handler(s) for this service...
Service "oral" has 1 instance(s).
  Instance "oral", status READY, has 1 handler(s) for this service...
Service "oralXDB" has 1 instance(s).
  Instance "oral", status READY, has 1 handler(s) for this service...
Service "oralpdb" has 1 instance(s).
  Instance "oral", status READY, has 1 handler(s) for this service...
The command completed successfully

<< 上一章节

下一章节 >>

登陆评论: 使用GITHUB登陆