这篇文章主要介绍如何在云主机上安装Oracle Database 19c,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!
能不能在免费的Oracle云主机上安装最新的Oracle Database呢?
答案是肯定的。虽然免费的Oracle云主机配置低,只有1OCPU,1GB内存,但还是能成功把19c的数据库正常跑起来!
首先,我们需要将安装包上传到云主机:
这里我们使用了rpm包的安装方式,以方便安装。从这里可以看到上传的速率还可以,能达到5MB/s了。
上传万rpm安装包后,就可以着手来安装数据库了!
先安装依赖包及设置必要的系统参数,我们可以使用oracle-database-preinstall-19c来简化该步骤:
[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执行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!
这一步的安装需要花点时间,大约需要20-30分钟。
安装完成Oracle Database 软件后,我们需要tmpfs的大小,因为系统默认的只有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用户,来创建数据库。注意:
/etc/init.d/oracledb_ORCLCDB-19c configure
这里不建议使用,由于系统配置低,使用这个脚本来创建数据库会失败。所以需要手工来创建数据库。
使用rpm安装的ORALCE_HOME为/opt/oracle/product/19c/dbhome_1
配置好参数文件:
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'
启动并创建数据库:
[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.
以上是“如何在云主机上安装Oracle Database 19c”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注亿速云行业资讯频道!
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。
原文链接:http://blog.itpub.net/13885898/viewspace-2694810/