Daily Archives: May 18, 2012

Oracle Client on Centos [ORA-24408: could not generate unique server group name]


Cara instalasi oracle client di centos 5.4,5.4 versi 32 bit

Jika menggunakan versi php 5.1 maka install oracle client versi 10

Jika oracle client di install versi 11 versi php 5.1 maka akan muncul error

“ORA-24408: could not generate unique server group name”

solusinya harus di downgrade ke versi oracle client : 10

oracle-instantclient-devel-10.2.0.3-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm
oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
oracle-instantclient-basic-10.2.0.3-1.i386.rpm

rpm -ivh oracle-instantclient-*

Cara instalasi oracle client di centos 6.2 versi 64 bit (centos)  versi php >= 5.2.10

install oracle client on centos 5.5 or RHEL 6
oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
oracle-instantclient-odbc-10.2.0.3-1.x86_64.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm

rpm -ivh oracle-*.rpm

[root@dctmp etc]# vim /etc/ld.so.conf.d/oracle_client.conf

/usr/lib/oracle/version-oracle-client/arsitektur/lib/

Contoh untuk 32 bit

Tambahkan di file oracle_client.conf
/usr/lib/oracle/10.2.0.3/client/lib/

[root@dctmp etc]# vim /root/.bash_profile
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib/
export LD_LIBRARY_PATH

save wq!

tar -zxvf oci8-1.4.5.tgz
cd oci8-1.4.5
phpize oci8-1.4.5
./configure && make && make install

echo extension=oci8.so > /etc/php.d/oci8.ini
echo “<?php phpinfo(); ?>” > /var/www/html/phpinfo.php

or

php -m  | grep oci8

/etc/init.d/httpd restart

Thanks

Download package di http://www.oracle.com/technetwork/topics/linuxsoft-082809.html

 

Script testing connection to oracle dababase using php script:

<?php
$tns2 = “(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.215)(PORT = 1521))) (CONNECT_DATA = (SID = crm)))”;
if($c = @oci_connect(“username”,”passowrd”,$tns2)){
echo “Successfully connected to Oracle.”;
oci_close($c);
} else {
$err = oci_error();
$error = $err[‘message’].”\n\n”;
print $error;
}
?>

 

shisdew

Listens until think alike

moses.spaceku@yahoo.com / voip ipbx

Hosted PBX, IP-PBX SOHO/ CALL CENTER, VOICE GATEWAY, VOICE CARD, COST EFECTIVE SOLUTIONS (LCR), GSM/CDMA GATEWAY

%d bloggers like this: