Thank you,
Now Apache starts OK ,
with phpinfo() I can see that Oracle and OCI8 are supported,
so I wrote a php script starting by:
$connection = OCILogon ("system","xxx", "ESCAPE.IORGA.COM");
if ($connection == false){
echo OCIError($connection);
exit;
}
I get the error message :
_oci_open_server: Error while trying to retrieve text for error
ORA-12541
ORA-12541 meens : TNS:no listener
my TNSNAMES.ORA is looking like :
ESCAPE.IORGA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ESC)
)
)
the remote LISTENER.ORA is looking like :
PASSWORDS_LISTENER= (oracle)
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = serveur-db)(PORT = 1526))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ESC)
)
(SID_DESC =
(SID_NAME = INET)
)
I can access the database with SQL+,
the libpthread is listed by : ldd ./httpd
if I change my script :
$db="(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ESC)
)
)";
$connection = OCILogon ("system","manager",$db );
I get another error message :
OCISessionBegin: Error while trying to retrieve text for error ORA-03106
(meening : fatal two-task communication protocol error)
any help would be appreciated
thanks,
Damien
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de
Jani Taskinen
Envoyé : mercredi 14 mars 2001 18:22
À : Damien Lièvre
Cc : [EMAIL PROTECTED]
Objet : Re: [PHP-INST] installing PHP with-apxs with-oci8 --with-oracle
onLinux
On Wed, 14 Mar 2001, Damien Lièvre wrote:
>I've successfully installed PHP4 on Linux, Apache with-apxs,
>
>I wanted to add support for Oracle ,
>
>I' ve installed Oracle Client (8.1.7), SQL+ works fine,
>I've executed :
>./configure --with-apxs=/usr/local/apache/bin/apxs --with-oci8=/home/oracle
/
>OraHome1 --with-oracle=/home/oracle/OraHome1
>make
>make install
>
>when I restart Apache I get the Error Message:
>
>Cannot load /usr/local/apache/libexec/libphp4.so into server:
>libclntsh.so.8.0: cannot open shared object file:
Do you have the path to libclntsh.so.8.0 in /etc/ld.so.conf ??
If not, add it and run /sbin/ldconfig
Also, make sure you have all the oracle specific environment variables
mentioned at http://www.php.net/oci8
Also, if it still doesn't work, make sure your Apache is linked with
libpthread ( # ldd httpd )
Read the page ( http://www.php.net/oci8 ) and the user notes on that
page for more information.
--Jani
--
PHP Install Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Install Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
