[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]

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 <John.Armsby at motorola.com> wrote:

> I have a little test script which runs from the shell "perl
> testOracleObject.pl"  It uses DBI successfully and prints a few
> records
to the screen. No warnings, works great.
>  
> I take the same script, add a little html stuff... and run it directly
> as a url from cgi-bin
> 
> print"content-type: text/html\n\n";
> print("<html><body>");
>  
&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


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00678" href="msg00678.html">[ale] Any DBI Oracle guys out there?</a></strong>
<ul><li><em>From:</em> John.Armsby at motorola.com (Armsby John-G16665)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00682.html">[ale] Any DBI Oracle guys out there?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00684.html">[ale] My Next Computer</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00682.html">[ale] Any DBI Oracle guys out there?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00680.html">[ale] Any DBI Oracle guys out there?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00683"><strong>Date</strong></a></li>
<li><a href="threads.html#00683"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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