Error 6 Initializing Sqlplus Message File Sp1lang.msb Not Found
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have
Error 6 Initializing Sqlplus Windows 7
Meta Discuss the workings and policies of this site About Us error 6 initializing sql*plus Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Error 6 Initializing Sql*plus Linux
Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their message file sp1.msb not found unix database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Message file not found when starting SQLPlus up vote 5 down vote favorite I've installed Oracle sp2-0667 windows XE 11.2 on Fedora 18 but have trouble starting SQLPlus. It quits with the following error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory All of the environment variables are properly set (copied from installation guide) # ~/.zshrc ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe # It is in fact installed there ORACLE_SID=XE NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` PATH=$ORACLE_HOME/bin:$PATH NLS_LANG is AMERICAN_AMERICA.AL32UTF8. As far as I understand Oracle ignores system language related variables but here they are anyway: LC_CTYPE=en_US.UTF-8 LANG=en_US.UTF-8 Any suggestions? oracle sqlplus share|improve this question asked Aug 5 '13 at 21:01 synapse 126113 did you export the variables, e.g. 'export ORACLE_HOME' –miracle173 Aug 6 '13 at 5:35 It is probably a permissions problem. Does the user you are trying to execute SQL*Plus as have permissions on the directories on $ORACLE_HOME? Easiest fix is to add the user to the dba group. –Phil Aug 6 '13 at 18:46 add a comment| 5 Answers 5 active oldest votes up vote 2 do
SQL*Plus Release 10.1SQL*Plus -- General What versions of the database will SQL*Plus 10.1 work with? (17-AUG-04) How do I change the default directory of SQL*Plus on Windows? (17-AUG-04)
Sp2-0750 Oracle_home In Windows
How can I test if a database is running? (10-JUN-04) How sp2-0667 sp2-0750 windows do I create a batch file to run a script in SQL*Plus? (20-APR-04) Why is the EXIT status
Sp2-1503: Unable To Initialize Oracle Call Interface
returned by SQL*Plus wrong under UNIX? (01-APR-04) What does "Message file sp1.msb not found" mean when I run SQL*Plus? (28-MAR-04) Is it possible to find out the filename of the http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus command file started with @ in SQL*Plus, like $0 in a UNIX shell script? (22-MAR-04) Where is Server Manager linemode (svrmgrl)? (21-MAR-04) SQL*Plus -- Display Is it possible to change the displayed font type in SQL*Plus on Windows? How can I, for example, display Chinese fonts? (26-SEP-04) Why does the width of a column change when I run a report http://www.oracle.com/technetwork/testcontent/faq101-094300.html on two different databases? (10-JUN-04) How do I stop the "X rows selected" and "PL/SQL procedure successfully completed." messages appearing? (10-JUN-04) How do I display the Euro symbol ("€") in SQL*Plus? (01-APR-04) SQL*Plus -- Syntax How can I stop being prompted "Enter value for X" when I use "&"? (10-JUN-04) How do I use a semicolon in a text string? (22-APR-04) How do I replace "CONNECT INTERNAL" with "/ AS SYSDBA"? (20-APR-04) When should I use the COPY command? (20-APR-04) How do I see which output came from which statement in my script? (02-APR-04) How can I format DBMS_OUTPUT since SQL*Plus strips leading spaces? (01-APR-04) Why does the minus sign (-) in my SQL statement disappear in SQL*Plus command line? (01-APR-04) Why can't I end a REM comment with a minus (-) sign in SQL*Plus command line? (01-APR-04) Why can't I use '&' in a comment, put comments after a semicolon, end a comment with a semicolon, or put a comment in the middle of command keywords? (01-APR-04) Why don't variables in my TTITLE substitute correctly? (01-APR-0
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/meassage-file-sp1-lang-msb-not-found-3872793 SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat error 6 bluesguyAZ59 iudithm COMPANIES RSA Conference UC4 Apperian Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your error 6 initializing account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. MEASSAGE FILE SP1 LANG .MSB not found sanjib.kundu asked Nov 11, 2010 | Replies (1) Hi, What does "Message file sp1.msb not found" mean when I run SQL*Plus? Sometimes when SQL*Plus is run, you see the error: Message file sp1.msb not found Error 6 initializing SQL*Plus This occurs when SQL*Plus was unable to find a message file during program initialization. The most common cause is that ORACLE_HOME has not been set. This prevents the message files being found and SQL*Plus would be unable to display error messages or text required for nor