Solved

Oracle ORA-24408: could not generate unique server group name PHP on Ubuntu

Posted on 2012-03-19
4
4,903 Views
Last Modified: 2012-03-20
I am trying to setup a PHP (Ubuntu) server to connect to an Oracle database.  Installed oci8 PHP extension by following these directions:

https://help.ubuntu.com/community/PHPOracle

When I try to make my connection with oci_connect, I get:

ORA-24408: could not generate unique server group name

This article suggests downgrading to 10g, but I'd like to get it working with the latest client if possible:

http://nickshontz.wordpress.com/2011/11/29/php-oracle/

Comments suggest it might be related to a hostname problem--but I'm not clear from comments how to address the issue.  Any help much appreciated.
0
Comment
Question by:scotru
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37743229
I'm only responding to a neglected question alert.  I'm not a PHP or Ubuntu person but have a lot of Unix in a previous life.

Check for a loopback.  Look at the following link in the section:  Loopback Interface

https://help.ubuntu.com/10.04/serverguide/C/network-configuration.html
0
 

Author Comment

by:scotru
ID: 37744072
Definitely on the right track.  I had to add a hosts entry for the server's host name in the /etc/hosts file for the loopback address.

127.0.0.1    server-hostname

This fixed the problem.  I'm not clear on the difference between 127.0.0.1 and 127.0.1.1 (maybe this should be the later, but it works with the 0.0.1).
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37744206
127.0.0.1 is the universal loopback address.  technically anything with 127. is also considered 'local'.
0
 

Author Comment

by:scotru
ID: 37744303
Ah, I see-- yea, I'm familiar with 127.0.0.1, just didn't realize the whole class A was local.  

Thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
The viewer will learn how to dynamically set the form action using jQuery.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now