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
If you've encountered the same issue I did and are looking for a solution, here's a step-by-step guide that worked for me. I hope it resolves your issue as well.
Steps:
Install
oracle-database-xe-18c-1.0-1.x86_64.rpm
from Oracle's official website, or alternatively, you can clone it from my repository at https://github.com/madyardwn/Config-Addition-OracleXe.git.Copy the folder inside the cloned repository to
/etc
.Execute the following command:
Note: You may encounter an error at this stage.
To address the error, add some lines of code to the
oracle-xe-18
file. You can follow the instructions provided in this video.After making the necessary modifications, run the following command again:
This should resolve the issue.