Re: after adding DBSERVERALIASES into onconfig file

Nick, Thank you so much for your help! You are right about the unique port id, I did it and it works. But one thing I don't like is that for a user to be able to access the remote server without giving out been prompted for his password, he has to be either trusted by the server (a entry in /etc/hosts.equiv) or he has to have the same account accessible to the server and has access in the .rhost. Does any body know if there is a better solution? Kathy "Kataria, Nick H" <Kataria.Nick@emeryworld.com> on 03/09/2000 09:09:10 AM To: Kathy.Huo@ti.com cc: Subject: Re: after adding DBSERVERALIASES into onconfig file Kathy, Try to make the service column in sqlhosts unique. sqlhosts: # added on Tue Dec 14 16:49:53 PST 1999 dataPower ontlitcp su598u 4010# added on Tue Dec 14 16:49:53 PST 1999 dataPowerShm onipcshm su598u 4010 (new: dummy1) # remote server dpTod ontlitcp su549u 4010 (new: 4011 from /etc/services) You may first try to online the server after commenting remote server line form sqlhosts and changing the serive name to dummy1 from 4010 (infect ipcshm does not require /etc/service to run - dummy1 will be the placeholder only). Let me know the results. Regards, Nick. <Kathy.Huo@ti.com> wrote in message news:<8a6mvc$3it$1@news.xmission.com>... > > > > Nigel, > Thank you very much for your help! > The red lines are the one I added: > In sqlhosts: > # added on Tue Dec 14 16:49:53 PST 1999 > dataPower ontlitcp su598u 4010> # added on Tue Dec 14 16:49:53 PST 1999 > dataPowerShm onipcshm su598u 4010> # remote server > dpTod ontlitcp su549u 4010> > In onconfig: > # DBSERVERALIASES # List of alternate > dbservernames > DBSERVERALIASES dataPowerShm,dpTod # changed on Tue Dec 14 16:49:50> PST 1999 > > But oninit still complains: > 14:33:05 listener-thread: err = -25572: oserr = 8: errstr = : Network> driver cannot bind a name to the port. > > Kathy > > > > > > Nigel Gall <nigelg@ppsl.com> on 03/08/2000 01:33:27 PM > > To: "'Kathy Huo'" <kathy.huo@ssi1.com> > cc: "'Informix List'" <informix-list@iiug.org> > Subject: RE: after adding DBSERVERALIASES into onconfig file > > > > > First off, it may prove helpful to provide us with a snapshot of your > DBSERVERNAME and DBSERVERALIASES lines from your $ONCONFIG file (before > and > after your changes were made) as well as snapshots of your sqlhosts > file. > > Off the top of my head, though, you may want to check the following: > > - Confirm that the spelling of dataPower is spelt exactly the same > (including case) in your $ONCONFIG and sqlhosts files. > > - Confirm that your DBSERVERALIASES values are separated by commas, all > on > one line. > > - You didn't change the value of DBSERVERNAME from <something> to > dataPower, > did you? I once did this over a year ago. Due to a bug in the tools I > couldn't use shared memory when accessing the instance, so I used the > onsoctcp INFORMIXSERVER as my DBSERVERNAME value. When I got the > upgraded > tools I tried modifying the $ONCONFIG to change the DBSERVERNAME to my > onshmipc INFORMIXSERVER, moving my onsoctcp INFORMIXSERVER to > DBSERVERALIASES; it failed giving me this same error message. I > suspected, > but didn't confirm, that the DBSERVERNAME is stored somewhere in the > rootdbs > (in the reserved pages?) and if you subsequently mess with this > $ONCONFIG > parameter initialization would fail. This is why I'm requesting the > before > and after snapshots above. > > Hope this helps. If it doesn't, then the more experienced gurus here > will > ask you more pointed questions. > > Best regards, > > Edmund Nigel Gall > Senior Information Systems Specialist > Process Plant Services Limited > Atlantic Avenue, Point Lisas Industrial Estate > Point Lisas, Couva, Trinidad & Tobago, W.I. > Tel: (868) 636 2906 x 274 Fax: (868) 679 3770 > > > -----Original Message----- > From: Kathy Huo [mailto:kathy.huo@ssi1.com] > Sent: 2000 March 08 2:04 PM > To: informix-list@iiug.org > Subject: after adding DBSERVERALIASES into onconfig file > > > I can't bring the server ON-LINE after manually adding server aliases > into onconfig file. The error message was: "shared memory not > initialized for INFORMIXSERVER 'dataPower'. Does it mean I have to > reinitialize the root database or reboot the server? > > > >