git clone https://aur.archlinux.org/oracle-xe.git
cd oracle-xe
wget http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip
makepkg -si
/etc/rc.d/oracle-xe configure
source oracle_env.sh
sqlplus /nolog
connect system/password
create user usename identified by password;
grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE to username;
connect username/password
select table_name from user_tables;
exit
sqlplus username/password
/etc/rc.d/oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable}
https://aur.archlinux.org/packages/oracle-xe/ https://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/connecting.htm#CHDJDAJA https://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm#XEGSG111
To find out the port on which Oracle Database XE is running, follow these steps:
Navigate to the installation directory of Oracle Database on your Manjaro KDE system, which is typically located at "/opt/oracle/product/18c/dbhomeXE/network/admin".
Open the terminal in that directory.
Use the "nano listener.ora" command to open the "listener.ora" file.
Inside the file, you'll be able to see the port on which Oracle Database XE is currently running.