Solved

Oracle Instant Client 11.2 Windows 64 bit > SP2-0667: Message file sp1<lang>.msb not found

Posted on 2010-11-08
4
8,059 Views
Last Modified: 2012-05-10
Even though I believe I have all the ENV vars set properly Instant Client still throws errors.  I'm on Win7 64bit.  I'm using instantclient-basic-win-x86-64-11.2.0.1.0.zip (55,084,309 bytes) and instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip (822,020 bytes) downloaded form link below.

C:\Windows\system32>path
PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\Oracle\in
stantclient_11_2\;C:\Oracle\instantclient_11_2\sqlplus\

C:\Windows\system32>set ORACLE_HOME
ORACLE_HOME=C:\Oracle\instantclient_11_2

C:\Windows\system32>sqlplus
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

C:\Windows\system32>

Open in new window


http://www.oracle.com/technetwork/topics/winx64soft-089540.html
0
Comment
Question by:Geoff Millikan
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 34086420
I've not messed with 11.2 and 64 bit but are you sure the PATH is right?

My 32Bit 11.1 version sqlplus isn't under it's own directory.

Verify the PATH needs the sqlplus folder.
0
 

Assisted Solution

by:Geoff Millikan
Geoff Millikan earned 0 total points
ID: 34087380

> are you sure the PATH is right?

What else could I possible set it to?

> Verify the PATH needs the sqlplus folder.

I cannot imagine why having it in the PATH would hurt anything.  But I copied everything out of \sqlplus\ and moved it up a level then deleted the \sqlplus\ directory.  I also added a trailing backslash to the ORACLE_HOME variable (but I tried that before and it didn't help).

And guess what, now it works! I'm guessing the issue was that the SQLPLUS files needed to be in the ORACLE_HOME directory.

[code]C:\Windows\system32>path
PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\Oracle\in
stantclient_11_2\

C:\Windows\system32>set ORACLE_HOME=C:\Oracle\instantclient_11_2\

C:\Windows\system32>set ORACLE_HOME
ORACLE_HOME=C:\Oracle\instantclient_11_2\

C:\Windows\system32>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 8 11:43:28 2010

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name:[/code]

0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34101525
>>I cannot imagine why having it in the PATH would hurt anything.

FYI:  It's in the installation docs that all the files need to be in the same directory.

http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/apd.htm#SQPUG157


1.Download the zip files containing the SQL*Plus Instant Client package, and the OCI package from the OTN Instant Client page at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html. Both packages must be from the same version such as 11.1.0.6.

2.Create a new directory, for example, /home/instantclient11_2 on UNIX or c:\instantclient11_2 on Windows.

3.Unzip the two packages into the new directory.

0
 

Author Closing Comment

by:Geoff Millikan
ID: 34126705
Added my own comments as part of the solution because they help understand what the solution really was.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question