CentOS7安装oracle19c

子鱼非安 2021-04-21

3639

oracle19c下载地址

百度网盘链接：https://pan.baidu.com/s/1mtsWs3dibid4vwFwuv08iQ

提取码：poi2

安装依赖包

[root@karms ~]# cat /etc/redhat-release 
CentOS Linux release 7.0.1406 (Core)
[root@karms ~]# yum install -y compat-libcap1 compat-libstdc++-33 gcc-c++ ksh libaio-devel libstdc++-devel elfutils-libelf-devel fontconfig-devel libXrender-devel

创建用户

[root@karms ~]# groupadd oinstall
[root@karms ~]# groupadd dba
[root@karms ~]# groupadd asmdba
[root@karms ~]# groupadd backupdba
[root@karms ~]# groupadd dgdba
[root@karms ~]# groupadd kmdba
[root@karms ~]# groupadd racdba
[root@karms ~]# groupadd oper
[root@karms ~]# useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper -m oracle

配置hosts文件

[root@karms ~]# ifconfig | grep 192
        inet 192.168.1.10  netmask 255.255.255.0  broadcast 192.168.1.255
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
[root@karms ~]# echo "karms 192.168.1.10" >> /etc/hosts

修改内核文件

[root@karms ~]# cat >> etc/sysctl.conf << EOF
> fs.aio-max-nr = 1048576
> fs.file-max = 6815744
> kernel.shmall = 16451328
> kernel.shmmax = 33692319744
> kernel.shmmni = 4096
> kernel.sem = 250 32000 100 128
> 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 = 1048576
> EOF
[root@karms ~]# sysctl -p
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 16451328
kernel.shmmax = 33692319744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
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 = 1048576

关闭selinux和firewalld

修/etc/selinux/config文件中第7行的SELINUX=disabled
systemctl stop firewalld
systemctl disable firewalld

设置环境变量

[oracle@localhost ~]$ cat >> .bash_profile << EOF
> export ORACLE_BASE=/u01/app/oracle
> export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1/
> export ORACLE_BIN=/u01/app/oracle/product/19.3.0/dbhome_1/bin/
> export PATH=/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:/bin:/usr/local/bin:$ORACLE_BIN
> export ORACLE_HOSTNAME=karms
> export ORACLE_SID=karms
> export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/lib
> export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
> EOF

创建所需目录

[root@karms ~]# mkdir -p u01/app/oracle/product/19.3.0/dbhome_1
[root@karms ~]# chown oracle.oinstall /u01 -R

修改shell限制

[root@karms ~]# cat >> etc/security/limits.conf << EOF
> @oinstall soft nofile 2048
> @oinstall hard nofile 65536
> @oinstall soft nproc 16384
> @oinstall soft stack 10240
> EOF

上面操作完毕

sync

init 6

注意下面这步

将oracle安装包上传到/u01/app/oracle/product/19.3.0/dbhome_1下

[oracle@karms dbhome_1]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@karms dbhome_1]$ unzip /home/oracle/V982063-01.zip -d .

执行安装脚本

[root@karms ~]# xhost +

access control disabled, clients can connect from any host

[root@karms ~]# su oracle

[oracle@karms root]$ cd u01/app/oracle/product/19.3.0/

[oracle@karms 19.3.0]$ cd dbhome_1/

[oracle@karms dbhome_1]$

[oracle@karms dbhome_1]$ ./runInstaller

正在启动 Oracle 数据库安装向导...

如果出现DISPLAY报错，修改oracle的export $DISPLAY，修改的值可以通过，修改可以右边命令查看printenv | grep DISPLAY

然后下面开始图形化开始

一切按照下面图片中进行请勿其他操作

选择仅设置软件下一步

下一步

这时提示某些程序包未安装

安装下面这包

[root@karms ~]# rpm -Uvh libaio-devel-0.3.109-13.el7.x86_64.rpm
[root@karms ~]# rpm -Uvh libXi-1.7.9-1.el7.x86_64.rpm
[root@karms ~]# rpm -Uvh libX11-1.6.5-1.el7.x86_64.rpm --nodeps
[root@karms ~]# rpm -Uvh libxcb-1.12-1.el7.x86_64.rpm  --nodeps
[root@karms ~]# rpm -Uvh kmod-libs-20-21.el7.x86_64.rpm
[root@karms ~]# rpm -Uvh --oldpackage kmod-20-21.el7.x86_64.rpm

安装完这些包后在点重新检查，点完如下，在点安装

耐心等待

按照提示执行脚本

注意执行第二个脚本默认回车就行

[root@karms dbhome_1]# sh u01/app/oraInventory/orainstRoot.sh 
更改权限/u01/app/oraInventory.
添加组的读取和写入权限。
删除全局的读取, 写入和执行权限。




更改组名/u01/app/oraInventory 到 oinstall.
脚本的执行已完成。
[root@karms dbhome_1]# sh u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.




The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  u01/app/oracle/product/19.3.0/dbhome_1




Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to usr/local/bin ...
   Copying oraenv to usr/local/bin ...
   Copying coraenv to usr/local/bin ...




Creating etc/oratab file...
Entries will be added to the etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
    u01/app/oracle/product/19.3.0/dbhome_1/bin/tfactl




Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed
[root@karms dbhome_1]#