How to reconfigure Oracle 10g xe on Linux

Question

I have installed Oracle 10g xe from a deb file on linux, and then started to configure it using this terminal command

sudo /etc/init.d/oracle-xe configure

but after finishing configuration I forgot the password, so how can I reconfigure it again after reinstallation as now when I use the previous command I receive

Oracle Database 10g Express Edition is already configured

Thanks,

Excellent tutorial is [here](https://forums.oracle.com/forums/thread.jspa?threadID=2301639). I guess one can find there solutions for most of the issues with Oracle Express on Linux (specifically Ubuntu). — Ondrej Kvasnovsky, Nov 04 '12 at 13:27

score 23 · Answer 1 · edited Sep 10 '12 at 23:42

23

Remove /etc/sysconfig/oracle-xe
and then /etc/init.d/oracle-xe configure

edited Sep 10 '12 at 23:42

athspk

6,722
7
37
51

answered Sep 10 '12 at 23:34

Cristian Florescu

1,660
20
24

1

Worked perfectly with Oracle 11g XE. – danidemi Dec 21 '15 at 14:24
4

Linux mint (ubuntu I believe as well) sudo rm /etc/default/oracle-xe – Georgy Gobozov Mar 02 '17 at 20:33
Worked on Ubuntu 16.04 with Oracle 11g XE. Thanks. – PRIHLOP Feb 28 '18 at 18:02

score 18 · Accepted Answer · edited Nov 04 '12 at 12:36

18

Oracle creates a system account named oracle. To change password to that account just use

passwd oracle

if you forgot another password from DB then log in as oracle user and use

sqlplus / as sysdba

to change the password for various DB accounts.

To reconfigure change in /etc/default/oracle-xe

CONFIGURE_RUN=true

to

CONFIGURE_RUN=false

and rerun

sudo /etc/init.d/oracle-xe configure

edited Nov 04 '12 at 12:36

j0k

22,600
28
79
90

answered Mar 25 '11 at 13:35

Sacx

6,276
4
22
29

score 5 · Answer 3 · answered Nov 06 '19 at 18:51

For Oracle XE 18c on Oracle Linux (7.7 in this case), the installation can be restarted by executing the following command as root:

/etc/init.d/oracle-xe-18c delete

Restart the installation with the same command that was issued initially:

/etc/init.d/oracle-xe-18c configure

score 1 · Answer 4 · answered Mar 25 '11 at 13:41

1

The problem is solved... While removing the oracle I used

sudo apt-get remove oracle-xe-universal

and then remove the configurations using

sudo rm -rf /usr/lib/oracle

but these commands don't remove the configurations completely, the solution is to remove the oracle-xe-universal from Synaptic Manager and mark for Complete Removal.

Then install oracle-xe-universal again from the deb file then configure it.

Thanks,

answered Mar 25 '11 at 13:41

Mohammad Kotb

585
1
4
11

Is much easier to change /etc/default/oracle-xe :) – Sacx Mar 25 '11 at 13:45

score 0 · Answer 5 · answered Nov 19 '18 at 20:22

0

In my case (Oracle XE 18c on Ubuntu), I had to remove the last line from /etc/oratab

answered Nov 19 '18 at 20:22

Marco Sulla

15,299
14
65
100

How to reconfigure Oracle 10g xe on Linux

5 Answers5

Linked