Error 6 Initializing Sql*plus Unix
Contents |
sp1.msb not found, Error 6 initializing SQL*Plus [message #98012] Mon, 20 October 2003 11:41 rachana Messages: 27Registered: August 2003 Junior Member I found where sqlplus is on the
Error 6 Initializing Sqlplus Windows 7
Unix box, but get an error when I execute it. Also, I error 6 initializing sql*plus linux get a different message, when I execute it from my home directory. Can someone guide me as to
Error 6 Initializing Sql*plus Windows
what to do, how to set up the oracle home, oracle sid and other parameters? Thanks! On the UNIX box, I have the following directory structure- $ pwd /opt/oracle/product/8.1.7/bin -rwxr-xr-x sp2-0667: 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
Sp2-0750 Oracle_home In Windows
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions sp2-0667 sp2-0750 windows Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million
Sp2-1503: Unable To Initialize Oracle Call Interface
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 http://www.orafaq.com/forum/t/37177/ 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? http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-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_HOME/sqlplus/mesg/*.msb files readable too when trying to use sqlplus with a non oracle owner user. share|improve this answer answered Aug 29 '14 at 12:56 HSeb72 111 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of s
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 http://www.unix.com/solaris/172084-unable-start-sqlplus.html to 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 problems with error 6 initializing 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 #--------------------------------------------------------------------------------------------------------------# #qz='sqlplus barcqz/xdr56yhn@BARP2' #wdc='sqlplus barcwdc/xdr56yhn@BARP2' #-----------------------------------------------------------------------
known simply as Solaris, is a Unix-based operating system introduced by Sun Microsystems. The Solaris OS is now owned by Oracle. Search Forums Show Threads Show Posts Tag Search Advanced Search Unanswered Threads Find All Thanked Posts Go to Page... unix and linux operating commands Unable to start SQLPLUS Solaris Thread Tools Search this Thread Display Modes #1 11-28-2011 solaris_user Registered User Join Date: Aug 2009 Last Activity: 23 May 2016, 7:16 AM EDT Location: Croatia Posts: 446 Thanks: 33 Thanked 18 Times in 17 Posts Unable to start SQLPLUS I upgraded my system to Solaris 11 and everything works but I can't start my database or what (I am a noob). OS: Code: -bash-4.1$ uname -a SunOS Solaris11 5.11 11.0 i86pc i386 i86pc -bash-4.1$ isainfo -kv 64-bit amd64 kernel modules Database version is 11g2 Enterprise edition, installed on ZFS file system. When I try to start sqlplus command I get Code: -bash-4.1$ ./sqlplus /as sysdba Error 6 initializing SQL*Plus SP2-0667: Message file sp1