Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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
?
8,642 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

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 77

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
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…
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.

715 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