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;
}
?>

 

Advertisements

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

  1. Eduardo nascimento July 13, 2012 at 11:18 am Reply

    Hello, i install full client oracle 11 with the option administrator checked, a think the client option in full client is suficient .

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

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: