Home > Oracle DBA > SP2-0667: Message file sp1.msb not found

SP2-0667: Message file sp1.msb not found

April 22, 2013

Recently i created one database and i got the below error while connecting to DB.

ERROR:-

$ sqlplus / as sysdba
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
$

Solution:-

Please set the environment correctly.

Original environment details.

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl2
PATH=$PATH:$ORACLE_HOME/bin

Modified environment details.

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
ORACLE_SID=orcl2
export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
export PATH

Upon setting the above modified values, error got resolved. This happend in my linux environment.

Advertisements
Categories: Oracle DBA
%d bloggers like this: