Re: cgi-->SQL/PERL-->SQL*PLUS processing..

From: <ether_nut_at_my-deja.com>
Date: Wed, 07 Jul 1999 13:40:15 GMT
Message-ID: <7lvlbt$crq$1@nnrp1.deja.com>

I've got those already in the script. Can someone elaborate on what else I might check to see what the problem might be? What rights are also necessary for the file to be written to /TMP by a script? It's set for drwxrwxrwt for /TMP

$sqlplus = '/oracle/app/oracle/product/7.3.4/sqlplus';
$orauser = 'user_name';
$orapass = 'password';
$logfile = '/export/srchprop.log';
$last_file = '/index.html';

$ENV{'ORACLE_HOME'} = '/oracle/app/oracle/product/7.3.4/';
$ENV{'ORACLE_OWNER'} = 'oracle';

$ENV{'ORACLE_SID'} = 'DBA1';
$ENV{'ORACLE_PATH'} = '/usr/local/bin';

---

In article <3782AFFB.BA365A8E_at_deere.com>,   John Higgins <JH33378_at_deere.com> wrote:
> Modify your script to display the environment variables ORACLE_HOME,
> ORACLE_SID. If these are not set by your CGI script, you cannot
connect.
>
> ether_nut_at_my-deja.com wrote:
>
> > Oracle 7.3.4...
> > I've got the SQL worksheet & SQL*PLUS running the queries from
remote,
> > but when I try and run queries from cgi-bin using PERL/SQL from the
> > webserver on the same machine(different IP), it gives an ORA-01034
error
> > and it puts this error in all the outputs on the web pages where the
SQL
> > return data should be. Since this is on SPARC Solaris 7, is this
UNIX,
> > Oracle rights causing outside system return failure or is it
> > the listener? The PERL scripts use /tmp to write/run SQL*PLUS script
to
> > return to APACHE to output as web page results formed by PERL.
> >
> > Any clues out there? Oracle TECH SUPPORT said it
> > might be the listener, but, it works from ENTERPRISE manager/SQL
> > worksheet when I'm sitting
> > remote location, just it won't give APACHE OUTPUT!!! ANyway,
ora-01034
> > means no oracle running, or SGA not sufficient, or Oracle OS link
> > is not configured correct. But this is BS because
> > it works in ORACLE environment which overides SGA and Oracle
instance
> > running, but OS/Oracle link?
> > Yeah, all the docs say is look at your OS setup, yeah
> > right.......where??
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 07 1999 - 08:40:15 CDT