Error 6 Initializing Sql*plus Cygwin
Contents |
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
Error 6 Initializing Sqlplus Windows 7
this site About Us Learn more about Stack Overflow the company Business error 6 initializing sql*plus linux Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask sp2-0667: message file sp1
Sp2-0667 Windows
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
Sp2-0750 Oracle_home In Windows
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_HOME/sqlplus/mesg/*.msb files readable too when trying to use sqlplus with a non oracle owner user. share|improve this answer answered
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have sp2-0667 sp2-0750 windows Meta Discuss the workings and policies of this site About Us
Error 6 Initializing Sql*plus Windows
Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with sp2-1503: unable to initialize oracle call interface us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files 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 when starting SQLPlus up vote 5 down vote favorite I've installed http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus 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
to friend Sqlplus not found Message file sp1
5月 Categories CentOS MySQL Oracle メモ 翻訳 Meta Valid XHTML XFN Entries RSS Comments RSS WordPress Search « Oracle 11gインストール - その3:Oracleのインストール Oracle自動起動の設定 » 9月 17 SQL*Plusが起動できない インストールしたOracle11gのSQL*Plusを起動しようとしたら以下のエラーが表示されました。 [oracle ~]$ sqlplus /nolog -bash: sqlplus: command not found 環境変数PATHにsqlplusへのパスが通っていないのが原因のようだけど とりあえず、sqlplusがあるディレクトリまで移動して起動できるか確認。 するとまたもやエラー。今度は以下のように表示されました。 [oracle bin]$ ./sqlplus /nolog 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 ORACLE_HOMEが設定されてないのが原因のようです。 そこで、oracleユーザの.bash_profileファイルにORACLE_HOMEを追記し PATHにもSQL*Plusへのパスを追加しました。 [oracle ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs unset USERNAME umask 022 export ORACLE_BASE=/opt/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1 PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH [oracle ~]$ . ./.bash_profile [oracle ~]$ sqlplus /nolog SQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 17 16:51:15 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. 無事SQL*Plusを起動できました。 This entry was posted on 月曜日, 9月 17th, 2007 at 16:54:00 and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site. 4 Responses to "SQL*Plusが起動できない" Added by Rhett Henly on 7月 19th, 2010 at 13:15:07 This text is helpfull for me Added by usk on 12月 9th, 2010 at 18:00:52 役に立ちました Added by usgnomoto on 8月 22nd, 2012 at 18:04:48 ありがとうございます。助かりました。 Added by Keshia Palmitessa on 1月 21st, 2014 at 20:12:36 Needed to write you the tiny observation to be able to thank you again considering the unique suggestions you have documented on this page. Leave a Reply Name (required) Mail (will not be published) (required) Website Comment Copyright © Rock Kitty.net Submit URL Webmaster Forum SEO News