ORACLE-msb notfound

 

root@TEL:~# su - oracle
oracle@TEL:~$ sqlplus /nolog
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
oracle@TEL:~$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
oracle@TEL:~$ sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 29 11:14:11 2020

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect /as sysdba;
Connected.
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> exit

SP2-0667: Message file sp1<lang>.msb not found sqlplus oracle

Ask Question

Asked 4 years ago

Active 3 years, 3 months ago

Viewed 62k times

2

I've a linux RedHat which contains oracle database. I setted all environnement variables, but when I running sqlplus command I've this error : SP2-0667: Message file sp1<lang>.msb not found

Here are my variables ans my sqlplus commands :

[oracle@as ~]$ echo $ORACLE_HOME
/oracle/product/12.1.0/dbhome_1
[oracle@as ~]$ echo $ORA_NLS33
/oracle/product/12.1.0/dbhome_1/nls/data
[oracle@as ~]$ echo $LD_LIBRARY_PATH
/oracle/product/12.1.0/dbhome_1/lib
[oracle@as ~]$ sqlplus
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Note that I'm currently running as oracle user, which seems to be the owner of the /oracle folder with read and excecute permission. I also seen that a file named sp1us.msb exists in the following folder :

[oracle@as ~]$ find $ORACLE_HOME | grep sp1
/oracle/product/12.1.0/dbhome_1/sqlplus/mesg/sp1us.msb
/oracle/product/12.1.0/dbhome_1/sqlplus/mesg/sp1us.msg

oraclelinuxsqlplus

share  improve this question   

edited Sep 19 '17 at 9:33

asked Dec 7 '16 at 15:24

Couim

19322 gold badges22 silver badges99 bronze badges

• This might be useful:oracle.com/technetwork/testcontent/faq101-094300.html#A4828 – JSapkota Dec 8 '16 at 10:29

add a comment

1 Answer

ActiveOldestVotes

4

I found the solution ! As the oracle documentation said about ORACLE_HOME, My env variables was setted in the /etc/profilefile, but not visible from env | grep ORACLE_HOME or dbhomeso I executed the following command :

export ORACLE_HOME=/app/oracle/product/12.1.0/dbhome_1

and now it works