When it was all said and done, I really didn't change anything as I just changed SERVICE_NAME = TEST226 back to SID_NAME = TEST226. I think something had probably hosed up with the listener, and that's why the stop and start of the listener corrected the issue.