Several ORACLE_HOMEs in MS Windows - Error 6 Initializing SQL*Plus. Sp1<Lang>.Msb Not Found And SP2-750 (Doc ID 466554.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

SQL*Plus - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to Oracle10g]
Microsoft Windows (32-bit)

Symptoms

New installation of SQL*Plus 10.1.0.4.2 in MS Windows platform.
This MS Windows box has several ORACLE_HOMEs, and each of them include different SQL*Plus from different versions (since SQL*Plus 8.1.7.X to 10.2.X).

c:\oracle\oms10g\bin\sqlplusw.exe display the following error messages:

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory.

SQLPLUS environment variable is not setup in registry.
ORACLE_HOME is setup in registry and is pointing to the correct path.
NLS_LANG is using the default value AMERICAN_AMERICA.WE8MSWIN1252.
You are connected at operating system level as the owner of the installation, hence, these error messages are not related to permissions to access msb files.

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