Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

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

by Yaerox (Scribe)
on Apr 16, 2014 at 12:22 UTC ( [id://1082494]=note: print w/replies, xml ) Need Help??


in reply to DBI::Oracle - fails on apache ( ORA-12154) - but works fine local

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]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1082494]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others sharing their wisdom with the Monastery: (2)
As of 2024-04-26 00:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found