In this post, we can use GitHub repository to fetch the repos and then be installing the Oracle Database 19c. 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@wastedb ~]# cd [root@wastedb ~]# echo $HOME /root [root@wastedb ~]# git clone https://github.com/dockerhelp/docker-oracle-ee-19c.git Cloning into 'docker-oracle-ee-19c'... remote: Enumerating objects: 12, done. remote: Counting objects: 100% (12/12), done. remote: Compressing objects: 100% (11/11), done. remote: Total 12 (delta 0), reused 0 (delta 0), pack-reused 0 Unpacking objects: 100% (12/12), done. [root@wastedb ~]#
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 (ORCL19) with one PDB
- Configure listener and TNSentries
[root@instance-20190904-1137 ~]# chmod u+x $HOME/docker-oracle-ee-19c/install/oracle_19c_install.sh
[root@instance-20190904-1137 ~]# sh $HOME/docker-oracle-ee-19c/install/oracle_19c_install.sh
Installing Dependencies
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 | 2.8 kB 00:00:00
ol7_ksplice | 2.8 kB 00:00:00
ol7_latest | 3.4 kB 00:00:00
ol7_optional_latest | 2.8 kB 00:00:00
ol7_software_collections | 2.8 kB 00:00:00
(1/17): ol7_UEKR5/x86_64/updateinfo | 49 kB 00:00:00
(2/17): ol7_developer/x86_64/primary_db | 423 kB 00:00:00
(3/17): ol7_developer_EPEL/x86_64/updateinfo | 4.9 kB 00:00:00
(4/17): ol7_addons/x86_64/primary_db | 128 kB 00:00:00
(5/17): ol7_ksplice/updateinfo | 4.5 kB 00:00:00
(6/17): ol7_ksplice/primary_db | 529 kB 00:00:00
(7/17): ol7_latest/x86_64/group_gz | 148 kB 00:00:00
(8/17): ol7_addons/x86_64/updateinfo | 69 kB 00:00:00
(9/17): ol7_latest/x86_64/updateinfo | 1.1 MB 00:00:00
(10/17): ol7_developer_EPEL/x86_64/primary_db | 11 MB 00:00:00
(11/17): ol7_optional_latest/x86_64/updateinfo | 851 kB 00:00:00
(12/17): ol7_UEKR5/x86_64/primary_db | 4.7 MB 00:00:00
(13/17): ol7_developer/x86_64/updateinfo | 71 B 00:00:00
(14/17): ol7_optional_latest/x86_64/primary_db | 4.0 MB 00:00:00
(15/17): ol7_latest/x86_64/primary_db | 14 MB 00:00:00
(16/17): ol7_software_collections/x86_64/updateinfo | 8.7 kB 00:00:00
(17/17): ol7_software_collections/x86_64/primary_db | 4.7 MB 00:00:00
Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version
Package unzip-6.0-20.el7.x86_64 already installed and latest version
Package binutils-2.27-41.base.0.1.el7.x86_64 already installed and latest version
Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version
Package gcc-4.8.5-39.0.1.el7.x86_64 already installed and latest version
Package gcc-c++-4.8.5-39.0.1.el7.x86_64 already installed and latest version
Package glibc-2.17-292.0.1.el7.i686 already installed and latest version
Package glibc-2.17-292.0.1.el7.x86_64 already installed and latest version
Package glibc-devel-2.17-292.0.1.el7.i686 already installed and latest version
Package glibc-devel-2.17-292.0.1.el7.x86_64 already installed and latest version
Package ksh-20120801-139.0.1.el7.x86_64 already installed and latest version
Package compat-libstdc++-33-3.2.3-72.el7.x86_64 already installed and latest version
Package libaio-0.3.109-13.el7.i686 already installed and latest version
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Package libaio-devel-0.3.109-13.el7.i686 already installed and latest version
Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version
Package libgcc-4.8.5-39.0.1.el7.i686 already installed and latest version
Package libgcc-4.8.5-39.0.1.el7.x86_64 already installed and latest version
Package libstdc++-4.8.5-39.0.1.el7.i686 already installed and latest version
Package libstdc++-4.8.5-39.0.1.el7.x86_64 already installed and latest version
Package libstdc++-devel-4.8.5-39.0.1.el7.i686 already installed and latest version
Package libstdc++-devel-4.8.5-39.0.1.el7.x86_64 already installed and latest version
Package libXi-1.7.9-1.el7.i686 already installed and latest version
Package libXi-1.7.9-1.el7.x86_64 already installed and latest version
Package libXtst-1.2.3-1.el7.i686 already installed and latest version
Package libXtst-1.2.3-1.el7.x86_64 already installed and latest version
Package 1:make-3.82-24.el7.x86_64 already installed and latest version
Package sysstat-10.1.5-18.el7.x86_64 already installed and latest version
Package oracle-database-preinstall-19c-1.0-1.el7.x86_64 already installed and latest version
Nothing to do
Loaded plugins: langpacks, ulninfo
Cleaning repos: ol7_UEKR5 ol7_addons ol7_developer ol7_developer_EPEL ol7_ksplice ol7_latest ol7_optional_latest ol7_software_collections
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/19.0.0/dbhome_1/install/response/db_2019-09-05_01-03-13PM.rsp
You can find the log of this install session at:
/u01/app/oraInventory/logs/InstallActions2019-09-05_01-03-13PM/installActions2019-09-05_01-03-13PM.log
As a root user, execute the following script(s):
1. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:
[instance-20190904-1137]
Successfully Setup Software.
Done
Last login: Thu Sep 5 13:03:13 GMT 2019 on pts/1
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Default 19c 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/ORCL19.
Database Information:
Global Database Name:ORCL19
System Identifier(SID):ORCL19
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL19/ORCL19.log" for further details.
Starting default listener
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /u01/app/oracle/product/19.0.0/dbhome_1/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Configuring Listener:LISTENER_ORCL19
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl start LISTENER_ORCL19
Listener Control complete.
Listener started successfully.
Profile configuration complete.
Oracle Net Services configuration successful. The exit code is 0
Configuring the TNS
Testing Database
Last login: Thu Sep 5 13:23:05 GMT 2019 on pts/1
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 5 13:23:09 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
System altered.
SQL>
NAME OPEN_MODE
--------- --------------------
ORCL19 READ WRITE
SQL>
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB19C READ WRITE NO
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Cleaning up
DataBase Installed!!!
[root@instance-20190904-1137 ~]#
In the end, it will show you the status of the database.
Note: It is tested on RHELv 6,7 and OEL v6,7 only. Also, working perfectly on OCI Compute, AWS EC2 and Azure VMs.
Database Name: ORCL19 with one pluggable database PDB19C has default password Welcome_1. Just switch to oracle user and login to the database.
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
@Skant:
Thanks for the newest & coolest feature.
But I have encountered a error while following this document.
I got error at stage “Extracting oracle database zip” saying it can’t unzip the file.
I troubleshoot issue for sometime but cant resolve it.
I tried
1. to install latest version for unzip utility
2. Tried for both 18c & 19c softwares.
but still issue persist. I will upload screen shots, can you please help