Error 6 Initializing Sqlplus Oracle
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 error 6 initializing sqlplus windows About Us Learn more about Stack Overflow the company Business Learn more about
Sqlplus Error 6 Initializing Sql*plus
hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack oracle sqlplus host string 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 a minute: Sign up sqlplus oracle_home 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: Message file sp1
Error 6 Initializing Sqlplus Windows 7
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 362 add a comment| up vote 1 down vote Try adding: export LD_LIBRARY_PATH==/u01/app/oracle/prod
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 error 6 initializing sql*plus linux site About Us Learn more about Stack Overflow the company Business Learn more error 6 initializing sqlplus sp2-0667 sp2-0750 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Sp2-0750: You May Need To Set Oracle_home To Your Oracle Software Directory
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 ORACLE_HOME Error http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus 6 initializing in Windows up vote 0 down vote favorite Hello I have a problem with ORALCE_HOME when i get starting with sqlplus it returns this : Error 6 initializing SQL*Plus SP2-0667: Message file sp1
[message #596761] Thu, 26 September 2013 04:10 shekhar.salunkhe Messages: 154Registered: January 2008 Location: Pune Senior Member Hi All, I have created http://www.orafaq.com/forum/t/189652/ oracle 11 XE .. 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