How to correctly set the ORACLE HOME variable on Ubuntu 9 x

Question

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    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    I tried running sqlplus    as sysdba  but all I get is   Error 6 initializing SQL Plus Message file sp1 lt lang gt  msb not found SP2-0750  You may need to set ORACLE HOME to your Oracle software directory   I tried setting the variable via export   also tried set     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    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

User · Answer

I had the same issue  In my home folder I ve got a script named sqlplus sh that takes care of this for me  containing   ORACLE HOME  usr lib oracle xe app oracle product 10 2 0 server export ORACLE HOME ORACLE SID XE export ORACLE SID NLS LANG   ORACLE HOME bin nls lang sh  export NLS LANG PATH  ORACLE HOME bin  PATH export PATH sqlplus  nolog

User · Answer

After installing weblogic and forms server on a Linux machine we met some problems initializing sqlplus and tnsping  We altered the bash profile in a way that the forms home acts as the oracle home  It works fine  both commands  sqlplus and tnsping  are executable for user oracle     bash profile    Get the aliases and functions if   -f    bashrc    then          bashrc fi    User specific environment and startup programs  PATH  PATH  HOME bin  export JAVA HOME  mnt software java jdk1 7 0 71 export ORACLE HOME  oracle Middleware Oracle FRHome1 export PATH  PATH  JAVA HOME bin  ORACLE HOME bin export LD LIBRARY PATH  oracle Middleware Oracle FRHome1 lib export FORMS PATH  FORMS PATH  oracle Middleware Oracle FRHome1 forms  oracle Middleware asinst 1 FormsComponent forms  appl myapp  home oracle myapp

User · Answer

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    To check the sanity of the installation    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

User · Answer

Once I also got that same type of error   I E   C  oracle product 10 2 0 db 2 gt SQLPLUS SYS AS SYSDBA Error 6 initializing SQL Plus Message file sp1 lt lang gt  msb not found SP2-0750  You may need to set ORACLE HOME to your Oracle software directory   This error is occurring as the home path is not correctly set  To rectify this  if you are using Windows  run the below query   C  oracle product 10 2 0 db 2 gt SET ORACLE HOME C  oracle product 10 2 0 db 2 C  oracle product 10 2 0 db 2 gt SQLPLUS SYS AS SYSDBA  SQL Plus  Release 10 2 0 3 0 - Production on Tue Apr 16 13 17 42 2013  Copyright  c  1982  2006  Oracle   All Rights Reserved    Or if you are using Linux  then replace set with export for the above command like so   C  oracle product 10 2 0 db 2 gt EXPORT ORACLE HOME  C  oracle product 10 2 0 db 2  C  oracle product 10 2 0 db 2 gt SQLPLUS SYS AS SYSDBA  SQL Plus  Release 10 2 0 3 0 - Production on Tue Apr 16 13 17 42 2013  Copyright  c  1982  2006  Oracle   All Rights Reserved

User · Answer

Had the same problem   All i had to do whas set the oracle shell variable      u01 app oracle product 11 2 0 xe bin oracle env sh   Sorterd

User · Answer

This is the right way to clear this error   export ORACLE HOME  u01 app oracle product 10 2 0 db 1 sqlplus   as sysdba

User · Answer

You have to set LANG as well  look for files named  sp1  msb   and set for instance export LANG us if you find a file name sp1us msb  The error message could sure be better

User · Answer

ORACLE HOME needs to be at the top level of the Oracle directory structure for the database installation  From that point  Oracle knows how to find all the other files it needs  For example  the error message you get is because Oracle can t locate the message files to report errors with  should be in the various mesg directories below the oracle home  Instead of the above value you give  I would try   export ORACLE HOME  usr lib oracle xe app oracle product 10 2 0

User · Answer

set  lt ORACLE HOME gt  path variable   example  path ORACLE HOME   value is C  oraclexe app oracle product 10 2 0 server

[oracle] How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?

Examples related to oracle

Examples related to oracle-xe