SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1.msb not found | Set Oracle Home SID in Windows and Linux

Hi,

Sometimes You can get ” SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1<lang>.msb not found ” error.

 

Details of error are as follows.

E:\app\ebys_win\product.1.0\dbhome_1\BIN> sqlplus.exe
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

 

 

This error is related with ORACLE_HOME and ORACLE_SID in the Windows Environment, so you should set them properly as follows.

set ORACLE_HOME=E:\app\ebys_win\product.1.0\dbhome_1

set ORACLE_SID=MSDB

 

Or you can set ORACLE_HOME and ORACLE_SID by right click on the My Computer > Advanced > Environment Variables. Click New under System variables. On the New System Variable tab, fill in the Variable name as ORACLE_HOME and Variable value with the location and Oracle SID NAME.

 

If your database is running on Linux or Unix, then you can add the following lines to the .bash_profile file.

bash-3.2$ vim .bash_profile

export ORACLE_HOME=/u01/app/product/12.2.0/dbhome_1
export ORACLE_BASE=/u01/app
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_SID=MSDB

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

 

and to set .bash_profile Run the following command.

bash-3.2$ . .bash_profile

 

Do you want to learn more details about Oracle database 19c Installation, then read the following articles.

Oracle Database 19c on Linux 7.6 Step by Step Installation -2

 

 451 views last month,  23 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply