Error Ora 24408
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the oci_connect(): ora-24408: could not generate unique server group name company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Php Oci_connect
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million ora 21561 programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-24408: could not generate unique server group name up vote 11 down vote favorite 1 system: Linux web 2.6.27.21-0.1-pae #1 SMP oracle instant client 2009-03-31 14:50:44 +0200 i686 i686 i386 GNU/Linux PHP Version 5.3.8 Apache Version Apache/2.2.21 (Linux/SUSE) OCI8 Support enabled Version 1.4.7 Revision $Revision: 321634 $ Active Persistent Connections 0 Active Connections 0 Oracle Run-time Client Library Version 11.2.0.3.0 Oracle Instant Client Version 11.2 when calling oci_connect - receiv ORA-24408: could not generate unique server group name can`t understand what the kind error is this and howto fix it. php oracle share|improve this question edited May 7 '12 at 23:05 hakre 134k26216387 asked May 7 '12 at 14:53 Subdigger 1,44521536 1 nickshontz.wordpress.com/2011/11/29/php-oracle –Sérgio Michels May 7 '12 at 23:59 Sérgio Michels - thanks, i`ll try –Subdigger May 8 '12 at 8:55 Sérgio Michels - it works tnx –Subdigger May 8 '12 at 9:20 Ok, I put this as an answer, so others can see that this question have a solution :) –Sérgio Michels May 8 '12 at 12:38 add a comment| 6 Answers 6 active oldest votes up vote -4 down vote accepted This is a error with compatibility of the runtime oracle 11g and PHP Oci support. As the OP confirm, the downgrade of the client to 10g works. The solution was found here. share|improve this answer answered May 8 '12 at 12:37 Sérgio Michels 11.9k12654 2 A downgrade is definitely NOT necessary - see my answer below. –Camden S. Dec 6 '13 at 15:56 @CamdenS. Resuscitating old topics? :-) I just put it as an answer as requested by the OP, maybe worth a comment in the blog post too. –Sérgio Michels Dec 6 '13 at 16:45 add a comment| up vote 32 down vote You can downgrade to 10g if you want (it evidently doesn't care about this) but that's not necessa
I came to work. It being Monday and all, seeing that PHP stopped talking to Oracle (which it was doing wonderfully until Friday), and that all reports are hence broken (which were not until Friday) is not a good start of the week. Add the cryptic Oracle errors, and you're set for nerve wrecking debugging.I quickly found out that the problem was that the server was restarted by IT during the weekend due to "other issues". Not even gonna go there. The fact is, after a http://stackoverflow.com/questions/10484231/ora-24408-could-not-generate-unique-server-group-name system reboot, PHP can no longer connect to Oracle, spawning the extremely helpful error "ORA-24408: COULD NOT GENERATE UNIQUE SERVER GROUP NAME" when calling oci_connect() (or similar).No amount of cursing helped, and the usual debugging method (ie Googling around) showed that the dominant solution was to downgrade to OCI8 v.10. What the hell ?Some saner guys mentioned http://www.hexblot.com/blog/making-php-play-nice-oracle-part-1 that this is usually caused by an enviroment problem, but even after tinkering about nothing helped, so I'll skip to the good part -- the problem is that the server need to be able to resolve its own hostname to localhost.That is, if your server hostname is myserver.local, then pinging myserver.local from itself should resolve to 127.0.0.1 and NOT the server proper ip ( eg your intranet LAN ip ).Do note that the safest way to see which is your hostname is to type "hostname" on the terminal (no quotes, duh). It might be more than you think!Therefore, you simply add your hostname to the server /etc/hostsfile and you're done. I have absolutely no flipping clue why this is, but it actually works. If you're one of the initiated Oracle clan members, kindly enlighten me; until someone does that though, I feel entitled to call this "requirement" a completely obnoxious badly document project breaking pain in the .. oh well.Hope someone else benefits from my lack of hair.Image from http://leadershipfreak.wordpress.com/2009/12/28/frustration-or-insp
Edit # nano /etc/sysconfig/network And # nano /etc/hosts With the same HOSTNAME Edit /etc/sysconfig/network # nano /etc/sysconfig/network 1 2 3 NETWORKING=yes NETWORKING_IPV6=no HOSTNAME=zacker Edit /etc/hosts http://ahmadzainuddinzakaria.blogspot.com/2012/06/warning-ociconnect-functionoci-connect.html # nano /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 zacker ::1 localhost6.localdomain6 localhost6 # /etc/init.d/network restart Posted by Ahmad Zainuddin at 19:27 Reactions: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 8 comments: kilimo14 March 2014 at 03:02Thanks. Worked for error ora me after hours of searchingReplyDeleteAhmad Zainuddin16 March 2014 at 23:49WelcomeReplyDeleteWilfred Arambhan13 April 2015 at 02:12I followed the above steps, but facing with same issue ORA-24408: could not generate unique server group name, below is my oracle connection test codeI need to connect to external oracle database: if($c = oci_connect('orcl_username', 'orcl_pswd', '//orcl.server.domain.name:1521/servicename')){echo "Successfully error ora 24408 connected to Oracle.";oci_close($c);} else {$err = oci_error();$error = $err['message']."\n\n";print $error;}/etc/sysconfig/network (in my server not oracle server)NETWORKING=yesNETWORKING_IPV6=noHOSTNAME=localhost/etc/hosts (in my server not oracle server)127.0.0.1 localhostDo I need to have the same configuration in oracle server as well? Please help me out.ReplyDeleteAhmad Zainuddin13 April 2015 at 02:33try to change hosts and network to another name, not localhost, restart and connect backReplyDeleteWilfred Arambhan13 April 2015 at 02:35Thanks for the reply, could you be more elaborate , do I need to change hostname to the oracle server name? or can this be any name and do I need to specify the ip?ReplyDeleteWilfred Arambhan13 April 2015 at 04:25So you mean do I want to remove the localhost and add the oracle server name ?ReplyDeleteWilfred Arambhan13 April 2015 at 08:30Okay, finally Ive found a way, my webserver hostname needs to be added in /etc/hosts like this 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 [hostname]orcl db ip orcl db hostnameand in /etc/sysconfig/networkNETWORKING=yesHOSTNAME=orcl db hostnamecheers!ReplyDe