oracle user profile help

[SM_3]

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

thanks

[Ian Lochray]

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]

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

[SM_3]

yes the files are there
-
what do I have to do to execute sqlplus successfully
-
thanks

[James Specht]

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

[Graham Cameron_1]

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.

[SM_3]

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]

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]

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

[SM_3]

it's not happening today

[Indira Aramandla]

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

[T G Manikandan]

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]

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]

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

[SM_3]

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]

What's the problem now?

[Kevin Hansen]

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