topic Re: oracle user profile help in Operating System - HP-UX

oracle user profile help

SM_3 — Thu, 16 Oct 2003 09:12:55 GMT

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

thanks

Re: oracle user profile help

Ian Lochray — Thu, 16 Oct 2003 09:30:21 GMT

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

Re: oracle user profile help

Graham Cameron_1 — Thu, 16 Oct 2003 09:36:13 GMT

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

Re: oracle user profile help

SM_3 — Thu, 16 Oct 2003 09:54:52 GMT

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

Re: oracle user profile help

James Specht — Thu, 16 Oct 2003 09:59:32 GMT

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

Re: oracle user profile help

Graham Cameron_1 — Thu, 16 Oct 2003 10:03:45 GMT

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.

Re: oracle user profile help

SM_3 — Thu, 16 Oct 2003 10:20:28 GMT

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

Re: oracle user profile help

Robert-Jan Goossens — Thu, 16 Oct 2003 10:27:43 GMT

Hi SM,

Take a look at this faq.

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

Regards,

Robert-Jan

Re: oracle user profile help

Ravi_8 — Thu, 16 Oct 2003 10:39:39 GMT

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

Re: oracle user profile help

SM_3 — Thu, 16 Oct 2003 11:19:47 GMT

it's not happening today

Re: oracle user profile help

Indira Aramandla — Thu, 16 Oct 2003 21:55:17 GMT

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

Re: oracle user profile help

T G Manikandan — Thu, 16 Oct 2003 22:16:31 GMT

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

Re: oracle user profile help

Ursula Blanz — Fri, 17 Oct 2003 07:32:47 GMT

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

Re: oracle user profile help

SM_3 — Fri, 17 Oct 2003 08:52:46 GMT

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

Re: oracle user profile help

SM_3 — Mon, 20 Oct 2003 07:36:17 GMT

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)

Re: oracle user profile help

T G Manikandan — Mon, 20 Oct 2003 07:40:27 GMT

What's the problem now?

Re: oracle user profile help

Kevin Hansen — Thu, 23 Oct 2003 08:22:01 GMT

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