Error 6 Initializing Sqlplus Sp2-0750
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss error 6 initializing sqlplus windows 7 the workings and policies of this site About Us Learn more
Sp2-0750: You May Need To Set Oracle_home To Your Oracle Software Directory
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow error 6 initializing sql*plus linux Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each sp2-0667 windows other. Join them; it only takes a minute: Sign up sqlplus fails to start. 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
Sp2-0750 Oracle_home In Windows
to your Oracle software directory I assume I don't have to install the whole oracle server for sql client to run. and 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.4k55792 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, ORACL
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 sp2-0667 sp2-0750 windows Windows? (17-AUG-04) How can I test if a database is running? sp2-1503: unable to initialize oracle call interface (10-JUN-04) How do I create a batch file to run a script in SQL*Plus? (20-APR-04) Why is the
Message File Sp1.msb Not Found Unix
EXIT status 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 http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files the filename of the 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 http://www.oracle.com/technetwork/testcontent/faq101-094300.html change when I run a report 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
[message #596761] Thu, 26 September 2013 04:10 shekhar.salunkhe Messages: 154Registered: January 2008 Location: Pune http://www.orafaq.com/forum/t/189652/ Senior Member Hi All, I have created oracle 11 XE https://communities.ca.com/thread/98684287 .. Once it is created it was running fine. I have worked on that 2 days. Problem is occured when I restart my machine.. I m getting below error: Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: error 6 You may need to set ORACLE_HOME to your Oracle software directory I have checked the forum in which it is mentioned that ORACLE_HOME is not properly set. I tried that one alot of time. Even now environment variable shows proper value. Please help me out. Thanks Report message error 6 initializing to a moderator Re: Error 6 initializing SQL*Plus [message #596762 is a reply to message #596761] Thu, 26 September 2013 04:17 John Watson Messages: 6429Registered: January 2010 Location: Global Village Senior Member Please can you show you current settings for the environment variables ORACLE_HOME and PATH? Then the command WHERE SQLPLUS, and the error? Like this:c:\users\john> c:\users\john>echo %ORACLE_HOME% c:\app\oracle\product\12.1.0\dbhome_1 c:\users\john>echo %PATH% c:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracl in\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\ tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2 Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Sony\VAIO Improvement;C:\Program Files (x86)\Sony\ am Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Managem am Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Inte IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\ )\PuTTY;"c:\Program Files\Windows NT\Accessories";C:\Program Files (x86)\Nmap c:\users\john>where sqlplus c:\app\oracle\product\12.1.0\dbhome_1\BIN\sqlplus.exe C:\app\oracle\product\11.2.0\db112\BIN\sqlplus.exe c:\users\john>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 26 10:16:59 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.All Places > CA Workload Automation > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredORACLE_HOME to your Oracle software directoryQuestion asked by CBucharowski on Jul 31, 2012Latest reply on Aug 18, 2015 by itoro Like • Show 0 Likes0 Comment • 2Running UNIX job for the first time in R11.3 and receiving the following error message. Does anyone have any insight on how to fix this error? User getting following error message when job executes. Agent is for a UNIX box. The script failed on the step that invokes SQLPlUS. The corresponding error messages are as follows: =============================== importRefData.ksh STARTED Tue Jul 31 11:50:02 EDT 2012 Resetting Stage Tables... Tue Jul 31 11:50:02 EDT 2012 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 ============================================================================== Thanks!! ChristineNitinP Aug 1, 2012 6:26 PMCorrect AnswerThe CA WA job is looking for same environment that a user profile exports. You can reproduce this on your UNIX by running the command as a user that does not have Oracle related profile setup. [root@oracle]# sqlplus / as sysdba Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directoryNow, with profile setup [root@WAR53BWA bin]# export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1 [root@WAR53BWA bin]# sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 1 14:11:01 2012 Copyright (c) 1982, 2005, Oracle. All rights reser