Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle user problem while using sqplus on AIX

Oracle user problem while using sqplus on AIX

From: <vind98_at_my-dejanews.com>
Date: Tue, 13 Oct 1998 11:47:03 GMT
Message-ID: <6vvejn$cqo$1@nnrp1.dejanews.com>


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 - 06:47:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US