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
Embed
17/05/2020 Basic installation for oracle-xe on archlinux · GitHub
https://gist.github.com/davidmaignan/d0d941cbf761678457b865e6de041af0 2/3
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}
0 Comentários