Vibrational excitation by positron collisions with molecular gases: a study of O and NO targets