Re: Interference among instances

I, Jacob Salomon, wrote: > > Kristopher Sarpolis, responding to my problem, wrote: > > > Check your sqlhosts file and make sure that ALL service names are > > unique. Even the ones for shared memory connections. I recall the > > documentation saying that they are not used for shared memory > > connections but if you make two the same you get screwy things like > > you are experiencing.. > > > > Example: > > > > shm1 onipcshm myhost unused # Wrong! > > net1 onsoctcp myhost net_svc1> > > > shm2 onipcshm myhost unused # Wrong! > > net2 onsoctcp myhost net_svc2> > Thaks much, Kris! > > You hit that one on the head, sorta... Both service names for the > share-memory-connections were "dummy". I added prefixes (prefices? ;-) > and changed these dummy service names as below: > > bcbgshm onipcshm fb01 bcbg_dummy > bcbgsoc onsoctcp fb01 bsoc > > bctestshm onipcshm fb01 bctest_dummy > bctestsoc onsoctcp fb01 bctest_svc> > and it changed the circumstance. This is where the "sorta" comes in: > > After starting my test instance, the bctestshm server, I go back to > the production window (running the bcbgshm server). Now the 761 error > does not happen. It goes directly to the 25588 error. As before, > the 25588 problem persists [on bcbgshm] even after I have knocked > down the bctestshm server. I had to bounce the bcbgshm server again. > Fortunately, I was able to - Yesterday, I couldn't get rid of one > zombie shared memory segment. OK, END OF STORY! That last bounce of the production system is what was needed. Obviously (now ;-) it was still operating under the erroneous sqlhosts wherein both shared memory servers had the same service name. When I bounced the production server, it oriented itself to the corrected sqlhosts. We are back in business. Thanks, Kris and Martina. BTW, I recall it is documented, at least in the training manual. Someplace... ;-) -- -- Jake (Never yelled "CROWDED THEATER!" during a fire) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+