Originally posted by ramaral
Also, has anyone encountered anything like two smon processes for the same database on the same machine? ie, pid 1400 ora_smon_SID, 1500 ora_smon_SID? I didn't think this was possible. Maybe the machine is screwed but wanted to know if anyone has encountered something like it.
This can happen when you don't have your environment variables setup correctly. You actually start two instances with the same name and different $ORACLE_HOMEs.