My Oracle Support Banner

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 JULY 16, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.