odd problems with users other than oracle trying to use sqlplus

From: <chriscj_at_cat.com>
Date: 1995/07/25
Message-ID: <3v3bl8$a9j_at_vixen.cso.uiuc.edu>#1/1

I am running SQLPLUS 3.1.4.3.1 on a DEC Alpha running DEC UNIX (OSF/1) V3.2A

Whenever any user other than oracle OR myself tries to run sqlplus locally We get an error which is the following.

1 {root} /apps/oracle/v7/# sqlplus a/general_access

Message 133 not found; No message file for product=SQLPlus, facility=SP2: Releas e 3.1.3.4.1 - Production on Tue Jul 25 12:59:14 1995

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Message 428 not found; No message file for product=SQLPlus, facility=SP2Message 231 not found; No message file for product=SQLPlus, facility=SP2

I've tracked it down to an environment problem of some kind because I run ksh and have a distinctly different environment than any other user and I can run sqlplus just fine and so can the oracle user. But users like root, webmaster, and other normal users fail. All of them have almost identical environments. A printenv of theses users yields:

PATH=/usr/local/bin:/usr/local/doc/gs:/usr/local/etc:/usr/local/etc/httpd:/usr/l
ocal/mtools:/usr/sys/bin:/usr/new:/usr/bin:/bin:/sbin:/usr/ucb:/usr/sbin:/usr/bi
n/X11:/apps/oracle/v7:/apps/oracle/v7/bin:/apps/oracle/v7/lib:/apps/oracle/v7:/u

sr/lib:/usr/etc:/usr/local:/usr/local/bin/elm:. TERM=vt300
LOGNAME=root
USER=root
SHELL=/bin/csh
HOME=/
WWW_HOME=http://blake.cis.cat.com:8081/
NNTPSERVER=gw1.cat.com
DOMAIN=.laf.cat.com
EDITOR=/usr/ucb/vi

MANPATH=/usr/man:/usr/local/man
LIBWWW_PERL=/usr/local/lib/libwww-perl
ORACLE_HOME=/users/oracle

ORACLE_SID=h8p1

Nothing seems unusual, any ideas what particular ENV varibale OR lack of variable would lead to error messages about message files not being found?

Chris

--
MIS Intern
Caterpillar LEC
chriscj_at_cat.com

Received on Tue Jul 25 1995 - 00:00:00 CEST