Search code examples
linuxoracleoracle10g

How to reconfigure Oracle 10g xe on Linux

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,

Solution

  • 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