如何在Ubuntu 9.x上正确设置ORACLE_HOME变量? [英] How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?

问题描述

我遇到的问题与此处列出的相同:如何恢复或更改Oracle sysdba密码尽管我没有丢失密码，但是我最初在configure脚本中输入了两次，然后登录时(localhost:8080/apex，密码不被接受.

I have the same problem as listed here: How to recover or change Oracle sysdba password although I did not lose the password, I entered it twice in the configure script originally, and then when I went to login (localhost:8080/apex, password not accepted.

我的数据库中没有任何东西，我只想安装和使用Oracle-XE.我已经尝试apt-get将其删除两次并重新安装，但是，即使我第二次删除我可以为Oracle XE找到的任何文件夹，如果我再次尝试运行/etc/init.d/oracle-xe configure并得到"Oracle Database 10g Express Edition已配置"，我也会尝试.

I don't have anything in the database, I just want to install and use Oracle-XE. I have tried apt-get removing it twice and reinstalling, but if I try to run /etc/init.d/oracle-xe configure again and I get "Oracle Database 10g Express Edition is already configured" despite the second time removing any folders I could find for Oracle XE.

我尝试运行sqlplus"/as sysdba"，但是得到的只是:

I tried running sqlplus "/ as sysdba" but all I get is:

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

我尝试通过export设置变量. (也尝试了set).

I tried setting the variable via export. (also tried set).

已尝试:export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus 以及所有的子目录.每次相同的错误.

Tried: export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus and all the subdirectories of that. Same error every time.

应该将ORACLE_HOME设置为什么?我见过的唯一参考文件只是说了一般性的意思，还是说了上面的版本号，然后是"/db_1".我没有db_1.

What is the ORACLE_HOME supposed to be set to? The only reference I have seen either just say general or say the above up to the version number then "/db_1". I do no thave a db_1.

让我知道您是否需要任何澄清.我不明白在此过程中我做错了什么.

Let me know if you need any clarification. I don't understand what I did wrong in this process.

推荐答案

通常，找不到msb文件的问题是环境设置问题的结果，但是在您的情况下，我对安装有点怀疑(我已经从未使用过apt-get + configure方法).

Usually the msb file not found problems are the result of an environment setting problem, but in your case I'm a little suspicious of the installation (I've never used the apt-get + configure method).

要检查安装是否正常:

• ORACLE_HOME应该设置为在找到sqlplus可执行文件的bin目录上一层的目录路径.
• $ORACLE_HOME/sqlplus/mesg
下应该有一些.msb文件
• 应该有数百个(不确定XE的数量).msb文件 在$ORACLE_HOME下(尝试显示find $ORACLE_HOME -name "*.msb" -print来显示它们)
• 您的路径应包含$ORACLE_HOME/bin.
• ORACLE_HOME下的所有文件应归user:oracle group:dba所有.

• ORACLE_HOME should be set to a directory path one level above the bin directory where sqlplus executable is found.
• There should some .msb files under $ORACLE_HOME/sqlplus/mesg
• There should be hundreds (not sure of the number with XE) of .msb files under $ORACLE_HOME (try find $ORACLE_HOME -name "*.msb" -print to show them)
• Your PATH should include $ORACLE_HOME/bin.
• All files under ORACLE_HOME should be owned by user:oracle group:dba.

这篇关于如何在Ubuntu 9.x上正确设置ORACLE_HOME变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！