Home » Infrastructure » Unix » Message file sp1.msb not found, Error 6 initializing SQL*Plus
Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #98012] Mon, 20 October 2003 11:41 Go to next message
rachana
Messages: 27
Registered: August 2003
Junior Member
I found where sqlplus is on the Unix box, but get an error when I execute it. Also, I get a different message, when I execute it from my home directory. Can someone guide me as to 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 1 oracle dba 4372 Mar 21 2001 netasst
-rwxr-x--x 1 oracle dba 8663040 Mar 21 2001 sqlplus
-rwxr-xr-x 1 oracle dba 8658944 Sep 15 2000 sqlplusO

$ pwd
/opt/oracle/product/8.1.7/bin
$ sqlplus
Message file sp1.msb not found
Error 6 initializing SQL*Plus
(I do not know what the above error message means?)

I get the following message, when I execute sqlplus in my home direcotry-
$ pwd
/home/rachana
$ sqlplus
ksh: sqlplus: not found

The following is my .profile file -

# Default user .profile file (/usr/bin/sh initialization).

# Set up the terminal:
if [[ "$TERM" = "" ]]
then
eval ` tset -s -Q -m ':?hp' `
else
eval ` tset -s -Q `
fi
stty erase "^H" kill "^U" intr "^C" eof "^D"
stty hupcl ixon ixoff
tabs

# Set up the search paths:
PATH=$PATH:.:/opt/oracle/product/8.1.7/bin/
export PATH

# Set up the shell environment:
set -u
trap "echo 'logout'" 0

# Set up the shell variables:
EDITOR=vi
export EDITOR
Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #98013 is a reply to message #98012] Tue, 21 October 2003 10:17 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
export ORACLE_HOME=/opt/oracle/product/8.1.7
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/ccs/lib:
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=/usr/local/bin:$ORACLE_HOME/bin:.:$PATH
export ORACLE_SID=your_sid

in your .profile. The 1st error is becos sqlplus is not able to locate message files.

-Thiru
Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #98270 is a reply to message #98012] Fri, 11 June 2004 00:31 Go to previous messageGo to next message
Lucas Grijander
Messages: 1
Registered: June 2004
Junior Member
export RDBMS_TYPE="ORACLE"
export DSQUERY="<your database>"
export SRVDBLIBS="-lsrv -lct -lsybdb -lblk -lcs -ltcl -lcomn -lintl"
export DBLIBS="-lct -lsybdb -lblk -lcs -ltcl -lcomn -lintl"
export ORACLE_HOME="/home/oracle/product/8.1.7" --> oracle directory
export OCILIBS="-lclntsh"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib"
export LIBPATH="$LIBPATH:$ORACLE_HOME/lib"
export SHLIB_PATH="$SHLIB_PATH:$ORACLE_HOME/lib"
export ORACLE_SID="$DSQUERY"
export TWO_TASK=$DSQUERY
export PATH="$ORACLE_HOME/bin:$PATH:/usr/local/bin:/usr/ucb"
export ORACLE_BASE=/home/oracle
Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #193772 is a reply to message #98012] Tue, 19 September 2006 06:16 Go to previous messageGo to next message
tennessee
Messages: 5
Registered: September 2006
Location: Germany
Junior Member
Hi there,

I have the same problem with instant Client.
How to fix this there? I do not have Oracle Home,
I do not have the sp1.msb and I have no Idea where to place the tnsnames.ora file. Can you help me?

Thanks in advance.
Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #268817 is a reply to message #193772] Wed, 19 September 2007 17:42 Go to previous messageGo to next message
chintoo
Messages: 1
Registered: September 2007
Junior Member
Check all your oracle parameters
For example my development service has those.


ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH


If it does not work than its a permission error.
Its not recomended to try this on production server.

cd $ORACLE_HOME
chmod 755 -R *

Regards

Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #268826 is a reply to message #98012] Wed, 19 September 2007 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
chintoo ,
responding to a 1 year old response to a 2 year old response to 4 year old post is typically not very helpful & a waste of time.

[Updated on: Wed, 19 September 2007 19:23] by Moderator

Report message to a moderator

Re: Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #413602 is a reply to message #98012] Thu, 16 July 2009 12:09 Go to previous message
atent
Messages: 1
Registered: July 2009
Junior Member
anacedent,

i just wanted to thank chintoo in this 2 year old reply to his 1 year old reply to a 2 year old reply to a 1 year old reply

it helped with my problem.

best regards
Previous Topic: Script to Automatically refresh the data
Next Topic: Find and Replace in text files only
Goto Forum:
  


Current Time: Thu Mar 28 14:10:02 CDT 2024