October 4, 2019

[NOTE] Installing Oracle XE on CentOS

Environment

  • CentOS 7, 64-bit - running on VirtualBox
  • Oracle DB Express Edition, 18c

Steps

1. Download Oracle XE 18c from here
https://www.oracle.com/database/technologies/xe-downloads.html


2. Download preinstall file and install it

$ curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
 

$ yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm


3. Install Oracle XE

$ yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

4. Configure

$ /etc/init.d/oracle-xe-18c configure

5. Start

$ systemctl start oracle-xe-18c

6. Auto-Start

$ systemctl enable oracle-xe-18c


Check

$ sudo more /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cherrycentvm-db)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

LISTENER_XE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = cherrycentvm-db)(PORT = 1521))


EM UI

https://<host>:5500/em



Reference

https://oracle-base.com/articles/18c/oracle-db-18c-xe-rpm-installation-on-oracle-linux-6-and-7


No comments: