Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-11-08
4
Medium Priority
?
9,006 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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 78

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

782 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