大家好，又见面了，我是你们的朋友全栈君。
最近有个项目要搭建测试环境在云平台上，加上又刚参加完oracle组织的oracle 19c的升级培训，所以准备在测试环境里面直接安装oracle19c，提前熟悉一下。并将安装过程记录分享给大家，这里主要介绍两种安装方式，一种是普通的图形界面安装，一种是静默安装。oracle19c还可以通过rpm包在线自动安装，这里不进行介绍。
oracle官方说法是Oracle Database 19c会作为Oracle长期支持的稳定版本，官方也建议大家选择19c这个版本的数据库。
一、安装准备
1、下载安装包
目前在官网下载19c时,详细的版本是 19.3，下载地址https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html。大家可以选择对应的操作系统版本下载。
2、服务器环境
| 事项 | 详情 |
|---|---|
| 操作系统 | Centos 7.3 |
| 数据库版本 | 19.3.0 |
| CPU | inter 16核 2.30GHz |
| 内存 | 64GB |
| swap | 20GB |
云平台统一的操作系统版本较低，我这边是7.3，问题应该不大，oracle官方建议是7.4版本以上。硬件配置是测试环境不是很高。
3、准备安装环境
3.1、服务器环境检查
[root@host-173-16-87-178 /]# grep MemTotal /proc/meminfo
MemTotal: 65806316 kB
[root@host-173-16-87-178 /]# grep SwapTotal /proc/meminfo
SwapTotal: 20971516 kB
[root@host-173-16-87-178 /]# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/cl-root 79G 13G 62G 18% /
[root@host-173-16-87-178 /]# df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 32G 28K 32G 1% /dev/shm
[root@host-173-16-87-178 /]# free -g
total used free shared buff/cache available
Mem: 62 0 61 0 0 61
Swap: 19 0 19
[root@host-173-16-87-178 /]# uname -m
x86_64
[root@host-173-16-87-178 /]#
3.2、安装系统依赖包
有以上依赖包要进行安装
1、检查少了哪些依赖包
[root@host-173-16-87-178 ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" bc binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat elfutils-libelf elfutils-libelf-devel fontconfig-devel libxcb smartmontools libX11 libXau libXtst libXrender libXrender-devel
bc-1.06.95.13.el7 (x86_64)
binutils-2.25.1.22.base.el7 (x86_64)
package compat-libcap1 is not installed
package compat-libstdc++-33 is not installed
gcc-4.8.5.36.el7_6.2 (x86_64)
package gcc-c++ is not installed
glibc-2.17.292.el7 (x86_64)
glibc-2.17.292.el7 (i686)
glibc-devel-2.17.292.el7 (x86_64)
package ksh is not installed
libaio-0.3.109.13.el7 (x86_64)
package libaio-devel is not installed
libgcc-4.8.5.39.el7 (x86_64)
libgcc-4.8.5.39.el7 (i686)
libstdc++-4.8.5.39.el7 (x86_64)
libstdc++-4.8.5.39.el7 (i686)
package libstdc++-devel is not installed
make-3.82.23.el7 (x86_64)
sysstat-10.1.5.18.el7 (x86_64)
elfutils-libelf-0.176.2.el7 (x86_64)
elfutils-libelf-0.176.2.el7 (i686)
package elfutils-libelf-devel is not installed
package fontconfig-devel is not installed
libxcb-1.13.1.el7 (x86_64)
smartmontools-7.0.1.el7_7.1 (x86_64)
libX11-1.6.5.2.el7 (x86_64)
libXau-1.0.8.2.1.el7 (x86_64)
libXtst-1.2.3.1.el7 (x86_64)
libXrender-0.9.10.1.el7 (x86_64)
package libXrender-devel is not installed
[root@host-173-16-87-178 ~]#
2、使用yum进行安装
[root@host-173-16-87-178 ~]# yum install -y compat-libcap1 compat-libstdc++-33 gcc-c++ ksh libaio-devel libstdc++-devel elfutils-libelf-devel fontconfig-devel libXrender-devel
Loaded plugins: fastestmirror, langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed
---> Package elfutils-libelf-devel.x86_64 0:0.176-2.el7 will be installed
---> Package fontconfig-devel.x86_64 0:2.13.0-4.3.el7 will be installed
--> Processing Dependency: pkgconfig(freetype2) >= 20.0.14 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: freetype-devel >= 2.8-7 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: pkgconfig(uuid) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
---> Package gcc-c++.x86_64 0:4.8.5-39.el7 will be installed
--> Processing Dependency: gcc = 4.8.5-39.el7 for package: gcc-c++-4.8.5-39.el7.x86_64
---> Package ksh.x86_64 0:20120801-139.el7 will be installed
---> Package libXrender-devel.x86_64 0:0.9.10-1.el7 will be installed
--> Processing Dependency: pkgconfig(renderproto) >= 0.9 for package: libXrender-devel-0.9.10-1.el7.x86_64
--> Processing Dependency: pkgconfig(xproto) for package: libXrender-devel-0.9.10-1.el7.x86_64
--> Processing Dependency: pkgconfig(x11) for package: libXrender-devel-0.9.10-1.el7.x86_64
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-39.el7 will be installed
--> Running transaction check
---> Package expat-devel.x86_64 0:2.1.0-10.el7_3 will be installed
--> Processing Dependency: expat = 2.1.0-10.el7_3 for package: expat-devel-2.1.0-10.el7_3.x86_64
---> Package freetype-devel.x86_64 0:2.8-14.el7 will be installed
--> Processing Dependency: freetype = 2.8-14.el7 for package: freetype-devel-2.8-14.el7.x86_64
--> Processing Dependency: pkgconfig(libpng) for package: freetype-devel-2.8-14.el7.x86_64
---> Package gcc.x86_64 0:4.8.5-36.el7_6.2 will be updated
---> Package gcc.x86_64 0:4.8.5-39.el7 will be an update
--> Processing Dependency: libgomp = 4.8.5-39.el7 for package: gcc-4.8.5-39.el7.x86_64
--> Processing Dependency: cpp = 4.8.5-39.el7 for package: gcc-4.8.5-39.el7.x86_64
---> Package libX11-devel.x86_64 0:1.6.7-2.el7 will be installed
--> Processing Dependency: libX11 = 1.6.7-2.el7 for package: libX11-devel-1.6.7-2.el7.x86_64
--> Processing Dependency: pkgconfig(xcb) >= 1.11.1 for package: libX11-devel-1.6.7-2.el7.x86_64
--> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.7-2.el7.x86_64
---> Package libuuid-devel.x86_64 0:2.23.2-61.el7_7.1 will be installed
--> Processing Dependency: libuuid = 2.23.2-61.el7_7.1 for package: libuuid-devel-2.23.2-61.el7_7.1.x86_64
---> Package xorg-x11-proto-devel.noarch 0:2018.4-1.el7 will be installed
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-36.el7_6.2 will be updated
---> Package cpp.x86_64 0:4.8.5-39.el7 will be an update
---> Package expat.x86_64 0:2.1.0-8.el7 will be updated
---> Package expat.x86_64 0:2.1.0-10.el7_3 will be an update
---> Package freetype.x86_64 0:2.8-12.el7_6.1 will be updated
---> Package freetype.x86_64 0:2.8-14.el7 will be an update
---> Package libX11.x86_64 0:1.6.5-2.el7 will be updated
---> Package libX11.x86_64 0:1.6.7-2.el7 will be an update
--> Processing Dependency: libX11-common >= 1.6.7-2.el7 for package: libX11-1.6.7-2.el7.x86_64
---> Package libgomp.x86_64 0:4.8.5-36.el7_6.2 will be updated
---> Package libgomp.x86_64 0:4.8.5-39.el7 will be an update
---> Package libpng-devel.x86_64 2:1.5.13-7.el7_2 will be installed
---> Package libuuid.x86_64 0:2.23.2-33.el7 will be updated
--> Processing Dependency: libuuid = 2.23.2-33.el7 for package: libblkid-2.23.2-33.el7.x86_64
--> Processing Dependency: libuuid = 2.23.2-33.el7 for package: libmount-2.23.2-33.el7.x86_64
--> Processing Dependency: libuuid = 2.23.2-33.el7 for package: util-linux-2.23.2-33.el7.x86_64
---> Package libuuid.x86_64 0:2.23.2-61.el7_7.1 will be an update
---> Package libxcb-devel.x86_64 0:1.13-1.el7 will be installed
--> Processing Dependency: pkgconfig(xau) >= 0.99.2 for package: libxcb-devel-1.13-1.el7.x86_64
--> Running transaction check
---> Package libX11-common.noarch 0:1.6.5-2.el7 will be updated
---> Package libX11-common.noarch 0:1.6.7-2.el7 will be an update
---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libblkid.x86_64 0:2.23.2-33.el7 will be updated
---> Package libblkid.x86_64 0:2.23.2-61.el7_7.1 will be an update
---> Package libmount.x86_64 0:2.23.2-33.el7 will be updated
---> Package libmount.x86_64 0:2.23.2-61.el7_7.1 will be an update
---> Package util-linux.x86_64 0:2.23.2-33.el7 will be updated
---> Package util-linux.x86_64 0:2.23.2-61.el7_7.1 will be an update
--> Processing Dependency: libsmartcols = 2.23.2-61.el7_7.1 for package: util-linux-2.23.2-61.el7_7.1.x86_64
--> Processing Dependency: libsmartcols.so.1(SMARTCOLS_2.25)(64bit) for package: util-linux-2.23.2-61.el7_7.1.x86_64
--> Processing Dependency: libsmartcols.so.1()(64bit) for package: util-linux-2.23.2-61.el7_7.1.x86_64
--> Running transaction check
---> Package libsmartcols.x86_64 0:2.23.2-61.el7_7.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================
Installing:
compat-libcap1 x86_64 1.10-7.el7 CentOS7.3 19 k
compat-libstdc++-33 x86_64 3.2.3-72.el7 CentOS7.3 191 k
elfutils-libelf-devel x86_64 0.176-2.el7 CentOS7.3 39 k
fontconfig-devel x86_64 2.13.0-4.3.el7 CentOS7.3 138 k
gcc-c++ x86_64 4.8.5-39.el7 CentOS7.3 7.2 M
ksh x86_64 20120801-139.el7 CentOS7.3 885 k
libXrender-devel x86_64 0.9.10-1.el7 CentOS7.3 17 k
libaio-devel x86_64 0.3.109-13.el7 CentOS7.3 13 k
libstdc++-devel x86_64 4.8.5-39.el7 CentOS7.3 1.5 M
Installing for dependencies:
expat-devel x86_64 2.1.0-10.el7_3 CentOS7.3 57 k
freetype-devel x86_64 2.8-14.el7 CentOS7.3 447 k
libX11-devel x86_64 1.6.7-2.el7 CentOS7.3 981 k
libXau-devel x86_64 1.0.8-2.1.el7 CentOS7.3 14 k
libpng-devel x86_64 2:1.5.13-7.el7_2 CentOS7.3 122 k
libsmartcols x86_64 2.23.2-61.el7_7.1 CentOS7.3 141 k
libuuid-devel x86_64 2.23.2-61.el7_7.1 CentOS7.3 92 k
libxcb-devel x86_64 1.13-1.el7 CentOS7.3 1.1 M
xorg-x11-proto-devel noarch 2018.4-1.el7 CentOS7.3 280 k
Updating for dependencies:
cpp x86_64 4.8.5-39.el7 CentOS7.3 5.9 M
expat x86_64 2.1.0-10.el7_3 CentOS7.3 81 k
freetype x86_64 2.8-14.el7 CentOS7.3 380 k
gcc x86_64 4.8.5-39.el7 CentOS7.3 16 M
libX11 x86_64 1.6.7-2.el7 CentOS7.3 607 k
libX11-common noarch 1.6.7-2.el7 CentOS7.3 164 k
libblkid x86_64 2.23.2-61.el7_7.1 CentOS7.3 181 k
libgomp x86_64 4.8.5-39.el7 CentOS7.3 158 k
libmount x86_64 2.23.2-61.el7_7.1 CentOS7.3 183 k
libuuid x86_64 2.23.2-61.el7_7.1 CentOS7.3 83 k
util-linux x86_64 2.23.2-61.el7_7.1 CentOS7.3 2.0 M
Transaction Summary
====================================================================================================================================================================
Install 9 Packages (+ 9 Dependent packages)
Upgrade ( 11 Dependent packages)
Total download size: 39 M
Downloading packages:
No Presto metadata available for CentOS7.3
(1/29): compat-libcap1-1.10-7.el7.x86_64.rpm | 19 kB 00:00:00
(2/29): cpp-4.8.5-39.el7.x86_64.rpm | 5.9 MB 00:00:00
(3/29): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm | 191 kB 00:00:00
(4/29): elfutils-libelf-devel-0.176-2.el7.x86_64.rpm | 39 kB 00:00:00
(5/29): expat-2.1.0-10.el7_3.x86_64.rpm | 81 kB 00:00:00
(6/29): fontconfig-devel-2.13.0-4.3.el7.x86_64.rpm | 138 kB 00:00:00
(7/29): freetype-2.8-14.el7.x86_64.rpm | 380 kB 00:00:00
(8/29): expat-devel-2.1.0-10.el7_3.x86_64.rpm | 57 kB 00:00:00
(9/29): freetype-devel-2.8-14.el7.x86_64.rpm | 447 kB 00:00:00
(10/29): gcc-c++-4.8.5-39.el7.x86_64.rpm | 7.2 MB 00:00:00
(11/29): ksh-20120801-139.el7.x86_64.rpm | 885 kB 00:00:00
(12/29): libX11-1.6.7-2.el7.x86_64.rpm | 607 kB 00:00:00
(13/29): libX11-common-1.6.7-2.el7.noarch.rpm | 164 kB 00:00:00
(14/29): gcc-4.8.5-39.el7.x86_64.rpm | 16 MB 00:00:02
(15/29): libXau-devel-1.0.8-2.1.el7.x86_64.rpm | 14 kB 00:00:00
(16/29): libXrender-devel-0.9.10-1.el7.x86_64.rpm | 17 kB 00:00:00
(17/29): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00
(18/29): libblkid-2.23.2-61.el7_7.1.x86_64.rpm | 181 kB 00:00:00
(19/29): libgomp-4.8.5-39.el7.x86_64.rpm | 158 kB 00:00:00
(20/29): libmount-2.23.2-61.el7_7.1.x86_64.rpm | 183 kB 00:00:00
(21/29): libpng-devel-1.5.13-7.el7_2.x86_64.rpm | 122 kB 00:00:00
(22/29): libsmartcols-2.23.2-61.el7_7.1.x86_64.rpm | 141 kB 00:00:00
(23/29): libX11-devel-1.6.7-2.el7.x86_64.rpm | 981 kB 00:00:00
(24/29): libuuid-2.23.2-61.el7_7.1.x86_64.rpm | 83 kB 00:00:00
(25/29): libstdc++-devel-4.8.5-39.el7.x86_64.rpm | 1.5 MB 00:00:00
(26/29): libuuid-devel-2.23.2-61.el7_7.1.x86_64.rpm | 92 kB 00:00:00
(27/29): libxcb-devel-1.13-1.el7.x86_64.rpm | 1.1 MB 00:00:00
(28/29): xorg-x11-proto-devel-2018.4-1.el7.noarch.rpm | 280 kB 00:00:00
(29/29): util-linux-2.23.2-61.el7_7.1.x86_64.rpm | 2.0 MB 00:00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 13 MB/s | 39 MB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : libuuid-2.23.2-61.el7_7.1.x86_64 1/40
Installing : xorg-x11-proto-devel-2018.4-1.el7.noarch 2/40
Updating : libblkid-2.23.2-61.el7_7.1.x86_64 3/40
Updating : libmount-2.23.2-61.el7_7.1.x86_64 4/40
Installing : libXau-devel-1.0.8-2.1.el7.x86_64 5/40
Installing : libxcb-devel-1.13-1.el7.x86_64 6/40
Installing : libuuid-devel-2.23.2-61.el7_7.1.x86_64 7/40
Updating : expat-2.1.0-10.el7_3.x86_64 8/40
Installing : expat-devel-2.1.0-10.el7_3.x86_64 9/40
Installing : libsmartcols-2.23.2-61.el7_7.1.x86_64 10/40
Updating : libX11-common-1.6.7-2.el7.noarch 11/40
Updating : libX11-1.6.7-2.el7.x86_64 12/40
Installing : libX11-devel-1.6.7-2.el7.x86_64 13/40
Installing : libstdc++-devel-4.8.5-39.el7.x86_64 14/40
Updating : libgomp-4.8.5-39.el7.x86_64 15/40
Updating : cpp-4.8.5-39.el7.x86_64 16/40
Updating : gcc-4.8.5-39.el7.x86_64 17/40
Updating : freetype-2.8-14.el7.x86_64 18/40
Installing : 2:libpng-devel-1.5.13-7.el7_2.x86_64 19/40
Installing : freetype-devel-2.8-14.el7.x86_64 20/40
Installing : fontconfig-devel-2.13.0-4.3.el7.x86_64 21/40
Installing : gcc-c++-4.8.5-39.el7.x86_64 22/40
Installing : libXrender-devel-0.9.10-1.el7.x86_64 23/40
Updating : util-linux-2.23.2-61.el7_7.1.x86_64 24/40
Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 25/40
Installing : libaio-devel-0.3.109-13.el7.x86_64 26/40
Installing : compat-libcap1-1.10-7.el7.x86_64 27/40
Installing : elfutils-libelf-devel-0.176-2.el7.x86_64 28/40
Installing : ksh-20120801-139.el7.x86_64 29/40
Cleanup : util-linux-2.23.2-33.el7.x86_64 30/40
Cleanup : libmount-2.23.2-33.el7.x86_64 31/40
Cleanup : gcc-4.8.5-36.el7_6.2.x86_64 32/40
Cleanup : libblkid-2.23.2-33.el7.x86_64 33/40
Cleanup : libX11-1.6.5-2.el7.x86_64 34/40
Cleanup : libX11-common-1.6.5-2.el7.noarch 35/40
Cleanup : libuuid-2.23.2-33.el7.x86_64 36/40
Cleanup : cpp-4.8.5-36.el7_6.2.x86_64 37/40
Cleanup : libgomp-4.8.5-36.el7_6.2.x86_64 38/40
Cleanup : expat-2.1.0-8.el7.x86_64 39/40
Cleanup : freetype-2.8-12.el7_6.1.x86_64 40/40
Verifying : util-linux-2.23.2-61.el7_7.1.x86_64 1/40
Verifying : 2:libpng-devel-1.5.13-7.el7_2.x86_64 2/40
Verifying : xorg-x11-proto-devel-2018.4-1.el7.noarch 3/40
Verifying : gcc-4.8.5-39.el7.x86_64 4/40
Verifying : freetype-2.8-14.el7.x86_64 5/40
Verifying : expat-devel-2.1.0-10.el7_3.x86_64 6/40
Verifying : fontconfig-devel-2.13.0-4.3.el7.x86_64 7/40
Verifying : cpp-4.8.5-39.el7.x86_64 8/40
Verifying : libuuid-2.23.2-61.el7_7.1.x86_64 9/40
Verifying : libgomp-4.8.5-39.el7.x86_64 10/40
Verifying : freetype-devel-2.8-14.el7.x86_64 11/40
Verifying : libX11-1.6.7-2.el7.x86_64 12/40
Verifying : libstdc++-devel-4.8.5-39.el7.x86_64 13/40
Verifying : libX11-common-1.6.7-2.el7.noarch 14/40
Verifying : libXrender-devel-0.9.10-1.el7.x86_64 15/40
Verifying : ksh-20120801-139.el7.x86_64 16/40
Verifying : libmount-2.23.2-61.el7_7.1.x86_64 17/40
Verifying : gcc-c++-4.8.5-39.el7.x86_64 18/40
Verifying : elfutils-libelf-devel-0.176-2.el7.x86_64 19/40
Verifying : compat-libcap1-1.10-7.el7.x86_64 20/40
Verifying : libaio-devel-0.3.109-13.el7.x86_64 21/40
Verifying : libuuid-devel-2.23.2-61.el7_7.1.x86_64 22/40
Verifying : libxcb-devel-1.13-1.el7.x86_64 23/40
Verifying : libsmartcols-2.23.2-61.el7_7.1.x86_64 24/40
Verifying : libX11-devel-1.6.7-2.el7.x86_64 25/40
Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 26/40
Verifying : libblkid-2.23.2-61.el7_7.1.x86_64 27/40
Verifying : expat-2.1.0-10.el7_3.x86_64 28/40
Verifying : libXau-devel-1.0.8-2.1.el7.x86_64 29/40
Verifying : libblkid-2.23.2-33.el7.x86_64 30/40
Verifying : libX11-common-1.6.5-2.el7.noarch 31/40
Verifying : expat-2.1.0-8.el7.x86_64 32/40
Verifying : libgomp-4.8.5-36.el7_6.2.x86_64 33/40
Verifying : libuuid-2.23.2-33.el7.x86_64 34/40
Verifying : libX11-1.6.5-2.el7.x86_64 35/40
Verifying : libmount-2.23.2-33.el7.x86_64 36/40
Verifying : gcc-4.8.5-36.el7_6.2.x86_64 37/40
Verifying : freetype-2.8-12.el7_6.1.x86_64 38/40
Verifying : util-linux-2.23.2-33.el7.x86_64 39/40
Verifying : cpp-4.8.5-36.el7_6.2.x86_64 40/40
file:///mnt/repodata/bc7372b8befa9b51b26a8a998ca89b5be3e5636e30546b1e3f11d198d7bed64d-productid.gz: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/bc7372b8befa9b51b26a8a998ca89b5be3e5636e30546b1e3f11d198d7bed64d-productid.gz"
Trying other mirror.
Installed:
compat-libcap1.x86_64 0:1.10-7.el7 compat-libstdc++-33.x86_64 0:3.2.3-72.el7 elfutils-libelf-devel.x86_64 0:0.176-2.el7
fontconfig-devel.x86_64 0:2.13.0-4.3.el7 gcc-c++.x86_64 0:4.8.5-39.el7 ksh.x86_64 0:20120801-139.el7
libXrender-devel.x86_64 0:0.9.10-1.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libstdc++-devel.x86_64 0:4.8.5-39.el7
Dependency Installed:
expat-devel.x86_64 0:2.1.0-10.el7_3 freetype-devel.x86_64 0:2.8-14.el7 libX11-devel.x86_64 0:1.6.7-2.el7 libXau-devel.x86_64 0:1.0.8-2.1.el7
libpng-devel.x86_64 2:1.5.13-7.el7_2 libsmartcols.x86_64 0:2.23.2-61.el7_7.1 libuuid-devel.x86_64 0:2.23.2-61.el7_7.1 libxcb-devel.x86_64 0:1.13-1.el7
xorg-x11-proto-devel.noarch 0:2018.4-1.el7
Dependency Updated:
cpp.x86_64 0:4.8.5-39.el7 expat.x86_64 0:2.1.0-10.el7_3 freetype.x86_64 0:2.8-14.el7 gcc.x86_64 0:4.8.5-39.el7
libX11.x86_64 0:1.6.7-2.el7 libX11-common.noarch 0:1.6.7-2.el7 libblkid.x86_64 0:2.23.2-61.el7_7.1 libgomp.x86_64 0:4.8.5-39.el7
libmount.x86_64 0:2.23.2-61.el7_7.1 libuuid.x86_64 0:2.23.2-61.el7_7.1 util-linux.x86_64 0:2.23.2-61.el7_7.1
Complete!
[root@host-173-16-87-178 ~]#
3.3、创建oracle用户组
[root@ywxtdb ~]# groupadd oinstall
[root@ywxtdb ~]# groupadd dba
[root@ywxtdb ~]# groupadd asmdba
[root@ywxtdb ~]# groupadd backupdba
[root@ywxtdb ~]# groupadd dgdba
[root@ywxtdb ~]# groupadd kmdba
[root@ywxtdb ~]# groupadd racdba
[root@ywxtdb ~]# groupadd oper
[root@ywxtdb ~]#
[root@ywxtdb ~]# useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper -m oracle
3.4、配置域名解析文件
配置/etc/hosts文件
[root@host-173-16-87-178 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
173.16.87.178 ywxtdb
3.5、配置系统内核参数
通过修改配置文件进行调整参数
[root@host-173-16-87-178 ~]# vi /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
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
#输入sysctl -P使配置生效
[root@host-173-16-87-178 ~]# /sbin/sysctl -p
net.ipv4.ip_no_pmtu_disc = 1
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.default.accept_redirects = 0
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.all.secure_redirects = 0
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.tcp_keepalive_time = 150
net.ipv4.tcp_keepalive_probes = 5
net.ipv4.tcp_keepalive_intvl = 6
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
[root@host-173-16-87-178 ~]#
3.6、关闭selinux和防火墙
[root@host-173-16-87-178 ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# 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=disabled
# SELINUXTYPE= can take one of three two values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
[root@host-173-16-87-178 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
You have mail in /var/spool/mail/root
[root@host-173-16-87-178 ~]#
3.7、配置用户环境
1、oracle用户环境变量
[root@host-173-16-87-178 ~]# su - oracle
[oracle@ywxtdb ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.5.0
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_HOSTNAME=ywxtdb
export ORACLE_SID=ywxtdb
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
[root@host-173-16-87-178 ~]#
#创建oracle安装目录
[root@host-173-16-87-178 ~]# mkdir /u01
[root@host-173-16-87-178 ~]# chmod 777 /u01
2、修改用户的Shell限制
[root@host-173-16-87-178 ~]# vi /etc/security/limits.conf
# /etc/security/limits.conf
#
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.
#
#Also note that configuration files in /etc/security/limits.d directory,
#which are read in alphabetical order, override the settings in this
#file in case the domain is the same or more specific.
#That means for example that setting a limit for wildcard domain here
#can be overriden with a wildcard setting in a config file in the
#subdirectory, but a user specific setting here can be overriden only
#with a user specific setting in the subdirectory.
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - a user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
"/etc/security/limits.conf" 67L, 2542C
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
# Set Oracle Database Server
@oinstall soft nofile 2048
@oinstall hard nofile 65536
@oinstall soft nproc 16384
@oinstall soft stack 10240
"/etc/security/limits.conf" 73L, 2681C written
[root@host-173-16-87-178 ~]#
二、安装
1、解压安装包
[root@ywxtdb soft]# mkdir -p /u01/app/oracle/product/19.5.0
[root@ywxtdb soft]# unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
2、方式一：图形界面
通过vnc工具连接到linux图形界面
[root@ywxtdb ~]# chown -R oracle:oinstall /soft/database/
[root@ywxtdb ~]# exit
logout
[oracle@ywxtdb database]$ ./runInstaller
1）下一步
2）单实例数据库安装，下一步
3）企业版，下一步
4）下一步
5）下一步
6）下一步
7)下一步
8）执行先决条件检查
yum执行安装kmod
[root@ywxtdb ~]# yum install kmod kmod-libs
Loaded plugins: fastestmirror, langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml"
Trying other mirror.
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package kmod.x86_64 0:20-9.el7 will be updated
---> Package kmod.x86_64 0:20-25.el7 will be an update
---> Package kmod-libs.x86_64 0:20-9.el7 will be updated
---> Package kmod-libs.x86_64 0:20-25.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================
Updating:
kmod x86_64 20-25.el7 CentOS7.3 122 k
kmod-libs x86_64 20-25.el7 CentOS7.3 51 k
Transaction Summary
====================================================================================================================================================================
Upgrade 2 Packages
Total size: 173 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : kmod-libs-20-25.el7.x86_64 1/4
Updating : kmod-20-25.el7.x86_64 2/4
Cleanup : kmod-libs-20-9.el7.x86_64 3/4
Cleanup : kmod-20-9.el7.x86_64 4/4
Verifying : kmod-20-25.el7.x86_64 1/4
Verifying : kmod-libs-20-25.el7.x86_64 2/4
Verifying : kmod-20-9.el7.x86_64 3/4
Verifying : kmod-libs-20-9.el7.x86_64 4/4
file:///mnt/repodata/bc7372b8befa9b51b26a8a998ca89b5be3e5636e30546b1e3f11d198d7bed64d-productid.gz: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/bc7372b8befa9b51b26a8a998ca89b5be3e5636e30546b1e3f11d198d7bed64d-productid.gz"
Trying other mirror.
Updated:
kmod.x86_64 0:20-25.el7 kmod-libs.x86_64 0:20-25.el7
Complete!
[root@ywxtdb ~]#
重新检查后，勾选全部忽略，然后下一步，选择是。
9）执行安装
10）中间会让我们使用root用户执行两个脚本。
另外打开一个shell窗口，执行命令，执行完成之后返回图形界面点击确定。
[root@ywxtdb ~]# /u01/app/oraInventory/orainstRoot.sh
更改权限/u01/app/oraInventory.
添加组的读取和写入权限。
删除全局的读取, 写入和执行权限。
更改组名/u01/app/oraInventory 到 oinstall.
脚本的执行已完成。
[root@ywxtdb ~]# /u01/app/oracle/product/19.5.0/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /soft/database
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 :
/soft/database/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@ywxtdb ~]#
11、至此oracle软件安装完成。
3、方式二：命令行静默安装
3.1配置响应文件
#备份
[oracle@zbglxtdb response]$ cd $ORACLE_HOME/install/response
[oracle@zbglxtdb response]$ cp db_install.rsp db_install.rsp.bak
#编辑db_install.rsp
[oracle@zbglxtdb response]$ vi db_install.rsp
主要是修改以下参数
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/19.5.0
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=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
3.2执行安装
[oracle@zbglxtdb 19.5.0]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.5.0/install/response/db_install.rsp
Launching Oracle Database Setup Wizard...
[FATAL] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /tmp/InstallActions2020-03-07_11-40-55AM/installActions2020-03-07_11-40-55AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/InstallActions2020-03-07_11-40-55AM/installActions2020-03-07_11-40-55AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
Moved the install session logs to:
/u01/app/oraInventory/logs/InstallActions2020-03-07_11-40-55AM
[oracle@zbglxtdb 19.5.0]$
发现安装报错，通过查看日志搜索/failed发现报错是权限问题，更改systemctl的权限之后重新执行安装成功。
查看报错日志
[root@zbglxtdb ~]#
[root@zbglxtdb ~]# more /tmp/InstallActions2020-03-07_11-40-55AM/installActions2020-03-07_11-40-55AM.log
/failed
...skipping
INFO: [Mar 7, 2020 11:41:04 AM] FINE: [VerificationCommand.execute:387]
Output: '<CV_VRES>126</CV_VRES><CV_ERES>0</CV_ERES><INITCMD>/tmp/InstallActions2020-03-07_11-40-55AM/CVU_19.0.0.0.0_oracle/exectask -getrunlevel </INITCMD><HOST>zbg
lxtdb</HOST><ERROR_LOG><ERR_DESC><ENTITY>GLOBAL</ENTITY><ERR_CMD><CMD>/bin/systemctl get-default</CMD><OUT>sh: /bin/systemctl: Permission denied
</OUT><STAT>126</STAT><ERR_LOC>CVU00367</ERR_LOC></ERR_CMD></ERR_DESC></ERROR_LOG><INFO_LOG><INFO>Exectask: Run level retrieval failed</INFO></INFO_LOG>'
INFO: [Mar 7, 2020 11:41:04 AM] ERROR: [Result.addErrorDescription:760] PRVG-2043 : Command "/bin/systemctl get-default" failed on node "zbglxtdb" and produced th
e following output:
sh: /bin/systemctl: Permission denied
INFO: [Mar 7, 2020 11:41:04 AM] ERROR: [Result.addErrorDescription:771] PRVG-2043 : Command "/bin/systemctl get-default" failed on node "zbglxtdb" and produced th
e following output:
sh: /bin/systemctl: Permission denied
INFO: [Mar 7, 2020 11:41:04 AM] INFO: [Task.perform:768]
TaskArchitecture:Architecture[CHECK_ARCHITECTURE]:TASK_START
INFO: [Mar 7, 2020 11:41:04 AM] INFO: [Task.perform:789]
m_nodeList='zbglxtdb'
INFO: [Mar 7, 2020 11:41:04 AM] FINE: [VerificationCommand.execute:387]
[root@zbglxtdb ~]#
[root@zbglxtdb ~]#
#根据报错提示是systemctl没有权限，查看系统该文件的权限发现确实其它用户没有权限，重新授权后再执行没有报错。
[root@zbglxtdb ~]# ls -l /bin/systemctl
-rwxr--r--. 1 root root 637680 Nov 7 2016 /bin/systemctl
[root@zbglxtdb ~]# chmod 755 /bin/systemctl
[oracle@zbglxtdb 19.5.0]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.5.0/install/response/db_install.rsp
Launching Oracle Database Setup Wizard...
[WARNING] [INS-32047] The location (/u01/app/oraInventory) specified for the central inventory is not empty.
ACTION: It is recommended to provide an empty location for the inventory.
The response file for this session can be found at:
/u01/app/oracle/product/19.5.0/install/response/db_2020-03-07_12-56-18PM.rsp
You can find the log of this install session at:
/tmp/InstallActions2020-03-07_12-56-18PM/installActions2020-03-07_12-56-18PM.log
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/19.5.0/root.sh
Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
[zbglxtdb]
Execute /u01/app/oracle/product/19.5.0/root.sh on the following nodes:
[zbglxtdb]
Successfully Setup Software.
Moved the install session logs to:
/u01/app/oraInventory/logs/InstallActions2020-03-07_12-56-18PM
[oracle@zbglxtdb 19.5.0]$
3.3根据提示使用root用户执行脚本完成安装
[root@zbglxtdb ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@zbglxtdb ~]# /u01/app/oracle/product/19.5.0/root.sh
Check /u01/app/oracle/product/19.5.0/install/root_zbglxtdb_2020-03-07_12-57-48-400665768.log for the output of root script
[root@zbglxtdb ~]#
查看相关日志如果没有错误，oracle软件安装就已经完成了，之后参下考面的静默方式完成建库操作。
三、创建数据库实例
1、方式一：图形界面创建
1）配置监听
oracle用户执行
[oracle@ywxtdb ~]$ netca
2）创建数据库
以oracle用户运行dbca
[oracle@ywxtdb ~]$ dbca
高级配置
下一步
配置oracle实例名称，根据自己的需要选择是否创建成容器数据库。不需要的话就取消
下一步
根据实际需要开启归档和闪回区
下一步
设置内存大小
设置字符集
至此oracle安装和建库已经完成，可以使用数据库了
2、方式二：命令行静默创建
相应模板存放位置
软件/u01/app/oracle/product/19.5.0/install/response/db_install.rsp
监听/u01/app/oracle/product/19.5.0/assistants/netca/netca.rsp
建库/u01/app/oracle/product/19.5.0/assistants/dbca/dbca.rsp
1）配置监听
执行以下命令通过netca.rsp文件创建监听
[oracle@zbglxtdb netca]$ netca /silent /responseFile /u01/app/oracle/product/19.5.0/assistants/netca/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/app/oracle/product/19.5.0/assistants/netca/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/19.5.0/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@zbglxtdb netca]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-3月 -2020 14:29:27
Copyright (c) 1991, 2019, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zbglxtdb)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 19.0.0.0.0 - Production
启动日期 07-3月 -2020 14:29:20
正常运行时间 0 天 0 小时 0 分 6 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 /u01/app/oracle/product/19.5.0/network/admin/listener.ora
监听程序日志文件 /u01/app/oracle/diag/tnslsnr/zbglxtdb/listener/alert/log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zbglxtdb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
监听程序不支持服务
命令执行成功
[oracle@zbglxtdb netca]$
1）创建数据库
编辑响应文件
[oracle@zbglxtdb ~]$ /u01/app/oracle/product/19.5.0/assistants/dbca
[oracle@zbglxtdb dbca]$ cp dbca.rsp dbca.rsp.bak
[oracle@zbglxtdb dbca]$ vi dbca.rsp
#主要修改以下参数
gdbName=zbglxtdb
sid=zbglxtdb
databaseConfigType=SI
templateName=General_Purpose.dbc
sysPassword=“password”
systemPassword=“passowrd”
emConfiguration=DBEXPRESS
dbsnmpPassword=“password”
datafileDestination=/u01/app/oracle/oradata
characterSet=AL32UTF8
totalMemory=8192
#如果要创建容器数据库，则还需要配置以下参数，如果是多个pdb则以pdbname为前缀
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=yhggi
pdbAdminPassword=password
执行安装
[oracle@zbglxtdb dbca]$ dbca -silent -createDatabase -responseFile /u01/app/oracle/product/19.5.0/assistants/dbca/dbca.rsp
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/zbglxtdb.
Database Information:
Global Database Name:zbglxtdb
System Identifier(SID):zbglxtdb
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/zbglxtdb/zbglxtdb.log" for further details.
[oracle@zbglxtdb dbca]$
安装完成。
3、检查
[oracle@ywxtdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 6 21:53:54 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
???:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
发现有乱码，需要修改客户端的字符集
[oracle@ywxtdb ~]$vi .bash_profile #添加下面这行后重新应用生效即可。
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
".bash_profile" 21L, 623C written
[oracle@ywxtdb ~]$ source .bash_profile
[oracle@ywxtdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 星期五 3月 6 21:56:33 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
ywxtdb OPEN
SQL> exit
从 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0 断开
[oracle@ywxtdb ~]$
备注：在安装过程中出现DBT-11218错误，继续往下的话会报ORA-27104错误，这是因为内核参数设置错误，建议将以下两个参数进行调整。
kernel.shmall：控制共享内存页数,该参数大小为物理内存除以pagesize
kernel.shmmax：设置为实际物理内存的2/3或者物理内存的一半
其它内核参数说明：
shmmax=物理内存*80%*80%，单位是字节
kernel.shmmax：表示单个共享内存段的最大值，以字节为单位，此值一般为物理内存的一半，不过大一点也没关系，这里设定的为4GB，即“4294967295/1024/1024/1024=4G”。
kernel.shmmin：表示单个共享内存段的最小值，默认为1byte
kernel.shmall：表示整个系统范围内可用共享内存页的总量，单位是页（page），在32位系统上一页等于4kB，也就是4096字节。计算公式是：shmmax/PAGE_SIZE
kernel.shmmni：表示整个系统范围内内存段的最大数量，一般为4096.
ip_local_port_range ：表示端口的范围。在监听器帮助客户端进程和服务器进程建立连接时，会用到指定范围内的端口。
kernel.sem ：表示设置的信号量，这4个参数内容大小固定。
net.core.rmem_default ：表示接收套接字缓冲区大小的缺省值（以字节为单位）。
net.core.rmem_max ：表示接收套接字缓冲区大小的最大值（以字节为单位）
net.core.wmem_default ：表示发送套接字缓冲区大小的缺省值（以字节为单位）。
net.core.wmem_max ：表示发送套接字缓冲区大小的最大值（以字节为单位）。
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/161643.html原文链接：https://javaforall.cn
【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛
【官方授权 正版激活】： 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...