Error 6 Initializing Sqlplus Oracle Client
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 of error 6 initializing sqlplus windows this site About Us Learn more about Stack Overflow the company Business Learn sqlplus error 6 initializing sql*plus more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ sqlplus oracle download 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; it only takes
Sqlplus Oracle_home
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 6 initializing SQL*Plus SP2-0667: sqlplus sql developer 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 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 answered Aug 20 '13 at 9:46 BigB 3
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You 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. Please enter a title. You can toad oracle client not post a blank message. Please type your message and try again. More
Sqlldr Oracle Client
discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 15 Replies
Error 6 Initializing Sqlplus Windows 7
Latest reply on Mar 16, 2013 12:25 AM by waldyd sqlplus with Instant Client? rmmangin Dec 29, 2009 6:17 PM Other than instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip what other modules must be installed http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus to use sqlplus with Instant Client to connect to database on a remote server? When I run sqlplus it errors out with "SP2-0667: Message file sp1.msb not found". The instantclient-sqlplus package does not have any *.msb files in it. I have the same question Show 0 Likes(0) 7474Views Tags: none (add) instantclientContent tagged with instantclient, sqlplusContent tagged with sqlplus This content has been marked as https://community.oracle.com/thread/1008604 final. Show 15 replies 1. Re: sqlplus with Instant Client? Pavan Kumar Dec 29, 2009 6:22 PM (in response to rmmangin) Hi, Might be the SQL Client files got corrupted or download Installation is corrupted. Try to re-install and Check. Is this 11g which you are working on. I am not sure still. - Pavan Kumar N Oracle 9i/10g - OCP http://oracleinternals.blogspot.com/ Like Show 0 Likes(0) Actions 2. Re: sqlplus with Instant Client? 367117 Dec 29, 2009 6:35 PM (in response to rmmangin) rmmangin wrote: instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip Did you set LD_LIBRARY_PATH ? What was the sequence of unzip ? Like Show 0 Likes(0) Actions 3. Re: sqlplus with Instant Client? rmmangin Dec 29, 2009 6:55 PM (in response to Pavan Kumar) $ORACLE_HOME is set to the base directory under which the lib and bin directories are located (/opt/oracle/product/ora_current). $LD_LIBRARY_PATH includes both $ORACLE_HOME/lib and $ORACLE_HOME/bin. The instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip files were both unzipped (in that order) into the $ORACLE_HOME/lib direcotry. The instantclient-sqlplus-linux32-11.2.0.1.zip was unzipped last, into the $ORACLE_HOME/bin directory. When I try "fine $ORACLE_HOME sp1us.msb -print" there is no sp1us.msb found. In fact there are no *.msb files anywhere under
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/sp20667-message-file-sp1ltlanggtmsb-not-found-5539771 SAP 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 https://www.experts-exchange.com/questions/21589397/Error-6-initializing-SQL-Plus.html 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 error 6 knowscognosdoi Clinton Jones blrvenkat 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 error 6 initializing | More 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 c
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error 6 initializing SQL*Plus Want to Advertise Here? Solved Error 6 initializing SQL*Plus Posted on 2005-10-10 Oracle Database 1 Verified Solution 3 Comments 39,921 Views Last Modified: 2012-06-21 Hi Experts, Recently I installed oracle on an AIX machine. When I start sqlplus promt, I get the following error $ sqlplus 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 The funny thing is that, at this point if I say $ echo $ORACLE_HOME i get the output as "/mna/home/oracle/OraHome" which is right... now if i reset it to the same by $ export ORACLE_HOME=/mna/home/oracle/OraHome $ sqlplus bingo it starts!!!!!!!!! Whats wrong ppl? Please help!! My Env List: ORACLE_HOME=/mna/home/oracle/OraHome;export ORACLE_SOME PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/s bin:/usr/local/bin:/usr/lbin:.;export PATH LIBPATH=$ORACLE_HOME/lib:$LIBPATH; export LIBPATH ORACLE_SID=xpdm; export ORACLE_SID 0 Question by:kingpukky Facebook Twitter LinkedIn Google LVL 6 Best Solution byDLyall Hi ORACLE_HOME=/mna/home/oracle/OraHome;export ORACLE_SOME (?) Typo here (ORACLE_SOME). Is this what's causimg the problem? Go to Solution 3 Comments LVL 3 Overall: Level 3 Oracle Database 3 Message Expert Comment by:Yogesh_Yadav2005-10-10 Hi, Here is cause of this problem and the possible solution: New install of oracle instant client version of sqlplus is failing when attempting to start. 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 Instant_Client zip file was downloaded into: /home/instantclient/ After unzip, sqlplus executable is found in: /home/instantclient/instantclient10_1 Cause LIBPATH is not set. LIBPATH is required to include the directory of the instant client libraries. Solution To implement the solution, please execute the following steps: 1. Set LIBPATH to include the directory where the instant client is stored. In above install, LIBPATH must include: /home/instantclient/instantclient10_1 Errors 0 LVL 6 Overall: Level 6 Oracle Database 6 Message Accepted Solution by:DLyall2005-10-10 Hi ORACLE_HOME=/mna/home/oracle/OraHom