Basic installation for oracle-xe on archlinux

installation_oracle_xe_archlinux.md

Clone git repository

git clone https://aur.archlinux.org/oracle-xe.git
cd oracle-xe

Download oracle-xe-rpm.zip

wget http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip

Installation (follow instructions)

makepkg -si

Run configuration

/etc/rc.d/oracle-xe configure

Locate oracle_env.sh - it should be located somewhere in the cloned folder

source oracle_env.sh 

Connect to oracle

sqlplus /nolog

at sql prompt

connect system/password

create a user

create user usename identified by password;

Grant permissions

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;

Swith to the newly created user

connect username/password

Check tables

select table_name from user_tables;

Logout

exit

Login

sqlplus username/password

Start, stop server

/etc/rc.d/oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable}

Ressources

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

my databse server would be running on which port?

my databse server would be running on which port?

On default port 1521.

my databse server would be running on which port?

To find out the port on which Oracle Database XE is running, follow these steps:

1. 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".

2. Open the terminal in that directory.

3. Use the "nano listener.ora" command to open the "listener.ora" file.

4. Inside the file, you'll be able to see the port on which Oracle Database XE is currently running.

[oracle-xe]$ /etc/rc.d/oracle-xe configure
-bash: /etc/rc.d/oracle-xe: No such file or directory

/etc/rc.d/oracle-xe: No such file or directory any solution for this please ?