IP修改后重启网卡

[root@ol8 network-scripts]#

systemctl restart NetworkManager

[root@ol8 network-scripts]# nmcli c

reload ifcfg-ens33

如果不行，可尝试以下命令

#

重载所有ifcfg或route到connection(不会立即生效)

nmcli c

reload ifcfg-xxx

#

重载指定ifcfg或route到connection(不会立即生效)

nmcli c

load /etc/sysconfig/network-scripts/ifcfg-ethX

nmcli c

load /etc/sysconfig/network-scripts/route-ethX

#

立即生效connection，有3种方法

nmcli c up

ethX

nmcli d

reapply ethX

nmcli d

connect ethX

建立用户组

[root@ol8 /]# /usr/sbin/groupadd -g 10001 oinstall

[root@ol8 /]# /usr/sbin/groupadd -g 10002 dba

[root@ol8 /]# /usr/sbin/groupadd -g 10003 oper

[root@ol8 /]# /usr/sbin/useradd -u 10001 -g oinstall -G

dba,oper oracle

[root@ol8 /]# passwd oracle

关闭防火墙还有selinux

[root@ol8 /]# systemctl stop firewalld.service

[root@ol8 /]# systemctl disable firewalld.service

Removed

/etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed

/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@ol8 /]# cat /etc/selinux/config

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is

enforced.

# permissive - SELinux prints warnings instead of

enforcing.

# disabled - No SELinux policy is loaded.

SELINUX=enforcing

SELINUXTYPE=targeted

关闭selinux

查看selinux状态：getenforce 或者sestatus -v

临时关闭：setenforce 0

永久关闭：vim /etc/selinux/config

设置SELINUX=disabled

创建工作的目录，然后赋予相应的权限

[root@ol8 /]# mkdir -p

/u01/app/oracle/product/19.2.0/db_1

[root@ol8 /]# chown -R oracle:oinstall /u01/

[root@ol8 /]# chmod -R 775 /u01/

oracle环境变量

[root@ol8 u01]# su - oracle

[oracle@ol8 ~]$ vi .bash_profile

ORACLE_SID=ora19c;export ORACLE_SID

ORACLE_UNQNAME=ora19c;export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/19.2.0/db_1; export

ORACLE_HOME

NLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS"; export

NLS_DATE_FORMAT

NLS_LANG=american_america.ZHS16GBK; export NLS_LANG

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export CLASSPATH

THREADS_FLAG=native; export THREADS_FLAG

export TEMP=/tmp

export TMPDIR=/tmp

umask 022

[oracle@ol8 ~]$ source .bash_profile

修改内核参数

官方的guide中提到 /etc/sysctl.conf 已经被不推荐使用了，应该修改

/etc/sysctl.d/97-oracle-database-sysctl.conf

[root@ol8 u01]# 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

[root@ol8 u01]# sysctl --system

限制用户资源

编辑 /etc/security/limits.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

注意：如果内存小于8G，最后两行大内存页配置可忽略

下面开始安装一些重要的包

dnf install bc gcc gcc-c++ binutils compat-libcap1

compat-libstdc++ dtrace-modules dtrace-modules-headers

dtrace-modules-provider-headers dtrace-utils elfutils-libelf

elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio

libaio-devel libdtrace-ctf-devel libX11 libXau libXi libXtst

libXrender libXrender-devel libgcc librdmacm-devel libstdc++

libstdc++-devel libxcb make smartmontools

sysstat

配置本地源

mount /dev/cdrom /mnt

[root@ol8 network-scripts]# cd /etc/yum.repos.d

[root@ol8 yum.repos.d]# ls

oracle-linux-ol8.repo

[root@ol8 yum.repos.d]# cp oracle-linux-ol8.repo

oracle-linux-ol8.repobak

vi oracle-linux-ol8.repo

[LocalRepo_BaseOS]

name=LocalRepo_BaseOS

baseurl=file:///mnt/BaseOS

gpgcheck=0

gpgkey=file:///mnt/BaseOS/Packages

enabled=1

[LocalRepo_AppStream]

name=LocalRepository_AppStream

baseurl=file:///mnt/AppStream

enabled=1

gpgcheck=0

gpgkey=file:///mnt/AppStream/Packages

[root@ol8 yum.repos.d]# yum repolist

LocalRepo_BaseOS 102 MB/s | 2.2

MB 00:00

LocalRepository_AppStream 119 MB/s | 5.6 MB 00:00

Last metadata expiration check: 0:00:01 ago on Thu 23 Apr 2020

05:49:19 PM CST.

repo id repo

name status

LocalRepo_AppStream LocalRepository_AppStream 4,804

LocalRepo_BaseOS LocalRepo_BaseOS 1,654

dnf clean all

dnf install net-tools

dnf install -y zip unzip

解压

su - oracle

unzip LINUX.X64_193000_db_home.zip -d

/u01/app/oracle/product/19.2.0/db_1/

[oracle@localhost db_1]$ export DISPLAY=:0.0

[oracle@localhost db_1]$ LANG=en_US ./runInstaller

oracle:export DISPLAY=:0.0

root: xhost +

安装报错1：

[oracle@ol8 db_1]$ ./runInstaller

ERROR: Unable to verify the graphical display setup. This

application requires X display. Make sure that xdpyinfo exist under

PATH variable.

/u01/app/oracle/product/19.2.0/db_1/perl/bin/perl: error while

loading shared libraries: libnsl.so.1: cannot open shared object

file: No such file or directory

[oracle@ol8 db_1]$ export DISPLAY=:0.0

安装报错2：

[oracle@ol8 db_1]$ ./runInstaller

/u01/app/oracle/product/19.2.0/db_1/perl/bin/perl: error while

loading shared libraries: libnsl.so.1: cannot open shared object

file: No such file or directory

报错2缺少库文件

[oracle@ol8 db_1]$ pwd

/u01/app/oracle/product/19.2.0/db_1

[oracle@ol8 db_1]$ ldd

/u01/app/oracle/product/19.2.0/db_1/perl/bin/perl

linux-vdso.so.1 (0x00007ffef6f78000)

libpthread.so.0 => /lib64/libpthread.so.0

(0x00007fd7f89cd000)

libnsl.so.1 => /lib64/libnsl.so.1

(0x00007fd7f87b4000)

libdl.so.2 => /lib64/libdl.so.2 (0x00007fd7f85b0000)

libm.so.6 => /lib64/libm.so.6 (0x00007fd7f822e000)

libcrypt.so.1 => /lib64/libcrypt.so.1

(0x00007fd7f8005000)

libutil.so.1 => /lib64/libutil.so.1

(0x00007fd7f7e01000)

libc.so.6 => /lib64/libc.so.6 (0x00007fd7f7a3e000)

libgcc_s.so.1 => /lib64/libgcc_s.so.1

(0x00007fd7f7826000)

/lib64/ld-linux-x86-64.so.2 (0x00007fd7f8bed000)

[root@ol8 mnt]# dnf install libnsl 扩展：DNF 即将取代 YUM，相关内容请自行查询。

LocalRepo_BaseOS 98 kB/s |

2.3 kB 00:00

LocalRepository_AppStream 85 kB/s | 2.8

kB 00:00

Dependencies resolved.

Package Architecture Version Repository Size Installing:

libnsl x86_64 2.28-72.0.1.el8 LocalRepo_BaseOS 94 k

Transaction Summary

Install 1 Package

Total size: 94 k

Installed size: 240 k

Is this ok [y/N]: y

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing :

libnsl-2.28-72.0.1.el8.x86_64 1/1

Running scriptlet:

libnsl-2.28-72.0.1.el8.x86_64 1/1

Verifying :

libnsl-2.28-72.0.1.el8.x86_64 1/1

Installed:

libnsl-2.28-72.0.1.el8.x86_64

安装报错3：

[oracle@ol8 db_1]$ LANG=en_US ./runInstaller

Launching Oracle Database Setup Wizard...

[WARNING] [INS-08101] Unexpected error while executing the

action at state: 'supportedOSCheck'

CAUSE: No additional

information available.

ACTION: Contact Oracle

Support Services or refer to the software manual.

SUMMARY:

-

java.lang.NullPointerException

报错3为OS 操作系统不兼容问题

不管是图形化界面还是静默安装，执行前设置 CV_ASSUME_DISTID，之后再次运行执行程序或脚本。

[oracle@ol8 db_1]$ export CV_ASSUME_DISTID=RHEL7.6

安装数据库软件后创建监听及数据库

netca

dbca

****************************************************************************************************

# 静默安装

./runInstaller -ignorePrereq -waitforcompletion -silent

\

-responseFile

/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp

\

oracle.install.option=INSTALL_DB_SWONLY \

ORACLE_HOSTNAME=henry \

UNIX_GROUP_NAME=oinstall \

INVENTORY_LOCATION=/u01/app/oraInventory \

SELECTED_LANGUAGES=en,en_GB \

ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_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 \

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \

DECLINE_SECURITY_UPDATES=true

# 静默创建

dbca -silent -createDatabase -templateName General_Purpose.dbc

\

-gdbname cdb1 \

-sid cdb1 \

-databaseConfigType SI \

-createAsContainerDatabase TRUE \

-numberOfPDBs 1 \

-pdbName pdb1 \

-useLocalUndoForPDBs TRUE \

-pdbAdminPassword oracle \

-sysPassword oracle \

-systemPassword oracle \

-characterSet AL32UTF8 \

-memoryPercentage 30

编辑 /etc/oratab 文件，将启动标志设置为 Y

cdb1:/u01/app/oracle/product/19.0.0/dbhome_1:Y

https://www.zybuluo.com/clisdodo/note/1490389