[csw-users] apache2 / mod_perl2 / oracle

[Ben Walton]

Excerpts from Dewey Hylton's message of Thu Nov 05 19:13:28 -0500 2009:

> reason the perl cgis are not getting ORACLE_HOME and other variables  
> passed and are failing to connect with oracle for that reason. i think  
> it's an apache config issue, but have yet to find it. i'd still rather  
> use apache2 and not have to rewrite so much of the config.

I just updated a box running solaris 8 with an old apache + oracle
setup to solaris 10.  I had to use the following two commands to get
some of the final oracle bits in place:

svccfg -s svc:/network/cswapache2:default setenv ORACLE_SID \*
svccfg -s svc:/network/cswapache2:default setenv ORACLE_HOME /homes/oracle/product/9.2.0.1.0/

The ORACLE_SID bit was important in my environment, but I'm not sure
if it's globally required or not.  Oracle is a black box to me that
our 'seer' (dba) deals with.

HTH.
-Ben

-- 
Ben Walton
Systems Programmer - CHASS
University of Toronto
C:416.407.5610 | W:416.978.4302

GPG Key Id: 8E89F6D2; Key Server: pgp.mit.edu
Contact me to arrange for a CAcert assurance meeting.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.opencsw.org/pipermail/users/attachments/20091105/3cdc05c8/attachment-0002.asc>