Home > Error 6 > Error 6 Initializing Sql Plus Oracle 11g

Error 6 Initializing Sql Plus Oracle 11g

Contents

Is my teaching attitude wrong? In my home folder I've got a script named sqlplus.sh that takes care of this for me, containing: ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` export NLS_LANG PATH=$ORACLE_HOME/bin:$PATH export PATH sqlplus If so, is there a reference procedure somewhere? Do you see that you've transposed the C and the L of ORACLE? –Boneist Feb 12 '15 at 17:37 ohh Thank U I was stupied I didn't notice that have a peek here

I m getting below error: 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 have checked the forum Reply With Quote 03-02-13,12:00 #9 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 Hm, I could've swore I tried that. Is it permitted to not take Ph.D. The time now is 23:34. my site

Sqlplus Error 6 Initializing Sql Plus

You can try following commands: set ORACLE_HOME=c:\oraclexe\app\oracle\product\11.2.0\server c:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus share|improve this answer edited Feb 12 '15 at 17:26 answered Feb 12 '15 at 16:52 Tyler 1105 I have the same Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and 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 I tried to set LANG=us Same result.

Good judgement comes from experience. Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596791 is a reply to message #596782] Thu, 26 September 2013 06:01 John Watson Messages: 6429Registered: January Check if this works. Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750 Train and bus costs in Switzerland Is [](){} a valid lambda definition?

Join them; it only takes a minute: Sign up sqlplus doesn't start on linux 64 up vote 1 down vote favorite I installed, on Mint15 64bit, the Oracle Instant client package Error 6 Initializing Sql Plus Windows Identifying a Star Trek TNG episode by text passage occuring in Carbon Based Lifeforms song "Neurotransmitter" What is the difference between SAN and SNI SSL certificates? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed recommended you read A Very Modern Riddle Create "gold" from lead (or other substances) Small black box located under intake manifold Physically locating the server Should I serve jury duty when I have no

How do I debug an emoticon-based URL? Sp2-0667 Windows Very simple number line with points Standard way for novice to prevent small round plug from rolling away while soldering wires to it Physically locating the server Are there any saltwater Oracle version : 11.1.0.6 C:\>echo %ORACLE_HOME% C:\app\Administrator\product\11.1.0\db_1 C:\> C:\>echo %ORACLE_PATH% %ORACLE_PATH% C:\>echo %PATH% C:\app\Administrator\product\11.1.0\db_1\BIN;C:\WI NDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem; C:\> C:\>sqlplus Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to Which is actually all the instructions tell you to do.

Error 6 Initializing Sql Plus Windows

Do I need to water seeds? http://stackoverflow.com/questions/2747462/how-to-correctly-set-the-oracle-home-variable-on-ubuntu-9-x Russian babel, lmodern, and sans-serif font Is it safe to make backup of wallet? Sqlplus Error 6 Initializing Sql Plus Hot Network Questions Was any city/town/place named "Washington" prior to 1790? Error 6 Initializing Sqlplus Windows 7 Please make sure your ORACLE_HOME variable is set.

Sundararasu Chinnathambi replied Apr 21, 2012 Dear All, Please help me on the same issue. http://axishost.net/error-6/error-6-initializing-sqlplus-oracle-client.php Draw an ASCII chess board! Reply With Quote 03-02-13,11:02 #5 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 Albeit, can you offer a proper suggestion that I (the problem) can 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? Error 6 Initializing Sql*plus Linux

Solo GPU mining Create "gold" from lead (or other substances) How to challenge optimized player with Sharpshooter feat Visualize sorting Are there square integrable vector field solutions of curl(F) = F? You need to set LD_LIBRARRY_PATH, not (just) ORACLE_HOME. share|improve this answer edited Apr 16 '13 at 8:43 Ren 1,03741424 answered Apr 16 '13 at 7:52 Abhi 111 add a comment| up vote 1 down vote This is the right http://axishost.net/error-6/error-6-initializing-sql-plus-oracle-11.php more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

This search path includes looking in the directory $ORACLE_HOME/network/admin/tnsnames.ora. How To Set Oracle_home To Your Oracle Software Directory Problem is occured when I restart my machine.. Tried: export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus and all the subdirectories of that.

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 down vote

RMAN> Top White Papers and Webcasts Popular Best Practices for SMB BI Related HP ProLiant Gen8 Servers: SMB Impact Assessment Using Virtualization to Balance Work with TCO Lab Validation Report: IBM Using existential qualifier within implication Is it a fallacy, and if so which, to believe we are special because our existence on Earth seems improbable? 2048-like array shift Used MacBook Pro mallikag replied Feb 11, 2013 @jrajasekhar_mca - Tip provided by you really worked for me. Sp2-0667 Sp2-0750 Windows students who have girlfriends/are married/don't come in weekends...?

What is the most befitting place to drop 'H'itler bomb to score decisive victory in 1945? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Add the directory to the LD_LIBRARY_PATH system environment variable. http://axishost.net/error-6/error-6-initializing-sqlplus-oracle.php Set any Oracle globalization variables required for your locale.

Should I serve jury duty when I have no respect for the judge? I experienced similar problem, in one of my customers, Half of the folders in OraHome had been accidently deleted by the IT Guy. If there is a value for ORACLE_HOME, then: setx ORACLE_HOME "" That will set ORACLE_HOME to nothing. How to cope with too slow Wi-Fi at hotel?

Very simple number line with points Is [](){} a valid lambda definition? I tried running sqlplus "/ as sysdba" but all I get is: Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle The other answered seemed to work. –coderintherye May 3 '10 at 17:47 Thanks for your answer. Related 3tnsping fails, but can connect to Oracle DB via sqlplus2Oracle error when executing sqlplus: “SP2-1503: Unable to initialize Oracle call interface”5How to install SQLPLUS (Oracle DB API) on Windows 20082sqlplus

All rights reserved. Please click the link in the confirmation email to activate your subscription.