Hello, I created this post to help people to create an easy and fast Oracle Database environment to test some commands, sql statements, backup and restore or just to learn something new. The goal here is to create one linux vm, as easy and simple as possible, than install and create an Oracle Database, with that you can use the learn and test almost all functionalities and increase your knowledge. If you find something wrong here, please inform me via comments or via email.
I hope you can learn something really helpful here, like it was for me.
# ----------------------------------
# Create a VM using VirtualBox.
# ----------------------------------
# The idea is create a VM as simple as possible. In this demonstration LAB that I am creating here, will fit for the versions XE and EE as well, we can have the same VM/Linux Installation for both tests.
# ----------------------------------
# VM Creating.
# ----------------------------------
OS: Oracle Linux 7.8 x86_64 |
# After installation of Linux on this VM, you can configure the "/etc/hosts" with the name of the server and the it's ip, this step is mandatory for the database creation.
# ----------------------------------
# 18c (Version XE)
# ----------------------------------
# To install all necessary packages on Linux, just execute this command, just it and all necessary packages will be installed for the Oracle Softwares.
yum -y install oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm yum -y install oracle-database-preinstall-18c.x86_64 |
# ----------------------------------
# To install the Oracle XE software, just download and save the RPM Package, use this link to download it: https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
# ----------------------------------
# Once the download it's done, just execute this command to install the Oracle XE Software.
yum -y localinstall /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm |
# ----------------------------------
# After the installation process is done, we have to create the database, just execute that command and the database will be created, the SID will be: XE
/etc/init.d/oracle-xe-18c configure |
# ----------------------------------
# This command asks you to insert the password of this instance.
# ----------------------------------
# That is it, after the database creation, you have to connect on the Oracle User, and connect on the database using sqlplus, (don't forget to setup the variables using . oraenv).
su – oracle |
# Look my example here!!!
# ----------------------------------
# Installation of Oracle XE
Last failed login: Thu Aug 27 14:30:18 CEST 2020 from 192.168.56.1 on ssh:notty
There was 1 failed login attempt since the last successful login.
Last login: Thu Aug 27 14:28:07 2020
# ----------------------------------
# Install the pre-install package
[root@oel7-ora-xe ~]# yum -y install oracle-database-preinstall-18c-1.0-1.el7.x86_64
Loaded plugins: ulninfo
ol7_UEKR5 | 2.5 kB 00:00:00
ol7_latest | 2.7 kB 00:00:00
(1/5): ol7_latest/x86_64/group | 660 kB 00:00:00
(2/5): ol7_UEKR5/x86_64/updateinfo | 72 kB 00:00:00
(3/5): ol7_latest/x86_64/updateinfo | 2.9 MB 00:00:00
(4/5): ol7_UEKR5/x86_64/primary_db | 12 MB 00:00:00
(5/5): ol7_latest/x86_64/primary_db | 36 MB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed
--> Processing Dependency: bc for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: sysstat for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: bind-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: net-tools for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: xorg-x11-xauth for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libaio for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: psmisc for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: unzip for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: glibc-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: compat-libstdc++-33 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: nfs-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: smartmontools for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Running transaction check
---> Package bc.x86_64 0:1.06.95-13.el7 will be installed
---> Package bind-utils.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
--> Processing Dependency: bind-libs(x86-64) = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: bind-libs-lite(x86-64) = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libisc.so.169()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libdns.so.1102()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libisccfg.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: liblwres.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libGeoIP.so.1()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libirs.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libbind9.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.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.x86_64 0:0.3.109-13.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.5.el7 will be installed
--> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.5.el7 for package: libstdc++-devel-4.8.5-39.0.5.el7.x86_64
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package nfs-utils.x86_64 1:1.3.0-0.66.0.1.el7_8 will be installed
--> Processing Dependency: gssproxy >= 0.7.0-3 for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libtirpc >= 0.2.4-0.7 for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: rpcbind for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: keyutils for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libevent for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libnfsidmap for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: quota for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libevent-2.0.so.5()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libtirpc.so.1()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libnfsidmap.so.0()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
---> Package psmisc.x86_64 0:22.20-16.el7 will be installed
---> Package smartmontools.x86_64 1:7.0-2.el7 will be installed
--> Processing Dependency: mailx for package: 1:smartmontools-7.0-2.el7.x86_64
---> Package sysstat.x86_64 0:10.1.5-19.el7 will be installed
--> Processing Dependency: libsensors.so.4()(64bit) for package: sysstat-10.1.5-19.el7.x86_64
---> Package unzip.x86_64 0:6.0-21.el7 will be installed
---> Package xorg-x11-utils.x86_64 0:7.5-23.el7 will be installed
--> Processing Dependency: libXext.so.6()(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: 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: libX11-xcb.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: libdmx.so.1()(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: libX11.so.6()(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: 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: libXi.so.6()(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: libXau.so.6()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
--> Processing Dependency: libXmuu.so.1()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
--> Running transaction check
---> Package GeoIP.x86_64 0:1.5.0-14.el7 will be installed
--> Processing Dependency: geoipupdate for package: GeoIP-1.5.0-14.el7.x86_64
---> Package bind-libs.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
--> Processing Dependency: bind-license = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64
---> Package bind-libs-lite.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
---> 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 gssproxy.x86_64 0:0.7.0-28.el7 will be installed
--> Processing Dependency: libini_config >= 1.3.1-31 for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libref_array.so.1(REF_ARRAY_0.1.1)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.1.0)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.2.0)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libverto-module-base for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libbasicobjects.so.0()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libref_array.so.1()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libcollection.so.2()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
---> Package keyutils.x86_64 0:1.5.8-3.el7 will be installed
---> 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 libevent.x86_64 0:2.0.21-4.el7 will be installed
---> Package libnfsidmap.x86_64 0:0.25-19.el7 will be installed
---> Package libstdc++.x86_64 0:4.8.5-39.0.3.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-39.0.5.el7 will be an update
---> Package libtirpc.x86_64 0:0.2.4-0.16.el7 will be installed
---> Package libxcb.x86_64 0:1.13-1.el7 will be installed
---> Package lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7 will be installed
---> Package mailx.x86_64 0:12.5-19.el7 will be installed
---> Package quota.x86_64 1:4.01-19.el7 will be installed
--> Processing Dependency: quota-nls = 1:4.01-19.el7 for package: 1:quota-4.01-19.el7.x86_64
--> Processing Dependency: tcp_wrappers for package: 1:quota-4.01-19.el7.x86_64
---> Package rpcbind.x86_64 0:0.2.0-49.el7 will be installed
--> Running transaction check
---> Package bind-license.noarch 32:9.11.4-16.P2.el7_8.6 will be installed
---> Package geoipupdate.x86_64 0:2.5.0-1.el7 will be installed
---> Package kernel-headers.x86_64 0:3.10.0-1127.19.1.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: libICE.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
--> Processing Dependency: libSM.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
---> Package libbasicobjects.x86_64 0:0.1.1-32.el7 will be installed
---> Package libcollection.x86_64 0:0.7.0-32.el7 will be installed
---> Package libini_config.x86_64 0:1.3.1-32.el7 will be installed
--> Processing Dependency: libpath_utils.so.1(PATH_UTILS_0.2.1)(64bit) for package: libini_config-1.3.1-32.el7.x86_64
--> Processing Dependency: libpath_utils.so.1()(64bit) for package: libini_config-1.3.1-32.el7.x86_64
---> Package libref_array.x86_64 0:0.1.5-32.el7 will be installed
---> Package libverto-libevent.x86_64 0:0.2.5-4.el7 will be installed
---> Package quota-nls.noarch 1:4.01-19.el7 will be installed
---> Package tcp_wrappers.x86_64 0:7.6-77.el7 will be installed
--> 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
---> Package libpath_utils.x86_64 0:0.2.1-32.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================
Package Arch Version Repository Size
================================================================================================================
Installing:
oracle-database-preinstall-18c x86_64 1.0-1.el7 ol7_latest 18 k
Installing for dependencies:
GeoIP x86_64 1.5.0-14.el7 ol7_latest 1.5 M
bc x86_64 1.06.95-13.el7 ol7_latest 114 k
bind-libs x86_64 32:9.11.4-16.P2.el7_8.6 ol7_latest 155 k
bind-libs-lite x86_64 32:9.11.4-16.P2.el7_8.6 ol7_latest 1.1 M
bind-license noarch 32:9.11.4-16.P2.el7_8.6 ol7_latest 89 k
bind-utils x86_64 32:9.11.4-16.P2.el7_8.6 ol7_latest 259 k
compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k
compat-libstdc++-33 x86_64 3.2.3-72.el7 ol7_latest 190 k
geoipupdate x86_64 2.5.0-1.el7 ol7_latest 34 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
gssproxy x86_64 0.7.0-28.el7 ol7_latest 110 k
kernel-headers x86_64 3.10.0-1127.19.1.el7 ol7_latest 9.0 M
keyutils x86_64 1.5.8-3.el7 ol7_latest 53 k
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 x86_64 0.3.109-13.el7 ol7_latest 24 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
libbasicobjects x86_64 0.1.1-32.el7 ol7_latest 25 k
libcollection x86_64 0.7.0-32.el7 ol7_latest 41 k
libdmx x86_64 1.1.3-3.el7 ol7_latest 15 k
libevent x86_64 2.0.21-4.el7 ol7_latest 208 k
libini_config x86_64 1.3.1-32.el7 ol7_latest 63 k
libnfsidmap x86_64 0.25-19.el7 ol7_latest 49 k
libpath_utils x86_64 0.2.1-32.el7 ol7_latest 28 k
libref_array x86_64 0.1.5-32.el7 ol7_latest 27 k
libstdc++-devel x86_64 4.8.5-39.0.5.el7 ol7_latest 1.5 M
libtirpc x86_64 0.2.4-0.16.el7 ol7_latest 89 k
libverto-libevent x86_64 0.2.5-4.el7 ol7_latest 8.2 k
libxcb x86_64 1.13-1.el7 ol7_latest 213 k
lm_sensors-libs x86_64 3.4.0-8.20160601gitf9185e5.el7 ol7_latest 41 k
mailx x86_64 12.5-19.el7 ol7_latest 244 k
net-tools x86_64 2.0-0.25.20131004git.el7 ol7_latest 305 k
nfs-utils x86_64 1:1.3.0-0.66.0.1.el7_8 ol7_latest 412 k
psmisc x86_64 22.20-16.el7 ol7_latest 141 k
quota x86_64 1:4.01-19.el7 ol7_latest 178 k
quota-nls noarch 1:4.01-19.el7 ol7_latest 90 k
rpcbind x86_64 0.2.0-49.el7 ol7_latest 59 k
smartmontools x86_64 1:7.0-2.el7 ol7_latest 546 k
sysstat x86_64 10.1.5-19.el7 ol7_latest 315 k
tcp_wrappers x86_64 7.6-77.el7 ol7_latest 78 k
unzip x86_64 6.0-21.el7 ol7_latest 171 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
Updating for dependencies:
libstdc++ x86_64 4.8.5-39.0.5.el7 ol7_latest 306 k
Transaction Summary
================================================================================================================
Install 1 Package (+60 Dependent packages)
Upgrade ( 1 Dependent package)
Total download size: 22 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/bc-1.06.95-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for bc-1.06.95-13.el7.x86_64.rpm is not installed
(1/62): bc-1.06.95-13.el7.x86_64.rpm | 114 kB 00:00:00
(2/62): bind-libs-9.11.4-16.P2.el7_8.6.x86_64.rpm | 155 kB 00:00:00
(3/62): GeoIP-1.5.0-14.el7.x86_64.rpm | 1.5 MB 00:00:00
(4/62): bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64.rpm | 1.1 MB 00:00:00
(5/62): bind-license-9.11.4-16.P2.el7_8.6.noarch.rpm | 89 kB 00:00:00
(6/62): bind-utils-9.11.4-16.P2.el7_8.6.x86_64.rpm | 259 kB 00:00:00
(7/62): compat-libcap1-1.10-7.el7.x86_64.rpm | 17 kB 00:00:00
(8/62): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm | 190 kB 00:00:00
(9/62): geoipupdate-2.5.0-1.el7.x86_64.rpm | 34 kB 00:00:00
(10/62): glibc-headers-2.17-307.0.1.el7.1.x86_64.rpm | 691 kB 00:00:00
(11/62): glibc-devel-2.17-307.0.1.el7.1.x86_64.rpm | 1.1 MB 00:00:00
(12/62): gssproxy-0.7.0-28.el7.x86_64.rpm | 110 kB 00:00:00
(13/62): keyutils-1.5.8-3.el7.x86_64.rpm | 53 kB 00:00:00
(14/62): ksh-20120801-142.0.1.el7.x86_64.rpm | 882 kB 00:00:00
(15/62): libICE-1.0.9-9.el7.x86_64.rpm | 66 kB 00:00:00
(16/62): kernel-headers-3.10.0-1127.19.1.el7.x86_64.rpm | 9.0 MB 00:00:00
(17/62): libSM-1.2.2-2.el7.x86_64.rpm | 39 kB 00:00:00
(18/62): libX11-common-1.6.7-2.el7.noarch.rpm | 164 kB 00:00:00
(19/62): libX11-1.6.7-2.el7.x86_64.rpm | 606 kB 00:00:00
(20/62): libXau-1.0.8-2.1.el7.x86_64.rpm | 28 kB 00:00:00
(21/62): libXi-1.7.9-1.el7.x86_64.rpm | 40 kB 00:00:00
(22/62): libXinerama-1.1.3-2.1.el7.x86_64.rpm | 13 kB 00:00:00
(23/62): libXmu-1.1.2-2.el7.x86_64.rpm | 70 kB 00:00:00
(24/62): libXrandr-1.5.1-2.el7.x86_64.rpm | 27 kB 00:00:00
(25/62): libXrender-0.9.10-1.el7.x86_64.rpm | 25 kB 00:00:00
(26/62): libXt-1.1.5-3.el7.x86_64.rpm | 172 kB 00:00:00
(27/62): libXtst-1.2.3-1.el7.x86_64.rpm | 20 kB 00:00:00
(28/62): libXv-1.0.11-1.el7.x86_64.rpm | 18 kB 00:00:00
(29/62): libXxf86dga-1.1.4-2.1.el7.x86_64.rpm | 18 kB 00:00:00
(30/62): libXxf86misc-1.0.3-7.1.el7.x86_64.rpm | 19 kB 00:00:00
(31/62): libXext-1.3.3-3.el7.x86_64.rpm | 38 kB 00:00:00
(32/62): libXxf86vm-1.1.4-1.el7.x86_64.rpm | 17 kB 00:00:00
(33/62): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00
(34/62): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00
(35/62): libbasicobjects-0.1.1-32.el7.x86_64.rpm | 25 kB 00:00:00
(36/62): libcollection-0.7.0-32.el7.x86_64.rpm | 41 kB 00:00:00
(37/62): libdmx-1.1.3-3.el7.x86_64.rpm | 15 kB 00:00:00
(38/62): libevent-2.0.21-4.el7.x86_64.rpm | 208 kB 00:00:00
(39/62): libini_config-1.3.1-32.el7.x86_64.rpm | 63 kB 00:00:00
(40/62): libnfsidmap-0.25-19.el7.x86_64.rpm | 49 kB 00:00:00
(41/62): libpath_utils-0.2.1-32.el7.x86_64.rpm | 28 kB 00:00:00
(42/62): libref_array-0.1.5-32.el7.x86_64.rpm | 27 kB 00:00:00
(43/62): libstdc++-devel-4.8.5-39.0.5.el7.x86_64.rpm | 1.5 MB 00:00:00
(44/62): libstdc++-4.8.5-39.0.5.el7.x86_64.rpm | 306 kB 00:00:00
(45/62): libtirpc-0.2.4-0.16.el7.x86_64.rpm | 89 kB 00:00:00
(46/62): libxcb-1.13-1.el7.x86_64.rpm | 213 kB 00:00:00
(47/62): lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64.rpm | 41 kB 00:00:00
(48/62): mailx-12.5-19.el7.x86_64.rpm | 244 kB 00:00:00
(49/62): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm | 305 kB 00:00:00
(50/62): nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64.rpm | 412 kB 00:00:00
(51/62): libverto-libevent-0.2.5-4.el7.x86_64.rpm | 8.2 kB 00:00:00
(52/62): oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm | 18 kB 00:00:00
(53/62): quota-4.01-19.el7.x86_64.rpm | 178 kB 00:00:00
(54/62): quota-nls-4.01-19.el7.noarch.rpm | 90 kB 00:00:00
(55/62): psmisc-22.20-16.el7.x86_64.rpm | 141 kB 00:00:00
(56/62): rpcbind-0.2.0-49.el7.x86_64.rpm | 59 kB 00:00:00
(57/62): sysstat-10.1.5-19.el7.x86_64.rpm | 315 kB 00:00:00
(58/62): smartmontools-7.0-2.el7.x86_64.rpm | 546 kB 00:00:00
(59/62): tcp_wrappers-7.6-77.el7.x86_64.rpm | 78 kB 00:00:00
(60/62): unzip-6.0-21.el7.x86_64.rpm | 171 kB 00:00:00
(61/62): xorg-x11-utils-7.5-23.el7.x86_64.rpm | 114 kB 00:00:00
(62/62): xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm | 29 kB 00:00:00
----------------------------------------------------------------------------------------------------------------
Total 17 MB/s | 22 MB 00:00:01
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.8-1.0.7.el7.x86_64 (@anaconda/7.8)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : libstdc++-4.8.5-39.0.5.el7.x86_64 1/63
Installing : libXau-1.0.8-2.1.el7.x86_64 2/63
Installing : libxcb-1.13-1.el7.x86_64 3/63
Installing : 32:bind-license-9.11.4-16.P2.el7_8.6.noarch 4/63
Installing : libref_array-0.1.5-32.el7.x86_64 5/63
Installing : libevent-2.0.21-4.el7.x86_64 6/63
Installing : libaio-0.3.109-13.el7.x86_64 7/63
Installing : libbasicobjects-0.1.1-32.el7.x86_64 8/63
Installing : libcollection-0.7.0-32.el7.x86_64 9/63
Installing : libICE-1.0.9-9.el7.x86_64 10/63
Installing : libtirpc-0.2.4-0.16.el7.x86_64 11/63
Installing : rpcbind-0.2.0-49.el7.x86_64 12/63
Installing : libSM-1.2.2-2.el7.x86_64 13/63
Installing : libaio-devel-0.3.109-13.el7.x86_64 14/63
Installing : libverto-libevent-0.2.5-4.el7.x86_64 15/63
Installing : libstdc++-devel-4.8.5-39.0.5.el7.x86_64 16/63
Installing : 1:quota-nls-4.01-19.el7.noarch 17/63
Installing : mailx-12.5-19.el7.x86_64 18/63|
Installing : 1:smartmontools-7.0-2.el7.x86_64 19/63
Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 20/63
Installing : keyutils-1.5.8-3.el7.x86_64 21/63
Installing : libnfsidmap-0.25-19.el7.x86_64 22/63
Installing : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64 23/63
Installing : sysstat-10.1.5-19.el7.x86_64 24/63
Installing : libpath_utils-0.2.1-32.el7.x86_64 25/63
Installing : libini_config-1.3.1-32.el7.x86_64 26/63
Installing : gssproxy-0.7.0-28.el7.x86_64 27/63
Installing : compat-libcap1-1.10-7.el7.x86_64 28/63
Installing : ksh-20120801-142.0.1.el7.x86_64 29/63
Installing : unzip-6.0-21.el7.x86_64 30/63
Installing : libX11-common-1.6.7-2.el7.noarch 31/63
Installing : libX11-1.6.7-2.el7.x86_64 32/63
Installing : libXext-1.3.3-3.el7.x86_64 33/63
Installing : libXi-1.7.9-1.el7.x86_64 34/63
Installing : libXrender-0.9.10-1.el7.x86_64 35/63
Installing : libXrandr-1.5.1-2.el7.x86_64 36/63
Installing : libXtst-1.2.3-1.el7.x86_64 37/63
Installing : libXxf86misc-1.0.3-7.1.el7.x86_64 38/63
Installing : libdmx-1.1.3-3.el7.x86_64 39/63
Installing : libXinerama-1.1.3-2.1.el7.x86_64 40/63
Installing : libXv-1.0.11-1.el7.x86_64 41/63
Installing : libXxf86vm-1.1.4-1.el7.x86_64 42/63
Installing : libXxf86dga-1.1.4-2.1.el7.x86_64 43/63
Installing : xorg-x11-utils-7.5-23.el7.x86_64 44/63
Installing : libXt-1.1.5-3.el7.x86_64 45/63
Installing : libXmu-1.1.2-2.el7.x86_64 46/63
Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 47/63
Installing : psmisc-22.20-16.el7.x86_64 48/63
Installing : net-tools-2.0-0.25.20131004git.el7.x86_64 49/63
Installing : kernel-headers-3.10.0-1127.19.1.el7.x86_64 50/63
Installing : glibc-headers-2.17-307.0.1.el7.1.x86_64 51/63
Installing : glibc-devel-2.17-307.0.1.el7.1.x86_64 52/63
Installing : bc-1.06.95-13.el7.x86_64 53/63
Installing : tcp_wrappers-7.6-77.el7.x86_64 54/63
Installing : 1:quota-4.01-19.el7.x86_64 55/63
Installing : 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64 56/63
Installing : geoipupdate-2.5.0-1.el7.x86_64 57/63
Installing : GeoIP-1.5.0-14.el7.x86_64 58/63
Installing : 32:bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64 59/63
Installing : 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64 60/63
Installing : 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64 61/63
Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64 62/63
Cleanup : libstdc++-4.8.5-39.0.3.el7.x86_64 63/63
Verifying : libtirpc-0.2.4-0.16.el7.x86_64 1/63
Verifying : libXext-1.3.3-3.el7.x86_64 2/63
Verifying : libXxf86misc-1.0.3-7.1.el7.x86_64 3/63
Verifying : libdmx-1.1.3-3.el7.x86_64 4/63
Verifying : libICE-1.0.9-9.el7.x86_64 5/63
Verifying : geoipupdate-2.5.0-1.el7.x86_64 6/63
Verifying : libXinerama-1.1.3-2.1.el7.x86_64 7/63
Verifying : libXrender-0.9.10-1.el7.x86_64 8/63
Verifying : libXt-1.1.5-3.el7.x86_64 9/63
Verifying : libXv-1.0.11-1.el7.x86_64 10/63
Verifying : libXi-1.7.9-1.el7.x86_64 11/63
Verifying : libXxf86vm-1.1.4-1.el7.x86_64 12/63
Verifying : tcp_wrappers-7.6-77.el7.x86_64 13/63
Verifying : libcollection-0.7.0-32.el7.x86_64 14/63
Verifying : 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64 15/63
Verifying : libbasicobjects-0.1.1-32.el7.x86_64 16/63
Verifying : gssproxy-0.7.0-28.el7.x86_64 17/63
Verifying : 1:smartmontools-7.0-2.el7.x86_64 18/63
Verifying : 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64 19/63
Verifying : bc-1.06.95-13.el7.x86_64 20/63
Verifying : GeoIP-1.5.0-14.el7.x86_64 21/63
Verifying : xorg-x11-utils-7.5-23.el7.x86_64 22/63
Verifying : sysstat-10.1.5-19.el7.x86_64 23/63
Verifying : kernel-headers-3.10.0-1127.19.1.el7.x86_64 24/63
Verifying : net-tools-2.0-0.25.20131004git.el7.x86_64 25/63
Verifying : libXtst-1.2.3-1.el7.x86_64 26/63
Verifying : 32:bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64 27/63
Verifying : rpcbind-0.2.0-49.el7.x86_64 28/63
Verifying : 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64 29/63
Verifying : glibc-headers-2.17-307.0.1.el7.1.x86_64 30/63
Verifying : libstdc++-4.8.5-39.0.5.el7.x86_64 31/63
Verifying : libaio-0.3.109-13.el7.x86_64 32/63
Verifying : libini_config-1.3.1-32.el7.x86_64 33/63
Verifying : psmisc-22.20-16.el7.x86_64 34/63
Verifying : libX11-common-1.6.7-2.el7.noarch 35/63
Verifying : unzip-6.0-21.el7.x86_64 36/63
Verifying : libxcb-1.13-1.el7.x86_64 37/63
Verifying : libevent-2.0.21-4.el7.x86_64 38/63
Verifying : ksh-20120801-142.0.1.el7.x86_64 39/63
Verifying : libverto-libevent-0.2.5-4.el7.x86_64 40/63
Verifying : compat-libcap1-1.10-7.el7.x86_64 41/63
Verifying : libXrandr-1.5.1-2.el7.x86_64 42/63
Verifying : libaio-devel-0.3.109-13.el7.x86_64 43/63
Verifying : libref_array-0.1.5-32.el7.x86_64 44/63
Verifying : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 45/63
Verifying : libpath_utils-0.2.1-32.el7.x86_64 46/63
Verifying : 1:quota-4.01-19.el7.x86_64 47/63
Verifying : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64 48/63
Verifying : libnfsidmap-0.25-19.el7.x86_64 49/63
Verifying : libstdc++-devel-4.8.5-39.0.5.el7.x86_64 50/63
Verifying : libSM-1.2.2-2.el7.x86_64 51/63
Verifying : oracle-database-preinstall-18c-1.0-1.el7.x86_64 52/63
Verifying : libXxf86dga-1.1.4-2.1.el7.x86_64 53/63
Verifying : libXmu-1.1.2-2.el7.x86_64 54/63
Verifying : keyutils-1.5.8-3.el7.x86_64 55/63
Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 56/63
Verifying : 32:bind-license-9.11.4-16.P2.el7_8.6.noarch 57/63
Verifying : libXau-1.0.8-2.1.el7.x86_64 58/63
Verifying : libX11-1.6.7-2.el7.x86_64 59/63
Verifying : glibc-devel-2.17-307.0.1.el7.1.x86_64 60/63
Verifying : mailx-12.5-19.el7.x86_64 61/63
Verifying : 1:quota-nls-4.01-19.el7.noarch 62/63
Verifying : libstdc++-4.8.5-39.0.3.el7.x86_64 63/63
Installed: oracle-database-preinstall-18c.x86_64 0:1.0-1.el7
Dependency Installed:
GeoIP.x86_64 0:1.5.0-14.el7 bc.x86_64 0:1.06.95-13.el7
bind-libs.x86_64 32:9.11.4-16.P2.el7_8.6 bind-libs-lite.x86_64 32:9.11.4-16.P2.el7_8.6
bind-license.noarch 32:9.11.4-16.P2.el7_8.6 bind-utils.x86_64 32:9.11.4-16.P2.el7_8.6
compat-libcap1.x86_64 0:1.10-7.el7 compat-libstdc++-33.x86_64 0:3.2.3-72.el7
geoipupdate.x86_64 0:2.5.0-1.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 gssproxy.x86_64 0:0.7.0-28.el7
kernel-headers.x86_64 0:3.10.0-1127.19.1.el7 keyutils.x86_64 0:1.5.8-3.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.x86_64 0:0.3.109-13.el7 libaio-devel.x86_64 0:0.3.109-13.el7
libbasicobjects.x86_64 0:0.1.1-32.el7 libcollection.x86_64 0:0.7.0-32.el7
libdmx.x86_64 0:1.1.3-3.el7 libevent.x86_64 0:2.0.21-4.el7
libini_config.x86_64 0:1.3.1-32.el7 libnfsidmap.x86_64 0:0.25-19.el7
libpath_utils.x86_64 0:0.2.1-32.el7 libref_array.x86_64 0:0.1.5-32.el7
libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7 libtirpc.x86_64 0:0.2.4-0.16.el7
libverto-libevent.x86_64 0:0.2.5-4.el7 libxcb.x86_64 0:1.13-1.el7
lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7 mailx.x86_64 0:12.5-19.el7
net-tools.x86_64 0:2.0-0.25.20131004git.el7 nfs-utils.x86_64 1:1.3.0-0.66.0.1.el7_8
psmisc.x86_64 0:22.20-16.el7 quota.x86_64 1:4.01-19.el7
quota-nls.noarch 1:4.01-19.el7 rpcbind.x86_64 0:0.2.0-49.el7
smartmontools.x86_64 1:7.0-2.el7 sysstat.x86_64 0:10.1.5-19.el7
tcp_wrappers.x86_64 0:7.6-77.el7 unzip.x86_64 0:6.0-21.el7
xorg-x11-utils.x86_64 0:7.5-23.el7 xorg-x11-xauth.x86_64 1:1.0.9-1.el7
Dependency Updated: libstdc++.x86_64 0:4.8.5-39.0.5.el7
Complete!
# ----------------------------------
# Install Oracle Software for XE Version
[root@oel7-ora-xe ~]# yum -y localinstall /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm
Loaded plugins: ulninfo
Examining /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm: oracle-database-xe-18c-1.0-1.x86_64
Marking /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-xe-18c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================
Package Arch Version Repository Size
================================================================================================================
Installing:
oracle-database-xe-18c x86_64 1.0-1 /oracle-database-xe-18c-1.0-1.x86_64 5.2 G
Transaction Summary
================================================================================================================
Install 1 Package
Total size: 5.2 G
Installed size: 5.2 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-xe-18c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database XE, optionally modify the parameters in '/etc/sysconfig/oracle-xe-18c.conf' and then execute
'/etc/init.d/oracle-xe-18c configure' as root.
Verifying : oracle-database-xe-18c-1.0-1.x86_64 1/1
Installed: oracle-database-xe-18c.x86_64 0:1.0-1
Complete!
# ----------------------------------
# Creating the XE Database Instance
[root@oel7-ora-xe ~]# /etc/init.d/oracle-xe-18c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password:
***********
Enter SYSTEM user password:
**********
Enter PDBADMIN User Password:
*********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: oel7-ora-xe.localdomain:1539/XEPDB1
Multitenant container database: oel7-ora-xe.localdomain:1539
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE
[root@oel7-ora-xe ~]# su – oracle
Last login: Thu Aug 27 14:40:56 CEST 2020 on pts/0
[oracle@oel7-ora-xe ~]$ . oraenv <<< XE
ORACLE_SID = [oracle] ? The Oracle base has been set to /opt/oracle
[oracle@oel7-ora-xe ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Aug 27 14:50:12 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 – Production
Version 18.4.0.0.0
SQL> select host_name
, instance_name
, version
, version_full
, status
, database_type
, edition
from gv$instance
order by 1, 2;
HOST_NAME INSTANCE_NAME VERSION VERSION_FULL STATUS DATABASE_TYPE EDITION
----------------------- ------------- ---------- ------------- ------- -------------- -------
oel7-ora-xe.localdomain XE 18.0.0.0.0 18.4.0.0.0 OPEN SINGLE XE
SQL>
# DONE!!!
----------------------------------------------------------------------------------------------
# NOW THE 19c ENTERPRISE EDITION VERSION
# ----------------------------------
# 19c (Version EE)
# ----------------------------------
# For the 19c EE Version, the process is the same, what changes is the pre-install package and other necessary step to create the database.
# ----------------------------------
# Install the pre-install package.
yum -y install oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm |
# ----------------------------------
# Install the software (you have to download it first, www.oracle.com/downloads).
yum -y localinstall /tmp/oracle-database-ee-19c-1.0-1.x86_64.rpm |
# ----------------------------------
# Create the folder where the database instance will be saved.
mkdir -p /opt/oracle/oradata/ |
# ----------------------------------
# This is the command to create the database using a single line command. (Remember, that is just an example).
dbca -silent -createDatabase -templateName General_Purpose.dbc \ |
# ----------------------------------
# DONE!!!
Now you can try on your own, good luck!!!
No comments:
Post a Comment