Re: odd problems with users other than oracle trying to use sqlplus

chriscj_at_cat.com wrote:
>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

Well, this is usually due to $ORACLE_HOME not being correctly set. You do have a set ORACLE_HOME env variable, but $ORACLE_HOME/bin is NOT in the PATH. Isn't this unusual? Try typing "which sqlplus" and see what your REAL $ORACLE_HOME is.

Regards
Pedro Received on Sat Jul 29 1995 - 00:00:00 CEST