如何在云主机上安装Oracle Database 19c
发表于:2024-12-13 作者:千家信息网编辑
千家信息网最后更新 2024年12月13日,这篇文章主要介绍如何在云主机上安装Oracle Database 19c,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!能不能在免费的Oracle云主机上安装最新的Oracle
千家信息网最后更新 2024年12月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安全错误
数据库的锁怎样保障安全
江西计算机网络技术专科
沈阳信息网络安全公司
数据库发送邮件
建立网络安全防护能力
c 连接db2数据库接口
天阔服务器默认管理地址
plsql连接选不到数据库
局域网视频服务器系统
哪种文件服务器最安全
软件开发工程师简历优化
关于老年人app软件开发
网络安全法只适用于
深圳邮箱提取外贸软件开发公司
免费英国服务器节点
宁波萌牙网络技术有限公司
达梦数据库or用法
我的世界服务器间歇泉无法加载
浪潮服务器远程管理口账号
能加1060显卡的服务器
java 数据库链接池
长城宽带dns服务器地址
数据库字段设置为text
华为新网络技术
软件开发合同中使用权定义
东营设备软件开发服务
河北存货管理软件开发定制
网络安全的策划与总结
辽宁数据网络技术服务工程
旅馆网络安全技术
文登软件开发