No—Oblivion doesn't require Xbox Live Gold. It's fully playable offline, single-player.
It has Live-supported features (leaderboards, achievements) but no subscription needed for the core game.