| Message file sp1.msb not found, Error 6 initializing SQL*Plus [message #98012] |
Mon, 20 October 2003 11:41  |
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  |
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 |
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 #268817 is a reply to message #193772] |
Wed, 19 September 2007 17:42 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
