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