这篇文章主要介绍如何在云主机上安装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”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注亿速云行业资讯频道!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。