RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
| From: | Jeffrey Iskandar Ahmad | Date: | Mon, 24 Sep 2001 05:04:26 +0000 |
| Subject: | RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68476@lists.php.net to get a copy of this message | ||
I have reinstalled but still cannot work.
How i compile:
./configure --with-mysql --with-apxs=/usr/local/apache/bin/apxs \
--with-ldap=/home/jeffrey/download/directory/install --with-oci8=/home/oracl
e
Apache server stop and started.
Im using redhat 7. Oracle 8i installed as programmer, apache_1.3.14. Remote
oracle server version is 8.0.5
My bash env as below:
ORACLE_HOME=/home/oracle
TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORA_NLS33=/home/oracle/ocommon/nls/admin/data
my php content:
putenv('TNS_ADMIN=/home/oracle/network/admin');
putenv("ORACLE_HOME=/home/oracle");
$db = " (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT =
1521))
)
(CONNECT_DATA =
(SID = I32)
)
)";
$c1 = ocilogon("ims","ims",$db);
if ($c1 == false){
echo OCIError($c1)."";
}
else
{
echo "success";
}
I still get the same error
OCISessionBegin: Error while trying to retrieve text for error ORA-03106
meening : fatal two-task communication protocol error)
I have tested using sqlplus(same php server) connect to remote server, there
is no problem.
Do you have sample configuration how to do it.. please.. :)
Jeffrey Iskandar Ahmad
System Engineer
Technology Division
TIME dotNet
-----Original Message-----
From: Andrew Hill [mailto:ahill@openlinksw.com]
Sent: Friday, September 21, 2001 11:31 PM
To: Jeffrey Iskandar Ahmad; php-general@lists.php.net
Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle
onLinux - remote oracle
Ensure that this is sent in the envrionment before compiling php and
starting apache as well.
Cheers,
Andrew
> -----Original Message-----
> From: Jeffrey Iskandar Ahmad [mailto:jeffrey@time.net.my]
> Sent: Friday, September 21, 2001 11:50 AM
> To: ahill@openlinksw.com; php-general@lists.php.net
> Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle
> onLinux - remote oracle
>
>
>
> I did but didnt work.
>
> Jeffrey Iskandar Ahmad
> System Engineer
> Technology Division
> TIME dotNet
>
>
> -----Original Message-----
> From: Andrew Hill [mailto:ahill@openlinksw.com]
> Sent: Friday, September 21, 2001 9:09 PM
> To: Jeffrey Iskandar Ahmad; php-general@lists.php.net
> Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle
> onLinux - remote oracle
>
>
> Jeffrey,
>
> Set your ORACLE_HOME environment variable.
> putenv("ORACLE_HOME=/path/to/oracle/home/dir");
>
> etc.
>
> HTH
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Data Integration Technology Providers
>
> > -----Original Message-----
> > From: Jeffrey Iskandar Ahmad [mailto:jeffrey@time.net.my]
> > Sent: Friday, September 21, 2001 5:47 AM
> > To: php-general@lists.php.net
> > Subject: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux
> > - remote oracle
> >
> >
> > I cannot connect to remote oracle database. I get the error below.
> >
> > OCISessionBegin: Error while trying to retrieve text for error ORA-03106
> > (meening : fatal two-task communication protocol error)
> >
> > My env is all correct.
> >
> > My test.php:
> > $db = " (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT =
> > 1521))
> > )
> > (CONNECT_DATA =
> > (SID = I32)
> > )
> > )";
> >
> > $c1 = ocilogon("ims","ims",$db);
> >
> > if ($c1 == false){
> > echo OCIError($c1)."";
> > exit;
> > }
> > else
> > {
> > echo "success";
> > }
> >
> >
> > Jeffrey Iskandar Ahmad
> > System Engineer
> > Technology Division
> > TIME dotNet
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net