Dear all,
Mo Tanya nih , saya sudah install oracle 9i di fedora core 2, php
4.4.1, dan apache 2. waktu saya tes phpinfo , modul oci8 dan
oraclenya sudah keluar juga.
oci8
OCI8 Support | enabled
Revision | $Revision: 1.183.2.18.2.2 $
Oracle Version |9.2
Compile-time ORACLE_HOME | /opt/oracle/920
Libraries Used | no value
oracle
Oracle Support | enabled
Oracle Version | 9.0
Compile-time ORACLE_HOME | /opt/oracle/920
Libraries Used | no value
Saya coba script sederhana untuk konek kedatabasenya.
<?php
PutEnv("ORACLE_SID=DDI");
PutEnv("ORACLE_HOME=/opt/oracle/920");
PutEnv("TNS_ADMIN=/opt/oracle");
if ($c=OCILogon("system", "oracle","DDI")) {
echo "Successfully connected to Oracle.\n";
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
?>
Hasilnya "successfully connected to oracle", itupun kadang-kadang
sukses kadang tidak.Trus waktu coba ambil data di table tidak keluar
datanya.apakah karena tidak ada librarynya atau perintah phpnya yang
salah.
Waktu configure php :
./configure -prefix=/usr/local/php \
--with-apxs2=/usr/local/apache2/bin/apxs2 \
--with-config-file-path=/usr/local/apache2/conf \
--with-oci8=/opt/oracle/920 \
--with-oracle=/opt/oracle/920 \
--disable-libgcc
saya lihat di log nya :
[Mon Jan 02 10:15:09 2006] [error] [client 202.159.63.74] PHP
Warning: ociparse(): supplied argument is not a valid OCI8-
Connection resource in /usr/local/apache2/htdocs/teskonek4.php on
line 4
[Mon Jan 02 10:15:09 2006] [error] [client 202.159.63.74] PHP
Warning: ociexecute(): supplied argument is not a valid OCI8-
Statement resource in /usr/local/apache2/htdocs/teskonek4.php on line
5
[Mon Jan 02 10:15:09 2006] [error] [client 202.159.63.74] PHP
Warning: ocifetchstatement(): supplied argument is not a valid OCI8-
Statement resource in /usr/local/apache2/htdocs/teskonek4.php on line
5
[EMAIL PROTECTED] root]#
Mohon pencerahannya.
tito
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Indo-Linux/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
