Error 6 Sp2-0750
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 sp2 0750 sqlplus Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Oracle Sp2 0750
or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is sp2 0667 sp2 0750 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 Here's how
Error 6 Initializing Sql*plus
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.msb not found SP2-0750: You may need to error 6 initializing sqlplus windows 7 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/product/11.2.0/xe/lib Otherwise check to see if you can ac
To: Subject: RE: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyourOracle software directory
Sp2-0667 Windows
Date: Thu, 5 Feb 2009 15:19:15 +0100 Thanks Michael It
Sp2-0750 Oracle_home In Windows
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 error 6 initializing sql*plus linux [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 http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus [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 https://www.redhat.com/archives/spacewalk-list/2009-February/msg00090.html 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/
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.All Places > CA Workload Automation > DiscussionsLog in to create and rate content, and https://communities.ca.com/thread/98684287 to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredORACLE_HOME to your http://www.oracle.com/technetwork/testcontent/faq101-094300.html Oracle software directoryQuestion asked by CBucharowski on Jul 31, 2012Latest reply on Aug 18, 2015 by itoro Like • Show 0 Likes0 Comment • 2Running UNIX job for the first time in R11.3 and receiving the following error message. Does anyone have any insight on how to fix this error 6 error? User getting following error message when job executes. Agent is for a UNIX box. The script failed on the step that invokes SQLPlUS. The corresponding error messages are as follows: =============================== importRefData.ksh STARTED Tue Jul 31 11:50:02 EDT 2012 Resetting Stage Tables... Tue Jul 31 11:50:02 EDT 2012 Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You error 6 initializing may need to set ORACLE_HOME to your Oracle software directory ============================================================================== Thanks!! ChristineNitinP Aug 1, 2012 6:26 PMCorrect AnswerThe CA WA job is looking for same environment that a user profile exports. You can reproduce this on your UNIX by running the command as a user that does not have Oracle related profile setup. [root@oracle]# sqlplus / as sysdba Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directoryNow, with profile setup [root@WAR53BWA bin]# export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1 [root@WAR53BWA bin]# sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 1 14:11:01 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name:[color=#ff021c]Note: [color]This is an example. Do not run sqlplus as root without consulting your DBA. Set the user in the CA WA job that can run sqlplus correctly (usually not root). You may also want to set this in the agentparm.txt: oscomponent.defaultshell.force=trueThe agent will then use the default shell to run UNIX scripts and to source the user's profile.See the reply in contextNo one else had this questionMark a
SQL*Plus Release 10.1SQL*Plus -- General What versions of the database will SQL*Plus 10.1 work with? (17-AUG-04) How do I change the default directory of SQL*Plus on Windows? (17-AUG-04) How can I test if a database is running? (10-JUN-04) How do I create a batch file to run a script in SQL*Plus? (20-APR-04) Why is the EXIT status returned by SQL*Plus wrong under UNIX? (01-APR-04) What does "Message file sp1.msb not found" mean when I run SQL*Plus? (28-MAR-04) Is it possible to find out the filename of the command file started with @ in SQL*Plus, like $0 in a UNIX shell script? (22-MAR-04) Where is Server Manager linemode (svrmgrl)? (21-MAR-04) SQL*Plus -- Display Is it possible to change the displayed font type in SQL*Plus on Windows? How can I, for example, display Chinese fonts? (26-SEP-04) Why does the width of a column change when I run a report on two different databases? (10-JUN-04) How do I stop the "X rows selected" and "PL/SQL procedure successfully completed." messages appearing? (10-JUN-04) How do I display the Euro symbol ("€") in SQL*Plus? (01-APR-04) SQL*Plus -- Syntax How can I stop being prompted "Enter value for X" when I use "&"? (10-JUN-04) How do I use a semicolon in a text string? (22-APR-04) How do I replace "CONNECT INTERNAL" with "/ AS SYSDBA"? (20-APR-04) When should I use the COPY command? (20-APR-04) How do I see which output came from which statement in my script? (02-APR-04) How can I format DBMS_OUTPUT since SQL*Plus strips leading spaces? (01-APR-04) Why does the minus sign (-) in my SQL statement disappear in SQL*Plus command line? (01-APR-04) Why can't I end a REM comment with a minus (-) sign in SQL*Plus command line? (01-APR-04) Why can't I use '&' in a comment, put comments after a semicolon, end a comment with a semicolon, or put a comment in the middle of command keywords? (01-APR-04) Why don't variables in my TTITLE substitute correctly? (01-APR-04) How do I put the current date in a spool file name? (01-APR-04) How do I set the SQL*Plus command prompt to show the connect identifier of the database to which I'm connected? (01-APR-04) How do I change the DOCTYPE tag using SET MARKUP HTML? (01-APR-04) What is the difference between a SQL*Plus command, a SQL command and a PL/SQL command? (28-MAR-04) How do I run a SELECT