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

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:06:42 CDT