message file SP1<lang>.msb not found wehn attempting to access oracle database

Posted on 2005-04-09
Last Modified: 2008-01-09
Some users trying to access a remote oracle database via sqlplus get the error "message file SP1<lang>.msb not found".  Some users have no problem accessing the same database from the same machine? What could be wrong and how can it be solved?
Question by:covier
    LVL 5

    Expert Comment


    there is a related question to your problem, take a look , its's all about your ENVIRONMENT variable.The question is in the middle of the page, and the answer.

    LVL 5

    Expert Comment


    Try to change the permissions(using regedt32) on the registry entry under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE to 'Full Control' for everyone. (Make sure you tell it to replace the permission on all subkeys.)

    I hope this helps. it is probably something to do with permission to find the message files location or permissions on the file itself.


    LVL 7

    Expert Comment

    by:Mehul Shah
    The Oracle_HOME parameter is not set for specific users. Please set the necessary oracle home environment variable.

    LVL 47

    Expert Comment

    - PLUS_DFLT environment variable is not set correctly.

    1. Start > cmd > regedit
    2. Go to HKEY_LOCAL_MACHINE -> SOFTWARE -> Oracle
    3. Go to the HOME for the new sqlplus PLUS80 executable
    4. Go to View --> New --> String Value
    5. Type PLUS_DFLT <enter>
    6. Double-click on PLUS_DFLT and enter PLUS80
    LVL 11

    Accepted Solution

    Have you installed D2K after Oracle client (on the same Oracle Home)? Because your registry entries are corrupted. Either you will have re-install Oraxcle client. Or if you have a valid back-up of registry (oracle home part only). you can import it and try again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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.

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    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…
    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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now