RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
Andrew Hill,
I would like to thank you very much for your help. I manage to connect to
remote oracle after a week try. The problem was I run apache as nobody and
nobody user does not have priviliege to access ~oracle directory. Now I can
continue with my project.. :)
Jeffrey Iskandar Ahmad
System Engineer
Technology Division
TIME dotNet
-Original Message-
From: Andrew Hill [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 9:38 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle
onLinux - remote oracle
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:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:04 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:31 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:50 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:09 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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
RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
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:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:04 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:31 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:50 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:09 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General 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 General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:31 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:50 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:09 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General 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 General 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 General 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]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General 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]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:09 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General 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 General 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]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 11:50 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:09 PM
To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 5:47 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General 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 General 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]
