Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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.