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

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.
Received on Tue Jul 06 1999 - 20:40:11 CDT