[no subject]

Thanks for taking the time to answer the post.

John


-----Original Message-----
From: ale-bounces at ale.org [<a  rel="nofollow" href="mailto:ale-bounces";>mailto:ale-bounces</a> at ale.org] On Behalf Of David Muse
Sent: Tuesday, January 18, 2005 1:45 PM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Any DBI Oracle guys out there?


Now that I think about it, there are some other potentially complicating factors...

Getting $ORACLE_HOME/lib into the LD_LIBRARY_PATH is part of the challenge, but there are a host of environment variables that should be set for any process using oracle.  It might be good to create a file with just those environment variable settings in them and source it from/etc/profile(or /etc/bashrc) and from apache's startup script.

Some platforms have an /etc/profile.d directory and any script in it will be sourced when a user logs in.

So, maybe you could create /etc/profile.d/oracle containing:

export ORACLE_VERSION=10.1.0
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/$ORACLE_VERSION
export ORACLE_SID=ora1
export PATH=$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_BASE/jdbc/lib/classes111.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_OWNER=oracle
export ORACLE_TERM=386
export NLS_LANG=american

And then, near the top of the apache startup script:

. /etc/profile.d/oracle

Dave

On Tue, 18 Jan 2005 12:04:39 -0500
Armsby John-G16665 &lt;John.Armsby at motorola.com&gt; wrote:

&gt; I have a little test script which runs from the shell &quot;perl 
&gt; testOracleObject.pl&quot;  It uses DBI successfully and prints a few 
&gt; records
to the screen. No warnings, works great.
&gt;  
&gt; I take the same script, add a little html stuff... and run it directly 
&gt; as a url from cgi-bin
&gt; 
&gt; print&quot;content-type: text/html\n\n&quot;;
&gt; print(&quot;&lt;html&gt;&lt;body&gt;&quot;);
&gt;  
&gt; <a  rel="nofollow" href="http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl";>http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl</a>
&gt; &lt;<a  rel="nofollow" href="http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl";>http://ga25web04.wepd.mot.com/cgi-bin/testOracleObject.pl</a>&gt;
&gt;  
&gt; and APACHE 2.0.46 blows up.
&gt;  
&gt; Any ideas??  I am stumped.  Next thing to do is post to perl guys.....
&gt;  
&gt; John
&gt;  
&gt;  
&gt;  
&gt; [Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81]
&gt; install_driver(Oracle) failed: Can't load 
&gt; '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Orac
&gt; le/Oracle.so' for module DBD::Oracle: libclntsh.so.9.0: cannot open 
&gt; shared object file: No such file or directory at 
&gt; /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 
&gt; 229.[Tue Jan 18 11:41:44 2005] [error] [client 155.102.104.81]  at 
&gt; (eval 1) line 3[Tue Jan 18 11:41:44 2005] [error] [client 
&gt; 155.102.104.81] Compilation failed in require at (eval 1) line 3.[Tue 
&gt; Jan 18 11:41:44 2005] [error] [client 155.102.104.81] Perhaps a 
&gt; required shared library or dll isn't installed where expected[Tue Jan 
&gt; 18 11:41:44 2005] [error] [client 155.102.104.81]  at 
&gt; oracleConnectionObject.pm line 54
_______________________________________________
Ale mailing list
Ale at ale.org
<a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00687.html">[ale] phpgroupware &amp; Global Addressbook</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00689.html">[ale] OT: Humor/Gates</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00680.html">[ale] Any DBI Oracle guys out there?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00690.html">[ale] Upgrade hell</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00688"><strong>Date</strong></a></li>
<li><a href="threads.html#00688"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>