共計(jì) 19692 個(gè)字符,預(yù)計(jì)需要花費(fèi) 50 分鐘才能閱讀完成。
這篇文章主要介紹如何在云主機(jī)上安裝 Oracle Database 19c,文中介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們一定要看完!
能不能在免費(fèi)的 Oracle 云主機(jī)上安裝最新的 Oracle Database 呢?
答案是肯定的。雖然免費(fèi)的 Oracle 云主機(jī)配置低,只有 1OCPU,1GB 內(nèi)存,但還是能成功把 19c 的數(shù)據(jù)庫(kù)正常跑起來(lái)!
首先,我們需要將安裝包上傳到云主機(jī):
這里我們使用了 rpm 包的安裝方式,以方便安裝。從這里可以看到上傳的速率還可以,能達(dá)到 5MB/ s 了。
上傳萬(wàn) rpm 安裝包后,就可以著手來(lái)安裝數(shù)據(jù)庫(kù)了!
先安裝依賴包及設(shè)置必要的系統(tǒng)參數(shù),我們可以使用 oracle-database-preinstall-19c 來(lái)簡(jiǎn)化該步驟:
[root@instance-20200526-2329 ~]# yum install oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
ol7_UEKR5 | 2.8 kB 00:00:00
ol7_addons | 2.8 kB 00:00:00
ol7_developer | 2.8 kB 00:00:00
ol7_developer_EPEL | 3.4 kB 00:00:00
ol7_ksplice | 2.8 kB 00:00:00
ol7_latest | 3.4 kB 00:00:00
ol7_oci_included | 2.9 kB 00:00:00
ol7_optional_latest | 2.8 kB 00:00:00
ol7_software_collections | 2.8 kB 00:00:00
ol7_ksplice/primary_db | 875 kB 00:00:00
Resolving Dependencies
-- Running transaction check
--- Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
-- Processing Dependency: xorg-x11-xauth for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: psmisc for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: glibc-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
-- Running transaction check
--- Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
--- Package glibc-devel.x86_64 0:2.17-307.0.1.el7.1 will be installed
-- Processing Dependency: glibc-headers = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
-- Processing Dependency: glibc-headers for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--- Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed
--- Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
--- Package libstdc++-devel.x86_64 0:4.8.5-39.0.3.el7 will be installed
--- Package psmisc.x86_64 0:22.20-16.el7 will be installed
--- Package xorg-x11-utils.x86_64 0:7.5-23.el7 will be installed
-- Processing Dependency: libxcb.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libxcb-shape.so.0()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libdmx.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXxf86vm.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXxf86misc.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXxf86dga.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXv.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXtst.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXrender.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXrandr.so.2()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXinerama.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXi.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libXext.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libX11.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
-- Processing Dependency: libX11-xcb.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--- Package xorg-x11-xauth.x86_64 1:1.0.9-1.el7 will be installed
-- Processing Dependency: libXmuu.so.1()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
-- Processing Dependency: libXau.so.6()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
-- Running transaction check
--- Package glibc-headers.x86_64 0:2.17-307.0.1.el7.1 will be installed
-- Processing Dependency: kernel-headers = 2.2.1 for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
-- Processing Dependency: kernel-headers for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
--- Package libX11.x86_64 0:1.6.7-2.el7 will be installed
-- Processing Dependency: libX11-common = 1.6.7-2.el7 for package: libX11-1.6.7-2.el7.x86_64
--- Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed
--- Package libXext.x86_64 0:1.3.3-3.el7 will be installed
--- Package libXi.x86_64 0:1.7.9-1.el7 will be installed
--- Package libXinerama.x86_64 0:1.1.3-2.1.el7 will be installed
--- Package libXmu.x86_64 0:1.1.2-2.el7 will be installed
-- Processing Dependency: libXt.so.6()(64bit) for package: libXmu-1.1.2-2.el7.x86_64
--- Package libXrandr.x86_64 0:1.5.1-2.el7 will be installed
--- Package libXrender.x86_64 0:0.9.10-1.el7 will be installed
--- Package libXtst.x86_64 0:1.2.3-1.el7 will be installed
--- Package libXv.x86_64 0:1.0.11-1.el7 will be installed
--- Package libXxf86dga.x86_64 0:1.1.4-2.1.el7 will be installed
--- Package libXxf86misc.x86_64 0:1.0.3-7.1.el7 will be installed
--- Package libXxf86vm.x86_64 0:1.1.4-1.el7 will be installed
--- Package libdmx.x86_64 0:1.1.3-3.el7 will be installed
--- Package libxcb.x86_64 0:1.13-1.el7 will be installed
-- Running transaction check
--- Package kernel-headers.x86_64 0:3.10.0-1127.8.2.el7 will be installed
--- Package libX11-common.noarch 0:1.6.7-2.el7 will be installed
--- Package libXt.x86_64 0:1.1.5-3.el7 will be installed
-- Processing Dependency: libSM.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
-- Processing Dependency: libICE.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
-- Running transaction check
--- Package libICE.x86_64 0:1.0.9-9.el7 will be installed
--- Package libSM.x86_64 0:1.2.2-2.el7 will be installed
-- Finished Dependency Resolution
Dependencies Resolved
===================================================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 k
Installing for dependencies:
compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k
glibc-devel x86_64 2.17-307.0.1.el7.1 ol7_latest 1.1 M
glibc-headers x86_64 2.17-307.0.1.el7.1 ol7_latest 691 k
kernel-headers x86_64 3.10.0-1127.8.2.el7 ol7_latest 8.9 M
ksh x86_64 20120801-142.0.1.el7 ol7_latest 882 k
libICE x86_64 1.0.9-9.el7 ol7_latest 66 k
libSM x86_64 1.2.2-2.el7 ol7_latest 39 k
libX11 x86_64 1.6.7-2.el7 ol7_latest 606 k
libX11-common noarch 1.6.7-2.el7 ol7_latest 164 k
libXau x86_64 1.0.8-2.1.el7 ol7_latest 28 k
libXext x86_64 1.3.3-3.el7 ol7_latest 38 k
libXi x86_64 1.7.9-1.el7 ol7_latest 40 k
libXinerama x86_64 1.1.3-2.1.el7 ol7_latest 13 k
libXmu x86_64 1.1.2-2.el7 ol7_latest 70 k
libXrandr x86_64 1.5.1-2.el7 ol7_latest 27 k
libXrender x86_64 0.9.10-1.el7 ol7_latest 25 k
libXt x86_64 1.1.5-3.el7 ol7_latest 172 k
libXtst x86_64 1.2.3-1.el7 ol7_latest 20 k
libXv x86_64 1.0.11-1.el7 ol7_latest 18 k
libXxf86dga x86_64 1.1.4-2.1.el7 ol7_latest 18 k
libXxf86misc x86_64 1.0.3-7.1.el7 ol7_latest 19 k
libXxf86vm x86_64 1.1.4-1.el7 ol7_latest 17 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
libdmx x86_64 1.1.3-3.el7 ol7_latest 15 k
libstdc++-devel x86_64 4.8.5-39.0.3.el7 ol7_latest 1.5 M
libxcb x86_64 1.13-1.el7 ol7_latest 213 k
psmisc x86_64 22.20-16.el7 ol7_latest 141 k
xorg-x11-utils x86_64 7.5-23.el7 ol7_latest 114 k
xorg-x11-xauth x86_64 1:1.0.9-1.el7 ol7_latest 29 k
Transaction Summary
===================================================================================================================================================================================================================
Install 1 Package (+29 Dependent packages)
Total download size: 15 M
Installed size: 24 M
Is this ok [y/d/N]: y
Downloading packages:
(1/30): compat-libcap1-1.10-7.el7.x86_64.rpm | 17 kB 00:00:00
(2/30): glibc-headers-2.17-307.0.1.el7.1.x86_64.rpm | 691 kB 00:00:00
(3/30): glibc-devel-2.17-307.0.1.el7.1.x86_64.rpm | 1.1 MB 00:00:00
(4/30): ksh-20120801-142.0.1.el7.x86_64.rpm | 882 kB 00:00:00
(5/30): libICE-1.0.9-9.el7.x86_64.rpm | 66 kB 00:00:00
(6/30): kernel-headers-3.10.0-1127.8.2.el7.x86_64.rpm | 8.9 MB 00:00:00
(7/30): libSM-1.2.2-2.el7.x86_64.rpm | 39 kB 00:00:00
(8/30): libX11-1.6.7-2.el7.x86_64.rpm | 606 kB 00:00:00
(9/30): libX11-common-1.6.7-2.el7.noarch.rpm | 164 kB 00:00:00
(10/30): libXext-1.3.3-3.el7.x86_64.rpm | 38 kB 00:00:00
(11/30): libXi-1.7.9-1.el7.x86_64.rpm | 40 kB 00:00:00
(12/30): libXinerama-1.1.3-2.1.el7.x86_64.rpm | 13 kB 00:00:00
(13/30): libXmu-1.1.2-2.el7.x86_64.rpm | 70 kB 00:00:00
(14/30): libXrandr-1.5.1-2.el7.x86_64.rpm | 27 kB 00:00:00
(15/30): libXrender-0.9.10-1.el7.x86_64.rpm | 25 kB 00:00:00
(16/30): libXt-1.1.5-3.el7.x86_64.rpm | 172 kB 00:00:00
(17/30): libXau-1.0.8-2.1.el7.x86_64.rpm | 28 kB 00:00:00
(18/30): libXtst-1.2.3-1.el7.x86_64.rpm | 20 kB 00:00:00
(19/30): libXv-1.0.11-1.el7.x86_64.rpm | 18 kB 00:00:00
(20/30): libXxf86misc-1.0.3-7.1.el7.x86_64.rpm | 19 kB 00:00:00
(21/30): libXxf86vm-1.1.4-1.el7.x86_64.rpm | 17 kB 00:00:00
(22/30): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00
(23/30): libdmx-1.1.3-3.el7.x86_64.rpm | 15 kB 00:00:00
(24/30): libstdc++-devel-4.8.5-39.0.3.el7.x86_64.rpm | 1.5 MB 00:00:00
(25/30): libxcb-1.13-1.el7.x86_64.rpm | 213 kB 00:00:00
(26/30): oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm | 19 kB 00:00:00
(27/30): psmisc-22.20-16.el7.x86_64.rpm | 141 kB 00:00:00
(28/30): xorg-x11-utils-7.5-23.el7.x86_64.rpm | 114 kB 00:00:00
(29/30): xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm | 29 kB 00:00:00
(30/30): libXxf86dga-1.1.4-2.1.el7.x86_64.rpm | 18 kB 00:00:00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 16 MB/s | 15 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libXau-1.0.8-2.1.el7.x86_64 1/30
Installing : libxcb-1.13-1.el7.x86_64 2/30
Installing : libICE-1.0.9-9.el7.x86_64 3/30
Installing : libSM-1.2.2-2.el7.x86_64 4/30
Installing : libaio-devel-0.3.109-13.el7.x86_64 5/30
Installing : compat-libcap1-1.10-7.el7.x86_64 6/30
Installing : ksh-20120801-142.0.1.el7.x86_64 7/30
Installing : kernel-headers-3.10.0-1127.8.2.el7.x86_64 8/30
Installing : glibc-headers-2.17-307.0.1.el7.1.x86_64 9/30
Installing : glibc-devel-2.17-307.0.1.el7.1.x86_64 10/30
Installing : psmisc-22.20-16.el7.x86_64 11/30
Installing : libX11-common-1.6.7-2.el7.noarch 12/30
Installing : libX11-1.6.7-2.el7.x86_64 13/30
Installing : libXext-1.3.3-3.el7.x86_64 14/30
Installing : libXi-1.7.9-1.el7.x86_64 15/30
Installing : libXrender-0.9.10-1.el7.x86_64 16/30
Installing : libXrandr-1.5.1-2.el7.x86_64 17/30
Installing : libXtst-1.2.3-1.el7.x86_64 18/30
Installing : libXxf86misc-1.0.3-7.1.el7.x86_64 19/30
Installing : libdmx-1.1.3-3.el7.x86_64 20/30
Installing : libXinerama-1.1.3-2.1.el7.x86_64 21/30
Installing : libXv-1.0.11-1.el7.x86_64 22/30
Installing : libXxf86vm-1.1.4-1.el7.x86_64 23/30
Installing : libXxf86dga-1.1.4-2.1.el7.x86_64 24/30
Installing : xorg-x11-utils-7.5-23.el7.x86_64 25/30
Installing : libXt-1.1.5-3.el7.x86_64 26/30
Installing : libXmu-1.1.2-2.el7.x86_64 27/30
Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 28/30
Installing : libstdc++-devel-4.8.5-39.0.3.el7.x86_64 29/30
Installing : oracle-database-preinstall-19c-1.0-2.el7.x86_64 30/30
Verifying : libXext-1.3.3-3.el7.x86_64 1/30
Verifying : libXxf86misc-1.0.3-7.1.el7.x86_64 2/30
Verifying : libdmx-1.1.3-3.el7.x86_64 3/30
Verifying : libICE-1.0.9-9.el7.x86_64 4/30
Verifying : libXinerama-1.1.3-2.1.el7.x86_64 5/30
Verifying : libXrender-0.9.10-1.el7.x86_64 6/30
Verifying : libXv-1.0.11-1.el7.x86_64 7/30
Verifying : libXi-1.7.9-1.el7.x86_64 8/30
Verifying : libXxf86vm-1.1.4-1.el7.x86_64 9/30
Verifying : libXt-1.1.5-3.el7.x86_64 10/30
Verifying : oracle-database-preinstall-19c-1.0-2.el7.x86_64 11/30
Verifying : libstdc++-devel-4.8.5-39.0.3.el7.x86_64 12/30
Verifying : xorg-x11-utils-7.5-23.el7.x86_64 13/30
Verifying : libXtst-1.2.3-1.el7.x86_64 14/30
Verifying : libX11-1.6.7-2.el7.x86_64 15/30
Verifying : libX11-common-1.6.7-2.el7.noarch 16/30
Verifying : libxcb-1.13-1.el7.x86_64 17/30
Verifying : glibc-headers-2.17-307.0.1.el7.1.x86_64 18/30
Verifying : psmisc-22.20-16.el7.x86_64 19/30
Verifying : kernel-headers-3.10.0-1127.8.2.el7.x86_64 20/30
Verifying : ksh-20120801-142.0.1.el7.x86_64 21/30
Verifying : compat-libcap1-1.10-7.el7.x86_64 22/30
Verifying : libXrandr-1.5.1-2.el7.x86_64 23/30
Verifying : libaio-devel-0.3.109-13.el7.x86_64 24/30
Verifying : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 25/30
Verifying : libXau-1.0.8-2.1.el7.x86_64 26/30
Verifying : libSM-1.2.2-2.el7.x86_64 27/30
Verifying : libXxf86dga-1.1.4-2.1.el7.x86_64 28/30
Verifying : libXmu-1.1.2-2.el7.x86_64 29/30
Verifying : glibc-devel-2.17-307.0.1.el7.1.x86_64 30/30
Installed:
oracle-database-preinstall-19c.x86_64 0:1.0-2.el7
Dependency Installed:
compat-libcap1.x86_64 0:1.10-7.el7 glibc-devel.x86_64 0:2.17-307.0.1.el7.1 glibc-headers.x86_64 0:2.17-307.0.1.el7.1 kernel-headers.x86_64 0:3.10.0-1127.8.2.el7 ksh.x86_64 0:20120801-142.0.1.el7
libICE.x86_64 0:1.0.9-9.el7 libSM.x86_64 0:1.2.2-2.el7 libX11.x86_64 0:1.6.7-2.el7 libX11-common.noarch 0:1.6.7-2.el7 libXau.x86_64 0:1.0.8-2.1.el7
libXext.x86_64 0:1.3.3-3.el7 libXi.x86_64 0:1.7.9-1.el7 libXinerama.x86_64 0:1.1.3-2.1.el7 libXmu.x86_64 0:1.1.2-2.el7 libXrandr.x86_64 0:1.5.1-2.el7
libXrender.x86_64 0:0.9.10-1.el7 libXt.x86_64 0:1.1.5-3.el7 libXtst.x86_64 0:1.2.3-1.el7 libXv.x86_64 0:1.0.11-1.el7 libXxf86dga.x86_64 0:1.1.4-2.1.el7
libXxf86misc.x86_64 0:1.0.3-7.1.el7 libXxf86vm.x86_64 0:1.1.4-1.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libdmx.x86_64 0:1.1.3-3.el7 libstdc++-devel.x86_64 0:4.8.5-39.0.3.el7
libxcb.x86_64 0:1.13-1.el7 psmisc.x86_64 0:22.20-16.el7 xorg-x11-utils.x86_64 0:7.5-23.el7 xorg-x11-xauth.x86_64 1:1.0.9-1.el7
Complete!
然后以 root 執(zhí)行 sysctl -p
[root@instance-20200526-2329 ~]# sysctl -p
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
然后安裝 oracle-database-ee-19c-1.0-1.x86_64.rpm:
[root@instance-20200526-2329 soft]# yum install ./oracle-database-ee-19c-1.0-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining ./oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64
Marking ./oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
-- Running transaction check
--- Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed
-- Finished Dependency Resolution
ol7_UEKR5/x86_64 | 2.8 kB 00:00:00
ol7_addons/x86_64 | 2.8 kB 00:00:00
ol7_developer/x86_64 | 2.8 kB 00:00:00
ol7_developer/x86_64/primary_db | 531 kB 00:00:00
ol7_developer_EPEL/x86_64 | 3.4 kB 00:00:00
ol7_ksplice | 2.8 kB 00:00:00
ol7_ksplice/primary_db | 875 kB 00:00:00
ol7_latest/x86_64 | 3.4 kB 00:00:00
ol7_latest/x86_64/updateinfo | 2.8 MB 00:00:00
ol7_latest/x86_64/primary_db | 22 MB 00:00:00
ol7_oci_included/x86_64 | 2.9 kB 00:00:00
ol7_optional_latest/x86_64 | 2.8 kB 00:00:00
ol7_optional_latest/x86_64/updateinfo | 1.0 MB 00:00:00
ol7_optional_latest/x86_64/primary_db | 4.7 MB 00:00:00
ol7_software_collections/x86_64 | 2.8 kB 00:00:00
ol7_software_collections/x86_64/updateinfo | 8.7 kB 00:00:00
ol7_software_collections/x86_64/primary_db | 4.9 MB 00:00:00
Dependencies Resolved
===================================================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================================================
Installing:
oracle-database-ee-19c x86_64 1.0-1 /oracle-database-ee-19c-1.0-1.x86_64 6.9 G
Transaction Summary
===================================================================================================================================================================================================================
Install 1 Package
Total size: 6.9 G
Installed size: 6.9 G
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1
Installed:
oracle-database-ee-19c.x86_64 0:1.0-1
Complete!
這一步的安裝需要花點(diǎn)時(shí)間,大約需要 20-30 分鐘。
安裝完成 Oracle Database 軟件后,我們需要 tmpfs 的大小,因?yàn)橄到y(tǒng)默認(rèn)的只有 486M,太小了:
[root@instance-20200526-2329 ~]# mount -o size=3072M -o remount /dev/shm
[root@instance-20200526-2329 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 458M 0 458M 0% /dev
tmpfs 3.0G 0 3.0G 0% /dev/shm
tmpfs 486M 31M 455M 7% /run
tmpfs 486M 0 486M 0% /sys/fs/cgroup
/dev/sda3 39G 13G 26G 33% /
/dev/sda1 200M 9.7M 191M 5% /boot/efi
tmpfs 98M 0 98M 0% /run/user/1001
然后切換到 Oracle 用戶,來(lái)創(chuàng)建數(shù)據(jù)庫(kù)。注意:
/etc/init.d/oracledb_ORCLCDB-19c configure
這里不建議使用,由于系統(tǒng)配置低,使用這個(gè)腳本來(lái)創(chuàng)建數(shù)據(jù)庫(kù)會(huì)失敗。所以需要手工來(lái)創(chuàng)建數(shù)據(jù)庫(kù)。
使用 rpm 安裝的 ORALCE_HOME 為 /opt/oracle/product/19c/dbhome_1
配置好參數(shù)文件:
db_name= ORCL
memory_target=768M
processes = 150
audit_file_dest= /opt/oracle/admin/orcl/adump
audit_trail = db
db_block_size=8192
db_domain=
db_create_file_dest= /opt/oracle/oradata/ORCL
db_recovery_file_dest= /opt/oracle/fast_recovery_area
db_recovery_file_dest_size=2G
diagnostic_dest= /opt/oracle
dispatchers= (PROTOCOL=TCP) (SERVICE=ORCLXDB)
open_cursors=300
remote_login_passwordfile= EXCLUSIVE
undo_tablespace= UNDOTBS1
control_files = (ora_control1, ora_control2)
compatible = 11.2.0
啟動(dòng)并創(chuàng)建數(shù)據(jù)庫(kù):
[oracle@instance-20200526-2329 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 07:05:06 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL startup nomount;
ORACLE instance started.
Total System Global Area 805303360 bytes
Fixed Size 8901696 bytes
Variable Size 486539264 bytes
Database Buffers 301989888 bytes
Redo Buffers 7872512 bytes
SQL CREATE DATABASE ORCL
CONTROLFILE REUSE
LOGFILE
GROUP 1 (/opt/oracle/oradata/ORCL/log1.log) SIZE 16M,
GROUP 2 (/opt/oracle/oradata/ORCL/log2.log) SIZE 16M
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts
UNDO TABLESPACE UNDOTBS1; 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Database created.
以上是“如何在云主機(jī)上安裝 Oracle Database 19c”這篇文章的所有內(nèi)容,感謝各位的閱讀!希望分享的內(nèi)容對(duì)大家有幫助,更多相關(guān)知識(shí),歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道!