CODEWITHSUNDEEP
oracle-databasecmdoracle11gsqlplusdatabase-administration
Saddam Meshaal
Saddam Meshaal

Reputation: 552

Message file UTILITY_MEG\spw<lang>.msb not found

I want to open SQL*Plus from CMD

When I try to open it using this command in Sqlplus I encounter this dialog error message:

Message file UTILITY_MEG\spw<lang>.msb not found.

after I close dialog message here is a copy of CMD:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Abo-Khaled>sqlplus
Error 14 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Users\Abo-Khaled>

I used these commands to solve the problem:

set oracle_home=C:\app\Abo-Khaled\product\11.2.0\dbhome_1\

set oracle_sid=orcl

BUT that doesn't solve the problem.

Notes:

Upvotes: 2

Views: 5635

Answers (3)

user7452271
user7452271

Reputation:

For the newer database 12c and up, I did not need an oracle_home variable. If you have one, then try deleting to see if the "Message file sp1.msb not found" goes away. This has been my experience of installing an Oracle DB on a desktop/laptop.

Upvotes: 0

rich mclean
rich mclean

Reputation: 11

I just had this issue and was able to resolve it by adjusting my windows path environment variable.

Make sure the path to the bin directory containing the correct sqlplus.exe comes first in the Windows path environment variable.

When you use sqlplus.exe in a command prompt, you may be executing a different sqlplus.exe than intended.

In my case, I also have the Oracle middleware installed which has its own sqlplus.exe which was being referenced and throwing the "Message file" error.

Once I put the path to the database home's bin directory first in the path variable, the issue went away.

Upvotes: 1

Andrew Brennan
Andrew Brennan

Reputation: 340

You need to set the NLS_LANG parameter in your command prompt. e.g. set nls_lang=ENGLISH

Upvotes: 0

Related Questions