cancel
Showing results for 
Search instead for 
Did you mean: 

oracle user profile help

SM_3
Super Advisor

oracle user profile help

What's the correct profile setup for oracle user?
-
sqlplus results in
:
Message file sp1.msb not found

thanks
16 REPLIES
Ian Lochray
Respected Contributor

Re: oracle user profile help

You should be able to use sqlplus with just ORACLE_HOME and ORACLE_SID set and $ORACLE_HOME/bin in your PATH.
Graham Cameron_1
Honored Contributor

Re: oracle user profile help

This is a problem either with $ORACLE_HOME, or with missing files.
Oracle utilities, including sqlplus, expect to find message files under $ORACLE_HOME.
eg
--
> echo $ORACLE_HOME
/app/oracle/product/817
> find $ORACLE_HOME -name sp1us.msb -exec ls -ld {} \;
-rw-r--r-- 1 oracle dba 10240 Aug 12 2000 /app/oracle/product/817/sqlplus/mesg/sp1us.msb
--
If the files are there then it's a language problem (the "us" in the filename is the language)

--
Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
SM_3
Super Advisor

Re: oracle user profile help

yes the files are there
-
what do I have to do to execute sqlplus successfully
-
thanks
James Specht
Trusted Contributor

Re: oracle user profile help

You could try what Ian said.

$ > export ORACLE_HOME=full_path_to_oracle_install
$ > export ORACLE_SID=database_name
$ > export PATH=$PATH:/$ORACLE_HOME/bin
$ > sqlplus

Don't try and do this as root. Run as a regular user on the box.

--Jim
"Everyone can be taught to sculpt: Michelangelo would have had to be taught how not to. So it is with the great programmers."
Graham Cameron_1
Honored Contributor

Re: oracle user profile help

Are you running the right version of sqlplus ?
"which sqlplus" should report $ORACLE_HOME/bin/sqlplus.
If it's being picked up from somewhere else then you need to change your path to pick up the correct version.
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
SM_3
Super Advisor

Re: oracle user profile help

yes sqlplus is found in /../../bin/sqlplus

but when I execute sqlplus the following occurs
Message file sp1.msb not found

but the file is on the system
Robert-Jan Goossens
Honored Contributor

Re: oracle user profile help

Hi SM,

Take a look at this faq.

http://otn.oracle.com/support/tech/sql_plus/htdocs/connect.html#sp1_lang

Regards,

Robert-Jan
Ravi_8
Honored Contributor

Re: oracle user profile help

Hi,

here is the profile that i use (for 9i)

export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle/base
export ORACLE_HOME=/oracle/base/product/9i
export PATH=/usr/local/bin:/oracle/base/product/9i/bin:$PATH
export export ORACLE_DOC=$ORACLE_BASE/doc
export ORACLE_SID=hpora
export ORACLE_TERM=vt100
export TMPDIR=/tmp
SHLIB_PATH=/$ORACLE_HOME/lib:/$ORACLE_HOME/lib32


never give up
SM_3
Super Advisor

Re: oracle user profile help

it's not happening today
Indira Aramandla
Honored Contributor

Re: oracle user profile help

Hi,

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

#export TERM=hp

# Set up the search paths:
PATH=$PATH:/opt/oracle/local/bin

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

# Set up the shell variables:
EDITOR=vi
export EDITOR

stty erase ^H

# Set-up the Oracle environment
export ORACLE_OWNER=oracle
export ORACLE_BASE=/opt/oracle/
export ORACLE_HOME=/opt/oracle/product/8.1.7.4
export PATH=/usr/local/bin:$ORACLE_HOME/bin:$PATH
export export ORACLE_DOC=$ORACLE_BASE/doc
export ORACLE_SID=
export ORACLE_TERM=vt100
export TMPDIR=/tmp
SHLIB_PATH=/$ORACLE_HOME/lib:/$ORACLE_HOME/lib32

export PS1='$PWD':'$ORACLE_SID>>'

export TNS_ADMIN=/opt/oracle/local/network/admin
Never give up, Keep Trying
T G Manikandan
Honored Contributor

Re: oracle user profile help

The problem is with the env. not set

Make sure these are there in the .profile file of the user


ORACLE_SID=; export ORACLE_SID
ORACLE_HOME=; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
Ursula Blanz
Occasional Visitor

Re: oracle user profile help

Hi SM,

Could it be, That your language isn't set correct ?
If the file sp1us.msb is in your path and in the right directory of ORACLE_HOME, then it could be, that NLS_LANG is missing or wrong.
What's set in your environment for NLS_LANG ?

Uschi
SM_3
Super Advisor

Re: oracle user profile help

thanks for all the replies
-
hang on
-
can't logon at the moment
-
will get back soon
-
SM_3
Super Advisor

Re: oracle user profile help

hello
-
ditching the 8i for 9i now
-
if you've read the other thread you'll know I'm restoring the system
-
didn't have the chance to mirror
-
ah well nevermind (it's not a production box)
T G Manikandan
Honored Contributor

Re: oracle user profile help

What's the problem now?
Kevin Hansen
Advisor

Re: oracle user profile help

either run the environment script in /usr/local/bin/ oraenv.sh or use it as an example to make your own.