如何在 Linux 上重新配置 Oracle 10g xe

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/5433118/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-05 03:24:15  来源:igfitidea点击:

How to reconfigure Oracle 10g xe on Linux

linuxoracleoracle10g

提问by Mohammad Kotb

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

我已经从 Linux 上的 deb 文件安装了 Oracle 10g xe,然后开始使用此终端命令对其进行配置

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

须藤 /etc/init.d/oracle-xe 配置

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

Oracle 数据库 10g 快捷版已配置

Thanks,

谢谢,

采纳答案by Sacx

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

Oracle 创建一个名为 oracle 的系统帐户。要更改该帐户的密码,只需使用

passwd oracle

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

如果您忘记了 DB 的另一个密码,请以 oracle 用户身份登录并使用

sqlplus / as sysdba

to change the password for various DB accounts.

更改各种数据库帐户的密码。

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

重新配置 /etc/default/oracle-xe 中的更改

CONFIGURE_RUN=true 

to

CONFIGURE_RUN=false

and rerun

并重新运行

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

回答by Mohammad Kotb

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

问题解决了...同时删除我使用的oracle

sudo apt-get remove oracle-xe-universal

sudo apt-get 删除 oracle-xe-universal

and then remove the configurations using

然后使用删除配置

sudo rm -rf /usr/lib/oracle

须藤 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.

但是这些命令并没有完全删除配置,解决方案是从 Synaptic Manager 中删除 oracle-xe-universal 并标记为完全删除。

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

然后从 deb 文件再次安装 oracle-xe-universal,然后配置它。

Thanks,

谢谢,

回答by myset

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

删除/etc/sysconfig/oracle-xe
然后/etc/init.d/oracle-xe configure

回答by Marco Sulla

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

就我而言(Ubuntu 上的 Oracle XE 18c),我不得不从 /etc/oratab

回答by Ben Johnson

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

对于 Oracle Linux 上的 Oracle XE 18c(在本例中为 7.7),可以通过执行以下命令重新启动安装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