Perl-Sensitive Sunglasses | |
PerlMonks |
DBI::Oracle - fails on apache ( ORA-12154) - but works fine localby Yaerox (Scribe) |
on Apr 16, 2014 at 08:41 UTC ( [id://1082456]=perlquestion: print w/replies, xml ) | Need Help?? |
Yaerox has asked for the wisdom of the Perl Monks concerning the following question: My dbi_test.pl script works fine when doing local on terminal. When getting this on my apache I'm getting: dbi_test.pl: DBI connect('_DBNAME_','_DBUSER_',...) failed: ORA-12154: TNS:could not resolve the connect identifier specROR: OCIServerAttach) at /srv/www/cgi-bin/dbi_test.pl line 14. My dbi_test.pl script is:
Already researched and tried to get where the problem is, but in case that i can use sqlplus without any problems it seems like the problem has to be with apache ... i did: perl -e 'use CGI ":all";print header;print "<pre>\n";map { print "$_ $ENV{$_}\n" } sort keys %ENV;print "</pre>\n";'to get my Apache-Environment-Variables and imo everything should be okay. Oracle-Base, Oracle-Home, Tns-Admin, Ld-Library-Path everything is set ... I don't have a clue how to go on ...
Back to
Seekers of Perl Wisdom
|
|