Login SQL*Plus Encountered SP2-0667 SP2-0750 even $ORACLE_HOME Has Set in Profile (Doc ID 1075034.1)

Last updated on AUGUST 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***

Symptoms

1. On 11.2.0.1, Oracle Grid Infrastructure and Oracle RDBMS were installed as one installation owner.

[oracle@rac1 ~]$ id
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),506(asmdba),507(asmoper)


2. When attempting to run SQL*Plus, following error reported:

[oracle@rac1 db_1]$ sqlplus "/ as sysdba"
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


3. $ORACLE_HOME was set in .bash_profile:

[oracle@rac1 db_1]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms