Error 6 Initializing Sql
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any
Error 6 Initializing Sql Windows
questions you might have Meta Discuss the workings and policies error 6 initializing sql*plus of this site About Us Learn more about Stack Overflow the company Business Learn more about
Error 6 Initializing Sql*plus Linux
hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site error 6 initializing sql*plus unix 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 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 error 6 initializing sqlplus windows 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.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 a
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
Error 6 Initializing Sqlplus Message File Sp1lang.msb Not Found
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions error 6 initializing sqlplus windows 7 Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million
Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORACLE_HOME Error 6 initializing in Windows up vote 0 down vote favorite Hello I have a problem with ORALCE_HOME when i http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus get starting with sqlplus it returns this : 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 Probleme is that i tried this commande but it doesn't work set PATH=c:\oracle\ora92\bin;%PATH% set ORALCE_HOME=c:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus is there anyone who can help me please windows oracle oracle11g share|improve this question edited Feb 12 '15 at 16:50 Maheswaran Ravisankar 12.6k41751 asked Feb 12 '15 at http://stackoverflow.com/questions/28482661/oracle-home-error-6-initializing-in-windows 16:27 cycilia 11 Which version of the client did you install? You mention 9.2 in your PATH, but your oracle home mentions 11.2. P.S. Did you typo ORACLE_HOME here, or is that what you actually used? If so, correct the typo and try again? –Boneist Feb 12 '15 at 16:45 @Boneist I installed oracle 11g I didn't understand what typo ?? –cycilia Feb 12 '15 at 16:58 you said set ORALCE_HOME, the error message tells you to set ORACLE_HOME. 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 –cycilia Feb 12 '15 at 18:00 @Boneist I hava another problem with oracle: ORA-01034: ORACLE not available –cycilia Feb 14 '15 at 20:55 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote In your case, ORACLE_HOME should be c:\oraclexe\app\oracle\product\11.2.0\server. 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 problem –cycilia Feb 12 '15 at 16:54 The msb file can be found in folder %ORACLE_HOME%\rdbms\mesg. you need to set its value as ".
Search Tutorials/Articles Search HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie [SOLVED] Error with Unix script User Name Remember Me? http://www.linuxquestions.org/questions/linux-newbie-8/error-with-unix-script-4175529782/ Password Linux - Newbie This Linux forum is for members that are new to https://www.redhat.com/archives/spacewalk-list/2009-February/msg00090.html Linux. Just starting out and have a question? If it is not in the man pages or the how-to's this is the place! Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, error 6 receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today! Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any error 6 initializing problems with the registration process or your account login, please contact us. If you need to reset your password, click here. Having a problem logging in? Please visit this page to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. Click Here to receive this Complete Guide absolutely free. Page 1 of 2 1 2 > Search this Thread 01-02-2015, 12:44 AM #1 santosh0782 Member Registered: Nov 2013 Posts: 132 Rep: Error with Unix script Hi, I have a written a script: Code: #!/usr/bin/ksh #-------------
To: Subject: RE: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyourOracle software directory Date: Thu, 5 Feb 2009 15:19:15 +0100 Thanks Michael It works [root berlxspw01 ~]# export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH [root@ berlxspw01 ~]# type sqlplus sqlplus is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus [root@ berlxspw01 ~]# 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 [root@ berlxspw01 ~]# export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server [root@ berlxspw01 ~]# sqlplus spacewalk/spacewalk xe SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 15:16:20 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> Gruß Christian -----Original Message----- From: spacewalk-list-bounces redhat com [mailto:spacewalk-list-bounces redhat com] On Behalf Of Michael Mraka Sent: Thursday, February 05, 2009 2:56 PM To: spacewalk-list redhat com Subject: Re: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyourOracle software directory Wolf, Christian wrote: % %%Wolf, Christian wrote: % %% Hi! % %% % %% If i enter "sqlplus" i get following error. % %% What is my mistake? % %% % %% [root berlxspw01 ~]# 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 % % %This is XE server's sqlplus which needs ORACLE_HOME set. % %Fix your PATH and run sqlplus from /usr/bin (instantclient's one); no % %ORACLE_HOME is necessary. % % At first i fix my path and run sqlplus and same error % [root berlxspw01 /]# cd /usr/lib/ % [root berlxspw01 lib]# 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 % % Then I make ls -l % [root berlxspw01 bin]# ls -l /usr/bin/sqlplus % lrwxrwxrwx 1 root root 43 5. Feb 09:52 /usr/bin/sqlplus -> /usr/lib/oracle/10.2.0.4/client/bin/sqlplus % % % At the end i go to the path und try sqlplus again: % [root berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/ % [root berlxspw01 bin]# 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 [root xen35 ~]# type sqlplus sqlp