Solved

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

Posted on 2010-11-08
4
7,990 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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

821 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