I use SAE 10 (ISO 46) machine oil for small electric motor bearings. This comes dear in the stores. I suggest trying McMaster-Carr:
formatting link
select page 1991, and scroll down to Machine and Turbine Oil, and choose ISO grade 46.
BTW, we had a "broken" fan motor in the shop a couple weeks back. Made LOTS of noise and seemed out of balance or something. I blew it off with the air hose, and, surprize!, found felts for oil above each bearing. Saturatated those with oil and lo and behold the noise went away. Almost completely. Pays not to neglect these things.