RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
| From: | Andrew Hill | Date: | Mon, 24 Sep 2001 13:37:54 +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-68510@lists.php.net to get a copy of this message | ||
Jeffrey,
Ensure your ORACLE_SID is also set.
This is a case of Oracle environment variables.
Log in as the oracle user and look at the output of an 'env'.
You are missing something there.
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: Monday, September 24, 2001 1:04 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 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
>
>
> --
> 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
>
>