Re: Establish Informix network listener...

T. Saunders wrote: > Hello all. I am currently having difficulty reconfiguring my lab's > Informix database to support network connections. We are running Informix > Universal Server 9.12.UC2X21 on a Solaris 2.6 platform. I can, using the > old onconfig and sqlhosts files, bring the DB server on-line, but it does > not respond to attempts to connect to it via the network. When I use the > new onconfig and sqlhosts files, with an entry in /etc/services to > establish a port number for Informix, I am unable to bring the server > online. Perusing the log file, I get the following: > > listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot > bind a name to the port. > > Assert Failed: Attempting to bring listener thread down > ...> PANIC: Attempting to bring system down > > My suspicion is that this isn't an Informix problem, but a system problem. > However, I am uncertain where to begin to look for help. Can anyone > provide suggestions, advice, pointers to appropriate documentation? > > Much thanks, > > TJ Saunders > System Administrator > Remote Sensing Lab > University of Washington This type of error would indicate that there is already something using the port number you specified in /etc/services. You should be able to check this with netstat -a | grep -i listen. Then in that output look for something listening on the port number for the service name provided in sqlhosts. Also, you don't need to use a service name in the sqlhosts file. You can directly specify a port number, for example: my_networkname ontlitcp myhostname 5454 The 5454 being the port number oninit will attempt to start listening on. Jacques ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************