In this post, we can use GitHub reposirotry to fetch the repos and then be installing the Oracle Database 18c. GitHub must be installed for this feature prerequisite.
In your VM or Bare Metal, check the status and version of GitHub if it is installed.
[root@ORA006 ~]# git version bash: git: command not found
As GitHub is not configured, we use YUM to install it with root user and recheck for GitHub version.
[root@ORA006 ~]# yum -y install git [root@ORA006 ~]# git version git version 1.7.1
In the next step, we need to clone repos from GitHub under the home directory of the root user.
[root@ORA006 ~]# cd [root@ORA006 ~]# echo $HOME /root [root@ORA006 ~]# git clone https://github.com/dockerhelp/docker-oracle-ee-18c.git Initialized empty Git repository in /root/docker-oracle-ee-18c/.git/ remote: Counting objects: 111, done. remote: Compressing objects: 100% (101/101), done. remote: Total 111 (delta 45), reused 9 (delta 1), pack-reused 0 Receiving objects: 100% (111/111), 666.20 KiB, done. Resolving deltas: 100% (45/45), done.
In the last step, we need to change the permission of a particular file and run it which will perform the following things:
- Installing required RPMs
- Configure Oracle user and groups
- Download the binaries
- Creating the default directories for Oracle Database
- Installing the Oracle Software
- Removing the setup files to save the FS space
- Installing the default Oracle Database (ORCL18) with one PDB
- Configure listener and tns entries
[root@ORA006 ~]# chmod u+x $HOME/docker-oracle-ee-18c/install/oracle_18c_install.sh [root@ORA006 ~]# sh $HOME/docker-oracle-ee-18c/install/oracle_18c_install.sh Installing Dependencies Loaded plugins: security, ulninfo Setting up Install Process ksplice-uptrack | 951 B 00:00 ksplice-uptrack/primary | 5.4 kB 00:00 ksplice-uptrack 22/22 ol6_UEKR3_latest | 1.2 kB 00:00 ol6_UEKR3_latest/primary | 38 MB 00:01 ol6_UEKR3_latest 928/928 ol6_UEKR4 | 1.2 kB 00:00 ol6_UEKR4/primary | 1.5 MB 00:00 ol6_UEKR4 114/114 ol6_UEK_latest | 1.2 kB 00:00 ol6_UEK_latest/primary | 38 MB 00:01 ol6_UEK_latest 792/792 ol6_latest | 1.4 kB 00:00 ol6_latest/primary | 6.6 MB 00:00 ol6_latest 11092/11092 Package wget-1.12-10.el6.x86_64 already installed and latest version Package unzip-6.0-5.el6.x86_64 already installed and latest version Package binutils-2.20.51.0.2-5.48.el6.x86_64 already installed and latest version Package compat-libcap1-1.10-1.x86_64 already installed and latest version Package gcc-4.4.7-23.0.1.el6.x86_64 already installed and latest version Package gcc-c++-4.4.7-23.0.1.el6.x86_64 already installed and latest version Package glibc-2.12-1.212.0.1.el6.i686 already installed and latest version Package glibc-2.12-1.212.0.1.el6.x86_64 already installed and latest version Package glibc-devel-2.12-1.212.0.1.el6.i686 already installed and latest version Package glibc-devel-2.12-1.212.0.1.el6.x86_64 already installed and latest version Package ksh-20120801-37.el6_9.x86_64 already installed and latest version Package compat-libstdc++-33-3.2.3-69.el6.x86_64 already installed and latest version Package libaio-0.3.107-10.el6.i686 already installed and latest version Package libaio-0.3.107-10.el6.x86_64 already installed and latest version Package libaio-devel-0.3.107-10.el6.i686 already installed and latest version Package libaio-devel-0.3.107-10.el6.x86_64 already installed and latest version Package libgcc-4.4.7-23.0.1.el6.i686 already installed and latest version Package libgcc-4.4.7-23.0.1.el6.x86_64 already installed and latest version Package libstdc++-4.4.7-23.0.1.el6.i686 already installed and latest version Package libstdc++-4.4.7-23.0.1.el6.x86_64 already installed and latest version Package libstdc++-devel-4.4.7-23.0.1.el6.i686 already installed and latest version Package libstdc++-devel-4.4.7-23.0.1.el6.x86_64 already installed and latest version Package libXi-1.7.8-1.el6.i686 already installed and latest version Package libXi-1.7.8-1.el6.x86_64 already installed and latest version Package libXtst-1.2.3-1.el6.i686 already installed and latest version Package libXtst-1.2.3-1.el6.x86_64 already installed and latest version Package 1:make-3.81-23.el6.x86_64 already installed and latest version Package sysstat-9.0.4-33.el6_9.1.x86_64 already installed and latest version Package oracle-database-preinstall-18c-1.0-1.el6.x86_64 already installed and latest version Nothing to do Loaded plugins: security, ulninfo Cleaning repos: ksplice-uptrack ol6_UEKR3_latest ol6_UEKR4 ol6_UEK_latest ol6_latest Cleaning up Everything Creating Directory Setting ENV Downloading oracle database zip Extracting oracle database zip setting up Response files Installing Oracle Binaries Launching Oracle Database Setup Wizard... The response file for this session can be found at: /u01/app/oracle/product/18.0.0/dbhome_1/install/response/db_2018-08-26_07-07-42AM.rsp You can find the log of this install session at: /u01/app/oraInventory/logs/InstallActions2018-08-26_07-07-42AM/installActions2018-08-26_07-07-42AM.log As a root user, execute the following script(s): 1. /u01/app/oracle/product/18.0.0/dbhome_1/root.sh Execute /u01/app/oracle/product/18.0.0/dbhome_1/root.sh on the following nodes: [ORA006] Successfully Setup Software. Done uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba) SQL*Plus: Release 18.0.0.0.0 - Production Version 18.3.0.0.0 Default 18c database install with PDB Prepare for db operation 8% complete Copying database files 31% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 43% complete 46% complete Completing Database Creation 51% complete 53% complete 54% complete Creating Pluggable Databases 58% complete 77% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/ORCL18. Database Information: Global Database Name:ORCL18 System Identifier(SID):ORCL18 Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL18/ORCL18.log" for further details. Starting default listener Parsing command line arguments: Parameter "silent" = true Parameter "responsefile" = /u01/app/oracle/product/18.0.0/dbhome_1/netca.rsp Done parsing command line arguments. Oracle Net Services Configuration: Configuring Listener:LISTENER_ORCL18 Listener configuration complete. Oracle Net Listener Startup: Running Listener Control: /u01/app/oracle/product/18.0.0/dbhome_1/bin/lsnrctl start LISTENER_ORCL18 Listener Control complete. Listener started successfully. Profile configuration complete. Oracle Net Services configuration successful. The exit code is 0 Configuring the TNS Testing Database SQL*Plus: Release 18.0.0.0.0 - Production on Sun Aug 26 07:21:01 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> System altered. SQL> NAME OPEN_MODE --------- -------------------- ORCL18 READ WRITE SQL> CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ----------- ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB18C READ WRITE NO SQL> Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 Cleaning up DataBase Installed!!! [root@ORA006 ~]#
In the end, it will show you a status of the database.
Note: It is tested on RHELv 6,7 and OEL v6,7 only.
Database Name: ORCL18 with one pluggable database PDB18C has default password Welcome_1.
This concept of Oracle Database with GitHub used development, training and learning purpose. We can not recommend using in Production.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
