I've always thought the Oracle games took place after Majora, but then I realized that made no sense and placed them after LttP. I mean, at the end when you beat both of them together, you see Link go off on the boat from Awakening. But I swear... when I beat Wind Waker, it just reminded me of Awakening so much. I forgot about the Oracle games (I don't consider them canon sometimes, since Capcom made them, but they really should be counted anyways. It's not like they're those poor CD-i games), and just imagined Link going off in the KoRL and crashing on Koholint during a storm, like Awakening, assuming Nintendo just hadn't had the KoRL designed at the time they made Awakening.
But then again... he has the Triforce at the beginning of the Oracle games, which are obviously previous to Awakening. And many people consider those as taking place after LttP, since Link clearly has the Triforce at the end of that game. BUT what if Link recovered the Triforce at the end of Wind Waker 2 and was sent to Holodrum and Labrynna to look for the new Hyrule? They have a lot in common with OoT's Hyrule, and it's possible the Triforce was guiding him to possible solutions to the "find your new home" dilemna. Just tossing it out there...