Azazia Software Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Add comment
Views: 718
Votes: 0
Comments: 0
Posted: 09 Oct, 2009
by: Patridge B.
Updated: 09 Oct, 2009
by: Patridge B.


-bash-3.00$ sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
-bash-3.00$

This can occur when the .bash_profile is not configured properly:

 

--------------------------------------------------------------------------------------------------
EXAMPLE .bashrc:
--------------------------------------------------------------------------------------------------

-bash-3.00$ cat .basrhc
#!/usr/local/bin/bash
export PATH=/usr/local/bin:/usr/local/mysql:/usr/local/mysql/bin:/usr/local/sparc-sun-solaris2.10/bin:/usr/local/ssl:/usr/local/ssl/lib:/usr/local/sbin:/usr/local/include:/usr/local/include/libxml2:/usr/bin:/usr/sbin:/usr/lib:/export/home/oracle/bin:/export/home/oracle:/export/home/oracle/instantclient:/export/home/oracle/sqlplus/mesg
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=/usr/local/oracle
export ORACLE_OWNER=oracle
export ORACLE_SID=cprod1
export SQLPATH=/export/home/oracle/instantclient/
export NLS_LANG=AMERICAN_AMERICA.UTF8
export LD_LIBRARY_PATH=/usr/local/lib:/usr/local/include:/usr/lib
export BLIB=/usr/local/bin
export JAVA_HOME=/usr/bin
alias ll='ls -al'
alias lld='ls -al |grep drw'

 

--------------------------------------------------------------------------------------------------
CHANGE TO
--------------------------------------------------------------------------------------------------

-bash-3.00$ cat .bashrc
# .bash_profile
CC=gcc ; export CC
CPPFLAGS="-I/usr/local/ssl/include" ; export CPPFLAGS
DISPLAY=ussan-triage01.corp.hds.com:0.0 ; export DISPLAY
PATH=/usr/local/bin:/usr/local/mysql:/usr/local/mysql/bin:/usr/local/sparc-sun-solaris2.10/bin:/usr/local/ssl:/usr/local/ssl/lib:/usr/local/sbin:/usr/local/include:/usr/local/include/libxml2:/usr/bin:/usr/sbin:/usr/lib:/export/home/oracle/bin:/export/home/oracle:/export/home/oracle/instantclient:/export/home/oracle/sqlplus/mesg:/usr/local/scripts
export PATH
ORACLE_BASE=/export/home/oracle ;export ORACLE_BASE
ORACLE_HOME=/export/home/oracle; export ORACLE_HOM
ORACLE_OWNER=oracle ; export ORACLE_OWNER
ORACLE_SID=cprod1 ; export ORACLE_SID
SQLPATH=/export/home/oracle/instantclient/ ;export SQLPATH
NLS_LANG=AMERICAN_AMERICA.UTF8 ; export NLS_LANG
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/include:/usr/lib ; export LD_LIBRARY_PATH
BLIB=/usr/local/bin ;export BLIB
JAVA_HOME=/usr/bin ; export JAVA_HOME
TERM=xtermc  ;export TERM
alias ll='ls -al'
alias lld='ls -al |grep drw'
alias vi='vim'

--------------------------------------------------------------------------------------------------

bash-3.00# su - oracle
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Oct 9 14:39:15 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL>

Others in this Category
document configure: error: Oracle Instant Client SDK header files not found
document PHP 5.3.0 Oracle OCI8 Instant Client 11.1.0.7.0 , Solaris 10: ERROR: ld.so.1: php: fatal: libnnz11.so: open failed: No such file or directory
document Cannot load /usr/local/apache/modules/libphp5.so into server: ld.so.1: httpd: fatal: libnnz11.so: open failed: No such file or directory



RSS