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
~/oracle-xe on master ?5 ❯ sqlplus /nolog
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Sep 22 17:32:11 2022
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
SQL> connect system/password
ERROR:
ORA-12547: TNS:lost contact
i am new to oracle18c database
i am getting this error