Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] connecting webserver to oracle database server10g

Uwe Schaefer

2007-03-30

Replies:

Hi,

> I have donwloaded and install Instant Client from oracle. It has created
> /usr/lib/oracle/10.2.0.3 directory. I have copied both zip files in this
> directory and unzip it. it has created instantclient_10_2 in
> /usr/lib/oracle/10.2.0.3 directory. While creating a softlink using
> libclntsh.so -> libclntsh.so.10.1, it says that bash: libclntsh.so:
> command not found

You should unzip both files to a different working directory, e.g.
/home/trusha/src/oracle or similar. With "same directory" I meant, that
both zips should be extracted into one directory not necessarily into
same dir like the installed client.
Being in /home/trusha/src/oracle/instantclient_10_2 you can create the
softlink with the following command:
ln -s libclntsh.so.10.1 libclntsh.so
When looking into the directory with "ls -l" you should see something
like "libclntsh.so -> libclntsh.so.10.1" afterwards.

> I have install apache2 and apache2-devel with required libapr1-devel and
> libapr-util1-devel). Then I have install php. it is installed in
> /etc/php5. While using configuration in as shown in FIG A, it says that
>
> bash: ./configure: No such file or command.
>

Please do not install standard php package. As far as I know there is no
oracle support built in. Get the sources from
http://www.php.net/downloads.php "Complete Source Code", e.g.
php-5.2.1.tar.gz
You may extract this to /home/trusha/src/php-5.2.1
There you will find "configure". Call it with all parameters in one line.

> Can you please help me in resolving this? FIG A says about
> LOCATION-OF_UNZIPPED_ORACLE_FILES..Does it mean
> /usr/lib/oracle/10.2.0.3/instantclient_10_2 ??????

Right. Meaning "/home/trusha/src/oracle/instantclient_10_2" in this case.

> For step5 and above, where to enter make??? where to add
> LD_LIBRARY_PATH? WHere to enter make install? from where php.ini file i
> copy to apache directory???? where do I create tnsnames.ora? Apache is
> installed in /etc/apache2 direcotry.

configure and make are called in /home/trusha/src/php-5.2.1
Before calling "make install" do a:
"export
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:$LD_LIBRARY_PATH"

php.ini-recommended is also created in /home/trusha/src/php-5.2.1
You can copy this by using the following:
cp php.ini-recommended /etc/apache2/php.ini

The tnsnames.ora file can be located somewhere as long as you provide
the path in the TNS_ADMIN environment variable. You may place it in
/home/trusha but maybe some Oracle ace knows a better location for this one.

Now the script starting apache should look like this:
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:$LD_LIBRARY_PATH
TNS_ADMIN=/home/trusha
export LD_LIBRARY_PATH TNS_ADMIN
apache2ctl start

Regards,
Uwe

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.