oracle user profile help

[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.