Re: DBI::Oracle - fails on apache ( ORA-12154)

Wow, now I'm confused. Usually I'm using my connection-string from tnsnames.ora. I tried pasting the full string into my perl script and everything works fine. For me this looks like my apache doesn't read/use the tnsnames.ora ...

Comment on Re: DBI::Oracle - fails on apache ( ORA-12154) - but works fine local

Replies are listed 'Best First'.
Re^2: DBI::Oracle - fails on apache ( ORA-12154) - but works fine local by Yaerox (Scribe) on Apr 16, 2014 at 12:58 UTC
I added the line `Include /etc/apache/httpd.conf.local` at the end of my /etc/apache/httpd.conf and my /etc/apache/httpd.conf.local looks like: `SetEnv ORACLE_BASE=/usr/lib/oracle SetEnv ORACLE_HOME=/usr/lib/oracle/12.1/client SetEnv LD_LIBRARY_PATH=/usr/lib/mpi/gcc/openmpi/lib:/usr/lib/oracle/12 +.1/client/lib SetEnv TNS_ADMIN=/usr/lib/oracle/12.1/client SetEnv PATH=/usr/lib/oracle/12.1/client:$PATH` [download] and everything workes fine after retsarting ...	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: DBI::Oracle - fails on apache ( ORA-12154) - but works fine local
by Yaerox (Scribe) on Apr 16, 2014 at 12:58 UTC

Include /etc/apache/httpd.conf.local

 
SetEnv ORACLE_BASE=/usr/lib/oracle
SetEnv ORACLE_HOME=/usr/lib/oracle/12.1/client
SetEnv LD_LIBRARY_PATH=/usr/lib/mpi/gcc/openmpi/lib:/usr/lib/oracle/12
+.1/client/lib
SetEnv TNS_ADMIN=/usr/lib/oracle/12.1/client
SetEnv PATH=/usr/lib/oracle/12.1/client:$PATH
[download]

[reply]
[d/l]
[select]