I download the oci-1.2.2.tgz file and generated the oci8.so file. After

adding the
extension=oci8.so
in php.ini

I get the error


unable to load dynamic library /usr/lib/php4/oci8.so


Thanks
Danish

danish wrote:

unable to load dynamic library /usr/lib/php4/oci8.so

At the command prompt:

ls -l /usr/lib/php4/oci8.so

What is the output?

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

Toby Inkster wrote:

danish wrote:
>

>
At the command prompt:
>
ls -l /usr/lib/php4/oci8.so
>
What is the output?
>
--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

sorry..im not in the office...ill be able to post the output tomorrow
morning..apologies for the delay...

Ill post the output tomorrow. please do go through the post. I have
done a lot of head banging, but im still going wrong somewhere...

Thanks
Danish

danish wrote:

Toby Inkster wrote:
>

>
>
sorry..im not in the office...ill be able to post the output tomorrow
morning..apologies for the delay...
>
Ill post the output tomorrow. please do go through the post. I have
done a lot of head banging, but im still going wrong somewhere...
>
Thanks
Danish
>

make sure the webserver owner userid has read+execute on oci8.so either via
group or world permissions.

--
Michael Austin
Database Consultant
Domain Registration and Linux/Windows Web Hosting Reseller
http://www.spacelots.com

Michael Austin wrote:

danish wrote:
>

Thanks a lot. I got it to work..just downloaded the source files of
apache web server and php4 ..then downloaded the oci8-1.2.2.tar.gz
files....compiled and built the apache, php4,oci8 files..added the
extension_dir and extension=oci8.so to php.ini..and yahoo! oci8 was
showing as supported..but now I have one other problem...

Im trying to connect to a remote oracle database, but when I run the
php code..it gives me the following error

ocilogon(): ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor in /home/danish/htdocs/test.php

Thanks
Danish

>
make sure the webserver owner userid has read+execute on oci8.so either via
group or world permissions.
>
--
Michael Austin
Database Consultant
Domain Registration and Linux/Windows Web Hosting Reseller
http://www.spacelots.com

On Tue, 16 Jan 2007 00:56:20 -0800, danish wrote:

ocilogon(): ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor in /home/danish/htdocs/test.php

That is a TNS configuration error. You need to properly configure the
database entry in the tnsnames.ora. Essentially, TNS entry has 3 parts:
1) The hostname of the database server
2) Port at which Oracle listener is listening, usually 1521.
3) Service name of the service to which to connect.
Here is an example:
MEDO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = medo.noip.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = brundo.noip.com)
)
)

Service names are defined by the SERVICE_NAMES Oracle parameter for RDBMS
version 9 and 10 or by MTS_SERVICE parameter for RDBMS 8i. An alternative
method is to supply a SID instead of the service name, but that is
deprecated.

--
http://www.mladen-gogala.com