Oracle19C安装 单实例 -- GUI方式
- 环境
IP | OS | Oracle |
192.168.56.102 | CentOS Linux release 7.7.1908 | 19.3 |
- 安装准备
关闭防火墙,关闭selinux
下载软件
Database Software Downloads | Oracle
创建用户并修改密码
groupadd -g 5001 dba
groupadd -g 5002 asmdba
groupadd -g 5003 backupdba
groupadd -g 5004 dgdba
groupadd -g 5005 kmdba
groupadd -g 5006 racdba
groupadd -g 5007 oper
groupadd -g 5008 oinstall
useradd -u 5000 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
passwd oracle
配置yum
wget http://yum.oracle.com/public-yum-ol7.repo -O /etc/yum.repos.d/public-yum-ol7.repo
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
安装preinstall
yum install oracle-database-preinstall-19c.x86_64 -y
修改系统限制
echo "
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
oracle soft data unlimited
oracle hard data unlimited
" >> /etc/security/limits.conf
修改内核参数
echo "
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
" >> /etc/sysctl.conf
sysctl -p
创建安装目录,并修改权限
mkdir -p /u01/app/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /u01
配置oracle用户环境变量
echo "
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
export ORACLE_SID=HPCDW
export LANG=en_US.UTF-8
export PATH=.:\${PATH}:\${ORACLE_HOME}/bin
export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${LD_LIBRARY_PATH}
" >> /home/oracle/.bash_profile
使用oracle用户登录操作系统,进入图形界面
上传LINUX.X64_193000_db_home.zip到ORACLE_HOME,并解压
开始安装
这里简单起见选择了安装oracle_home的同事安装一个但实力数据库
选择一般用途类数据库
大部分信息都从环境变量读取而来,这里修改了global database name ,密码和取消勾选创建容器数据库。
提示密码强度不够,这里忽略,选yes
下一步
这里直接输入root密码,让安装过程直接执行root.sh
提示交换空间不够,忽略
提示两个包缺失,忽略(因为安装了preinstall,所以应该没有大的依赖问题,选择忽略尝试继续安装)
选 yes
这里可以保留一份相应文件,然后在install
开始安装
提示是否允许root权限,选yes
等待。。。
数据库安装成功
监听配置,随操作系统启动请参考Oracle19C安装 单实例 -- rpm方式_oracle_data_location-CSDN博客
----------------------------------------------------------
groupadd -g 5001 dba
groupadd -g 5002 asmdba
groupadd -g 5003 backupdba
groupadd -g 5004 dgdba
groupadd -g 5005 kmdba
groupadd -g 5006 racdba
groupadd -g 5007 oper
groupadd -g 5008 oinstall
useradd -u 5000 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
wget http://yum.oracle.com/public-yum-ol7.repo -O /etc/yum.repos.d/public-yum-ol7.repo
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
yum install oracle-database-preinstall-19c.x86_64 -y
rpm -ivh /softwares/oracle-database-ee-19c-1.0-1.x86_64.rpm
echo "
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
oracle soft data unlimited
oracle hard data unlimited
" >> /etc/security/limits.conf
echo "
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
" >> /etc/sysctl.conf
sysctl -p
mkdir -p /u01/app/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /u01
echo "
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
export ORACLE_SID=HPCDW
export LANG=en_US.UTF-8
export PATH=.:\${PATH}:\${ORACLE_HOME}/bin
export LD_LIBRARY_PATH=\${ORACLE_HOME)/lib:\${LD_LIBRARY_PATH}
" >> /home/oracle/.bash_profile
从Oracle18C起,Oracle安装文件需要结业在$ORACLE_HOME路径。