如何在云主机上安装Oracle Database 19c
发表于:2025-02-13 作者:千家信息网编辑
千家信息网最后更新 2025年02月13日,这篇文章主要介绍如何在云主机上安装Oracle Database 19c,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!能不能在免费的Oracle云主机上安装最新的Oracle
千家信息网最后更新 2025年02月13日如何在云主机上安装Oracle Database 19c
这篇文章主要介绍如何在云主机上安装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-19cLoaded plugins: langpacks, ulninfool7_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 ResolutionDependencies Resolved=================================================================================================================================================================================================================== Package Arch Version Repository Size===================================================================================================================================================================================================================Installing: oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 kInstalling 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 kTransaction Summary===================================================================================================================================================================================================================Install 1 Package (+29 Dependent packages)Total download size: 15 MInstalled size: 24 MIs this ok [y/d/N]: yDownloading 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 checkRunning transaction testTransaction test succeededRunning 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 -pfs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2fs.aio-max-nr = 1048576net.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, ulninfoExamining ./oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64Marking ./oracle-database-ee-19c-1.0-1.x86_64.rpm to be installedResolving Dependencies--> Running transaction check---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed--> Finished Dependency Resolutionol7_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 GTransaction Summary===================================================================================================================================================================================================================Install 1 PackageTotal size: 6.9 GInstalled size: 6.9 GIs this ok [y/d/N]: yDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning 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 -hFilesystem Size Used Avail Use% Mounted ondevtmpfs 458M 0 458M 0% /devtmpfs 3.0G 0 3.0G 0% /dev/shmtmpfs 486M 31M 455M 7% /runtmpfs 486M 0 486M 0% /sys/fs/cgroup/dev/sda3 39G 13G 26G 33% //dev/sda1 200M 9.7M 191M 5% /boot/efitmpfs 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=768Mprocesses = 150audit_file_dest='/opt/oracle/admin/orcl/adump'audit_trail ='db'db_block_size=8192db_domain=''db_create_file_dest='/opt/oracle/oradata/ORCL'db_recovery_file_dest='/opt/oracle/fast_recovery_area'db_recovery_file_dest_size=2Gdiagnostic_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 sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 07:05:06 2020Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to an idle instance.SQL> startup nomount;ORACLE instance started.Total System Global Area 805303360 bytesFixed Size 8901696 bytesVariable Size 486539264 bytesDatabase Buffers 301989888 bytesRedo Buffers 7872512 bytesSQL> 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"这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注行业资讯频道!
数据
数据库
主机
系统
配置
内容
参数
只有
篇文章
必要
成功
价值
兴趣
内存
大小
小伙
小伙伴
建议
手工
文件
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
深圳会议软件开发公司
网络技术岗位工作流程
速达v7服务器名在哪
华为服务器密码在哪里找
要素类 导入地理数据库失败
网上服务器cpu怎么找
软件开发套定额
部队网络技术培训个人申请书
租服务器app哪个好用
福建漳州网络安全维护文章
check在数据库
幼儿园放假前网络安全教育
网络安全认识与生活
node实现本地服务器
最服务器的国企
三石网络技术开发微信小程序
深圳市扩斯网络技术有限公司
软件开发业务组
数据库用于控制数据访问的是
rust代理数据库
mini数据库备份和恢复
珠宝软件开发管理
侯振谱软件开发
冬奥会无线网络技术
各大网络公司的服务器在哪里
华为昆仑服务器价格
安全互联网服务器属于通信吗
计算机系统和网络安全问题
美剧星球的服务器在哪里
推荐最好的服务器