RE: [PHP-INST] installing PHP with-apxs with-oci8 --with-oracle onLinux
| From: | Damien Lièvre | Date: | Thu, 15 Mar 2001 15:55:48 +0000 |
| Subject: | RE: [PHP-INST] installing PHP with-apxs with-oci8 --with-oracle onLinux | ||
| References: | 1 | Groups: | php.install |
| Request: | Send a blank email to php-install+get-2409@lists.php.net to get a copy of this message | ||
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 : jani@kossu.pentap.net [mailto:jani@kossu.pentap.net]De la part de
Jani Taskinen
Envoyé : mercredi 14 mars 2001 18:22
À : Damien Lièvre
Cc : php-install@lists.php.net
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: php-install-unsubscribe@lists.php.net
For additional commands, e-mail: php-install-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net