Re: Oracle user problem while using sqplus on AIX

At least $ORACLE_HOME should be defined and preferably $ORACLE_SID. The rest of the pathnames can be and should be derived from $ORACLE_HOME. The only other parameter that probably needs to be defined is LD_LIBRARY_PATH, which should equal $ORACLE_HOME/lib;/usr/local/lib.

It looks like your .profile or even /etc/profile is not called in batch mode. This file should run /usr/local/bin/oraenv (ksh) or /usr/local/bin/coraenv (csh). I know this file is often not run in batchmode as the .profile doesn't run. I have the same problem in AIX jobs, I usually call oraenv explicitly, because I think hardcoding the $ORACLE_HOME variable is not a good idea.

Hth,

Sybrand Bakker, Oracle DBA

vind98_at_my-dejanews.com wrote:

> I'm running a test batch job on an AIX server using a batch scheduler called
> OpEquus. The scheduler kicks off a shell script which in turn calls another
> shell script that logs in to sqlplus and executes an sql statement.
> The problem I'm encountering is that I can execute the script from the command
> line as user 'oracle' but when I execute the script through the scheduler as
> 'oracle' I get a message 'FAILURE TO INITIALIZE SQLPLUS'.
>
> The scheduler is C++ coded to do a su - oracle from root user but it doesn't
> appear to be working as it should.
>
> So my question is - What part of a users environment variables allow that user
> to log into sqlplus?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Oct 13 1998 - 08:39:06 CDT