How to Install Oracle Database 18c Express Edition on Oracle Cloud Free Tier (for life) | Centos 7
Credits :
1
2
STEP 1 - Download Oracle Required Software
1. mkdir Downloads
2. cd /home/opc/Downloads
3. curl -L -O https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
3. curl -L -O https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
4. sudo yum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm (Pre-Requistis only)
STEP 2 - Change RPM To Avoid Issue 1 :
( Issue 1 : This system has 971 MB of RAM and does not meet minimum requirements )
- Install & run rpmrebuild (if you don't have it already)
1. sudo yum install rpmrebuild
2. cd /home/opc
3. rpmrebuild -e -p /home/opc/oracle-database-xe-18c-1.0-1.x86_64.rpm
( this might take few mins )
- Once rpmrebuild is opened :
1. Scroll down ( to bottom ) -> search for this line : [ $PhyMem -lt 1024 ]
2. Change to : [ $PhyMem -lt 102 ]
3. Press Esc -> type : wq!
4. Wait for RPM to be re-build ( it's auto and take few mins ).
- Do the rpmrebuild modification :
1. Scroll down ( to bottom ) -> search for this line : [ $PhyMem -lt 1024 ]
2. Change to : [ $PhyMem -lt 102 ]
3. Press Esc -> type : wq!
4. Wait for RPM to be re-build ( it's auto and take few mins ).
- Install Database from new RPM :
1. cd /home/opc/rpmbuild/RPMS/x86_64/
2. sudo yum localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm
STEP 3 - Change Config File Before Database Configuration To Avoid Issue 2 :
( Issue 2 : sga_target 296M is too small )
- Once step 2 completed - Edit File : /etc/init.d/oracle-xe-18c
1. sudo -s
2. cp /etc/sysconfig/oracle-xe-18c.conf /etc/sysconfig/oracle-xe-18c.orig
3. vi /etc/sysconfig/oracle-xe-18c.conf
4. search for "sga_target=" (/sga_target= in vi)
5. change from : MEMORY_CONSTRUCT="-initParams sga_target=${sga}M,pga_aggregate_target=${pga}M"
To : MEMORY_CONSTRUCT="-initParams sga_target=500M,pga_aggregate_target=${pga}M"
6. Save file.
STEP 4 - Run Database Configuration :
( This may take up to 30 mins )
1. /etc/init.d/oracle-xe-18c configure