Oracle Instant Client Error 6 Initializing Sql Plus
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site sp2-0750: you may need to set oracle_home to your oracle software directory About Us Learn more about Stack Overflow the company Business Learn more about
Error 6 Initializing Sqlplus Windows 7
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Error 6 Initializing Sql*plus
the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sqlplus fails to start.
Error 6 Initializing Sql*plus Linux
wants *.msb files up vote 2 down vote favorite 1 Installed sqlplus from oracle downloads. Unpacked both files instantclient-basic-linux.x64-12.1.0.1.0.zip instantclient-sqlplus-linux.x64-12.1.0.1.0.zip sqlplus fails to start with this 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 I assume I don't have to install the whole oracle server for sql client to run. and error 6 initializing sql*plus windows basic-linux zip is deemed to be everything you need to run OCI apps which sqlplus is. Where do I get these .msb files? oracle sqlplus share|improve this question asked Aug 19 '13 at 19:10 Randall Stevens 3401417 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote accepted You may need to set ORACLE_HOME to your Oracle software directory You need to set ORACLE_HOME to wherever you've unzippd the files: export ORACLE_HOME=/path/to/instantclient You probably also want to add that to your PATH, and might need to add it to LD_LIBRARY_PATH. Which is actually all the instructions tell you to do. share|improve this answer answered Aug 19 '13 at 19:34 Alex Poole 86.9k55993 thanks, only LD_LIBRARY_PATH was needed, just like the instructions you mentioned. –Randall Stevens Aug 19 '13 at 20:50 add a comment| up vote 1 down vote ensure to have you ORACLE_HOME/sqlplus, ORACLE_HOME/sqlplus/mesg directories allowed for read and execute, and all the ORACLE_HOME/sqlplus/mesg/*.msb files readable too when trying to use sqlplus with a non oracle owner user. share|improve this answer answered Aug 29 '14 at 12:56 HSeb72 111 add a comment| Your Answer draft saved draf
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) How can I test sp2-0667 windows if a database is running? (10-JUN-04) How do I create a batch file sp2-0750 oracle_home in windows to run a script in SQL*Plus? (20-APR-04) Why is the EXIT status returned by SQL*Plus wrong under UNIX? (01-APR-04) What sp2-0667 sp2-0750 windows 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 command file started with @ in SQL*Plus, like $0 in http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files 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 on two different databases? (10-JUN-04) How do I stop the "X rows selected" and http://www.oracle.com/technetwork/testcontent/faq101-094300.html "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-04) How do I put the current date in a spool file name? (01-APR-04) How do I set the SQL*Plus command prompt to show the connect identifier of the database
to friend Sqlplus not found Message file sp1.msb not found [message #441190] Fri, 29 January 2010 06:25 zeelombe Messages: 7Registered: January 2010 Location: LUSAKA http://www.orafaq.com/forum/t/154516/ ZAMBIA Junior Member hi, people i need help resolving this problem bash: sqlplus: command not found Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You 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 install Zend Core error 6 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: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior error 6 initializing 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, ORACLE_SID, NLS_LANG, ORA_NLS33, and LD_LIBRARY_PATH. Also check that the file sp1XX