up vote 0 down vote favorite 1

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[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[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

oracle linux sqlplus share improve this question edited Sep 19 '17 at 9:33 asked Dec 7 '16 at 15:24 Calliste Hanriat 16124This might be useful:oracle.com/technetwork/testcontent/faq101-094300.html??#A4828 – JSapkota Dec 8 '16 at 10:29 add a comment

1 Answer

active oldest votes up vote 1 down vote

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_1export ORACLE_HOME=/app/oracle/product/12.1.0/dbhome_1

and now it works

share improve this answer answered Sep 19 '17 at 9:32 Calliste Hanriat 16124 add a comment

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!