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,887 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now