Results 1 to 14 of 14
  1. #1
    Join Date
    Mar 2013
    Posts
    8

    Post Unanswered: sp1<lang>.msb not found

    Greetings,

    while connecting locally to sqlplus I encountered the following errors:

    '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'


    So, I tried: set ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server

    the set allowed it and the echo confirmed the Path was: TRUE

    However, the problem has not be resolved. Can anyone explain this or help me solve this issue? FYI my level of knowledge is novice but I am in an sql programming course.

    Info:
    System = Windows 7 64bit OS
    Software in question: Oracle 11g 11.2.0 for 32-bit Windows

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    open Command Window & issue OS command below

    DIR %ORACLE_HOME%

    COPY the results from above then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2013
    Posts
    8

    COPY and PASTE results

    note: I tried the first command like 'dir %ORACLE_HOME%'


    C:\Windows\system32>dir %ORACLE_HOME%
    Volume in drive C has no label.
    Volume Serial Number is 189B-D4C6

    Directory of C:\oraclexe\app\oracle\product

    File Not Found

    note: now the second command like 'dir ORACLE_HOME'

    C:\Windows\system32>dir ORACLE_HOME
    Volume in drive C has no label.
    Volume Serial Number is 189B-D4C6

    Directory of C:\Windows\system32\ORACLE_HOME

    03/02/2013 02:59 AM <DIR> .
    03/02/2013 02:59 AM <DIR> ..
    0 File(s) 0 bytes
    2 Dir(s) 81,597,505,536 bytes free

    C:\Windows\system32>


    Additionally, I tried 'tnsping' (
    while in the ORACLE_HOME Directory) with the following results:


    C:\Windows\System32\ORACLE_HOME>tnsping

    TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-MAR-2
    013 10:54:13

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

    TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility
    =TNS

    C:\Windows\System32\ORACLE_HOME>
    Last edited by yunqhero; 03-02-13 at 11:56.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    contrary to your original post, it does not appear that environmental variable ORACLE_HOME is (properly) set.

    ORACLE_HOME must be properly set before the sqlplus utility can be successfully launched

    Problem Exists Between Keyboard And Chair
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2013
    Posts
    8
    Albeit, can you offer a proper suggestion that I (the problem) can use?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    C:\Windows\System32>set ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server
    
    C:\Windows\System32>echo %ORACLE_HOME%
    %ORACLE_HOME%
    
    C:\Windows\System32>set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server
    
    C:\Windows\System32>echo %ORACLE_HOME%
    C:\oraclexe\app\oracle\product\11.2.0\server
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2013
    Posts
    8
    The result is the same. However, I changed the PATH for %ORACLE_HOME%.


    C:\>echo %ORACLE_HOME%
    C:\oraclexe\app\oracle\product\11.2.0\server\bin\O RACLE.EXE XE

    C:\>echo %ORACLE_SID%
    orcl

    C:\>echo %ORACLE_BASE%
    C:\oracle

    C:\>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:\>sqlplus /sysdba
    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:\>

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

    ORACLE_HOME value is not correct.

    SET ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\ server
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Mar 2013
    Posts
    8
    Hm, I could've swore I tried that. But...it worked this time. Thank you.

  10. #10
    Join Date
    Mar 2013
    Posts
    8
    Now, the TNS: protocol adapter error is showing up. (I CANT WIN)

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    are both OS Services for database & listener started & running now?

    always use COPY & PASTE so we can see exactly what you do & how Oracle responds
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Mar 2013
    Posts
    8
    I am not sure if they are both started but here is what I have tried:



    c:\>sqlplus

    SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 2 12:14:09 2013

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

    Enter user-name: system
    Enter password:
    ERROR:
    ORA-12560: TNSrotocol adapter error


    Then I tried:


    c:\>sqlplus /nolog

    SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 2 12:20:36 2013

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

    SQL> (Not sure what to do here to go further)

  13. #13
    Join Date
    Mar 2013
    Posts
    8
    I tried the following and here is the output:


    C:\Windows\system32>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-MAR-2013 12:36
    :02

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1) ))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%HOST%)( PORT=%PORT%)))
    TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNSrotocol adapter error
    TNS-00515: Connect failed because target host or object does not exist
    32-bit Windows Error: 109: Unknown error

    C:\Windows\system32>

  14. #14
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    are both OS Services for database & listener started & running now?
    I am not sure if they are both started
    TNS-12541: TNS:no listener
    This error would suggest that you haven't checked that they have both started.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •