Message File Sp1lang.msb Not Found Error 6 Initializing Sqlplus
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Message File Sp1 Lang .msb Not Found Windows
of this site About Us Learn more about Stack Overflow the company error 6 initializing sqlplus windows 7 Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask
Error 6 Initializing Sql*plus
Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; error 6 initializing sql*plus linux 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 XE 11.2 on Fedora 18 but have trouble starting SQLPlus. It quits with the following error: Error message file sp1.msb not found unix 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| 6 Answers 6 active oldest votes up vote 2 down vote This error usually occurs if you are executing sqlplus as a different user (other than the one which installed Oracle software), due to permission issues Check Oracle Note: 356850.1 share|improve this answer
to friend Sqlplus not found Message file sp1.msb not found [message #441190] Fri, 29 January 2010 06:25 zeelombe Messages: 7Registered: January 2010
Sp2-0667 Windows
Location: LUSAKA ZAMBIA Junior Member hi, people i need help resolving sp2-0750 oracle_home in windows this problem bash: sqlplus: command not found Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You
Sp2-0667 Sp2-0750 Windows
may need to set ORACLE_HOME to your Oracle software directory i install oracle 10gR and the process was successful i could do everything. the problem started when i http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus. what cani do regards Report message to a moderator Re: Sqlplus not found Message file sp1.msb not found [message #441191 is a reply to message #441190] Fri, 29 January 2010 06:29 Michel Cadot Messages: 63905Registered: March 2007 http://www.orafaq.com/forum/t/154516/ Location: Nanterre, France, http://... Senior MemberAccount Moderator Quote:You may need to set ORACLE_HOME to your Oracle software directory Did you do that? Regards Michel Report message to a moderator Re: Sqlplus not found Message file sp1.msb not found [message #441192 is a reply to message #441190] Fri, 29 January 2010 06:30 ramoradba Messages: 2454Registered: January 2009 Location: AndhraPradesh,Hyderabad,I... Senior Member From Oracle FAQ Quote: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 normal operation. Other causes are when the message file is corrupt or cannot be read. Make sure that all the environment variables or registry entries needed to run SQL*Plus are set. The variables are platform specific but may include ORACLE_HOME, OR
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/sp20667-message-file-sp1ltlanggtmsb-not-found-5539771 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 http://www.dbforums.com/showthread.php?1690477-sp1-lt-lang-gt-msb-not-found DACREE MarkDeVries Inside-ERP VoIP_News MacProTX I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Craig Borysowich Dennis Stevenson DukeGanote Richard mircea_luca iudithm Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk error 6 blrvenkat jakarman Adrian_Grigoriu COMPANIES Sophos EdgeWave Skybot Software Epicor Software ... 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 error 6 initializing Oracle Groups Your 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. SP2-0667: Message file sp1.msb not found Nate Himmons asked Jul 9, 2014 | Replies (14) On a Linux server already running an Oracle 11.2.0.3 with ASM. Just installed Oracle 11G R2 client under a user account. After installation, set all the environment variables then tried to run SQLPLUS and received an 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 My goal is to use the client installation to connect to the d
check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 14 of 14 Thread: sp1.msb not found Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-02-13,04:14 #1 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 Unanswered: sp1.msb not found Greetings, while connecting locally to sqlplus I encountered the following errors: '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' 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 Reply With Quote 03-02-13,10:04 #2 anacedent View Profile View Forum Posts Registered User 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. Reply With Quote 03-02-13,10:45 #3 yunqhero View Profile View Forum Posts Registered User 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 . 03/02/2013 02:59 AM .. 0 File(s) 0 bytes 2 Dir(s) 81,597,505,536 bytes free C:\Windows\s