We've written a small "password changer" app for our Oracle databases that basically parses all the SIDs from the tnsnames.ora file, then attempts a connect as the user and change their password.
Everything works well until the app hits a SID that is down, it generates the expected failure to connect, but then no more connections are attempted (there's about 60 in all), then a tnsnames.ora failure to resolve error is generated for the remaining SIDs in the list.
Has anyone experienced this type of issue?
