Oracle xe 18c on Centos 7 64 bit

1. install minimal centos 7 64bit
2. yum update -y
--kalau tidak bisa, maka repository perlu diupdate
a.buka /etc/yum.repos.d/CentOS-Base.repo
b.ubah yang di [base] menjadi

[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra
baseurl=http://ftp.riken.jp/Linux/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

3.simpan dan update lagi
4.download dan install preinstall nya

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

 5. download dan install databasenya

yum –y localinstall oracle-database*18c*

6. sebagai root, jalankan:

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

tunggu selesai, lalu

. oraenv

hasilnya:

ORACLE_SID = [root] ? XE
The Oracle base has been set to /opt/oracle

7. set autostart oracle dg:

systemctl daemon-reload
systemctl enable oracle-xe-18c

8. agar bisa diakses dari luar:

$ sqlplus system
Enter password: SYSTEM_password
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

masuk /opt/oracle/product/18c/dbhomeXE/network/admin
file listener.ora dan tnsnames.ora diganti isinya dg 0.0.0.0


9.ubah port ssh dulu, jadi 39000

vi /etc/ssh/sshd_config

Port=39000
PermitRootLogin Yes

9.set ip tables
 

systemctl stop firewalld
systemctl disable firewalld

systemctl mask --now firewalld

yum install iptables-services 

systemctl start iptables
systemctl enable iptables

iptables -F
iptables -A INPUT -f -j DROP
iptables -A INPUT -p tcp --tcp-flags ALL NONE -j DROP
iptables -A INPUT -p tcp ! --syn -m state --state NEW -j DROP
iptables -A INPUT -p tcp --tcp-flags ALL ALL -j DROP
iptables -A INPUT -i lo -j ACCEPT

iptables -A INPUT -p tcp -m tcp --dport 39000 -j ACCEPT

        iptables -A INPUT -p tcp -m tcp --dport 1521 -j ACCEPT

 to save:

iptables-save | tee /etc/sysconfig/iptables

cek status :

systemctl status iptables

10. reboot utk cek iptablesnya

iptables -nvL

11. remote oracle




 12.Disable EM express, you should set port to 0

    exec dbms_xdb_config.sethttpsport(0);
    exec dbms_xdb_config.sethttpport(0);