- 一、安装前准备
1.1关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
1.2禁用NetworkManager服务
systemctl stop NetworkManager
systemctl disable NetworkManager
1.3禁用SELINUX
setenforce 0
sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/’ /etc/selinux/config
(备注:
关闭selinux
查看selinux状态:getenforce 或者sestatus -v
临时关闭:[root@oracledb ~] setenforce 0
永久关闭:[root@oracledb ~] vim /etc/selinux/config
设置SELINUX=disabled)
1.4 配置HOSTS解析
vi /etc/hosts
1.5安装jdk
cd /usr/local
mkdir java
cd java
tar -zxvf jdk-8u261-linux-x64.tar.gz
vi /etc/profile
添加如下内容:
source /etc/profile
java -version
1.6创建用户以及组
groupadd oper
groupadd dba
groupadd asmdba
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd racdba
groupadd oinstall
useradd oracle
passwd oracle
usermod -g oinstall -G oper,dba,asmdba,backupdba,dgdba,kmdba,racdba oracle
1.7创建安装目录并赋权
mkdir -p /home/u01/app/oracle/product/19.3.0/dbhome_1/
mkdir -p /home/u01/app /oraInventory
chmod +755 -R /home/u01/app /
chown -R oracle:oinstall /home/u01/
1.8配置环境变量
su – oracle
vi .bash_profile
export ORACLE_SID=orcl
export ORACLE_BASE=/u19/app/oracle
export ORACLE_HOME=
O
R
A
C
L
E
B
A
S
E
/
p
r
o
d
u
c
t
/
19.3.0
/
d
b
h
o
m
e
1
e
x
p
o
r
t
P
A
T
H
=
ORACLE_BASE/product/19.3.0/dbhome_1 export PATH=
ORACLEBASE/product/19.3.0/dbhome1exportPATH=PATH:
O
R
A
C
L
E
H
O
M
E
/
b
i
n
e
x
p
o
r
t
L
D
L
I
B
R
A
R
Y
P
A
T
H
=
ORACLE_HOME/bin export LD_LIBRARY_PATH=
ORACLEHOME/binexportLDLIBRARYPATH=LD_LIBRARY_PATH:
O
R
A
C
L
E
H
O
M
E
/
l
i
b
e
x
p
o
r
t
C
L
A
S
S
P
A
T
H
=
ORACLE_HOME/lib export CLASSPATH=
ORACLEHOME/libexportCLASSPATH=ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LANG=zh_CN.UTF-8
export NLS_LANG=‘AMERICAN_AMERICA.AL32UTF8’
#解决sqlplus 上下键,删除键乱码问题。需要安装rlwrap,依赖包readlines,libtermcap-devel
alias sqlplus=‘rlwrap sqlplus’
alias rman=‘rlwrap rman’
alias lsnrctl=‘rlwrap lsnrctl’
使用配置生效:
source .bash_profile
1.9配置LIMITS限制参数
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
1.10修改系统内核参数sysctl.conf文件
vi /etc/sysctl.conf
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.file-max= 6815744
fs.aio-max-nr = 1048576
启用新的配置文件信息
sysctl -p
- 二、安装需要的rpm包
2.1查询是否安装如下依赖包:
rpm -q bc binutils cpp compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel gcc gcc-c++ glibc glibc-devel ksh kmod kmod-libs libaio libaio-devel libgcc libstdc++ libstdc+±devel make sysstat unixODBC
2.2无网环境需要用rpm安装:
rpm -ivh (安装缺少的rpm包)
rpm -Uvh(升级需要升级的包)
rpm -Uvh *.rpm --nodeps –force(强力安装)
备注:
compat-libstdc++安装后即使安装后显示未安装也没关系
- 三、安装软件
3.1解压数据库软件
su – oracle
unzip -q LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
3.2生成响应文件
O
R
A
C
L
E
H
O
M
E
/
i
n
s
t
a
l
l
.
r
s
p
备
注
:
应
答
文
件
的
参
考
位
置
在
ORACLE_HOME/install.rsp 备注:应答文件的参考位置在
ORACLEHOME/install.rsp备注:应答文件的参考位置在ORACLE_HOME/install/response/下
vim $ORACLE_HOME/install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/home/u01/app/oraInventory
ORACLE_BASE=/home/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=backupdba
oracle.install.db.OSDGDBA_GROUP=dgdba
oracle.install.db.OSKMDBA_GROUP=kmdba
oracle.install.db.OSRACDBA_GROUP=racdba
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.rootconfig.configMethod=ROOT
3.3静默安装
sh $ORACLE_HOME/runInstaller -silent -noconfig -force -ignorePrereq -responseFile $ORACLE_HOME/install.rsp
提示如下内容则表示成功:
Successfully Setup Software with warning(s).
3.4执行脚本
su - root
sh /u19/app/oraInventory/orainstRoot.sh
sh /u19/app/oracle/product/19.3.0/dbhome_1/root.sh
- 四、创建实例
4.1 .配置响应文件
O
R
A
C
L
E
H
O
M
E
/
d
b
c
a
.
r
s
p
备
注
:
配
置
项
可
参
考
ORACLE_HOME/dbca.rsp 备注:配置项可参考
ORACLEHOME/dbca.rsp备注:配置项可参考ORACLE_HOME/assistants/dbca/dbca.rsp)
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=orcl
sid=orcl
sysPassword=Egis_2016
oracleHomeUserPassword=Egis_2016
emExpressPort=5500
totalMemory=4096
4.2配置实例
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile $ORACLE_HOME/dbca.rsp
- 五、创建监听
4.1 .配置响应文件 O R A C L E H O M E / n e t c a . r s p 备 注 : 配 置 项 可 参 考 ORACLE_HOME/netca.rsp 备注:配置项可参考 ORACLEHOME/netca.rsp备注:配置项可参考ORACLE_HOME/assistants/netca/netca.rsp)
[GENERAL]
RESPONSEFILE_VERSION=“19.3”
CREATE_TYPE=“CUSTOM”
[oracle.net.ca]
INSTALLED_COMPONENTS={“server”,“net8”,“javavm”}
INSTALL_TYPE="“typical”"
LISTENER_NUMBER=1
LISTENER_NAMES={“LISTENER”}
LISTENER_PROTOCOLS={“TCP;1521”}
LISTENER_START="“LISTENER”"
NAMING_METHODS={“TNSNAMES”,“ONAMES”,“HOSTNAME”}
NSN_NUMBER=1
NSN_NAMES={“EXTPROC_CONNECTION_DATA”}
NSN_SERVICE={“PLSExtProc”}
NSN_PROTOCOLS={“TCP;HOSTNAME;1521”}
4.2配置监听
$ORACLE_HOME/bin/netca -silent -responsefile $ORACLE_HOME/netca.rsp