ITPub博客

首页 > 云计算 > 公有云实践 > 使用免费的Oracle云服务-在云主机上安装Oracle Database 19c

使用免费的Oracle云服务-在云主机上安装Oracle Database 19c

原创 公有云实践 作者:Jet_Zhang 时间:2020-05-30 15:26:30 0 删除 编辑

能不能在免费的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.

Nice! 我们成功在Oracle云主机上创建了Oracle数据库!

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13885898/viewspace-2694810/,如需转载,请注明出处,否则将追究法律责任。

全部评论
中国南方Oracle用户组(SOUG)联合创始人,Oracle 10g OCM,曾服务于国外某大型银行,现为国内某保险公司的技术经理。擅长系统架构设计、Oracle/PostgreSQL数据库的故障和性能诊断、熟悉Tomcat内核,对Linux内核也有较浓厚的兴趣等。

注册时间:2014-02-19

  • 博文量
    79
  • 访问量
    468003