Oracle Error 6-14
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 this site About Us Learn more about Stack Overflow the company sp2-0750: you may need to set oracle_home to your oracle software directory 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 6.2 million error 6 initializing sql*plus 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 both error 6 initializing sql*plus linux 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? oracle sqlplus
Sp2-0667 Windows
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.9k55993 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 service. Not the answ
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development Exceptions" for more information. Format: A description shown in sp2-0750 oracle_home in windows the actual exception thrown. Cause: The most probable cause for the error. sp2-0667 sp2-0750 windows Action: Suggestions for resolving the error. Descriptor Exceptions (1 - 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
Sp2-1503: Unable To Initialize Oracle Call Interface
not declared as type TOC=h2-"1007943"3 but the mapping uses indirection. Mapping is set to use indirection but the related attribute is not defined as type TOC=h2-"1007943"2. It is thrown on http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files foreign reference mappings. Action: If you want to use indirection on the mapping, change the attribute to type TOC=h2-"1007943"1. Otherwise, change the mapping associated with the attribute so that it does not use indirection. Error code: 2 ATTRIBUTE_AND_MAPPING_WITHOUT_INDIRECTION_ MISMATCH Cause:
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 > https://communities.ca.com/thread/98684287 CA Workload Automation > DiscussionsLog in to create and rate https://prevexp.wordpress.com/2010/09/06/message-file-sp1-msb-not-found-error-6-initializing-sqlplus/ content, and to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredORACLE_HOME to your Oracle software directoryQuestion asked by CBucharowski on Jul 31, 2012Latest reply on Aug 18, 2015 by itoro Like • Show 0 Likes0 Comment • 2Running error 6 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? User getting following error message when job executes. Agent is for a UNIX box. The script failed on the step that invokes SQLPlUS. The error 6 initializing 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
Error 6 initializingSQL*Plus September 6, 2010June 18, 2011 areda oracle, Unix/LinuxOracle, Unix/Linux Problem: When I attempt to start SQL*PLUS I am getting an error Message file sp1.msb not found Error 6 initializing SQL*Plus Action: you can follow the steps Remember: you have to login from the owner account of oracle DB. root@AIX:> su – oracle /u01/mts/Pl-sql oracle@AIX:> oraenv ORACLE_SID = [root] ? ORACLE_HOME = [/u01/app/oracle/product/8.1.5] ? Osh [-1] oracle@AIX:~> cd $ORACLE_HOME oracle@AIX:/u01/app/oracle/product/8.1.5> ls Apache arch glibc-2.1.3-stubs.tar.gz javavm jsp ocommon owm relnotes slax svrmgr JRE assistants hs jdbc ldap odg plsql root.sh sqlj wwg README.stub bin install jis lib oracore precomp root.sh.old sqlplus xdk admin dbs install.platform jlib network otrace rdbms setup_stubs.sh starterdb oracle@AIX:/u01/app/oracle/product/8.1.5> cd sqlplus/ oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus> ls admin demo doc lib mesg oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>sqlplus internal Message file sp1.msb not found Error 6 initializing SQL*Plus oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>mkdir tmp oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>cd mesg/ oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>ls cpye.msb cpyus.msb cpyus.msg sp1e.msb sp1us.msb sp1us.msg sp2e.msb sp2us.msb sp2us.msg oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>ls -l total 152 -rw-r-r- 1 oracle oinstall 4096 mar 21 14:53 cpye.msb -rw-r-r- 1 oracle oinstall 4096 mar 21 14:53 cpyus.msb -rw-r-r- 1 oracle oinstall 1672 mar 21 14:53 cpyus.msg -rw-r-r- 1 oracle oinstall 11264 mar 21 14:53 sp1e.msb -rw-r-r- 1 oracle oinstall 10240 mar 21 14:53 sp1us.msb -rw-r-r- 1 oracle oinstall 15097 mar 21 14:53 sp1us.msg -rw-r-r- 1 oracle oinstall 29184 mar 21 14:53 sp2e.msb -rw-r-r- 1 oracle oinstall