开发者

How to reconfigure Oracle 10g xe on Linux

I have installed Oracle 10g xe from a deb file on linux, an开发者_StackOverflow中文版d 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,


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


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 


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


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,


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜