使用免費的Oracle雲服務-在雲主機上安裝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.
Nice! 我們成功在Oracle雲主機上建立了Oracle資料庫！
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13885898/viewspace-2694810/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 使用免費的Oracle雲服務－建立雲主機Oracle
- 使用免費的Oracle雲服務－通過console連線雲主機Oracle
- 試用免費的Oracle雲服務Oracle
- 使用免費的Oracle雲服務-建立ATP資料庫Oracle資料庫
- 使用免費的Oracle雲服務-遠端連線ATPOracle
- 使用免費的Oracle雲服務-建立並使用ADW資料庫Oracle資料庫
- Oracle Database 19c安裝Sample SchemasOracleDatabase
- 使用免費的Oracle雲服務-使用並監控ATP資料庫Oracle資料庫
- Oracle 19c Concepts(01)：Introduction to Oracle DatabaseOracleDatabase
- Oracle 19c Concepts(13)：Oracle Database InstanceOracleDatabase
- Oracle 19c的安裝Oracle
- Oracle 19c TFA的安裝與使用Oracle
- Oracle OCP(35)：Database 安裝OracleDatabase
- 在Centos 上安裝oracle-database-preinstall-19c軟體包CentOSOracleDatabase
- oracle 19c 安裝、解除安裝Oracle
- Oracle 19c Database Management ToolsOracleDatabase
- Oracle 19c RPM安裝Oracle
- Oracle 19c Concepts(00)：Changes in This Release for Oracle Database ConceptsOracleDatabase
- 【Oracle】Windows安裝oracle11gR1 database 11.1.0.6OracleWindowsDatabase
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- 1 Oracle Database 19c 新特性OracleDatabase
- oracle 19C 靜默安裝Oracle
- Docker中安裝Oracle 19cDockerOracle
- Oracle 19c 安裝嚐鮮Oracle
- 【DB寶3】在Docker中使用rpm包的方式安裝Oracle 19cDockerOracle
- oracle 19c dataguard silent install (oracle 19c dataguard 靜默安裝)Oracle
- 在Oracle Linux 7.1上安裝DockerOracleLinuxDocker
- 雲列印軟體免費版在哪？雲列印服務怎麼使用？
- Oracle Database 19c中的自動索引OracleDatabase索引
- Oracle 19c Concepts(18)：Concepts for Database AdministratorsOracleDatabase
- Oracle 19c Concepts(19)：Concepts for Database DevelopersOracleDatabaseDeveloper
- Oracle 19C 下載和安裝Oracle
- 在FC5上安裝oracle 9204Oracle
- 雲主機如何安裝grunt
- 阿貝雲-免費雲伺服器雲服務提供商伺服器
- 免費雲伺服器/虛擬主機伺服器
- Oracle 19c Concepts(17)：Topics for Database Administrators and DevelopersOracleDatabaseDeveloper
- Disable Database Audit In Oracle 19c RAC-20220111DatabaseOracle