Error 6 Initializing Sqlplus
Contents |
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 this site About Us Learn more about Stack error 6 initializing sqlplus windows Overflow the company Business Learn more about hiring developers or posting ads with us error 6 initializing sql plus Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database sqlplus oracle_home professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer error 6 initializing sql*plus windows 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: Message file sp1
Error 6 Initializing Sql*plus Linux
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 362 add a comment| up vote 1 down vote Try adding: export LD_LIBRARY_PATH==/u01/app/oracle/product/11.2.0/xe/lib Otherwise check to see if you can access the lib directory above. share|improve this answer answered Jun 18 '14 at 13:03 Gandolf989 97737 add a comment| up vote 1 down vote I was able to resolv
[message #596761] Thu, 26 September 2013 04:10 shekhar.salunkhe Messages: 154Registered: January 2008 Location: Pune Senior Member Hi All, I have created oracle 11 XE
Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750
.. Once it is created it was running fine. I have error 6 initializing sqlplus unix worked on that 2 days. Problem is occured when I restart my machine.. I m getting below error: error 6 initializing sql*plus unix Error 6 initializing SQL*Plus Message file sp1
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 About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/6013508/error-6-initializing-sqlplus Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files 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 other. Join them; it only takes a minute: Sign up Error 6 Initializing SQL*Plus up vote 2 down vote favorite 1 When i open sqlplus it shows Error 6 Initializing SQL*Plus Message file error 6 sp1
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 About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow 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 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 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, ORACLE_HOME/sqlplus/mesg directories allowed for read and execute, and all the ORACLE_