这篇文章主要介绍如何在云主机上安装oracle Database 19c,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!能不能在免费的Oracle云主机上安装最新的Oracle Database呢?答案是肯定的。虽然免
这篇文章主要介绍如何在云主机上安装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”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注编程网精选频道!
--结束END--
本文标题: 如何在云主机上安装Oracle Database 19c
本文链接: https://www.lsjlt.com/news/235729.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-09
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0