davidmaignan/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

SBeausoleil · 2019-02-21T20:53:42Z

I get an error when I try to connect to SYS:

ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

What can I do to connec to SYS? What is SYSDBA?

EDIT: I found that you must write
connect SYS/<password here> AS SYSDBA
to connect to SYS

ReyesEvan · 2019-03-28T05:58:36Z

This is a gorgeus tutorial. Everyone trying to install Oracle should read this.

isdin · 2019-06-16T11:38:54Z

You're the best bro ! trying for 1 full day, now it's working!

SyedTayyabUlMazhar · 2019-10-03T16:11:10Z

You can also download oracle-xe-rpm.zip from :
https://www.oracle.com/database/technologies/xe-prior-releases.html

jaalorsa517 · 2019-10-22T19:44:35Z

http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip do not exist!
https://www.oracle.com/database/technologies/xe-prior-releases.html but it doesn't install by the md5sums file

SyedTayyabUlMazhar · 2019-10-23T10:00:01Z

@jaalorsa517
You just have to download the linux file from https://www.oracle.com/database/technologies/xe-prior-releases.html

and put it in cloned repo folder. Then just make pkg as shown in gist.

ak-seyam · 2020-02-09T09:05:53Z

just a quick note for newbies like myself: Do not use spaces in your mount point folder you will get an error from cd

nando-dotjs · 2020-02-16T06:42:42Z

It works, thank you! Great tutorial :)

jee4nc · 2020-04-09T08:27:21Z

Thanks! im new in Arch distros and i will need oracle 11g for my university classes. greeting from Chile 🇨🇱

joshuac17 · 2020-09-07T04:15:40Z

Does anybody knows if these steps also works to install Oracle Express 18c on Arch/Manjaro?

mksonkar · 2020-09-12T11:19:01Z

Great concise guide. Worked like a charm. Needed to install this for college. Thank You!

mksonkar · 2020-09-12T11:22:19Z

Does anybody knows if these steps also works to install Oracle Express 18c on Arch/Manjaro?

Check out this guide.
https://geraldonit.com/2018/10/23/how-to-install-oracle-database-18c-xe-on-linux/

Also just a google search will give you a couple of other guides.

ak-seyam · 2020-10-19T21:50:21Z

Does anybody knows if these steps also works to install Oracle Express 18c on Arch/Manjaro?

Same steps just use oracle-xe and

wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
# instead of 
# wget http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip

make sure to at c## before creating a new common user

ghassenelkamel · 2021-02-08T19:01:11Z

/etc/rc.d/oracle-xe configure
bash: /etc/rc.d/oracle-xe: No such file or directory
Arch uses systemd not rc.d and init

SunnyRaj84348 · 2021-02-08T19:08:35Z

/etc/rc.d/oracle-xe configure
bash: /etc/rc.d/oracle-xe: No such file or directory
Arch uses systemd not rc.d and init

Read pinned comment link

cr105ph1nx · 2021-10-25T18:52:37Z

I spent more than 3 hours trying to install Oracle Database Express following the ArchWiki doc with no success. Your concise guide saved me a lot of headache!

Nannku · 2022-06-10T02:56:30Z

Hello, i can't find /rc.d/ folder or anything that seems like it

sunnyraj-misc · 2022-06-10T03:06:20Z

Hello, i can't find /rc.d/ folder or anything that seems like it

As per systemd init, use systemd enable --now oracle-xe

OSITO326 · 2022-09-07T04:32:55Z

Run configuration:

/etc/rc.d/oracle-xe configure

bash: /etc/rc.d/oracle-xe: No such file or directory
Arch uses systemd not rc.d and init

could someone give me a hand please 🙏🏽🙏🏽🙏🏽

achmadya-dev · 2022-09-10T07:28:43Z

Run configuration:
/etc/rc.d/oracle-xe configure
bash: /etc/rc.d/oracle-xe: No such file or directory Arch uses systemd not rc.d and init

could someone give me a hand please 🙏🏽🙏🏽🙏🏽

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.
- If you prefer, download and extract the .rpm file.
Copy the folder inside the cloned repository to /etc.
Execute the following command:
```
/etc/init.d/oracle-xe-18c
```
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:
```
/etc/init.d/oracle-xe-18c
```
This should resolve the issue.

SunnyRaj84348 · 2022-09-12T16:48:55Z

Run configuration:
/etc/rc.d/oracle-xe configure
bash: /etc/rc.d/oracle-xe: No such file or directory Arch uses systemd not rc.d and init

could someone give me a hand please 🙏🏽🙏🏽🙏🏽

systemctl enable --now oracle-xe

arnald275 · 2022-09-22T12:04:00Z

~/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

SQL> connect system/password
ERROR:
ORA-12547: TNS:lost contact

i am new to oracle18c database
i am getting this error

HJhonatanVR · 2023-02-16T05:22:39Z

SQL> connect system/password
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

Could anyone help me? pls

SYN2002 · 2023-04-01T20:28:33Z

/etc/rc.d/oracle-xe configure bash: /etc/rc.d/oracle-xe: No such file or directory Arch uses systemd not rc.d and in

In my case oracle-xe-18c file is present inside "/home/sayan/oracle-xe/src/etc/init.d/" and the conf file in "/home/sayan/oracle-xe/src/etc/sysconfig/" . now do these steps to run your smooth installation-

open(not esecute) the above oracle-xe-18c file and in line no 57 update the path as- CONFIGURATION="/home/sayan/oracle-xe/src/etc/sysconfig/$CONFIG_NAME".
now open terminal and enter as root(i.e. su)
now execute the mention command (/home/sayan/oracle-xe/src/etc/init.d/oracle-xe-18c configure) and do the necessery
cd to the clone folder and do this- "source oracle_env.sh"
sqlplus /nolog
now after that if "connect system/password" will give some error then visit this website- http://www.dadbm.com/how-to-fix-ora-12547-tns-lost-contact-when-try-to-connect-to-oracle/
for user creation follow this - https://www.youtube.com/watch?v=wGmX57PFUzU&ab_channel=DevNami

Tipe: wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
instead of
wget http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip

There you go all set:)

SYN2002 · 2023-04-01T20:29:34Z

SQL> connect system/password ERROR: ORA-12162: TNS:net service name is incorrectly specified

Could anyone help me? pls

visit this website- http://www.dadbm.com/how-to-fix-ora-12547-tns-lost-contact-when-try-to-connect-to-oracle/

jabedzaman · 2023-05-03T15:55:10Z

my databse server would be running on which port?

SunnyRaj84348 · 2023-05-04T11:35:32Z

my databse server would be running on which port?

On default port 1521.

ajeevsan · 2023-07-24T08:30:36Z

my databse server would be running on which port?

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.

elgs · 2023-12-19T04:46:31Z

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

YassWrld · 2024-02-11T17:26:36Z

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

davidmaignan/installation_oracle_xe_archlinux.md

Clone git repository

Download oracle-xe-rpm.zip

Installation (follow instructions)

Run configuration

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

Connect to oracle

at sql prompt

create a user

Grant permissions

Swith to the newly created user

Check tables

Logout

Login

Start, stop server

Ressources

SBeausoleil commented Feb 21, 2019 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

ReyesEvan commented Mar 28, 2019

Uh oh!

isdin commented Jun 16, 2019 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

SyedTayyabUlMazhar commented Oct 3, 2019

Uh oh!

jaalorsa517 commented Oct 22, 2019

Uh oh!

SyedTayyabUlMazhar commented Oct 23, 2019

Uh oh!

ak-seyam commented Feb 9, 2020

Uh oh!

nando-dotjs commented Feb 16, 2020

Uh oh!

jee4nc commented Apr 9, 2020

Uh oh!

joshuac17 commented Sep 7, 2020

Uh oh!

mksonkar commented Sep 12, 2020

Uh oh!

mksonkar commented Sep 12, 2020

Uh oh!

ak-seyam commented Oct 19, 2020 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

ghassenelkamel commented Feb 8, 2021

Uh oh!

SunnyRaj84348 commented Feb 8, 2021

Uh oh!

cr105ph1nx commented Oct 25, 2021

Uh oh!

Nannku commented Jun 10, 2022

Uh oh!

sunnyraj-misc commented Jun 10, 2022

Uh oh!

OSITO326 commented Sep 7, 2022

Uh oh!

achmadya-dev commented Sep 10, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Steps:

Uh oh!

SunnyRaj84348 commented Sep 12, 2022

Uh oh!

arnald275 commented Sep 22, 2022

Uh oh!

HJhonatanVR commented Feb 16, 2023

Uh oh!

SYN2002 commented Apr 1, 2023 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

SYN2002 commented Apr 1, 2023

Uh oh!

jabedzaman commented May 3, 2023

Uh oh!

SunnyRaj84348 commented May 4, 2023

Uh oh!

ajeevsan commented Jul 24, 2023

Uh oh!

elgs commented Dec 19, 2023

Uh oh!

SBeausoleil commented Feb 21, 2019 •

edited

Loading

isdin commented Jun 16, 2019 •

edited

Loading

ak-seyam commented Oct 19, 2020 •

edited

Loading

achmadya-dev commented Sep 10, 2022 •

edited

Loading

SYN2002 commented Apr 1, 2023 •

edited

Loading